ex-objection-query-builder

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.

Parameter	Type	Default	Description
columns	string[]	[]	An array containing the columns to filter
value	string	undefined	The value to filter
options	object	{}	A set of configurations for the filter (see options object)

# options object

Property	Type	Default	Description
ignoreAccent	boolean	true	Ignore words accents
ignoreCase	boolean	true	Ignore words case
ignoreMask	boolean	true	Remove any mask (-.,()/\[]) of the informed value

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