1. 用Brew安装Lua

brew install lua

2. 安装luarocks

luarocks 是 Lua 的包管理工具

brew install luarocks

3. 安装 luasocket 依赖，远程调试需要用到

luarocks install luasocket
Installing https://luarocks.org/luasocket-3.0rc1-2.src.rock

env MACOSX_DEPLOYMENT_TARGET=...
luasocket 3.0rc1-2 is now installed in /usr/local (license: MIT)

4. 用IDE开发Lua安装lua插件

3F18C9B7-3B50-4F43-BB2E-F52FFDDDA477.png

我安装的Lua插件
运行一个demo

2.png

结果：

3.png

5. 用IDE调试Lua代码

IDE不能本地调试，只能用远程调试的方式。
使用 MobDebug 来进行远程调试，可以参考主页说明。
下载项目，在项目的src目录下运行语句

lua -e "require('mobdebug').listen()"
Lua Remote Debugger
Run the program you wish to debug

在ide中设置断点，并Debug

4.png

6. 安装数据库依赖包

6.1 安装 luasql-mysql

luarocks install luasql-mysql
Warning: falling back to curl - install luasec to get native HTTPS support

Installing https://luarocks.org/luasql-mysql-2.4.0-1.src.rock

Error: Could not find header file for MYSQL
  No file mysql.h in /usr/local/include
  No file mysql.h in /usr/include
  No file mysql.h in /include
You may have to install MYSQL in your system and/or pass MYSQL_DIR or MYSQL_INCDIR to the luarocks command.
Example: luarocks install luasql-mysql MYSQL_DIR=/usr/local

安装失败，缺少依赖的 xx.h 头文件，把需要的头文件放在自己的自定义的环境路径中：

pwd
/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15/include
ls
errmsg.h        mariadb_ctype.h     mysql.h
ma_list.h       mariadb_stmt.h
mariadb_com.h       mariadb_version.h

此时自定义路径安装 luasql-mysql

luarocks install luasql-mysql MYSQL_DIR=/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15
Warning: falling back to curl - install luasec to get native HTTPS support
Installing https://luarocks.org/luasql-mysql-2.4.0-1.src.rock

env MACOSX_DEPLOYMENT_TARGET=10.8 gcc -O2 -fPIC -I/usr/local/opt/lua/include/lua5.3 -c src/luasql.c -o src/luasql.o -I/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15/include
env MACOSX_DEPLOYMENT_TARGET=10.8 gcc -O2 -fPIC -I/usr/local/opt/lua/include/lua5.3 -c src/ls_mysql.c -o src/ls_mysql.o -I/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15/include
env MACOSX_DEPLOYMENT_TARGET=10.8 gcc -bundle -undefined dynamic_lookup -all_load -o luasql/mysql.so src/luasql.o src/ls_mysql.o -L/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15/lib -Wl,-rpath,/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15/lib: -lmysqlclient
ld: warning: directory not found for option '-L/Users/jjz/workspace/lua-env/luasql/mysql-8.0.15/lib'
luasql-mysql 2.4.0-1 is now installed in /usr/local (license: MIT/X11)

测试一下：

luasql = require "luasql.mysql"
--创建环境对象
env = luasql.mysql*()*
--连接数据库
conn = env:connect*(*"dcm","root","","localhost",3306*)*
--设置数据库的编码格式
conn:execute"SET NAMES UTF8"
--执行数据库操作
cur = conn:execute*(*"select * from dcm_action"*)*
row = cur:fetch*({}*,"a"*)*
--文件对象的创建
file = io.open*(*"role.txt","w+"*)*;
**while**row *do*
var = string.format*(*"%s", row.id*)*
print*(*var*)*
file:write*(*var*)*
row = cur:fetch*(*row,"a"*)*
*end*
file:close*()*--关闭文件对象
conn:close*()*--关闭数据库连接
env:close*()*--关闭数据库环境

结果：

/usr/local/Cellar/lua/5.3.5_1/bin/lua mysqlDemo.lua
4cbROUp2nnxXA6Uk
4cbROVD2nnbdC2Uo
Process finished with exit code 0

6.2 其他的 数据库依赖包解决方法应该差不多，有空补上