whereNotBetween method

QueryBuilder whereNotBetween(
  1. String field,
  2. dynamic start,
  3. dynamic end
)

Adds a WHERE condition that filters field NOT between start and end.

Implementation

QueryBuilder whereNotBetween(String field, dynamic start, dynamic end) {
  final paramStart = 'p${_paramIndex++}';
  final paramEnd = 'p${_paramIndex++}';

  if (DB.driver == DBDriver.postgres) {
    _wheres.add('$field NOT BETWEEN :$paramStart AND :$paramEnd');
  } else {
    _wheres.add('$field NOT BETWEEN ? AND ?');
  }

  _bindings[paramStart] = start;
  _bindings[paramEnd] = end;

  return this;
}