deleteAll method

Future<int> deleteAll(
  1. List<ISQLiteItem> items
)

Implementation

Future<int> deleteAll(List<ISQLiteItem> items) async {
  var db = await getOpenDatabase();
  int totalDeleted = 0;

  await db.transaction((txn) async {
    for (var item in items) {
      final id = item.getPrimaryKey();

      if (id != null) {
        int rowsDeleted = await txn.delete(
          item.getTableName(),
          where: '${item.getPrimaryKeyName()} = ?',
          whereArgs: [id],
        );
        if (rowsDeleted > 0) {
          totalDeleted++;
        }
      }
    }
  });

  return totalDeleted;
}