Dox Migration

Database migration package for Postgres SQL.

Usage

Create migration file

.sql file

dox_migration create CreateUserTable --sql 

.dart file

dox_migration create CreateUserTable --dart 

.dart file required dox query builder

Run migration and rollback

.env sample

DB_HOST=localhost
DB_PORT=5432
DB_NAME=dox_example_app
DB_USERNAME=admin
DB_PASSWORD=password

Migrate

await Migration().migrate();

Rollback

await Migration().rollback();

Without using .env

PgEndpoint endPoint = PgEndpoint(
    host: 'localhost',
    port: 5432,
    database: 'postgres',
    username: 'postgres',
    password: 'postgres',
);
await Migration().migrate(endPoint: endPoint);