Schema
import { pgTable, serial, text, integer } from 'drizzle-orm';
export const users = pgTable('users', {
id: serial('id').primaryKey(),
name: text('name').notNull(),
logins: integer('logins').notNull().default(0),
});To increment or decrement the number of logins (logins) for a user, use the update (update) query with your own isIncrease variable and conditional operator.
import { eq, sql } from 'drizzle-orm';
const isIncrease = false;
const credit = 1;
const id = 1
await db
.update(users)
.set({
logins: sql`${users.logins} + ${isIncrease ? credit : -credit}`,
})
.where(eq(users.id, id));