Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Knex.js - How To Update a Field With An Expression

How do we get Knex to create the following SQL statement:

UPDATE item SET qtyonhand = qtyonhand + 1 WHERE rowid = 8

We're currently using the following code:

knex('item')
    .transacting(trx)
    .update({qtyonhand: 10})
    .where('rowid', 8)

However, in order for our inventory application to work in a multi-user environment we need the qtyonhand value to add or subtract with what's actually in the database at that moment rather than passing a value that may be stale by the time the update statement is executed.

like image 702
A2MetalCore Avatar asked Feb 13 '17 19:02

A2MetalCore


1 Answers

Here are 2 different ways

knex('item').increment('qtyonhand').where('rowid',8)

or

knex('item').update({
  qtyonhand: knex.raw('?? + 1', ['qtyonhand'])
}).where('rowid',8)
like image 55
Mikael Lepistö Avatar answered Sep 28 '22 10:09

Mikael Lepistö