YcheukfMigration is a db migration module for zend framework 2. It just like YII. Project originally based on ZfSimpleMigrations, and support multiple db migration. Only run at command line.
- db migration like YII, ROR. (finished)
- mult db migration support. (finished)
- PHP5
- Zend Framework 2 - Not needed to generate your models
- ycheukf/debug - A debug module for zf2
Install via git
Clone this repo
git clone https://github.com/ycheukf/migration.git
Install via Composer
Add this to your composer.json under "require":
"ycheukf/migration": "dev-master"
Run command:
php composer.phar update
1: add module 'YcheukfMigration' to your application.config.php
return array(
'modules' => array(
'YcheukfMigration',
'Application',
),
);
2: get the helpinfo by running "php public/index.php"
1: generate a new migration-file in path/migrations/default
php public/index.php migration generate
2: apply a migration (upgrade or downgrade) .
php public/index.php migration up db;
// or
php public/index.php migration down db;
"db" is the key of the db-config array, usually written at path/config/autoload/global.php
return array(
'db' => array(//that is it
'driver' => 'Pdo',
'dsn' => 'mysql:dbname=myzf2;host=localhost',
'username' => 'root',
'password' => 'root',
'driver_options' => array(
\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
),
),
// ...
);
3: apply migration for all the db-array which is returned by an event "setDbConfigsFromEvent"
php public/index.php migration up --dbsfromevent
// or
php public/index.php migration down --dbsfromevent
4: apply migration for a key "db" of the db-array which is returned by an event "setDbConfigsFromEvent"
php public/index.php migration up db --dbsfromevent
// or
php public/index.php migration down db --dbsfromevent