1234567891011121314151617 |
- --拉取数据状态
- local M = {}
- local mysqldbx = require "mysqldbx"
- local tools = require "tools"
- local skynet = require "skynet"
- local cjson = require "cjson"
- function M.getRecord(msg_body)
- local isok ,key = tools.checkData({"record_date"},msg_body)
- if not isok then
- return false,string.format("缺少字段: %s.", key)
- end
- local sql = string.format("SELECT * FROM daily_records2 WHERE record_date = '%s' ",msg_body.record_date)
- local list = mysqldbx.query(sql)
- return true,list[1]
- end
- return M
|