DbController ​
- Type
- Class
- Namespace
- craft\console\controllers
- Inherits
- craft\console\controllers\DbController » craft\console\Controller » yii\console\Controller » yii\base\Controller » yii\base\Component » yii\base\BaseObject
- Implements
- yii\base\Configurable, yii\base\ViewContextInterface
- Uses traits
- craft\console\ControllerTrait
- Since
- 3.6.0
Performs database operations.
Public Properties ​
| Property | Description |
|---|---|
| action | yii\base\Action, null – The action that is currently being executed. |
| behaviors | yii\base\Behavior – List of behaviors attached to this component. |
| color | boolean, null – Whether to enable ANSI color in the output. |
| defaultAction | string – The ID of the action that is used when the action ID is not specified in the request. |
| dropAllTables | boolean – Whether to drop all preexisting tables in the database prior to restoring the backup. |
| format | string, null – The output format that should be used (custom, directory, tar, or plain). |
| help | boolean – Whether to display help information about current command. |
| helpSummary | string – The one-line short summary describing this controller. |
| id | string – The ID of this controller. |
| interactive | boolean – Whether to run the command interactively. |
| isolated | – Whether the command should ensure it is only being run once at a time. |
| layout | string, null, false – The name of the layout to be applied to this controller's views. |
| module | yii\base\Module – The module that this controller belongs to. |
| modules | yii\base\Module – All ancestor modules that this controller is located within. |
| overwrite | boolean – Whether to overwrite an existing backup file, if a specific file path is given. |
| passedOptionValues | array – The properties corresponding to the passed options. |
| passedOptions | array – The names of the options passed during execution. |
| request | craft\console\Request |
| response | yii\base\Response, array, string – The response. |
| route | string – The route (module ID, controller ID and action ID) of the current request. |
| silentExitOnException | boolean, null – If true - script finish with ExitCode::OK in case of exception. |
| uniqueId | string – The controller ID that is prefixed with the module ID (if any). |
| view | yii\base\View, yii\web\View – The view object that can be used to render views or view files. |
| viewPath | string – The directory containing the view files for this controller. |
| zip | boolean – Whether the backup should be saved as a zip file. |
dropAllTables ​
- Type
- boolean
- Default value
false- Since
- 4.1.0
Whether to drop all preexisting tables in the database prior to restoring the backup.
format ​
The output format that should be used (custom, directory, tar, or plain).
The backupCommandFormat config setting will be used by default.
overwrite ​
- Type
- boolean
- Default value
false
Whether to overwrite an existing backup file, if a specific file path is given.
zip ​
- Type
- boolean
- Default value
false
Whether the backup should be saved as a zip file.
Public Methods ​
| Method | Description |
|---|---|
| __call() | Calls the named method which is not a class method. |
| __clone() | This method is called after the object is created by cloning an existing one. |
| __construct() | |
| __get() | Returns the value of a component property. |
| __isset() | Checks if a property is set, i.e. defined and not null. |
| __set() | Sets the value of a component property. |
| __unset() | Sets a component property to be null. |
| actionBackup() | Creates a new database backup. |
| actionConvertCharset() | Converts tables’ character sets and collations. (MySQL only) |
| actionDropAllTables() | Drops all tables in the database. |
| actionDropTablePrefix() | Drops the database table prefix from all tables. |
| actionRestore() | Restores a database backup. |
| actions() | Declares external actions for the controller. |
| afterAction() | This method is invoked right after an action is executed. |
| ansiFormat() | Formats a string with ANSI codes. |
| attachBehavior() | Attaches a behavior to this component. |
| attachBehaviors() | Attaches a list of behaviors to the component. |
| beforeAction() | This method is invoked right before an action is executed. |
| behaviors() | Returns a list of behaviors that this component should behave as. |
| bindActionParams() | Binds the parameters to the action. |
| canGetProperty() | Returns a value indicating whether a property can be read. |
| canSetProperty() | Returns a value indicating whether a property can be set. |
| className() | Returns the fully qualified name of this class. |
| confirm() | Asks user to confirm by typing y or n. |
| createAction() | Creates an action based on the given action ID. |
| createDirectory() | Creates a directory, and outputs to the console. |
| detachBehavior() | Detaches a behavior from the component. |
| detachBehaviors() | Detaches all behaviors from the component. |
| do() | Performs an action with descriptive output. |
| ensureBehaviors() | Makes sure that the behaviors declared in behaviors() are attached to this component. |
| failure() | Outputs a failure message to the console. |
| findLayoutFile() | Finds the applicable layout file. |
| getActionArgsHelp() | Returns the help information for the anonymous arguments for the action. |
| getActionHelp() | Returns the detailed help information for the specified action. |
| getActionHelpSummary() | Returns a one-line short summary describing the specified action. |
| getActionOptionsHelp() | Returns the help information for the options for the action. |
| getBehavior() | Returns the named behavior object. |
| getBehaviors() | Returns all behaviors attached to this component. |
| getHelp() | Returns help information for this controller. |
| getHelpSummary() | Returns one-line short summary describing this controller. |
| getModules() | Returns all ancestor modules of this controller. |
| getOptionValues() | Returns properties corresponding to the options for the action id Child classes may override this method to specify possible properties. |
| getPassedOptionValues() | Returns the properties corresponding to the passed options. |
| getPassedOptions() | Returns the names of valid options passed during execution. |
| getRoute() | Returns the route of the current request. |
| getUniqueId() | Returns the unique ID of the controller. |
| getView() | Returns the view object that can be used to render views or view files. |
| getViewPath() | Returns the directory containing view files for this controller. |
| hasEventHandlers() | Returns a value indicating whether there is any handler attached to the named event. |
| hasMethod() | Returns a value indicating whether a method is defined. |
| hasProperty() | Returns a value indicating whether a property is defined for this component. |
| init() | Initializes the object. |
| isColorEnabled() | Returns a value indicating whether ANSI color is enabled. |
| markdownToAnsi() | Converts Markdown to be better readable in console environments by applying some ANSI format. |
| note() | Outputs a note to the console. |
| off() | Detaches an existing event handler from this component. |
| on() | Attaches an event handler to an event. |
| optionAliases() | Returns option alias names. |
| 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. |
| output() | Prints text to STDOUT appended with a carriage return (PHP_EOL). |
| passwordPrompt() | Prompts the user for a password and validates it. |
| prompt() | Prompts the user for input and validates it. |
| render() | Renders a view and applies layout if available. |
| renderContent() | Renders a static string by applying a layout. |
| renderFile() | Renders a view file. |
| renderPartial() | Renders a view without applying layout. |
| run() | Runs a request specified in terms of a route. |
| runAction() | Runs an action with the specified action ID and parameters. |
| 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. |
| setView() | Sets the view object to be used by this controller. |
| setViewPath() | Sets the directory that contains the view files. |
| stderr() | Prints a string to STDERR. |
| stdout() | Prints a string to STDOUT. |
| success() | Outputs a success message to the console. |
| table() | Outputs a table via craft\helpers\Console::table(). |
| tip() | Outputs a tip to the console. |
| trigger() | Triggers an event. |
| warning() | Outputs a warning to the console. |
| writeJson() | JSON-encodes a value and writes it to a file. |
| writeToFile() | Writes contents to a file, and outputs to the console. |
actionBackup() ​
Creates a new database backup.
Example:
php craft db/backup ./my-backups/Arguments ​
$path(string, null) – The path the database backup should be created at. Can be any of the following:A full file path
A folder path (backup will be saved in there with a dynamically-generated name)
A filename (backup will be saved in the working directory with the given name)
Blank (backup will be saved to the
storage/backups/folder with a dynamically-generated name)
Returns ​
actionConvertCharset() ​
Converts tables’ character sets and collations. (MySQL only)
Example:
php craft db/convert-charset utf8 utf8_unicode_ciArguments ​
$charset(string, null) – The target character set, which honorsDbConfig::$charsetor defaults toutf8.$collation(string, null) – The target collation, which honorsDbConfig::$collationor defaults toutf8_unicode_ci.
Returns ​
actionDropAllTables() ​
- Since
- 4.1.0
Drops all tables in the database.
Example:
php craft db/drop-all-tablesThrows ​
actionDropTablePrefix() ​
- Since
- 4.5.10
Drops the database table prefix from all tables.
Arguments ​
$prefix(string, null) – The current table prefix. If omitted, the prefix will be detected automatically.
Returns ​
actionRestore() ​
Restores a database backup.
Example:
php craft db/restore ./my-backup.sqlArguments ​
Returns ​
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.
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.
Arguments ​
$actionID(string) – The action id of the current request
Returns ​
string[] – The names of the options valid for the action
Protected Methods ​
| Method | Description |
|---|---|
| bindInjectedParams() | Fills parameters based on types and names in action method signature. |
| checkRootUser() | Returns whether a command should be executed depending on whether it's being run as a root user, and whether they're OK with that. |
| checkTty() | Sets yii\console\Controller::$interactive to false if this isn’t a TTY shell. |
| createAttributeValidator() | Creates a function for the validator option of Controller::prompt. |
| defineActions() | Returns an array of custom actions that should be available on the controller. |
| getActionMethodReflection() | |
| outputCommand() | |
| parseDocCommentDetail() | Returns full description from the docblock. |
| parseDocCommentSummary() | Returns the first line of docblock. |
| parseDocCommentTags() | Parses the comment block into tags. |
Constants ​
| Constant | Description |
|---|---|
EXIT_CODE_ERROR | |
EXIT_CODE_NORMAL |