whereBetween method

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

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

Implementation

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

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

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

  return this;
}