dbutils 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
SqfliteDarwin: Darwin specific implementation.
SqfliteOptions: internal options.
SqflitePlugin: sqflite Plugin registration.
SQLiteDB: SQLite helper class
Transaction: Database transaction to use during a transaction

DatabaseFactoryLoggerDebugExt on DatabaseFactory: Debug extension for Logger.
SqfliteDatabaseAndroidExt on Database: Android only API
SqfliteDatabaseExecutorExt on DatabaseExecutor: Helpers
SqfliteDatabaseFactoryDebug on DatabaseFactory: Debug extension

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

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

Func = Future<bool> Function(): Signature of callbacks that have no arguments and return no data.
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.