BriteDatabaseExecutor class abstract

Common API for BriteDatabase and BriteTransaction to execute SQL commands.

Implemented types
Implementers
Available Extensions

Constructors

BriteDatabaseExecutor()

Properties

database Database
Get the database.
no setterinherited
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.
inherited
delete(String table, {String? where, List<Object?>? whereArgs}) Future<int>
Convenience method for deleting rows in the database.
inherited
execute(String sql, [List<Object?>? arguments]) Future<void>
Execute an SQL query with no return value.
inherited
executeAndTrigger(Iterable<String> tables, String sql, [List<Object?>? arguments]) Future<void>
See execute
insert(String table, Map<String, Object?> values, {String? nullColumnHack, ConflictAlgorithm? conflictAlgorithm}) Future<int>
This method helps insert a map of values into the specified table and returns the id of the last inserted row.
inherited
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.
inherited
queryCursor(String table, {bool? distinct, List<String>? columns, String? where, List<Object?>? whereArgs, String? groupBy, String? having, String? orderBy, int? limit, int? offset, int? bufferSize}) Future<QueryCursor>
See DatabaseExecutor.rawQueryCursor for details about the argument bufferSize See DatabaseExecutor.query for the other arguments.
inherited
rawDelete(String sql, [List<Object?>? arguments]) Future<int>
Executes a raw SQL DELETE query and returns the number of changes made.
inherited
rawDeleteAndTrigger(Iterable<String> tables, String sql, [List<Object?>? arguments]) Future<int>
See rawDelete
rawInsert(String sql, [List<Object?>? arguments]) Future<int>
Executes a raw SQL INSERT query and returns the last inserted row ID.
inherited
rawInsertAndTrigger(Iterable<String> tables, String sql, [List<Object?>? arguments]) Future<int>
See rawInsert
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.
inherited
rawQueryCursor(String sql, List<Object?>? arguments, {int? bufferSize}) Future<QueryCursor>
Executes a raw SQL SELECT with a cursor.
inherited
rawUpdate(String sql, [List<Object?>? arguments]) Future<int>
Executes a raw SQL UPDATE query and returns the number of changes made.
inherited
rawUpdateAndTrigger(Iterable<String> tables, String sql, [List<Object?>? arguments]) Future<int>
See rawUpdate
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
inherited

Operators

operator ==(Object other) bool
The equality operator.
inherited