Class yii\console\controllers\MigrateController

Inheritanceyii\console\controllers\MigrateController » yii\console\controllers\BaseMigrateController » yii\console\Controller » yii\base\Controller » yii\base\Component » yii\base\BaseObject
Implementsyii\base\Configurable, yii\base\ViewContextInterface
Available since version2.0
Source Code https://github.com/yiisoft/yii2/blob/master/framework/console/controllers/MigrateController.php

Manages application migrations.

A migration means a set of persistent changes to the application environment that is shared among different developers. For example, in an application backed by a database, a migration may refer to a set of changes to the database, such as creating a new table, adding a new table column.

This command provides support for tracking the migration history, upgrading or downloading with migrations, and creating new migration skeletons.

The migration history is stored in a database table named as $migrationTable. The table will be automatically created the first time this command is executed, if it does not exist. You may also manually create it as follows:

CREATE TABLE migration (
    version varchar(180) PRIMARY KEY,
    apply_time integer
)

Below are some common usages of this command:

# creates a new migration named 'create_user_table'
yii migrate/create create_user_table

# applies ALL new migrations
yii migrate

# reverts the last applied migration
yii migrate/down

Since 2.0.10 you can use namespaced migrations. In order to enable this feature you should configure $migrationNamespaces property for the controller at application configuration:

return [
    'controllerMap' => [
        'migrate' => [
            'class' => 'yii\console\controllers\MigrateController',
            'migrationNamespaces' => [
                'app\migrations',
                'some\extension\migrations',
            ],
            //'migrationPath' => null, // allows to disable not namespaced migration completely
        ],
    ],
];

Public Properties

Hide inherited properties

PropertyTypeDescriptionDefined By
$action yii\base\Action|null The action that is currently being executed. yii\base\Controller
$behaviors yii\base\Behavior[] List of behaviors attached to this component. This property is read-only. yii\base\Component
$color boolean|null Whether to enable ANSI color in the output. yii\console\Controller
$comment string The comment for the table being created. yii\console\controllers\MigrateController
$compact boolean Indicates whether the console output should be compacted. yii\console\controllers\BaseMigrateController
$db yii\db\Connection|array|string The DB connection object or the application component ID of the DB connection to use when applying migrations. yii\console\controllers\MigrateController
$defaultAction string The ID of the action that is used when the action ID is not specified in the request. yii\base\Controller
$fields array Column definition strings used for creating migration code. yii\console\controllers\MigrateController
$generatorTemplateFiles array A set of template paths for generating migration code automatically. yii\console\controllers\MigrateController
$help boolean Whether to display help information about current command. yii\console\Controller
$helpSummary string This property is read-only. yii\console\Controller
$id string The ID of this controller. yii\base\Controller
$interactive boolean Whether to run the command interactively. yii\console\Controller
$layout null|string|false The name of the layout to be applied to this controller's views. yii\base\Controller
$migrationNamespaces array List of namespaces containing the migration classes. yii\console\controllers\BaseMigrateController
$migrationPath string|array The directory containing the migration classes. yii\console\controllers\BaseMigrateController
$migrationTable string The name of the table for keeping applied migration information. yii\console\controllers\MigrateController
$module yii\base\Module The module that this controller belongs to. yii\base\Controller
$modules yii\base\Module[] All ancestor modules that this controller is located within. This property is read-only. yii\base\Controller
$passedOptionValues array The properties corresponding to the passed options. This property is read-only. yii\console\Controller
$passedOptions array The names of the options passed during execution. This property is read-only. yii\console\Controller
$request yii\console\Request yii\console\Controller
$response yii\console\Response yii\console\Controller
$route string The route (module ID, controller ID and action ID) of the current request. This property is read-only. yii\base\Controller
$silentExitOnException boolean|null If true - script finish with ExitCode::OK in case of exception. yii\console\Controller
$templateFile string The template file for generating new migrations. yii\console\controllers\MigrateController
$uniqueId string The controller ID that is prefixed with the module ID (if any). This property is read-only. yii\base\Controller
$useTablePrefix boolean Indicates whether the table names generated should consider the tablePrefix setting of the DB connection. yii\console\controllers\MigrateController
$view yii\base\View|yii\web\View The view object that can be used to render views or view files. yii\base\Controller
$viewPath string The directory containing the view files for this controller. yii\base\Controller

Public Methods

Hide inherited methods

