Description:
sqflite migration
Migrate your mobile sqlite database #
Library to manage sqlite db migrations using sqflite plugin.
Getting Started #
import 'package:path/path.dart';
import 'package:sqflite/sqflite.dart';
import 'package:sqflite_migration/sqflite_migration.dart';
final initialScript = [
'''
create table _todo_list (
id integer primary key autoincrement,
alias text not null
)
''',
'''
create table _task (
id integer primary key autoincrement,
description text,
todo_list_id integer not null,
CONSTRAINT fk_todo_lists
FOREIGN KEY (todo_list_id)
REFERENCES _todo_list(id)
);
'''
];
final migrations = [
'''
alter table _task add column done integer default 0;
'''
];
final config = MigrationConfig(initializationScript: initialScript, migrationScripts: migrations);
Future<Database> open() async {
final databasesPath = await getDatabasesPath();
final path = join(databasesPath, 'test.db');
return await openDatabaseWithMigration(path, config);
}
copied to clipboard
License
For personal and professional use. You cannot resell or redistribute these repositories in their original state.
Customer Reviews
There are no reviews.
