CODEWITHSUNDEEP
node.jsnestjsrollbackprisma
Felix Hagspiel
Felix Hagspiel

Reputation: 2937

Rollback of Prisma Interactive Transaction in NestJS not working when throwing an error

I am using the prisma ORM and NestJS and I got the following example code:

async createMerchant(data: Prisma.MerchantCreateInput): Promise<Merchant> {
  return await this.prisma.$transaction(async (): Promise<Merchant> => {
    await this.prisma.merchant.create({
      data,
    });
    throw new Error(`Some error`);
  });
}

I would expect that the transaction is rolled back as I have thrown an error, but it is not, it creates a new database entry.

Here is the example of the official documentation.

Is this maybe related to the dependency injection of NestJS and that the injected prisma service is not correctly recognizing the error? Or am I doing something wrong?

Upvotes: 6

Views: 5614

Answers (1)

Danila
Danila

Reputation: 18516

As example shows you need to use prisma instance that is passed as an argument to your callback function, like that:

async createMerchant(data: Prisma.MerchantCreateInput): Promise<Merchant> {
  return await this.prisma.$transaction(async (prisma): Promise<Merchant> => {
    // Not this.prisma, but prisma from argument
    await prisma.merchant.create({
      data,
    });
    throw new Error(`Some error`);
  });
}

Upvotes: 15

Related Questions