delete method
Delete rows from table and return number of changes.
var userEloquent = UserEloquent();
// delete all rows from users
userEloquent.delete();
// delete rows where name has 'j' from users
userEloquent.where('name','%j%',operator:Operator.like).delete();
Implementation
@override
Future<int> delete() async {
String query = 'Delete';
try {
resetSelectedColunns();
resetDistinct();
resetOrderBy();
resetGroupBy();
resetOffset();
var selectQuery =
generateQuery('Select $getPrimaryColumn from $tableName');
query +=
' FROM $tableName WHERE $tableName.$getPrimaryColumn IN ($selectQuery)';
resetAll();
Database _db = await getDatabase;
return await _db.rawDelete(query);
} catch (e) {
throw Exception('Generated query: "$query" \n' + e.toString());
}
}