delete method

  1. @override
Future<int> delete()

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());
  }
}