12345678910111213141516 |
- --原始数据
- local M = {}
- local mysqldbx = require "mysqldbx"
- local tools = require "tools"
- local skynet = require "skynet"
- local cjson = require "cjson"
- function M.delete_origin_data_by_time(msg_body)
- local isok ,key = tools.checkData({"start_create_time","end_create_time"},msg_body)
- if not isok then
- return false,string.format("缺少字段: %s.", key)
- end
- local delete_time_param = " AND DATE(created_at) >= DATE(FROM_UNIXTIME(" .. (msg_body.start_create_time / 1000) .. ")) AND DATE(created_at) <= DATE(FROM_UNIXTIME(" .. (msg_body.end_create_time / 1000) .. "))"
- end
- return M
|