Class yii\console\controllers\MigrateController

Inheritance	yii\console\controllers\MigrateController » yii\console\controllers\BaseMigrateController » yii\console\Controller » yii\base\Controller » yii\base\Component » yii\base\Object
Implements	yii\base\Configurable, yii\base\ViewContextInterface
Available since version	2.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

Property	Type	Description	Defined By
$action	yii\base\Action	The action that is currently being executed.	yii\base\Controller
$behaviors	yii\base\Behavior[]	List of behaviors attached to this component	yii\base\Component
$color	boolean	Whether to enable ANSI color in the output.	yii\console\Controller
$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		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.	yii\base\Controller
$passedOptionValues	array	The properties corresponding to the passed options	yii\console\Controller
$passedOptions	array	The names of the options passed during execution	yii\console\Controller
$route	string	The route (module ID, controller ID and action ID) of the current request.	yii\base\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).	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

Method	Description	Defined By
__call()	Calls the named method which is not a class method.	yii\base\Object
__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\Object
__isset()	Checks if a property is set, i.e. defined and not null.	yii\base\Object
__set()	Sets value of an object property.	yii\base\Object
__unset()	Sets an object property to null.	yii\base\Object
actionCreate()	Creates a new migration.	yii\console\controllers\BaseMigrateController
actionDown()	Downgrades the application by reverting old migrations.	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\Object
canSetProperty()	Returns a value indicating whether a property can be set.	yii\base\Object
className()	Returns the fully qualified name of this class.	yii\base\Object
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\Object
hasProperty()	Returns a value indicating whether a property is defined.	yii\base\Object
init()	Initializes the object.	yii\base\Object
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

Method	Description	Defined 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
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
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

Events

Event	Type	Description	Defined 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

Constant	Value	Description	Defined 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		yii\console\Controller
EXIT_CODE_NORMAL	0		yii\console\Controller

Property Details

$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.

public yii\db\Connection|array|string $db = 'db'

$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 = false

Method Details