delete method
Implementation
Future<int> delete(ISQLiteItem item) async {
var db = await getOpenDatabase();
final primaryKeyValue = item.toMap()[item.getPrimaryKeyName()];
var rowsDeleted = 0;
if (primaryKeyValue != null) {
rowsDeleted = await db.delete(
item.getTableName(),
where: '${item.getPrimaryKeyName()} = ?',
whereArgs: [primaryKeyValue],
);
} else {
// Handle the case where the primary key is null (e.g., raise an error).
// Return 0 to indicate that no rows were deleted.
}
return rowsDeleted;
}