Transaction using strapi

Question

I am learning to use strapi, and have a question. How I do the database transaction like commit & rollback when using strapi & mySql ?

Thank You

Answer 1

You can create a transactions as follows

await strapi.connections.default.transaction(
          async (trx) => {
                //functions inside transaction
                await trx.raw("insert into table..............")
          });