A database schema migration tool, to execute the proper sequence of SQL commands that are required to get your DB to the desired state.
The sequence of operations is defined by the sorted order of versions.
Versions are semver, and single numbers (1
, 2
)
will be transformed accordingly (1.0.0
, 2.0.0
).
A simple usage example:
import 'dart:async';
import 'package:db_schema_migration/db_schema_migration.dart';
import 'package:db_schema_migration/postgresql.dart';
import 'package:postgresql/postgresql.dart';
Future main() async {
Connection connection = await _getConnection();
var migrator = new PostgresqlSchemaMigrator();
var migrations = new Migrations();
migrations.add(1,
'CREATE TABLE user(name VARCHAR(127) PRIMARY KEY, password_hash VARCHAR(127));');
migrations.add(2, 'ALTER TABLE user ADD COLUMN address varchar(127);');
await migrator.migrate(connection, 'user', migrations);
// Now the DB has a user table with name, password_hash and address columns.
}
How to group migrations:
How to version migrations:
1
, 2
, 3
, ...20161204.1
, 20161204.2
, ...20161204.134.1
, 20161204.134.2
, ...Add this to your package's pubspec.yaml file:
dependencies:
db_schema_migration: ^0.0.1
You can install packages from the command line:
with pub:
$ pub get
Alternatively, your editor might support pub get
.
Check the docs for your editor to learn more.
Now in your Dart code, you can use:
import 'package:db_schema_migration/db_schema_migration.dart';
Version | Uploaded | Documentation | Archive |
---|---|---|---|
0.0.1 | Dec 4, 2016 |
|
|
Popularity:
Describes how popular the package is relative to other packages.
[more]
|
0
|
Health:
Code health derived from static analysis.
[more]
|
--
|
Maintenance:
Reflects how tidy and up-to-date the package is.
[more]
|
--
|
Overall:
Weighted score of the above.
[more]
|
0
|
The package version is not analyzed, because it does not support Dart 2. Until this is resolved, the package will receive a health and maintenance score of 0.
Support Dart 2 in pubspec.yaml
.
The SDK constraint in pubspec.yaml
doesn't allow the Dart 2.0.0 release. For information about upgrading it to be Dart 2 compatible, please see https://www.dartlang.org/dart-2#migration.
Make sure dartdoc
successfully runs on your package's source files. (-10 points)
Dependencies were not resolved.
Package | Constraint | Resolved | Available |
---|---|---|---|
Direct dependencies | |||
Dart SDK | >=1.0.0 <2.0.0 |