Class OperatorClauseTool

Compare.

Test all operators.

Test between operator.

Example

{
  between: [10, 20],
}
Copy

Test eq/neq operator.

Example

{
  eq: 'foo',
}
Copy

Example

{
  neq: 'foo',
}
Copy

Test exists operator.

Example

{
  exists: true,
}
Copy

Test lt/gt/lte/gte operator.

Example

{
  lt: 10,
}
Copy

Example

{
  lte: 10,
}
Copy

Example

{
  gt: 10,
}
Copy

Example

{
  gte: 10,
}
Copy

Test ilike operator.

Example

{
  ilike: 'foo',
}
Copy

Test inc operator.

Example

{
  inc: ['foo', 'bar'],
}
Copy

Test like operator.

Example

{
  like: 'foo',
}
Copy

Test nilike operator.

Example

{
  nilike: 'foo',
}
Copy

Test nin operator.

Example

{
  nin: ['foo', 'bar'],
}
Copy

Test nlike operator.

Example

{
  nlike: 'foo',
}
Copy

Test regexp.

Example

{
  regexp: 'foo.*',
}
Copy

Example

{
  regexp: 'foo.*',
  flags: 'i',
}
Copy