dbmigrator_psql 0.1.2
dbmigrator_psql: ^0.1.2 copied to clipboard
PostgreSQL database migration library with file-based, versioned schema management supporting both upgrades and downgrades.
example/dbmigrator_psql_example.dart
import 'package:dbmigrator_psql/dbmigrator_psql.dart';
import 'package:postgres/postgres.dart';
void main() async {
final conn = await Connection.open(
Endpoint(host: 'localhost', database: 'test_db'),
settings: ConnectionSettings(sslMode: SslMode.disable),
);
final res = await conn.migrator(options: PsqlMigrationOptions(path: './migrations')).migrate(version: '2.0.0');
print(res.message); // "Migrated from 1.0.0 ➡ 2.0.0 in 3 seconds."
}