DatabaseExecutor class abstract
Common API for Database and Transaction to execute SQL commands
Constructors
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
batch(
) → Batch - Creates a batch, used for performing multiple operation in a single atomic operation.
-
delete(
String table, {String? where, List< Object?> ? whereArgs}) → Future<int> - Convenience method for deleting rows in the database.
-
execute(
String sql, [List< Object?> ? arguments]) → Future<void> - Execute an SQL query with no return value.
-
insert(
String table, Map< String, Object?> values, {String? nullColumnHack, ConflictAlgorithm? conflictAlgorithm}) → Future<int> -
This method helps insert a map of
valuesinto the specifiedtableand returns the id of the last inserted row. -
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
query(
String table, {bool? distinct, List< String> ? columns, String? where, List<Object?> ? whereArgs, String? groupBy, String? having, String? orderBy, int? limit, int? offset}) → Future<List< Map< >String, Object?> > - This is a helper to query a table and return the items found. All optional clauses and filters are formatted as SQL queries excluding the clauses' names.
-
rawDelete(
String sql, [List< Object?> ? arguments]) → Future<int> - Executes a raw SQL DELETE query and returns the number of changes made.
-
rawInsert(
String sql, [List< Object?> ? arguments]) → Future<int> - Executes a raw SQL INSERT query and returns the last inserted row ID.
-
rawQuery(
String sql, [List< Object?> ? arguments]) → Future<List< Map< >String, Object?> > - Executes a raw SQL SELECT query and returns a list of the rows that were found.
-
rawUpdate(
String sql, [List< Object?> ? arguments]) → Future<int> - Executes a raw SQL UPDATE query and returns the number of changes made.
-
toString(
) → String -
A string representation of this object.
inherited
-
update(
String table, Map< String, Object?> values, {String? where, List<Object?> ? whereArgs, ConflictAlgorithm? conflictAlgorithm}) → Future<int> - Convenience method for updating rows in the database. Returns the number of changes made
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited