2017 © Pedro Peláez
 

library phpmig

Simple migrations system for php

image

avalara/phpmig

Simple migrations system for php

  • Wednesday, January 10, 2018
  • by Avalara
  • Repository
  • 23 Watchers
  • 0 Stars
  • 16 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 74 Forks
  • 0 Open issues
  • 14 Versions
  • 0 % Grown

The README.md

Phpmig

Build
Status, (*1)

What is it?

Phpmig is a (database) migration tool for php, that should be adaptable for use with most PHP 5.3+ projects. It's kind of like doctrine migrations, without the doctrine. Although you can use doctrine if you want. And ironically, I use doctrine in my examples., (*2)

How does it work?

$ phpmig migrate

Phpmig aims to be vendor/framework independent, and in doing so, requires you to do a little bit of work up front to use it., (*3)

Phpmig requires a bootstrap file, that must return an object that implements the ArrayAccess interface with several predefined keys. We recommend returning an instance of Pimple, a simple dependency injection container. This is also an ideal opportunity to expose your own services to the migrations themselves, which have access to the container, such as a schema management abstraction., (*4)

Getting Started

The best way to install phpmig is using composer:, (*5)

$ curl -sS https://getcomposer.org/installer | php
$ php composer.phar require davedevelopment/phpmig

You can then use the localised version of phpmig for that project, (*6)

$ bin/phpmig --version

Phpmig can do a little configuring for you to get started, go to the root of your project and:, (*7)

$ phpmig init
+d ./migrations Place your migration files in here
+f ./phpmig.php Create services in here
$ 

Note that you can move phpmig.php to config/phpmig.php, the commands will look first in the config directory than in the root., (*8)

Phpmig can generate migrations using the generate command. Migration files are named versionnumber_name.php, where version number is made up of 0-9 and name is CamelCase or snake_case. Each migration file should contain a class with the same name as the file in CamelCase., (*9)

$ phpmig generate AddRatingToLolCats
+f ./migrations/20111018171411_AddRatingToLolCats.php
$ phpmig status

 Status   Migration ID    Migration Name 
-----------------------------------------
   down  20111018171929  AddRatingToLolCats

Use the migrate command to run migrations

$ phpmig migrate
 == 20111018171411 AddRatingToLolCats migrating
 == 20111018171411 AddRatingToLolCats migrated 0.0005s
$ phpmig status

 Status   Migration ID    Migration Name 
-----------------------------------------
     up  20111018171929  AddRatingToLolCats
$ 

Better Persistence

The init command creates a bootstrap file that specifies a flat file to use to track which migrations have been run, which isn't great. You can use the provided adapters to store this information in your database., (*10)

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    return $dbh;
};

$container['phpmig.adapter'] = function ($c) {
    return new Adapter\PDO\Sql($c['db'], 'migrations');
};

$container['phpmig.migrations_path'] = __DIR__ . DIRECTORY_SEPARATOR . 'migrations';

return $container;

```

### Postgres PDO `SqlPgsql` 
Adds support for qualifying the migrations table with a schema.

```php
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    return $dbh;
};

$container['phpmig.adapter'] = function ($c) {
    return new Adapter\PDO\SqlPgsql($c['db'], 'migrations', 'migrationschema');
};

return $container;
```



Or you can use Doctrine's DBAL:

```php
 'pdo_sqlite',
        'path'   => __DIR__ . DIRECTORY_SEPARATOR . 'db.sqlite',
    ));
};

$container['phpmig.adapter'] = function ($c) {
    return new Adapter\Doctrine\DBAL($c['db'], 'migrations');
};

$container['phpmig.migrations_path'] = __DIR__ . DIRECTORY_SEPARATOR . 'migrations';

return $container;
```

Setting up migrations with Zend Framework  requires a couple additional steps. You first need to prepare
the configuration. It might be in any format supported by Zend_Config. Here is an
example in YAML for MySQL:

```yaml
phpmig:
  tableName: migrations
  createStatement: CREATE TABLE migrations ( version VARCHAR(255) NOT NULL );
```

In configuration file you need to provide the table name where the migrations will
be stored and a create statement. You can use one of the configurations provided
in the config folder for some common RDBMS.

Here is how the bootstrap file should look like:

```php
registerNamespace('Zend_');

use Phpmig\Adapter\Zend\Db;
use Pimple\Container;

$container = new Container();

$container['db'] = function () {
    return Zend_Db::factory('pdo_mysql', array(
        'dbname' => 'DBNAME',
        'username' => 'USERNAME',
        'password' => 'PASSWORD',
        'host' => 'localhost'
    ));
};