MethodDescriptionDefined By
__call() Calls the named method which is not a class method. yii\base\BaseObject
__clone() This method is called after the object is created by cloning an existing one. yii\base\Component
__construct() yii\base\Controller
__get() Returns the value of an object property. yii\base\BaseObject
__isset() Checks if a property is set, i.e. defined and not null. yii\base\BaseObject
__set() Sets value of an object property. yii\base\BaseObject
__unset() Sets an object property to null. yii\base\BaseObject
actionCreate() Creates a new migration. yii\console\controllers\BaseMigrateController
actionDown() Downgrades the application by reverting old migrations. yii\console\controllers\BaseMigrateController
actionFresh() Drops all tables and related constraints. Starts the migration from the beginning. yii\console\controllers\BaseMigrateController
actionHistory() Displays the migration history. yii\console\controllers\BaseMigrateController
actionMark() Modifies the migration history to the specified version. yii\console\controllers\BaseMigrateController
actionNew() Displays the un-applied new migrations. yii\console\controllers\BaseMigrateController
actionRedo() Redoes the last few migrations. yii\console\controllers\BaseMigrateController
actionTo() Upgrades or downgrades till the specified version. yii\console\controllers\BaseMigrateController
actionUp() Upgrades the application by applying new migrations. yii\console\controllers\BaseMigrateController
actions() Declares external actions for the controller. yii\base\Controller
afterAction() This method is invoked right after an action is executed. yii\base\Controller
ansiFormat() Formats a string with ANSI codes. yii\console\Controller
attachBehavior() Attaches a behavior to this component. yii\base\Component
attachBehaviors() Attaches a list of behaviors to the component. yii\base\Component
beforeAction() This method is invoked right before an action is to be executed (after all possible filters.) It checks the existence of the $migrationPath. yii\console\controllers\MigrateController
behaviors() Returns a list of behaviors that this component should behave as. yii\base\Component
bindActionParams() Binds the parameters to the action. yii\console\Controller
canGetProperty() Returns a value indicating whether a property can be read. yii\base\BaseObject
canSetProperty() Returns a value indicating whether a property can be set. yii\base\BaseObject
className() Returns the fully qualified name of this class. yii\base\BaseObject
confirm() Asks user to confirm by typing y or n. yii\console\Controller
createAction() Creates an action based on the given action ID. yii\base\Controller
detachBehavior() Detaches a behavior from the component. yii\base\Component
detachBehaviors() Detaches all behaviors from the component. yii\base\Component
ensureBehaviors() Makes sure that the behaviors declared in behaviors() are attached to this component. yii\base\Component
findLayoutFile() Finds the applicable layout file. yii\base\Controller
getActionArgsHelp() Returns the help information for the anonymous arguments for the action. yii\console\Controller
getActionHelp() Returns the detailed help information for the specified action. yii\console\Controller
getActionHelpSummary() Returns a one-line short summary describing the specified action. yii\console\Controller
getActionOptionsHelp() Returns the help information for the options for the action. yii\console\Controller
getBehavior() Returns the named behavior object. yii\base\Component
getBehaviors() Returns all behaviors attached to this component. yii\base\Component
getHelp() Returns help information for this controller. yii\console\Controller
getHelpSummary() Returns one-line short summary describing this controller. yii\console\Controller
getModules() Returns all ancestor modules of this controller. yii\base\Controller
getOptionValues() Returns properties corresponding to the options for the action id Child classes may override this method to specify possible properties. yii\console\Controller
getPassedOptionValues() Returns the properties corresponding to the passed options. yii\console\Controller
getPassedOptions() Returns the names of valid options passed during execution. yii\console\Controller
getRoute() Returns the route of the current request. yii\base\Controller
getUniqueId() Returns the unique ID of the controller. yii\base\Controller
getView() Returns the view object that can be used to render views or view files. yii\base\Controller
getViewPath() Returns the directory containing view files for this controller. yii\base\Controller
hasEventHandlers() Returns a value indicating whether there is any handler attached to the named event. yii\base\Component
hasMethod() Returns a value indicating whether a method is defined. yii\base\BaseObject
hasProperty() Returns a value indicating whether a property is defined. yii\base\BaseObject
init() Initializes the object. yii\base\Controller
isColorEnabled() Returns a value indicating whether ANSI color is enabled. yii\console\Controller
off() Detaches an existing event handler from this component. yii\base\Component
on() Attaches an event handler to an event. yii\base\Component
optionAliases() Returns option alias names. yii\console\controllers\MigrateController
options() Returns the names of valid options for the action (id) An option requires the existence of a public member variable whose name is the option name. yii\console\controllers\MigrateController
prompt() Prompts the user for input and validates it. yii\console\Controller
render() Renders a view and applies layout if available. yii\base\Controller
renderContent() Renders a static string by applying a layout. yii\base\Controller
renderFile() Renders a view file. yii\base\Controller
renderPartial() Renders a view without applying layout. yii\base\Controller
run() Runs a request specified in terms of a route. yii\base\Controller
runAction() Runs an action with the specified action ID and parameters. yii\console\Controller
select() Gives the user an option to choose from. Giving '?' as an input will show a list of options to choose from and their explanations. yii\console\Controller
setView() Sets the view object to be used by this controller. yii\base\Controller
setViewPath() Sets the directory that contains the view files. yii\base\Controller
stderr() Prints a string to STDERR. yii\console\Controller
stdout() Prints a string to STDOUT. yii\console\Controller
trigger() Triggers an event. yii\base\Component

