v1.4.0

Transactions are now supported thanks to @darksaid98

Syntax:

 -- Shared Param Format
local queries = {
    'INSERT INTO `bans` (token) VALUES (:test)',
    'INSERT INTO `bans` (token) VALUES (:test)',
    'INSERT INTO `bans` (token) VALUES (:test)',
}
local params = { ['test'] = 'thisisatestvalue' }
    
exports.oxmysql:transaction(queries, params, function(result) 
    print(result) -- true/false
end)

 -- Specific Format
local queries = {
    { query = 'INSERT INTO `test` (id, text) VALUES (:nene, :meme)', values = { ['nene'] = 'thisisatest', ['meme'] = 'this is a text' } },
    { query = 'INSERT INTO `test` (id, text) VALUES (:nene, :meme)', values = { ['nene'] = 'thisisates2', ['meme'] = 'this is a text' } },
    { query = 'INSERT INTO `test` (id) VALUES (:nene)', parameters = { ['nene'] = 'thisisatest4' } },
}

exports.oxmysql:transaction(queries, function(result) 
    print(result) -- true/false
end)

Allows setting isolation level for transactions through convar mysql_transaction_isolation_level.

The default value is 2, it accepts integers 1-4.

  switch (GetConvarInt('mysql_transaction_isolation_level', 2)) {
    case 1:
      return 'SET TRANSACTION ISOLATION LEVEL REPEATABLE READ';
    case 2:
      return 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED';
    case 3:
      return 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED';
    case 4:
      return 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE';
    default:
      return 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED';
  };

Features

• Added transactions support (#20) #20 (darksaid98)

Code Refactoring

• Transaction tweaks and version bump 1.4.0 (dunak-debug)