lua-resty-query

lua-resty-mysql 的便捷包装器

需求

与 lua-resty-mysql 相同。

概要

    local single_query = require"lua.resty.query".single
    local multi_query = require"lua.resty.query".multiple
    local encode = require"cjson".encode
    
    local res, err = single_query "select * from user;"
    if not res then
        ngx.print(err)
    else
        ngx.print(encode(res))
    end
    
    local res_list, err = single_query "select * from user where id=1;select * from user where id=2;"
    if not res_list then
        ngx.print(err)
    else
        for res, err in res_list do
            if not res then
                ngx.print(err)
            else
                ngx.print(encode(res))
            end
        end
    end