luasql操作实例

local luasql = require("luasql.mysql");
local ev = luasql.mysql();
local con = ev:connect("database", "username", "pwd", "ip", 3306);
print(con);

function rows (connection, sql_statement)
  local cursor = assert (connection:execute(sql_statement))
  return function ()
    return cursor:fetch()
  end
end
local enddate=os.date('%Y-%m-%d', os.time());
local startdate=os.date('%Y-%m-%d', os.time()-86400);
local clickplaysql = string.format('select count(*) from test where strdate >= \'%s\' and strdate <= \'%s\' and secondType=\'click_play\'', startdate, enddate);
local clickplaycount = rows(con, clickplaysql);
local clickplay = clickplaycount();
local playsucsql = string.format('select count(*) from test where strdate >= \'%s\' and strdate <= \'%s\' and secondType=\'play_suc\'', startdate, enddate);
local playsuccount = rows(con, playsucsql);
local playsuc = playsuccount();
local clickpaysql = string.format('select count(*) from test where strdate >= \'%s\' and strdate <= \'%s\' and secondType in (\'open_dialog_driving\', \'open_dialog_passive_num\')', startdate, enddate);
local clickpaycount = rows(con, clickpaysql);
local clickpay = clickpaycount();
local paychecksql = string.format('select count(*) from test where strdate >= \'%s\' and strdate <= \'%s\' and secondType in (\'pay_driving\', \'pay_passive_follow\')', startdate, enddate);
local paycheckcount = rows(con, paychecksql);
local paycheck = paycheckcount();
local sharesql = string.format('select count(*) from test where strdate >= \'%s\' and strdate <= \'%s\' and secondType in (\'copy_code\')', startdate, enddate);
local sharecount = rows(con, sharesql);
local share = sharecount();
local content = string.format('1:%d, 2:%d , 3:%d, 4:%d, 5:%d'
    , clickplay, playsuc, clickpay, paycheck, share);
local f = io.open(startdate .. '.log', "a+");
f:write(content);
f:flush();
f:close();