fiisoft/phinx

Console-commands to use Phinx's library console-commands in custom console application (based on symfony/console package).

FiiSoft Phinx

Console-commands to use Phinx's library console-commands in custom console application (based on symfony/console package)., _(*1)

My advice is - do not use it unless you are enough strong mentally to immune for such bad code., _(*2)

It contains wrappers for Phinx's commands:, _(*3)

• breakpoint
• create
• migrate
• rollback
• seed:create
• seed:run
• status
• test

It also contains six special commands (not available in Phinx): * mark - marks migration as migrated without migrating it (adds entry log to phinxlog so migration seems to be already migrated) * unmark - removes entry log from phinxlog, without rollback on migration (so migration will be migrated on next migrate) * repeat - repeats single migration (specified by its version number) even if migrated * revoke - performs rollback on single migration (specified by its version number) * remove - removes entry log from phinxlog and deletes corresponding migration file from disk * cleanup - removes entries of missing migrations from phinxlog (if files are not available), _(*4)

In addition, it comes with special generic-purpose command phinx which allows to run other Phinx-specific commands in special way., _(*5)

Keep in mind that this library uses its own configuration-schema as well as template for migrations classes and base abstract class for them., _(*6)

The main goal of this custom configuration is to manage migrations for many destiny databases (in various environments). Therefore configurations are grouped in something called "destiny"., _(*7)

Here are some examples., _(*8)

• The simplest possible (aka minimal required) configuration:

$config = new PhinxConfig([
    'local' => [
        'environments' => [
            'dev' => [
                'adapter' => 'pgsql',
                'host' => 'localhost',
                'name' => 'dbname',
                'user' => 'username',
                'pass' => 'password',
            ]
        ],
    ]
]);

This creates config for one destiny called local with one environment dev. Migration files for this destiny will be stored in (current working directory)/phinx/local/migrations directory. Notice that the name of destiny becames part of path., _(*9)

• Similar configuration but with path to files with migrations in specified directory without name of destiny:

$config = new PhinxConfig([
    'local' => [
        'paths_root' => __DIR__ . DIRECTORY_SEPARATOR . 'phinx',
        'environments' => [
            'dev' => [
                'adapter' => 'pgsql',
                'host' => 'localhost',
                'name' => 'dbname',
                'user' => 'username',
                'pass' => 'password',
            ]
        ],
    ]
]);

In this case path to migration files is __DIR__/phinx/migrations - there is no name of destiny local in path., _(*10)

• Third way to create the simplest configuration is to specify path to directory with migrations like this:

$config = new PhinxConfig([
    'defaults' => [
        'phinx_files' => __DIR__ . DIRECTORY_SEPARATOR . 'dev',
    ],
    'local' => [
        'environments' => [
            'dev' => [
                'adapter' => 'pgsql',
                'host' => 'localhost',
                'name' => 'dbname',
                'user' => 'username',
                'pass' => 'password',
            ]
        ],
    ]
]);

This defines root folder for all destinations. The path for migration files for local is now __DIR__/dev/local/migrations., _(*11)

To handle various different sets of migrations reffered to the same database, use:, _(*12)

$config = new PhinxConfig([
    'defaults' => [
        'adapter' => 'pgsql',
        'host' => 'localhost',
        'name' => 'dbname',
        'user' => 'username',
        'pass' => 'password',
    ],
    'alpha' => [
      'environments' => [
          'dev' => [
          ],
      ],
    ],
    'bravo' => [
      'environments' => [
          'dev' => [
          ],
          'default_migration_table' => 'phinx_migrations',
      ],
    ],
];

This configuration defines two destinations: alpha and bravo., _(*13)

Migration files for alpha will be stored in (current working directory)/phinx/alpha/migrations and the name of the table used by Phinx will be phinxlog (as default)., _(*14)

Migration files for bravo will be stored in (current working directory)/phinx/bravo/migrations and the name of the table used by Phinx will be phinx_migrations., _(*15)

Because there are no other data specified, both destinations will share the same database, so it gives possibility to handle various sets of migrations for the same database., _(*16)

There is also a bin/finx executable file provided with library. Usage of it is a bit hard to explain because it uses its own schema of arguments., _(*17)

Some examples (lets assume the local destination is defined in configuration):, _(*18)

• bin/finx list show list of available commands
• bin/finx the same as above (command list is default)
• bin/finx phinx show help for generic command (phinx)
• bin/finx phinx local status show status of migrations from destiny local
• bin/finx phinx local the same as above (command status is default)
• bin/finx local the same as above (status is default, keyword phinx can be omitted)
• bin/finx phinx:status local the same as above (by direct call of command status)

Some examples of call command migrate with environment dev from destination local, in different ways (and all do exactly the same!):, _(*19)

• bin/finx phinx local migrate -e dev
• bin/finx phinx local dev migrate
• bin/finx phinx local migrate
• bin/finx phinx:migrate local -e dev
• bin/finx phinx:migrate local dev
• bin/finx phinx:migrate local
• bin/finx local migrate -e dev
• bin/finx local dev migrate
• bin/finx local migrate (this one I prefer)

As you can see, it's a bit crazy., _(*20)