$container['phpmig.adapter'] = function($c) {
    $configuration = null;
    $configurationFile = PHPMIG_PATH . '/config/mysql.yaml';

    if (file_exists($configurationFile)) {
        $configuration = new Zend_Config_Yaml($configurationFile, null, array('ignore_constants' => true));
    }

    return new Db($c['db'], $configuration);
};

$container['phpmig.migrations_path'] = __DIR__ . DIRECTORY_SEPARATOR . 'migrations';

return $container;
```

Example with Eloquent ORM 5.1
------------------
```php
 'xxx',
    'host'      => 'xxx',
    'database'  => 'xxx',
    'username'  => 'xxx',
    'password'  => 'x',
    'charset'   => 'xxx',
    'collation' => 'xxx',
    'prefix'    => '',
];

$container['db'] = function ($c) {
    $capsule = new Capsule();
    $capsule->addConnection($c['config']);
    $capsule->setAsGlobal();
    $capsule->bootEloquent();

   return $capsule;
};

$container['phpmig.adapter'] = function($c) {
    return new Adapter\Illuminate\Database($c['db'], 'migrations');
};
$container['phpmig.migrations_path'] = __DIR__ . DIRECTORY_SEPARATOR . 'migrations';

return $container;
```


Writing Migrations
------------------

The migrations should extend the Phpmig\Migration\Migration class, and have
access to the container. For example, assuming you've rewritten your bootstrap
file like above:

```php
getContainer(); 
        $container['db']->query($sql);
    }

    /**
     * Undo the migration
     */
    public function down()
    {
        $sql = "ALTER TABLE `lol_cats` DROP COLUMN `rating`";
        $container = $this->getContainer(); 
        $container['db']->query($sql);
    }
}
```

Customising the migration template
-----------------------------------

You can change the default migration template by providing the path to a file 
in the `phpmig.migrations_template_path` config value. If the template has a 
`.php` extension it is included and parsed as PHP, and the `$className` variable 
is replaced: 

```php
= "

use Phpmig\Migration\Migration;

class = $className ?> extends Migration
{
    $someValue = = $this->container['value'] ?>; 

    /**
     * Do the migration
     */
    public function up()
    {
        $container = $this->getContainer();
    }

    /**
     * Undo the migration
     */
    public function down()
    {
        $container = $this->getContainer();
    }
}

If it uses any other extension (e.g., .stub or .tmpl) it's parsed using the sprintf function, so the class name should be set to %s to ensure it gets replaced:, (*11)

<?php

use Phpmig\Migration\Migration;

class %s extends Migration
{
    /**
     * Do the migration
     */
    public function up()
    {
        $container = $this->getContainer(); 
    }

    /**
     * Undo the migration
     */
    public function down()
    {
        $container = $this->getContainer(); 
    }
}

Module Migrations

If you have an application that consists of different modules and you want to be able to separate the migration, Phpmig has a built-in way to achieve this., (*12)

<?php

/** @var Pimple\Container $container */
$container['phpmig.sets'] = function ($container) {
    return array(
        'cms' => array(
            'adapter' => new Adapter\File\Flat('modules/migrationLogs/cms_migrations.log'),
            'migrations_path' => 'migrations/cms'
        ),
        'blog' => array(
            'adapter' => new Adapter\File\Flat('modules/migrationLogs/blog_migrations.log'),
            'migrations_path' => 'migrations/blog'
        )
    );
};

this way each set has their own migration log and the ability to migrate changes independently of each other., (*13)

to run the set migration you just use the command below:, (*14)

$ phpmig up -s <SET NAME HERE> --<VERSION HERE>

For example, if a change was made to the cms migration, you'll type in this command:, (*15)

$ phpmig up -s cms --2

and the migration tool will run the migration setup for cms., (*16)

to downgrade a migration would be:, (*17)

$ phpmig down -s <SET NAME HERE> --<VERSION HERE>

Multi path migrations

By default you have to provide the path to migrations directory, but you can organize your migrations script however you like and have several migrations directory. To do this you can provide an array of migration file paths to the container :, (*18)

<?php

/** @var Pimple\Container $container */
$container['phpmig.migrations'] = function () {
    return array_merge(
        glob('migrations_1/*.php'),
        glob('migrations_2/*.php')
    );
};

You can then provide a target directory to the generate command. The target directory is mandatory if you haven't provided a phpmig.migrations_path config value., (*19)

$ phpmig generate AddRatingToLolCats ./migrations

Rolling Back

