See the Lua SQLite project for an excellent example of a way to do this. http://luasqlite.luaforge.net/lsqlite.html SQLite is an embedded SQL database that is a perfect match for an embedded scripting language like Lua. It basically lets you do cool things like: db = sqlite.open("somefile") for row in db:rows("SELECT * FROM users WHERE id>0") do print(unpack(row)) end db:exec("some sql statement") et cetera. If you're comfortable with Lua, you'll like SQLite. -----Original Message----- From: lua-bounces@bazar2.conectiva.com.br on behalf of PA Sent: Tue 3/7/2006 11:29 PM To: Lua list Cc: Subject: SQL syntax in Lua? Hello, I would like to, hmmm, use some SQL like syntax in Lua and I was wondering if anyone had any thoughts on such endeavor? My current thinking is to chain function calls which mimic SQL constructs. Something along these lines: DB:Select( 'name' ): From( aSource ): Where( 'name', 'like', '%joe%' ): Where( 'city', '=', 'NYC' ): Order( 'name' )() Or perhaps wrap the above in a function call which would execute in a custom environment (providing additional substitution magic along the way): local aStatement = function() Select( name ) From( aSource ) Where( name, like, '%joe%' ) Where( city, eq, 'NYC' ) Order( name ) end DB:run( aStatement ) Any thoughts on such constructs? Thanks for any insights! Cheers -- PA, Onnay Equitursay http://alt.textdrive.com/
<<winmail.dat>>