Database class abstract

Database to send sql commands, created during openDatabase

Implemented types
Available Extensions

Constructors

Database()

Properties

database Database
Get the database.
no setterinherited
hashCode int
The hash code for this object.
no setterinherited
isOpen bool
Tell if the database is open, returns false once close has been called
no setter
path String
The path of the database
no setter
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
close() Future<void>
Close the database. Cannot be accessed anymore
delete(String table, {String? where, List<Object?>? whereArgs}) Future<int>
Convenience method for deleting rows in the database.
inherited
devInvokeMethod<T>(String method, [Object? arguments]) Future<T>
testing only
devInvokeSqlMethod<T>(String method, String sql, [List<Object?>? arguments]) Future<T>
testing only
execute(String sql, [List<Object?>? arguments]) Future<void>
Execute an SQL query with no return value.
inherited
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
rawInsert(String sql, [List<Object?>? arguments]) Future<int>
Executes a raw SQL INSERT query and returns the last inserted row ID.
inherited
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
readTransaction<T>(Future<T> action(Transaction txn)) Future<T>
Read-only transaction (experimental, for now only supported in async_sqlite, use a normal transaction otherwise)
toString() String
A string representation of this object.
inherited
transaction<T>(Future<T> action(Transaction txn), {bool? exclusive}) Future<T>
Calls in action must only be done using the transaction object using the database will trigger a dead-lock.
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