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 其他的 数据库依赖包解决方法应该差不多，有空补上