Class yii\console\controllers\MigrateController

Inheritanceyii\console\controllers\MigrateController » yii\console\controllers\BaseMigrateController » yii\console\Controller » yii\base\Controller » yii\base\Component » yii\base\Object
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

Public Properties

Hide inherited properties

PropertyTypeDescriptionDefined 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
$help string 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 string|boolean The name of the layout to be applied to this controller's views. yii\base\Controller
$migrationPath string The directory storing 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
$route string The route (module ID, controller ID and action ID) of the current request. yii\base\Controller
$templateFile yii\console\controllers\MigrateController
$uniqueId string The controller ID that is prefixed with the module ID (if any). yii\base\Controller
$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\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
getRoute() Returns the route of the current request. yii\base\Controller
getUniqueId() 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
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
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
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
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
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
removeMigrationHistory() Removes existing migration from the history. 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 yii\console\Controller
EXIT_CODE_NORMAL 0 yii\console\Controller

Property Details

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

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.

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

The name of the table for keeping applied migration information.

$templateFile public property
$templateFile = '@yii/views/migration.php'

Method Details

addMigrationHistory() protected method

Adds new migration entry to the history.

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.

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.

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.

void createMigrationHistoryTable( )
getMigrationHistory() protected method

Returns the migration history.

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

array options( $actionID )
$actionID string

The action id of the current request
return array

The names of the options valid for the action
removeMigrationHistory() protected method

Removes existing migration from the history.

void removeMigrationHistory( $version )
$version string

Migration version name.