Using increment on Decimal fields?

In the docs, it explicitly mentions atomic number operations like

increment

increment

increment

increment,

decrement

decrement

decrement

decrement etc. only works on

Float

Float

Float

Float and

Int

Int

Int

Int. https://www.prisma.io/docs/orm/reference/prisma-client-reference#atomic-number-operations

However, I tried it on a

Decimal

Decimal

Decimal

Decimal field, and it seems to work fine. Does that mean I can use it without any issues? Or are there any issues that could pop up?

Part of my schema:

model Pot {
  id            String   @id @default(cuid())
  currentAmount Decimal  @default(0.00) @db.Decimal(12, 2)
}

model Pot {
  id            String   @id @default(cuid())
  currentAmount Decimal  @default(0.00) @db.Decimal(12, 2)
}

model Pot {
  id            String   @id @default(cuid())
  currentAmount Decimal  @default(0.00) @db.Decimal(12, 2)
}

model Pot {
  id            String   @id @default(cuid())
  currentAmount Decimal  @default(0.00) @db.Decimal(12, 2)
}

Query:

await prisma.pot.update({
   where: { userId, potId },
   data: { currentAmount: { increment: amountToUpdate } },
  })

await prisma.pot.update({
   where: { userId, potId },
   data: { currentAmount: { increment: amountToUpdate } },
  })

await prisma.pot.update({
   where: { userId, potId },
   data: { currentAmount: { increment: amountToUpdate } },
  })

await prisma.pot.update({
   where: { userId, potId },
   data: { currentAmount: { increment: amountToUpdate } },
  })

amountToUpdate

amountToUpdate

amountToUpdate

amountToUpdate is a string.

Using increment on Decimal fields?

Similar Threads

Similar Threads

Similar Threads