23 lines
827 B
Dart
23 lines
827 B
Dart
import 'package:path/path.dart';
|
|
import 'package:sqflite/sqflite.dart';
|
|
|
|
Future<void> openSqliteDatabase() async {
|
|
final database = openDatabase(
|
|
// Set the path to the database. Note: Using the `join` function from the
|
|
// `path` package is best practice to ensure the path is correctly
|
|
// constructed for each platform.
|
|
join(await getDatabasesPath(), 'immich_database.db'),
|
|
|
|
// When the database is first created, create a table to store dogs.
|
|
onCreate: (db, version) {
|
|
// Run the CREATE TABLE statement on the database.
|
|
return db.execute(
|
|
'CREATE TABLE dogs(id INTEGER PRIMARY KEY, name TEXT, age INTEGER)',
|
|
);
|
|
},
|
|
// Set the version. This executes the onCreate function and provides a
|
|
// path to perform database upgrades and downgrades.
|
|
version: 1,
|
|
);
|
|
}
|