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
-
getVersion(
) → Future< int> -
Available on DatabaseExecutor, provided by the SqfliteDatabaseExecutorExt extension
Get the database inner version -
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.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
bufferSizeSee 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)
-
setVersion(
int version) → Future< void> -
Available on DatabaseExecutor, provided by the SqfliteDatabaseExecutorExt extension
Set the database inner version Used internally for open helpers and automatic versioning -
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