No description, website, or topics provided.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
resty/query
.gitignore
README.md
dist.ini

README.md

lua-resty-query

Wrapper for querying mysql and postgresql database in Openresty. Just config database -> Give sql string -> get data

Requirements

Synopsis

local Query = require"resty.query.postgresql"

-- config your database and get a query function
local query = Query{
    HOST = 'localhost',
    PORT = 5432,
    USER = 'postgres',
    PASSWORD = '111111',
    DATABASE = 'test',
    POOL_SIZE = 50,
}
-- now use this function in your controllers
local res, err = query('select * from "user"')
if err then
    return err
end