pckg/migrator

Database and config migrations made simple

Migrator

, _(*1)

, _(*2)

Usage

Register Pckg\Migration\Provider\Migration provider in your application. This is only needed if you don't use Pckg\Framework\Provider\Framework., _(*3)

...
use Pckg\Migration\Provider\Migration;
...
public function providers()
{
    return [
        Migration::class,
    ];
}

Consoles

All commands are app-scoped and need to be prefixed with php console $appName., _(*4)

migrator:install - Install migrations from environment, _(*5)

• --only=SomeMigration - Install only listed migrations
• --fields - Install only fields (no indexes/key)
• --indexes - Install only indexes/key (no fields)
• --yes - Say yes to all questions
• --clear - Clear cache before and after
• --retry=1 - Retry iterations
• --repository=default - Install only repository

Create a migration

<?php

namespace Foo\Migration;

use Foo\Migration\SomeMigration;

class SomeMigration extends \Pckg\Framework\Provider
{

    public function up()
    {
        $clients = $this->table('clients');
        $clients->deletable();
        $clients->varchar('name');
        $clients->json('props');

        $projects = $this->table('projects');
        $projects->timeable();
        $projects->deletable();
        $projects->integer('client_id')->references('clients');
        $projects->varchar('name');

        $this->save();
    }
}

Apply migration

List your migrations in ./config/migrations.php or ./app/$app/config/migrations.php., _(*6)

<?php

use Foo\Migration\SomeMigration;

return [
    SomeMigration::class,
];

Or add your migration to the Provider., _(*7)

<?php

namespace Foo\Provider;

use Pckg\Framework\Provider;
use Foo\Migration\SomeMigration;

class Feature extends Provider
{

    public function migrations()
    {
        return [
            SomeMigration::class,
        ];
    }
}

And then execute migrations:, _(*8)

# php console $appName migrator:install, _(*9)