pull_data_status2.lua 533 B

1234567891011121314151617
  1. --拉取数据状态
  2. local M = {}
  3. local mysqldbx = require "mysqldbx"
  4. local tools = require "tools"
  5. local skynet = require "skynet"
  6. local cjson = require "cjson"
  7. function M.getRecord(msg_body)
  8. local isok ,key = tools.checkData({"record_date"},msg_body)
  9. if not isok then
  10. return false,string.format("缺少字段: %s.", key)
  11. end
  12. local sql = string.format("SELECT * FROM daily_records2 WHERE record_date = '%s' ",msg_body.record_date)
  13. local list = mysqldbx.query(sql)
  14. return true,list[1]
  15. end
  16. return M