You can roll back the last run migration by using the rollback command, (*20)

$ phpmig rollback

To rollback all migration up to a specific migration you can specify the rollback target, (*21)

$ phpmig rollback -t 20111101000144

or, (*22)

$ phpmig rollback --target=20111101000144

By specifying 0 as the rollback target phpmig will revert all migrations, (*23)

$ phpmig rollback -t 0

You can also rollback only a specific migration using the down command, (*24)

$ phpmig down 20111101000144

Using Outside CLI

In order to use the migration tool outside the cli context use Phpmig\Api\PhpmigApplication., (*25)

<?php

use Phpmig\Api\PhpmigApplication;

// require the composer autoloader
require __DIR__ . '/vendor/autoload.php';

$output = new \Symfony\Component\Console\Output\NullOutput();

// create container from bootstrap file
$container = require __DIR__ . '/tests/dom/phpmig.php';

$app = new PhpmigApplication($container, $output);

// run the migrations
$app->up();

Todo

  • Some sort of migration manager, that will take some of the logic out of the commands for calculating which migrations have been run, which need running etc
  • Adapters for Zend_Db and/or Zend_Db_Table and others?
  • Redo and rollback commands
  • Tests!
  • Configuration?
  • Someway of protecting against class definition clashes with regard to the symfony dependencies and the user supplied bootstrap?

Contributing

Feel free to fork and send me pull requests, I try and keep the tool really basic, if you want to start adding tons of features to phpmig, I'd recommend taking a look at robmorgan/phinx., (*26)

Inspiration

I basically started copying ActiveRecord::Migrations in terms of the migration features, the bootstrapping was my own idea, the layout of the code was inspired by Symfony and Behat, (*27)

What is new in this fork

The change in this fork is that Migrator now calls Adapter::execute() instead of calling Migration::up() and Adapter::up() - same for ::down(). Adapter::execute() will call instead Migration::up() and Adapter::up(), which allows to override Adapter::execute() avoinding adding too much boilerplate in Migrations., (*28)

Adapting your code for this fork

If you have not implemented customs Adapters, you should be fine. If you did, then add "use \Phpmig\Adapter\SimpleAdapter;" and change "Foo implements AdapterInterface" with "Foo extends SimpleAdapter", (*29)

Example: how to use the new Adapter::execute()

class TransactionalSqlAdapter extends Adapter\PDO\Sql {
    public function __construct(\PDO $connection, $tableName) {
        parent::__construct($connection, $tableName);
    }
    public function execute(Migration $migration, $direction) {
        try {
            $migration->getContainer()['db']->beginTransaction();
            $success = parent::execute($migration, $direction);
            if ($success === True) {
                $successfulTransaction = $migration->getContainer()['db']->commit();
            } else {
                $migration->getContainer()['db']->rollback();
                $successfulTransaction = False;
            }
        } catch (\PDOException $e) {
            $migration->getContainer()['db']->rollback();
            $successfulTransaction = False;
        }
        return $successfulTransaction;
    }
}
$container['phpmig.adapter'] = $container->share(function() use ($container) {
    return new TransactionalSqlAdapter($container['db'], 'migrations');
});

Pimple is copyright Fabien Potencier. Everything I haven't copied from anyone else is Copyright (c) 2011 Dave Marshall. See LICENCE for further details, (*30)

The Versions

10/01 2018

dev-master

9999999-dev http://github.com/Avalara/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

10/01 2018

v2.0

2.0.0.0 http://github.com/Avalara/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

10/01 2018

v2.1

2.1.0.0 http://github.com/Avalara/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

15/12 2017

dev-edi_master

dev-edi_master http://github.com/Avalara/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

29/07 2015

v1.2.0

1.2.0.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

08/12 2014

v1.1.0

1.1.0.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

23/10 2013

1.0.x-dev

1.0.9999999.9999999-dev http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

23/10 2013

v1.0.0

1.0.0.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

21/10 2013

0.5.x-dev

0.5.9999999.9999999-dev http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

18/02 2013

v0.4.0

0.4.0.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

31/10 2012

v0.3.0

0.3.0.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

The Development Requires

by David Nielsen

migrations database migrations

10/08 2012

v0.2.2

0.2.2.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

by David Nielsen

migrations database migrations

29/06 2012

v0.2.1

0.2.1.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

by David Nielsen

migrations database migrations

08/02 2012

v0.2.0

0.2.0.0 http://github.com/davedevelopment/phpmig

Simple migrations system for php

  Sources   Download

MIT

The Requires

 

by David Nielsen

migrations database migrations