whereIn method

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

WHERE IN clause

Implementation

QueryBuilder whereIn(String field, List<dynamic> values) {
  if (values.isEmpty) {
    _wheres.add('1 = 0'); // Always false 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 IN ($paramNames)');
  return this;
}