RE: SQL syntax in Lua?

["Dowling, Brendan" <bdowling@...>]

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>>