lua mysql清洗数据

luarock是一个类似包管理，但是安装起来麻烦

安装部署大概

https://luarocks.org/

这里要提前安装  yum install mysql-devel

如果没找到libmysqlclient，尝试找下,再不行就下载

luarocks install luasql-mysql MYSQL_INCDIR=/usr/include/mysql

 cp /usr/local/mysql/lib/libmysqlclient.so /usr/local/lib

luarocks install luasql-mysql

执行的时候lua 文件名称

lua 的代码简洁，复杂的数据清洗通过lua处理很块

mysql = require "luasql.mysql"

local env  = mysql.mysql()
local conn = env:connect('BB_test','root','123456')

print(env,conn)

print(status,errorString )

cursor,errorString = conn:execute([[select * from BWccount]])
print(cursor,errorString)

row = cursor:fetch ({}, "a")

while row do
   print(string.format("BWID: %s, BWName: %s", row.BWID, rowBWName))
   local strSQL = string.format("select * from bwfri where BWID=%d", row.BWID);
   print(strSQL);
   fcursor,ferrorString = conn:execute(strSQL)
   frow = fcursor:fetch ({}, "a");
   if frow == nil then
        print(string.format("BWID=%u BWFRIEND TABLE CANNOT FOUND",row.BWID));
        iSQL = string.format("INSERT INTO `bwfriend` VALUES ('%u', '%u', '', '', '');", row.BWAccountID, row.BWAccountID);
        icursor,ierrorString = conn:execute(iSQL)
        icursor:close();
        printf(iSQL)
   end
   fcursor:close();
   row = cursor:fetch (row, "a")

end

cursor:close()
conn:close()
env:close()