Examples Transactions

Database-js supports transactions if the underlying driver supports them. The transaction code on the API has been written to be backwards compatible with existing drivers. The followng have been added to the API:

connection.isTransactionSupported()

Returns a boolean value, true if transactions are supported by the driver, false if they are not.

connection.inTransaction()

Returns a boolean value, true if the connection is currently in a transaction state, false if it is not or if the driver does not support transactions.

connection.beginTransaction()

Returns a Promise. Resolves to true if a transaction was started.

connection.commit()

Returns a Promise. Resolves to true if a active transaction was committed.

connection.rollback()

Returns a Promise. Resolves to true if a transaction was rolled back.