Atomic operations: update row based on current value

[john-prutton]

I'm wondering if it is possible to update a row's value based on its current value. Maybe I would need to use the magic sql helper with sql.fromList? Any help is appreciated. :)

-- sql syntax
UPDATE products
SET stock = stock - 1
WHERE product_id IN (1, 2, 3, 4, 5);

// drizzle syntax
  await db
    .update(products)
    .set({ stock: products.stock - 1 }) // what I would like
    .where(inArray(products.id, productIds));

[Angelelz]

Yes, for this type of operations you need the sql operator:

  await db
    .update(products)
    .set({ stock: sql`${products.stock} - 1` })
    .where(inArray(products.id, productIds));