Use operators 'like` or 'greater than' in Knex query with object syntax

Question

I'm using JSON objects to build Knex queries like this:

{where: {id: '5'}

How can I use the same query format (object syntax) with operators like like or greater than ?

Answer 1

You can use where/andWhere. The code below shows an update that only happens if the user_id = userId and book_reference = bookName and if result < res.

knex('user_books')
    .where({
      user_id: userId,
      book_reference: bookName
    })
    .andWhere('result', '<', res)
    .update({
      'updated_at': bookshelf.knex.raw('CURRENT_TIMESTAMP'),
      'text_done': true,
    })

Answer 2

I don't think it's possible. Looking at the relevant source code of the query builder, it looks like:

_objectWhere(obj) {
  const boolVal = this._bool();
  const notVal = this._not() ? 'Not' : '';
  for (const key in obj) {
    this[boolVal + 'Where' + notVal](key, obj[key]);
  }
  return this;
}

Which basically calls the appropiate Where function with just two parameters (thus no operator, which means =)