DatabaseCommandController

Constructs the command controller

No description

Injects the reflection service

Processes a command line request.

Resolves and checks the current command method name

Note: The resulting command method name might not have the correct case, which isn't a problem because PHP is case insensitive regarding method names.

Initializes the arguments array of this controller by creating an empty argument object for each of the method arguments found in the designated command method.

Maps arguments delivered by the request object to the local controller arguments.

Forwards the request to another command and / or CommandController.

Request is directly transferred to the other command / controller without the need for a new request.

Calls the specified command method and passes the arguments.

If the command returns a string, it is appended to the content in the response object. If the command doesn't return anything and a valid view exists, the view is rendered automatically.

Returns the CLI Flow command depending on the environment

Outputs specified text to the console window You can specify arguments that will be passed to the text via sprintf

Outputs specified text to the console window and appends a line break

Formats the given text to fit into MAXIMUM_LINE_LENGTH and outputs it to the console window

Exits the CLI through the dispatcher and makes sure that Flow is properly shut down.

If your command relies on functionality which is triggered through the Bootstrap shutdown (such as the persistence framework), you must use quit() instead of exit().

Sends the response and exits the CLI without any further code execution Should be used for commands that flush code caches.

Create a Doctrine DBAL Connection with the configured settings.

Convert the database schema to use the given character set and collation (defaults to utf8mb4 and utf8mb4_unicode_ci).

This command can be used to convert the database configured in the Flow settings to the utf8mb4 character set and the utf8mb4_unicode_ci collation (by default, a custom collation can be given). It will only work when using the pdo_mysql driver.

Make a backup before using it, to be on the safe side. If you want to inspect the statements used for conversion, you can use the $output parameter to write them into a file. This file can be used to do the conversion manually.

For background information on this, see:

• http://stackoverflow.com/questions/766809/
• http://dev.mysql.com/doc/refman/5.5/en/alter-table.html
• https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434
• https://mathiasbynens.be/notes/mysql-utf8mb4
• https://florian.ec/articles/mysql-doctrine-utf8/

The main purpose of this is to fix setups that were created with Flow before version 5.0. In those cases, the tables will have a collation that does not match the default collation of later Flow versions, potentially leading to problems when creating foreign key constraints (among others, potentially).

If you have special needs regarding the charset and collation, you can override the defaults with different ones.

Note: This command is not a general purpose conversion tool. It will specifically not fix cases of actual utf8 stored in latin1 columns. For this a conversion to BLOB followed by a conversion to the proper type, charset and collation is needed instead.

Convert the tables in the current database to use given character set and collation.