executeDelete<T> method
Executes an SQL DELETE query and returns the result as a SQLResponseOf object.
The tableName
parameter specifies the name of the table to delete from.
The where
parameter is a JsonRow object representing the WHERE clause.
The nullAsBlank
parameter specifies whether to treat null values as blank.
The transform
parameter is an optional function to transform the query result.
Implementation
Future<SQLResponseOf<T>> executeDelete<T>({required String tableName, JsonRow where = const {}, bool nullAsBlank = false, T Function(dynamic)? transform}) {
return executeSQL(
dataSetType: "table",
transform: transform,
sql: where.asDeleteCommand(
tableName: tableName,
nullAsBlank: nullAsBlank,
quoteChar: quoteChar,
dataBaseProvider: dataBaseProvider,
),
);
}