Using Database Transactions to Write Queries in Strapi

[Filipe_Cunha]

@commentsBot

e write software, we always want to make it as flawless as possible. While we always strive for it hard enough, sometimes bugs still can appear in

I’m have tested your code, but the rollback does not work.

          return await strapi.db.connection.transaction(async (transacting) => {
              // Find the user
              try{
                const fromUser = await strapi.query('api::local.local').create({ data:{id:444 }}, null, { transacting });
                const toUser = await strapi.query('api::local.local').create({ data:{id:999 }}, null, { transacting });

  
              // respond with the receipt (don't forget to sanitize our output!)
              return "worked"
              }
              catch(e){
                return e
              }
          });

here, the id 999 already exists in the database, and it returns duplicated key error, however, the id 444 is inserted before this error and not removed when the transaction fails.

I also tried the following approach:

      async transaction2(ctx){
        const transacting = await strapi.db.connection.transaction();
        try {
          const fromUser = await strapi.query('api::local.local').create({ data:{id:444}}, null, { transacting });
          const toUser = await strapi.query('api::local.local').create({ data:{id:999}}, null, { transacting });
          await transacting.commit();
          return "Deu"
      } catch (err) {
          await transacting.rollback();
          console.log("ROLLBACK")
          return err
      }
      } 

The result is the same. When I call the rollback function, the first query is not reverted.
Any solution for this?