hhpack/migrate

Lightweight migration tool for Hack

migrate

, _(*1)

Basic usage

First place the database.json of the configuration file in the config directory.
Please specify the setting referring to the following., _(*2)

• type - the type of migration, it only supports SQL base.
• path - the directory of the migration file.
• enviroments - Database connection setting for environment.

{
  "type": "sql",
  "path": "db/migrate",
  "enviroments": {
    "development": {
      "host": "localhost",
      "port": 3306,
      "name": "migrate",
      "user": { "ENV": "DB_USERNAME" },
      "password": { "ENV": "DB_PASSWORD" }
    }
  }
}

Create a database

You can run the create command to create the database., _(*3)

vendor/bin/migrate create

Generate a migration file

Use the gen command to generate a migration file., _(*4)

vendor/bin/migrate gen create-users

Upgrade of schema

Use the up command to upgrade the schema.
You can upgrade to a specific version by specifying the --to option., _(*5)

vendor/bin/migrate up

or, _(*6)

vendor/bin/migrate up --to=20150824010439-create-users

Downgrade of schema

To downgrade to the specified version, use the down command., _(*7)

vendor/bin/migrate down 20150824010439-create-users

Reset of schema

Restore all applied migrations., _(*8)

vendor/bin/migrate reset

Drop database

You can delete the database with the following command., _(*9)

vendor/bin/migrate drop

Migrator

Current version supports SQL based migration., _(*10)

use HHPack\Migrate\Migrator;
use HHPack\Migrate\SqlMigrationLoader;
use HHPack\Migrate\DatabaseClient;

$mysql = await DatabaseClient::createConnection('mysql:dbname=migrate;port=3306', 'migrate', 'migrate');
$loader = new SqlMigrationLoader(__DIR__ . '/sql/migrations');

$migrator = new Migrator($loader, $mysql);

await $migrator->upgrade();

Downgrade of schema

use HHPack\Migrate\Migrator;
use HHPack\Migrate\SqlMigrationLoader;
use HHPack\Migrate\DatabaseClient;

$mysql = await DatabaseClient::createConnection('mysql:dbname=migrate;port=3306', 'migrate', 'migrate');
$loader = new SqlMigrationLoader(__DIR__ . '/sql/migrations');

$migrator = new Migrator($loader, $mysql);

await $migrator->downgrade('20150825102100-create-posts');

Run the test

1. Create a database, _(*11)

   CREATE USER 'migrate'@'localhost' IDENTIFIED BY 'migrate';

2. Create a user, _(*12)

   GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON migrate.* TO 'migrate'@'localhost';

3. Execute unit test, _(*13)

   You can run the test with the following command., _(*14)

   composer install
   composer test