whereNotIn method

QueryBuilder whereNotIn(
  1. String field,
  2. List values
)

WHERE NOT IN clause

Implementation

QueryBuilder whereNotIn(String field, List<dynamic> values) {
  if (values.isEmpty) {
    _wheres.add('1 = 1'); // Always true if no values
    return this;
  }

  final paramNames = List.generate(values.length, (i) {
    final paramName = 'p${_paramIndex++}';
    _bindings[paramName] = values[i];
    return DB.driver == DBDriver.postgres ? ':$paramName' : '?';
  }).join(', ');

  _wheres.add('$field NOT IN ($paramNames)');
  return this;
}