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

DatabaseFactoryLoggerDebugExt on DatabaseFactory: Debug extension for Logger.
SqfliteDatabaseExecutorExt on DatabaseExecutor: Helpers
SqfliteDatabaseFactoryDebug on DatabaseFactory: Debug extension

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

onDatabaseVersionChangeError(Database db, int oldVersion, int newVersion) → Future<void>: to specify during openDatabase for onDowngrade Downgrading will always fail

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.