Protected Methods

Hide inherited methods

MethodDescriptionDefined By
addDefaultPrimaryKey() Adds default primary key to fields list if there's no primary key specified. yii\console\controllers\MigrateController
addMigrationHistory() Adds new migration entry to the history. yii\console\controllers\MigrateController
bindInjectedParams() Fills parameters based on types and names in action method signature. yii\base\Controller
createMigration() Creates a new migration instance. yii\console\controllers\MigrateController
createMigrationHistoryTable() Creates the migration history table. yii\console\controllers\MigrateController
generateMigrationSourceCode() Generates new migration source PHP code. yii\console\controllers\MigrateController
generateTableName() If useTablePrefix equals true, then the table name will contain the prefix format. yii\console\controllers\MigrateController
getActionMethodReflection() yii\console\Controller
getMigrationHistory() Returns the migration history. yii\console\controllers\MigrateController
getMigrationNameLimit() Return the maximum name length for a migration. yii\console\controllers\MigrateController
getNewMigrations() Returns the migrations that are not applied. yii\console\controllers\BaseMigrateController
includeMigrationFile() Includes the migration file for a given migration class name. yii\console\controllers\BaseMigrateController
migrateDown() Downgrades with the specified migration class. yii\console\controllers\BaseMigrateController
migrateToTime() Migrates to the specified apply time in the past. yii\console\controllers\BaseMigrateController
migrateToVersion() Migrates to the certain version. yii\console\controllers\BaseMigrateController
migrateUp() Upgrades with the specified migration class. yii\console\controllers\BaseMigrateController
parseDocCommentDetail() Returns full description from the docblock. yii\console\Controller
parseDocCommentSummary() Returns the first line of docblock. yii\console\Controller
parseDocCommentTags() Parses the comment block into tags. yii\console\Controller
parseFields() Parse the command line migration fields. yii\console\controllers\MigrateController
removeMigrationHistory() Removes existing migration from the history. yii\console\controllers\MigrateController
splitFieldIntoChunks() Splits field into chunks yii\console\controllers\MigrateController
truncateDatabase() Truncates the database. yii\console\controllers\MigrateController

Events

Hide inherited events

EventTypeDescriptionDefined By
EVENT_AFTER_ACTION yii\base\ActionEvent An event raised right after executing a controller action. yii\base\Controller
EVENT_BEFORE_ACTION yii\base\ActionEvent An event raised right before executing a controller action. yii\base\Controller

Constants

Hide inherited constants

ConstantValueDescriptionDefined By
BASE_MIGRATION 'm000000_000000_base' The name of the dummy migration that marks the beginning of the whole migration history. yii\console\controllers\BaseMigrateController
EXIT_CODE_ERROR 1 Deprecated since 2.0.13. Use yii\console\ExitCode::UNSPECIFIED_ERROR instead. yii\console\Controller
EXIT_CODE_NORMAL 0 Deprecated since 2.0.13. Use yii\console\ExitCode::OK instead. yii\console\Controller
MAX_NAME_LENGTH 180 Maximum length of a migration name. yii\console\controllers\MigrateController

Property Details

$comment public property (available since version 2.0.14)

The comment for the table being created.

public string $comment ''
$db public property

The DB connection object or the application component ID of the DB connection to use when applying migrations. Starting from version 2.0.3, this can also be a configuration array for creating the object.

$fields public property (available since version 2.0.7)

Column definition strings used for creating migration code.

The format of each definition is COLUMN_NAME:COLUMN_TYPE:COLUMN_DECORATOR. Delimiter is ,. For example, --fields="name:string(12):notNull:unique" produces a string column of size 12 which is not null and unique values.

