Transaction system

[stombre]

Support a transaction system make sense;

• Define API
• Transaction class
• Transaction on query
• Transaction on model
• Test all cases
• Documentation
• Uncaught exception / local storage

API proposal (with async local storage);

const { Transaction } = ilorm;

Transaction.run(async () => {
  // everything here is in the transaction
  const account = await account.query().findOne({ ... });

  if (account.balance > amountMoney) {
    item.isBuyed = true;
    account.balance -= amountMoney;
    await Promise.all([
      item.save(),
      account.save(),
    ]);
  }
});

More declarative one;

Transaction.run(async (trx) => {
  // everything here is in the transaction
  const account = await account.query(trx).findOne({ ... });

  if (account.balance > amountMoney) {
    item.isBuyed = true;
    account.balance -= amountMoney;
    await Promise.all([
      item.save(trx),
      account.save(trx),
    ]);
  }
});

Exception cancel transaction? 🤔

Quid multi connector / ilorm?

Alternative syntax;

const trx = new Transaction();
const account = await account.query(trx).findOne({ ... });

if (account.balance > amountMoney) {
  item.isBuyed = true;
  account.balance -= amountMoney;
  await Promise.all([
    item.save(trx),
    account.save(trx),
  ]);
}

await trx.commit();

[stombre]

Part of the subject are tracked here; #17 #16
PR related to transaction merged #15