Transaction

Transaction executes multiple queries and commits them only if all succeed

Database.transaction(query, data, cb)

query: table
cb?: function(result)

returns: boolean

local queries = {
    { 'INSERT INTO `table` (column1) VALUES (?)', { 'value1' } },
    { 'INSERT INTO `table` (column1, column2) VALUES (?, ?)', { 'value1', 'value2' } },
}
 
local result = Database.transaction(queries)
 
print(result)