Best way to increment/decrement a field?

[jamesonev]

What's the best practice to decrement a field in one of my records? I took a look at #266 (from prisma1) but couldn't find it documented anywhere. I'm just trying to atomically decrement a field that I know exists, ideally in a single query.

[ryands17]

Hey @jamesonev 👋
Unfortunately this is not possible directly and there is an open issue for that as well here. Do add a 👍 on this so that we can measure the priority.

As a workaround, you would need to use prisma.executeRaw as follows. Here I am incrementing the Post's views.

await prisma.executeRaw(`update "Post" set views = views + 1 where id = 1`)

[moishinetzer]

This is now natively supported by increment: x since 2.6.0

Check out the release notes: https://github.com/prisma/prisma/releases/tag/2.6.0

[LeandreArnaud]

Hi @jamesonev ,
It seems that Prisma heard @ryands17 👍 :

prisma.table.update({
      where: { id: 1234 },
      data: {views: {increment: 1}}
    });

[bluuewhale]

awesome

[mualle]

great!

[camilo86]

This is amazing

[opaque-maniac]

Thanks

[kingfishx23]

I usually use:

Increment:
prisma.table.update({
  where: { id: 1234 },
  data: {views: {increment: 1}}
});

Decrement:
prisma.table.update({
  where: { id: 1234 },
  data: {views: {increment: -1}}
});

[ujjwal-kr]

there is a decrement by now

[janpio]

Indeed: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#operators