sqflite library

Classes

Batch
A batch is used to perform multiple operation as a single atomic unit. A Batch object can be acquired by calling Database.batch. It provides methods for adding operation. None of the operation will be executed (or visible locally) until commit() is called.
Database
Database to send sql commands, created during openDatabase
DatabaseExecutor
Common API for Database and Transaction to execute SQL commands
DatabaseFactory
Basic databases operations
OpenDatabaseOptions
Options for opening the database see openDatabase for details
Sqflite
sqflite plugin
SqfliteOptions
internal options. [...]
Transaction
Database transaction to use during a transaction

Constants

inMemoryDatabasePath → const String
":memory:"

Properties

databaseFactory DatabaseFactory
read-only
onDatabaseDowngradeDelete OnDatabaseVersionChangeFn
final

Functions

deleteDatabase(String path) → Future<void>
Delete the database at the given path
getDatabasesPath() → Future<String>
Get the default databases location [...]
onDatabaseVersionChangeError(Database db, int oldVersion int newVersion) → Future<void>
to specify during openDatabase for onDowngrade Downgrading will always fail
openDatabase(String path, { int version, OnDatabaseConfigureFn onConfigure, OnDatabaseCreateFn onCreate, OnDatabaseVersionChangeFn onUpgrade, OnDatabaseVersionChangeFn onDowngrade, OnDatabaseOpenFn onOpen, bool readOnly: false bool singleInstance: true }) → Future<Database>
Open the database at a given path [...]
openReadOnlyDatabase(String path) → Future<Database>
Open the database at a given path in read only mode

Enums

ConflictAlgorithm

Typedefs

OnDatabaseConfigureFn(Database db) → FutureOr<void>
OnDatabaseCreateFn(Database db, int version) → FutureOr<void>
OnDatabaseOpenFn(Database db) → FutureOr<void>
OnDatabaseVersionChangeFn(Database db, int oldVersion int newVersion) → FutureOr<void>

Exceptions / Errors

DatabaseException