schmunk42 / database-command
Yii command to create database migrations from existing schema
Installs: 5 850
Dependents: 0
Suggesters: 0
Security: 0
Stars: 19
Watchers: 6
Forks: 11
Open Issues: 9
Requires
- php: >=5.3.2
- yiisoft/yii: >=1.1.0
README
Yii command to create database migrations from existing schema.
Migration classes are created in application runtime
folder.
Requirements
- Yii 1.1.*
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.
Or install it via composer require schmunk42/database-command
.
Configuration
config/console.php
'commandMap' => array(
'database' => array(
'class' => 'vendor.schmunk42.database-command.EDatabaseCommand',
),
)
Note: You may have to replace
vendor.schmunk42.database-command.EDatabaseCommand
with the acutal installation path.
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>]
[--ignoreMigrationTable=<1|0>] [--truncateTable=<0|1>]
[--insertAutoIncrementValues=<1|0>] [--migrationPath=<application.runtime>]
Example
To create a migration from an existing application database schema, 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
Resources
- Availble via Phundament 3 Composer Package Repository
http://packages.phundament.com
- Fork on github
- CHANGELOG
- View at Yii Extensions