Hi guys, how u doing?

I have the same cenarious here. I'm devolping a create user service and when this service calls my repository to create the user, i open a transaction. Inside this transaction i need to call my add-profile service to create the user with the respective profiles.

The problem occurs because my repository where i create the user is using the transaction, but when i call my service to create profile it is using the prisma client.

I can't create nasted transactions, but i can overwrite other classes "this" context to use the same transaction as PrismaClient. This is the only way that i found to do what i want. The otherway was duplicating code to use nasted queries how is showed in documentation.

The $transaction property doesn't exists in Transactions.
My workaround was to use a function where receives a transaction and when $transaction is called i use the Proxy to redirect to our original transaction.

This is the only way that i found that works. When i tryed to use other things like {...tx, $transaction: async (func) => func(tx)} the transaction connection was closed.

Waiting for nasted transactions in prisma

Here you go:

 const { boardId } = req.body;
  const { description, status, title } = req.body.task;

  const [createTask] = await prisma.$transaction(async (prisma) => {
    const createTask = await prisma.task.create({
      data: {
        board: boardId,
        description,
        status,
        title,
      },
    });

    const statusArray = await prisma.board.findUnique({
      where: {
        id: boardId,
      },
      select: {
        [status]: true,
      },
    });

    const updateBoardStatusArray = await prisma.board.update({
      where: {
        id: boardId,
      },
      data: {
        [status]: {
          set: [...statusArray[status], createTask.id],
        },
      },
    });
    
    return [createTask, statusArray, updateBoardStatusArray];
  });

  // return data from first query
  res.status(201).json({ task: createTask });

You can learn more about Interactive Transaction here

this code is also work and this is the 1st way

import { PrismaClient } from "@prisma/client";

export type PrismaTransactionalClient = Parameters<
    Parameters<PrismaClient['$transaction']>[0]
>[0];

but there is a 2nd way and this is the official way

import { Prisma } from "@prisma/client";

export type PrismaTransactionalClient = Prisma.TransactionClient;