Using increment on Decimal fields?

In the docs, it explicitly mentions atomic number operations like

increment

increment

decrement

decrement

etc. only works on

Float

Float

and

Int

Int

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)
}

Query:

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

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

amountToUpdate

amountToUpdate

is a string.

Prisma•7mo ago•

4 replies

In the docs, it explicitly mentions atomic number operations like

increment

increment

decrement

decrement

etc. only works on

Float

Float

and

Int

Int

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)
}

Query:

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

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

amountToUpdate

amountToUpdate

is a string.