sqflite_migration 0.0.1 copy "sqflite_migration: ^0.0.1" to clipboard
sqflite_migration: ^0.0.1 copied to clipboard

outdated

Library to manage sqlite db migrations.

Build Status codecov

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';

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);
}