Database class abstract
Database to send sql commands, created during openDatabase
- Implemented types
- Available extensions
Constructors
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
-
androidSetLocale(
String languageTag) → Future< void> -
Available on Database, provided by the SqfliteDatabaseAndroidExt extension
Sets the locale for this database. The specified IETF BCP 47 language tag string (en-US, zh-CN, fr-FR, zh-Hant-TW, ...) must be as defined inLocale.forLanguageTagin Android/Java documentation. -
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)
-
setJournalMode(
String journalMode) → Future< void> -
Available on Database, provided by the SqfliteDatabaseExt extension
On android, the recommended way is to set the journal mode in the manifest. if not setting the journal mode using execute will fail so rawQuery should be used instead, so this helper hides the issue. -
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