Note: primary key is added automatically and is named id by default. If you want to use another name you may specify it explicitly like --fields="id_key:primaryKey,name:string(12):notNull:unique"

public array $fields = []
$generatorTemplateFiles public property (available since version 2.0.7)

A set of template paths for generating migration code automatically.

The key is the template type, the value is a path or the alias. Supported types are:

  • create_table: table creating template
  • drop_table: table dropping template
  • add_column: adding new column template
  • drop_column: dropping column template
  • create_junction: create junction template
public array $generatorTemplateFiles = ['create_table' => '@yii/views/createTableMigration.php''drop_table' => '@yii/views/dropTableMigration.php''add_column' => '@yii/views/addColumnMigration.php''drop_column' => '@yii/views/dropColumnMigration.php''create_junction' => '@yii/views/createTableMigration.php']
$migrationTable public property

The name of the table for keeping applied migration information.

public string $migrationTable '{{%migration}}'
$templateFile public property

The template file for generating new migrations. This can be either a path alias (e.g. "@app/migrations/template.php") or a file path.

public string $templateFile '@yii/views/migration.php'
$useTablePrefix public property (available since version 2.0.8)

Indicates whether the table names generated should consider the tablePrefix setting of the DB connection. For example, if the table name is post the generator wil return {{%post}}.

public boolean $useTablePrefix true

Method Details

addDefaultPrimaryKey() protected method (available since version 2.0.7)

Adds default primary key to fields list if there's no primary key specified.

protected void addDefaultPrimaryKey ( &$fields )
$fields array

Parsed fields

addMigrationHistory() protected method

Adds new migration entry to the history.

protected void addMigrationHistory ( $version )
$version string

Migration version name.

beforeAction() public method

This method is invoked right before an action is to be executed (after all possible filters.) It checks the existence of the $migrationPath.

public boolean beforeAction ( $action )
$action yii\base\Action

The action to be executed.

return boolean

Whether the action should continue to be executed.

createMigration() protected method

Creates a new migration instance.

protected yii\db\Migration createMigration ( $class )
$class string

The migration class name

return yii\db\Migration

The migration instance

createMigrationHistoryTable() protected method

Creates the migration history table.

protected void createMigrationHistoryTable ( )
generateMigrationSourceCode() protected method (available since version 2.0.8)

Generates new migration source PHP code.

Child class may override this method, adding extra logic or variation to the process.

protected string generateMigrationSourceCode ( $params )
$params array

Generation parameters, usually following parameters are present:

  • name: string migration base name
  • className: string migration class name
return string

Generated PHP code.

generateTableName() protected method (available since version 2.0.8)

If useTablePrefix equals true, then the table name will contain the prefix format.

protected string generateTableName ( $tableName )
$tableName string

The table name to generate.

getMigrationHistory() protected method

Returns the migration history.

protected array getMigrationHistory ( $limit )
$limit integer

The maximum number of records in the history to be returned. null for "no limit".

return array

The migration history

getMigrationNameLimit() protected method (available since version 2.0.13)

Return the maximum name length for a migration.

Subclasses may override this method to define a limit.

protected integer|null getMigrationNameLimit ( )
return integer|null

The maximum name length for a migration or null if no limit applies.

optionAliases() public method (available since version 2.0.8)

Returns option alias names.

Child classes may override this method to specify alias options.

public array optionAliases ( )
return array

The options alias names valid for the action where the keys is alias name for option and value is option name.

options() public method

Returns the names of valid options for the action (id) An option requires the existence of a public member variable whose name is the option name.

Child classes may override this method to specify possible options.

Note that the values setting via options are not available until beforeAction() is being called.

public string[] options ( $actionID )
$actionID string

The action id of the current request

return string[]

The names of the options valid for the action

parseFields() protected method (available since version 2.0.7)

Parse the command line migration fields.

protected array parseFields ( )
return array

Parse result with following fields:

  • fields: array, parsed fields
  • foreignKeys: array, detected foreign keys
removeMigrationHistory() protected method

Removes existing migration from the history.

protected void removeMigrationHistory ( $version )
$version string

Migration version name.

splitFieldIntoChunks() protected method

Splits field into chunks

protected string[]|false splitFieldIntoChunks ( $field )
$field string
truncateDatabase() protected method (available since version 2.0.13)

Truncates the database.

This method should be overwritten in subclasses to implement the task of clearing the database.

protected void truncateDatabase ( )
throws yii\base\NotSupportedException

if not overridden