Methods - transactions management

When a connection has been opened and no transaction has been started, then the provider should execute queries in auto commit mode.

begin_transaction()

This method starts a new transaction.

commit_transaction()

This method commits the current transaction.

rollback_transaction()

This method cancels the current transaction.

add_savepoint()

This method adds a save point to the current transaction, which allows for partial rollbacks within transactions.

rollback_savepoint()

This method rolls back to a previously defined save point within the current transaction.

delete_savepoint()

This method deletes a previously defined save point within the current transaction, it does not affect the transaction but it simply won't be possible to roll back to the savepoint afterwards.