graph_sqlite 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
- QueryCursor
- Cursor for query by page cursor.
- Sqflite
- sqflite plugin
- SqfliteOptions
- internal options.
- SqflitePlugin
- sqflite Plugin registration.
- Transaction
- Database transaction to use during a transaction
Enums
- ConflictAlgorithm
- Insert/Update conflict resolver
Extensions
- DatabaseFactoryLoggerDebugExt on DatabaseFactory
- Debug extension for Logger.
- SqfliteDatabaseAndroidExt on Database
- Android only API
- SqfliteDatabaseExecutorExt on DatabaseExecutor
- Helpers
- SqfliteDatabaseFactoryDebug on DatabaseFactory
- Debug extension
Constants
- inMemoryDatabasePath → const String
- Special database name opened in memory
Properties
- databaseFactory ↔ DatabaseFactory
-
sqflite Default factory.
getter/setter pair
- databaseFactoryOrNull ↔ DatabaseFactory?
-
Default database factory.
getter/setter pair
- databaseFactorySqflitePlugin → DatabaseFactory
-
Default factory that uses the plugin.
no setter
- onDatabaseDowngradeDelete → OnDatabaseVersionChangeFn
-
Downgrading will delete the database and open it again.
final
- sqfliteLogLevelNone → int
-
No logs
final
- sqfliteLogLevelSql → int
-
Log native sql commands
final
- sqfliteLogLevelVerbose → int
-
Log native verbose
final
Functions
-
databaseExists(
String path) → Future< bool> - Check if a database exists at a given path.
-
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, {bool? singleInstance = true}) → Future< Database> - Open the database at a given path in read only mode
Typedefs
-
OnDatabaseConfigureFn
= FutureOr<
void> Function(Database db) -
Prototype of the function called before calling
onCreate
/onUpdate
/onOpen
when the database is open. -
OnDatabaseCreateFn
= FutureOr<
void> Function(Database db, int version) - Prototype of the function called when the database is created.
-
OnDatabaseOpenFn
= FutureOr<
void> Function(Database db) - Prototype of the function called when the database is open.
-
OnDatabaseVersionChangeFn
= FutureOr<
void> Function(Database db, int oldVersion, int newVersion) - Prototype of the function called when the version has changed.
Exceptions / Errors
- DatabaseException
- Wrap sqlite native exception