"database_type": "mysql",//数据库类型,此值必须与dbpoxy.yml配置一致
"enable": true,//本配置文件是否启用
"inject": "=",//全局防注入字符串,多个以英文半角豆号分隔
{//新增一条数据库记录预定义,操作id,cmd_id为1,通过cmd_id对应触发
"table_name": "users",//表名
"op_name": "insert",//操作符,支持insert,update,query,delete,work(事务)
"inject": "=",//单指令防注入字符串,多个以英文半角豆号分隔
"value": { //数据库操作指令,insert,update,delete指令使用sql_exec定义
"sql_exec": "INSERT INTO users(age, name, num, createat) VALUES ({0}, {1}, {2}, {3})"
"param_count": 4//数据库操作指令参数数量,内核会以此值验证CGP消息
"table_name":"users",//表名
"op_name":"query",//操作符,支持insert,update,query,delete,work(事务)
"value": {//数据库操作指令,insert,update,delete指令使用sql_query定义
"sql_query":"SELECT * FROM users;"
"table_name":"users",//表名
"op_name":"work",//操作符,支持insert,update,query,delete,work(事务)
"sql_works":[//数据库操作指令,insert,update,delete指令使用sql_works定义
{"table_name":"users", "work":"INSERT INTO users(age, name, num, createat) VALUES ({0}, {1}, {2}, {3})","id_alias":"insertid"},
{"table_name":"users", "work":"UPDATE users SET age={4}, name={5} WHERE id=insertid"},
{"table_name":"users", "work":"DELETE FROM users WHERE id=insertid"}