v2.9.1

(Experimental) New transaction usage

This function is not yet fully supported and will receive breaking changes in future updates - this export and information is provided only for feedback and testing purposes.

Sample usage of the new transaction export.

CreateThread(function()
    local success = exports.oxmysql:experimentalTransaction(function(query)
        local a = query('INSERT INTO users (identifier) VALUES (?)', { 'someid' })
        
        if not a then return false end -- if a is undefined, return false and rollback
        
        -- local b = query('SELEC * FROM users WHERE id = ? LIMIT 1', { a.insertId }) -- syntax error leads to rollback

        -- Wait(30000) -- connection will timeout and rollback transaction

        -- error('sad') -- any errors will rollback

        -- no return, or any truthy value, will commit the transaction and release the connection
    end)

    print(success)
end)

Bug Fixes

• db: incorrect error handling when no callback is defined (Linden)

Code Refactoring

• db/startTransaction: remove execute from cb (Linden)
• db/startTransaction: add 30s timeout to transactions (Linden)
• db/startTransaction: include query and values in errors (Linden)

Commits

• 8b8670e: v2.9.0 (GitHub Actions)