The datasource.mysql
module allows make queries to a MySQL database
Usage:
local db = require('datasource.myqsl.<NAME_FROM_CONFIG>')
query('<SQL QUERY>') result, error
Make a query. If an error occurred, it will be returns as second value
A result format:
{
-- row 1
{
<FIELD1_NAME> = <FIELD1_VALUE>,
<FIELD2_NAME> = <FIELD2_VALUE>,
...
},
-- row 2
{
<FIELD1_NAME> = <FIELD1_VALUE>,
<FIELD2_NAME> = <FIELD2_VALUE>,
...
},
-- row N
...
}
An example:
local db = require('datasource.mysql.dev')
local res, err = db.query("SELECT id, name FROM users")
if err ~= nil then
return
end
-- res
{
{
id = 1,
name = 'root',
},
{
id = 2,
name = 'admin',
},
{
id = 4,
name = 'user1',
},
}