Drizzle Team•10mo ago

increase or decrease values

using the the db update, is there anyway to increase or decrease a number value without having to get it first from the database?

5 Replies

Mykhailo•10mo ago

Hello, @hk! Try something like this:

await db
      .update(users)
      .set({ logins: sql`${users.logins} + 1`})
      .where(eq(users.id, id));

await db
      .update(users)
      .set({ logins: sql`${users.logins} + 1`})
      .where(eq(users.id, id));

hk•10mo ago

yeah exactly what I tried and seems to work @solo is it possible to make the + like this?

const operator = isIncrease === true ? '+' : '-'

const operator = isIncrease === true ? '+' : '-'

hk•10mo ago

but it seems like sql operator is putting the value as the actual string '+' instead of just +

Mykhailo•10mo ago

@hk ye, unfortunately, it doesn't work, but you can try this way:

 const isIncrease = false;
 const credit = 1;

const response = await db
  .update(users)
  .set({
    logins: sql`${users.logins} + ${isIncrease ? credit : -credit}`,
  })

 const isIncrease = false;
 const credit = 1;

const response = await db
  .update(users)
  .set({
    logins: sql`${users.logins} + ${isIncrease ? credit : -credit}`,
  })

hk•10mo ago

yeah that make sense thanks!

Gaming

Programming

increase or decrease values