local mysql = require "resty.mysql"
local luastring = require "resty.string"
local print = ngx.print
local ngx_null = ngx.null
local ngx_time = ngx.time() --os.time()¸
local tostring = tostring
local tonumber = tonumber
local cjson = require "cjson"
local dogs = ngx.shared.dogs
dogs:flush_all()
local body,flags = dogs:get("key2")
local res = body
--local res=ngx.null
if 1==1 then
local db, err = mysql:new()
if not db then
ngx.say("failed to instantiate mysql: ", err)
return
end
db:set_timeout(1000) -- 1 sec
local ok, err, errno, sqlstate = db:connect{
host = "127.0.0.1",
port = 3306,
database = "mysql",
user = "root",
password = "root",
max_packet_size = 1024 * 1024 }
if not ok then
ngx.say("failed to connect: ", err, ": ", errno, " ", sqlstate)
return
end
res, err, errno, sqlstate =
db:query("select * from mysql.user limit 100", 10)
if not res then
ngx.say("bad result: ", err, ": ", errno, ": ", sqlstate, ".")
return
end
local res=cjson.encode(res)
local body=res
local success,err = dogs:set("key2", res)
end
end
local body ={
cody=cjson.decode(body),
c=123,
yu=45
}
print(cjson.encode(body))