Simple Migrations for Zend Framework 2. Project originally based on ZendDbMigrations but module author did not response for issues and pull-requests so fork became independent project.
The following DB adapter drivers are supported by this module.
- Pdo_Sqlite
- Pdo_Mysql
- Pdo_Pgsql
- Mysqli only if you configure the driver options with
'buffer_results' => true
php composer.phar require vgarvardt/zf-simple-migrations:dev-master
php composer.phar updateadd ZfSimpleMigrations to the modules array in application.config.php
migration version [<name>]- show last applied migration (namespecifies a configured migration)migration list [<name>] [--all]- list available migrations (allincludes applied migrations)migration apply [<name>] [<version>] [--force] [--down] [--fake]- apply or rollback migrationmigration generate [<name>]- generate migration skeleton class
Migration classes are stored in /path/to/project/migrations/ dir by default.
Generic migration class has name Version<YmdHis> and implement ZfSimpleMigrations\Library\MigrationInterface.
<?php
namespace ZfSimpleMigrations\Migrations;
use ZfSimpleMigrations\Library\AbstractMigration;
use Zend\Db\Metadata\MetadataInterface;
class Version20130403165433 extends AbstractMigration
{
public static $description = "Migration description";
public function up(MetadataInterface $schema)
{
//$this->addSql(/*Sql instruction*/);
}
public function down(MetadataInterface $schema)
{
//$this->addSql(/*Sql instruction*/);
}
}While this module supports execution of multiple SQL statements it does not have way to detect if any other statement
than the first contained an error. It is highly recommended you only provide single SQL statements to addSql at a
time. I.e instead of
$this->addSql('SELECT NOW(); SELECT NOW(); SELECT NOW();');You should use
$this->addSql('SELECT NOW();');
$this->addSql('SELECT NOW();');
$this->addSql('SELECT NOW();');By implementing the Zend\ServiceManager\ServiceLocatorAwareInterface in your migration class you get access to the
ServiceLocator used in the application.
<?php
namespace ZfSimpleMigrations\Migrations;
use ZfSimpleMigrations\Library\AbstractMigration;
use Zend\Db\Metadata\MetadataInterface;
use Zend\ServiceManager\ServiceLocatorAwareInterface;
use Zend\ServiceManager\ServiceLocatorAwareTrait;
class Version20130403165433 extends AbstractMigration
implements ServiceLocatorAwareInterface
{
use ServiceLocatorAwareTrait;
public static $description = "Migration description";
public function up(MetadataInterface $schema)
{
//$this->getServiceLocator()->get(/*Get service by alias*/);
//$this->addSql(/*Sql instruction*/);
}
public function down(MetadataInterface $schema)
{
//$this->getServiceLocator()->get(/*Get service by alias*/);
//$this->addSql(/*Sql instruction*/);
}
}By implementing the Zend\Db\Adapter\AdapterAwareInterface in your migration class you get access to the Db Adapter
configured for the migration.
<?php
namespace ZfSimpleMigrations\Migrations;
use Zend\Db\Adapter\AdapterAwareInterface;
use Zend\Db\Adapter\AdapterAwareTrait;
use Zend\Db\Sql\Ddl\Column\Integer;
use Zend\Db\Sql\Ddl\Column\Varchar;
use Zend\Db\Sql\Ddl\Constraint\PrimaryKey;
use Zend\Db\Sql\Ddl\CreateTable;
use Zend\Db\Sql\Ddl\DropTable;
use ZfSimpleMigrations\Library\AbstractMigration;
use Zend\Db\Metadata\MetadataInterface;
class Version20150524162247 extends AbstractMigration implements AdapterAwareInterface
{
use AdapterAwareTrait;
public static $description = "Migration description";
public function up(MetadataInterface $schema)
{
$table = new CreateTable('my_table');
$table->addColumn(new Integer('id', false));
$table->addConstraint(new PrimaryKey('id'));
$table->addColumn(new Varchar('my_column', 64));
$this->addSql($table->getSqlString($this->adapter->getPlatform()));
}
public function down(MetadataInterface $schema)
{
$drop = new DropTable('my_table');
$this->addSql($drop->getSqlString($this->adapter->getPlatform()));
}
}The top-level key used to configure this module is migrations.
Each key under migrations is a migrations configuration, and the value is an array with one or more of the following
keys.
The path to the directory where migration files are stored. Defaults to ./migrations in the project root dir.
The class namespace that migration classes will be generated with. Defaults to ZfSimpleMigrations\Migrations.
Flag to log output of the migration. Defaults to true.
The service alias that will be used to fetch a Zend\Db\Adapter\Adapter from the service manager.
'migrations' => array(
'default' => array(
'dir' => dirname(__FILE__) . '/../../../../migrations-app',
'namespace' => 'App\Migrations',
),
'albums' => array(
'dir' => dirname(__FILE__) . '/../../../../migrations-albums',
'namespace' => 'Albums\Migrations',
'adapter' => 'AlbumDb'
),
),
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent