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
Extensions
- SqfliteDatabaseExecutorExt
- Helpers
- SqfliteDatabaseFactoryDebug
- Debug extension
Constants
- inMemoryDatabasePath → const String
-
Special database name opened in memory
':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
foronDowngrade
Downgrading will always fail
Enums
- ConflictAlgorithm
- Insert/Update conflict resolver
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