sqlite_api 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.
- Transaction
- Database transaction to use during a transaction
Enums
- ConflictAlgorithm
- Insert/Update conflict resolver
Extensions
- DatabaseFactoryLoggerDebugExt on DatabaseFactory
- Debug extension for Logger.
- SqfliteDatabaseExecutorExt on DatabaseExecutor
- Helpers
- SqfliteDatabaseFactoryDebug on DatabaseFactory
- Debug extension
Constants
- inMemoryDatabasePath → const String
- Special database name opened in memory
Properties
- 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
-
onDatabaseVersionChangeError(
Database db, int oldVersion, int newVersion) → Future< void> -
to specify during openDatabase for
onDowngrade
Downgrading will always fail
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