Hey 👋 I’m wondering, is there something similar to this sort of API for database transactions:

const transactionId = prisma.trasaction()

prisma.user.create()

try {
   prisma.session.create()
} catch {
   prisma.rollback(transactionId)
}

Hey Michael 👋, We don’t have that specific API but we have

interactiveTransactions

(docs) which can accomplish a similar thing.

prisma.$transaction(async (tx) => {
  await prisma.session.create()

  // if an error is thrown, the transaction is rolled back
})

Be aware, this feature is still in preview.

👋 Hello @Michael Roberts, did Austin's recommendation help with your question? Let us know if this is still an open question!

Hey @Vladi Stevanovic for whatever reason I didn’t get the ping, never mind 🙂

Yes, any uncaught error within the

$transaction

callback will trigger a rollback. From the docs:

If the application encounters an error along the way, the async function will throw an exception and automatically rollback the transaction.