medium10 pts · first answer countsprismatransactionssql

Moving credits between accounts

This code moves credits between two users. If the server crashes between the two lines, credits disappear. What is the right fix?

await prisma.account.update({
  where: { id: fromId },
  data: { credits: { decrement: amount } },
})
await prisma.account.update({
  where: { id: toId },
  data: { credits: { increment: amount } },
})

A.Swap the order so the increment runs firstB.Retry the second update in a loop until it succeeds, so the credits always arrive eventuallyC.Run a nightly job that fixes the balancesD.Wrap both updates in prisma.$transaction so they commit together or not at all

← One schema for form and API Composite index column order →