database-command

Yii command to create database migrations from existing schema. Migration classes are created in application runtime folder.

Features

• primary key generation
• foreign key generation (skipped for SQLite)
• complete data and schmema dump

Download

Get it from github and place it into your application.

Usage

Run the command...

./yiic database

... to show the help page

dump [<name>] [--prefix=<table_prefix,...>] [--dbConnection=<db>]
    [--createSchema=<1|0>] [--insertData=<1|0>] [--foreignKeyChecks=<1|0>] 
    [--truncateTable=<0|1>] [--migrationPath=<alias>] [--ignoreMigrationTable=<1|0>]

Param	Default	Info
name	dump	migration class name
--prefix		dump only tables with given prefix (specify multiple prefixes separated by commas)
--createSchema	1	wheter to create tables
--insertData	1	wheter to create insert statements
--foreignKeyChecks	0	set to 0 to disable foreign key checks
--truncateTable	0	wheter to remove all records from the table first
--dbConnection	db	application component to use
--migrationPath	application.migrations	default dump folder
--ignoreMigrationTable	1	wheter to ignore to migration table

Example

To create a migration from an existing application scheme, define an alternative database component in your application, e.g. db-production.

This example shows data dumping, removes all data (truncate tables) and omits foreign key checks:

 ./yiic database dump p3_replace_data \
   --prefix=Auth,Rights,usr,p3 --createSchema=0 \
   --foreignKeyChecks=0 --truncateTable=1

Separate schema and data:

 ./yiic database dump my_schema --insertData=0
 ./yiic database dump my_data --createSchema=0

Replace your whole data with data from dbProduction:

 ./yiic database dump replace_data \
   --truncateTable=1 --foreignKeyChecks=0 \
   --createSchema=0 --dbConnection=dbProduction

The following command dumps all tables starting with p3_media and omits the schema create statements:

./yiic database dump p3media_no_schema_production \
--prefix=p3_media --createSchema=0 --dbConnection=dbProduction

Requirements

• Yii 1.1.*

Configuration

config/console.php

'commandMap' => array(
    'database' => array(
        'class' => 'application.vendor.database-command.EDatabaseCommand',
    ),
),
'components'=>array(
    'db'=>array(
      'connectionString' => 'mysql:host=192.168.0.1;dbname=db_name',
      'username' => 'user',
      'password' => 'pw',
      'emulatePrepare' => true,
      'enableProfiling' => true,
      'charset' => 'utf8',
      'driverMap'=>array(
            'mysql' => 'application.vendor.database-command.db.MysqlSchema'
),

Resources

• Availble via Phundament 3 Composer Package Repository http://packages.phundament.com
• Fork on github
• CHANGELOG
• View at Yii Extensions