lua-resty-sql
get sql statement from lua object
$ opm get xiangnanscu/lua-resty-sql
lua-resty-sql
Get sql statement from lua object.
Requirements
Nothing.
Synopsis
local Sql = require"resty.sql.postgresql"
local Profile = {
table_name = 'profile',
fields = {
{name='id'},
{name='sex'},
},
}
local foreign_key = {name='p', reference=Profile}
local User = {
table_name = 'user',
fields = {
{name='id'},
foreign_key,
{name='name'},
},
foreign_keys = {
p = foreign_key,
},
}
local sql = Sql:class{model=User}
-- now use sql in your controllers
local s1, err = sql:new{}:where{p__sex='male',name__startswith='k'}:statement()
if err then
return err
end
local s2, err = sql:new{}:update{name='kate'}:where{id=1}:statement()
if err then
return err
end
Authors
Nan Xiang(@xiangnanscu)
License
mit
Versions
-
get sql statement from lua object 2018-03-18 11:40:01
-
get sql statement from lua object 2018-03-18 08:31:16