havingBetween method

  1. @override
QueryBuilder havingBetween(
  1. String column,
  2. List values, {
  3. String boolean = 'and',
  4. bool not = false,
})
inherited

Implementation

@override
QueryBuilder havingBetween(
  String column,
  List<dynamic> values, {
  String boolean = 'and',
  bool not = false,
}) {
  if (values.length < 2) {
    throw InvalidArgumentException(
      'The list of values must contain at least two items.',
    );
  }

  final paramName1 = _nextParamName();
  final paramName2 = _nextParamName();
  bindings[paramName1] = values[0];
  bindings[paramName2] = values[1];

  String clause =
      "$column ${not ? "NOT BETWEEN" : "BETWEEN"} :$paramName1 AND :$paramName2";
  if (_having.isEmpty) {
    _having.add(clause);
  } else {
    _having.add(" $boolean $clause");
  }
  return this;
}