[Adonis v4] Transactions Problem on SQLite

[ambrizals]

Hi, i got some problem when try to create database transaction in adonis v4. In development and production this code is worked. When i try to run functional test entire database transaction is fail.

const trx = await Database.beginTransaction();

try {
  const detail = await Detail.create(
    {
      transaksi: id,
      jenis: req.jenis,
      qty: req.qty,
      price: req.price,
      deskripsi: req.deskripsi,
    },
    trx
  );

  if (req.jenis == 0) {
    // Product area
    await Produk.create(
      {
        transaksi_detail: detail.id,
        produk: req.produk,
      },
      trx
    );
  } else {
    // Custom area
    await Custom.create({
      transaksi_detail: detail.id,
      name: req.name,
    });
  }

  const transaksi = await Transaksi.findOrFail(id);
  await transaksi.merge({
    total_transaksi: transaksiData.total_transaksi + req.price,
  });
  await transaksi.save(trx);
  await trx.commit();

  return true;
} catch (error) {
  await trx.rollback();
  return false;
}

I don't think is testing tool problem, when i try to change database config to sqlite that problem is still exists.

Am i missing something ?.

[thetutlage]

This following call is not using the transaction.

await Custom.create({
      transaksi_detail: detail.id,
      name: req.name,
    });

Also the following call should be using the transaction client as well

 const transaksi = await Transaksi.findOrFail(id);

Remember SQLite has only one connection and that is blocked in the case you create a transaction and hence all queries have to use the transaction object.