Extended Migration Command
This extension is an enhanced version of the Yii Database Migration Tool that adds module support and many more usefull features. If there is anything you would like to have added, or you found a bug please report it on github or contact me via email.
- Module-Support (migrations are distributed in a seperate folder for every module) so you can...
- Yii 1.1.6 or above (MigrateCommand was introduced in this version) if you copy MigrateCommand and CDbMigration you should be able to use this extension with any yii version.
- Extract the release file under
- Add the following to your config file for yiic command:
'commandMap' => array( 'migrate' => array( // alias of the path where you extracted the zip file 'class' => 'application.extensions.yiiext.commands.migrate.EMigrateCommand', // this is the path where you want your core application migrations to be created 'migrationPath' => 'application.db.migrations', // the name of the table created in your database to save versioning information 'migrationTable' => 'tbl_migration', // the application migrations are in a pseudo-module called "core" by default 'applicationModuleName' => 'core', // define all available modules (if you do not set this, modules will be set from yii app config) 'modulePaths' => array( 'admin' => 'application.modules.admin.db.migrations', 'user' => 'application.modules.user.db.migrations', 'yourModule' => 'application.any.other.path.possible', // ... ), // you can customize the modules migrations subdirectory which is used when you are using yii module config 'migrationSubPath' => 'migrations', // here you can configure which modules should be active, you can disable a module by adding its name to this array 'disabledModules' => array( 'admin', 'anOtherModule', // ... ), // the name of the application component that should be used to connect to the database 'connectionID'=>'db', // alias of the template file used to create new migrations 'templateFile'=>'application.db.migration_template', ), ),
Please note: if you already used MigrateCommand before, make sure to add the module column to your migrationTable:
ALTER TABLE `tbl_migration` ADD COLUMN `module` varchar(32) DEFAULT NULL; UPDATE `tbl_migration` SET module='core';
You can run
yiic migrate help to see all parameters and a short example on how to use them.
The basics are explained in the Definitive Guide to Yii. Read them first if you haven't used database migration before. The usage of Extended Migration Command is not much different from the native one. The only command that is different is create where you have to additionally specify the modulename:
yiic migrate create modulename create_user_table
This creates a new migration named 'create_user_table' in module 'modulename'. The native usage
yiic migrate create create_user_table
creates a new migration named 'create_user_table' in the application(core).
In all other commands (
mark) you can use the parameter
<modulenames> can be a comma seperated list of module names or a single module name. This parameter will limit the current command to affect only the specified modules.
yiic migrate new --module=core
This will show you all new migrations for module core and
yiic migrate up 5 --module=core,user
will migrate up the next 5 new migrations in modules core and user. If there are new migrations in other modules they will be ignored.
yiic migrate history --module=core,user
will show you which migrations have been applied for modules core and user in the past. If you do not specify a module the command behaves like the native one and does the migration for all modules.
add a module
Simply enable it in your config and run
yiic migrate up --module=yourModule.
remove a module
yiic migrate to m000000_000000 --module=yourModule. For this to work all your migrations must have the down()-method implemented correctly.
0.8.0 (to be released)
- Enh: #12 added customization of 'migrations' subdirectory via $migrationSubPath (cebe thanks to redguy666)
- fix for getTable trying to hit a db cache and die in endless loop (cebe)
- made sure that mark and to action are working correctly (cebe)
- adjusted sql commands to be compatible with nearly all pdo db systems (cebe)
- modules are now loaded from yii application config if not set (cebe)
- improved create action error handling (cebe)
0.6.0 (2011-09-12) not released, did not work
- adjusted sql commands to be compatible with sqlite and postgres (cebe thanks to redguy)
- added compatibility with CDbMigration, migrations need not extend EDbMigration (cebe)
- implemented mark-action so it now works with modules (cebe)
- implemented to-action so it now works with modules (cebe)
- fixed problem that base-migrations where not cretated on mark command (cebe)
- added confirm() method to EDbMigration (cebe)
- fixed a problem with finding new migrations (cebe)
- added base migration for every single module (cebe)
- fixed problem with history and down migration when --module parameter is set (cebe)
- added $moduleDelimiter property and replaced string function with multibyte versions (cebe)
- complete refactoring of basic functionality, more stability and more straight forward (cebe)
- Initial public release (cebe)
- module support for migrations
- extended execute() of CDbMigration with parameter $verbose