How do you run a transaction with Prisma in NestJS?

Q: How do you run a transaction with Prisma in NestJS?

// Interactive transaction — steps can reference each other's results async placeOrder(dto: CreateOrderDto) { return this.prisma.$transaction(async tx => { const order = await tx.order.create({ data: dto }); await tx.product.update({ where: { id: dto.productId }, data: { stock: { decrement: dto.qty } }, }); await tx.notification.create({ data: { orderId: order.id, type: 'ORDER_PLACED' }, }); return order; // all steps use the same tx client }); } // Sequential transaction — independent operations bundled atomically const [createdUser, createdProfile] = await this.prisma.$transaction([ this.prisma.user.create({ data: { email: dto.email } }), this.prisma.profile.create({ data: { bio: dto.bio } }), // Cannot reference createdUser.id here — array is built before execution ]); // Transaction options await this.prisma.$transaction(async tx => { /* ... */ }, { maxWait: 5000, // ms to wait for a connection from the pool timeout: 10000, // ms before the transaction is aborted isolationLevel: Prisma.TransactionIsolationLevel.Serializable, }); Interactive transactions (callback) — use when each step depends on the result of a previous step. Sequential transactions (array) — use for truly independent operations that must commit or roll back together. In interactive transactions, always use the tx client — using this.prisma inside the callback bypasses the transaction. maxWait controls how long to wait for a connection; timeout controls the transaction duration limit. Nested interactive transactions are supported in Prisma 5+ via savepoints.

Difficulty: 5/10

Prisma transactions, NestJS request scope, Error handling

Use $transaction() with a callback for interactive transactions where each step depends on the previous result. Use the array form for sequential independent operations that must be atomic but do not reference each other's results. Pass isolationLevel and timeout options for fine-grained control.

Prisma interactive and sequential transactions

Prisma transaction patterns:

1
Interactive transactions (callback) — use when each step depends on the result of a previous step.
2

How do you run a transaction with Prisma in NestJS?

Difficulty: 5/10

Prisma transactions, NestJS request scope, Error handling

Use $transaction() with a callback for interactive transactions where each step depends on the previous result. Use the array form for sequential independent operations that must be atomic but do not reference each other's results. Pass isolationLevel and timeout options for fine-grained control.

Prisma interactive and sequential transactions

Prisma transaction patterns:

1
Interactive transactions (callback) — use when each step depends on the result of a previous step.
2

How do you run a transaction with Prisma in NestJS?

Use $transaction() with a callback for interactive transactions where each step depends on the previous result. Use the array form for sequential independent operations that must be atomic but do not reference each other's results. Pass isolationLevel and timeout options for fine-grained control.

How do you run a transaction with Prisma in NestJS?

Use $transaction() with a callback for interactive transactions where each step depends on the previous result. Use the array form for sequential independent operations that must be atomic but do not reference each other's results. Pass isolationLevel and timeout options for fine-grained control.

Scenario Questions

Follow-up Questions