sqflite_migrations_with_multiverse_time_travel 0.2.0

Runs database migrations for apps using sqflite. Check out different branches during development without having to reset the db.

Sqflite Migrations with Multiverse Time Travel

This is an integration for db_migrations_with_multiverse_time_travel.

Usage

import 'package:sqflite_migrations_with_multiverse_time_travel/sqflite_migrations_with_multiverse_time_travel.dart';
import 'package:sqflite_common_ffi/sqflite_ffi.dart';

final migrations = [
  Migration(
    definedAt: DateTime.utc(2025, 3, 14, 1),
    up: """
create table users (
  id integer primary key autoincrement,
  name text not null
);

insert into users (name) values ('Alice');
insert into users (name) values ('Bob');
""",
    down: """
drop table users;
""",
  ),
];

Future<void> main() async {
  sqfliteFfiInit();

  var databaseFactory = databaseFactoryFfi;
  var db = await databaseFactory.openDatabase(inMemoryDatabasePath);

  await SqfliteDatabase(db).migrate(migrations);

  for (final row in await db.query('users')) {
    print(row);
  }

  await db.close();
}