Transactions #

You may use the transaction method provided by the Sutando connection to run a set of operations within a database transaction. If an exception is thrown within the transaction closure, the transaction will automatically be rolled back and the exception is re-thrown. If the closure executes successfully, the transaction will automatically be committed. You don't need to worry about manually rolling back or committing while using the transaction method:

const { sutando } = require('sutando');

sutando.transaction(async (trx) => {
  await User.query().transacting(trx).create(/* ... */);
 
  await db.table('users').transacting(trx).insert(/* ... */);

  const user = new User;
  user.name = 'Sally';

  await user.save({
    client: trx,
  });
});

Manually Using Transactions #

If you would like to begin a transaction manually and have complete control over rollbacks and commits, you may use the beginTransaction method provided by the sutando:

const { sutando } = require('sutando');

const trx = await sutando.beginTransaction();

You can rollback the transaction via the rollBack method:

await sutando.rollBack();

Lastly, you can commit a transaction via the commit method:

await sutando.commit();