ex-objection-query-builder v1.1.3

Extended Objection Query Builder

An extended query builder for Objection.js.
This package adds extra methods to the Objection.js query builder.

Installation

npm install ex-objection-query-builder

or

yarn add ex-objection-query-builder

How to use

Just require the package in your model and then override the QueryBuilder method.
Example:

const { Model } = require('objection');
const { ExObjectionQueryBuilder } = require('ex-objection-query-builder');

class User extends Model {
  static get QueryBuilder() {
    return ExObjectionQueryBuilder;
  }
}

Methods

All the available methods are listed below

# whereLike(columns = [], value, options = {})

Search for results that contains the specified value at the specifieds columns.

# options object

Important:

The ignoreAccent is working only with postgres because of the use of unaccentfunction.
To use it you need to activate this function. For that just ran the following:

CREATE EXTENSION unaccent;

The ignoreCase also works only with postgres because of the operator ILIKE