delete method

@override Future<int> delete({ Filter<ModelBase> where(TMeta t)?, bool? useIsolate, bool all = false, })

Implementation

@override
Future<int> delete({
  Filter Function(TMeta t)? where,
  bool? useIsolate,
  bool all = false,
}) async {
  assert(
    all || where != null,
    'Either provide where query or specify all = true to delete all.',
  );
  final db = await dbContext.database;
  final formattedQuery =
      where != null ? await whereString(where, useIsolate: useIsolate) : null;
  return db.transaction<int>((txn) async {
    final batch = txn.batch()
      ..delete(
        t.tableName,
        where: formattedQuery?.filter,
        whereArgs: formattedQuery?.whereArgs,
      );
    final result = await batch.commit(
      noResult: false,
      continueOnError: false,
    );
    if (result.isEmpty) {
      return 0;
    }
    final res = result[0];
    if (res is int) {
      return res;
    }
    return 0;
  });
}