deleteWhere method

SqlWrite deleteWhere(
  1. SqlTable<Object?> table, {
  2. required SqlPredicate where,
})

Creates a DELETE constrained by where.

Implementation

SqlWrite deleteWhere(SqlTable<Object?> table, {required SqlPredicate where}) {
  final builder = _BoundSqlBuilder(dialect)
    ..write('DELETE FROM ')
    ..write(_quoteTable(table))
    ..write(' WHERE ');
  _writePredicate(
    builder,
    <SqlTable<Object?>>[table],
    const <SqlTable<Object?>, String>{},
    where,
  );
  return SqlWrite._(builder.build(kind: SqlStatementKind.write), table);
}