. */ namespace Doctrine\DBAL\Migrations\Tools\Console\Command; use Symfony\Component\Console\Input\InputInterface; use Symfony\Component\Console\Output\OutputInterface; use Symfony\Component\Console\Input\InputArgument; use Symfony\Component\Console\Input\InputOption; /** * Command for executing single migrations up or down manually. * * @license http://www.opensource.org/licenses/lgpl-license.php LGPL * @link www.doctrine-project.org * @since 2.0 * @author Jonathan Wage */ class ExecuteCommand extends AbstractCommand { protected function configure() { $this ->setName('migrations:execute') ->setDescription('Execute a single migration version up or down manually.') ->addArgument('version', InputArgument::REQUIRED, 'The version to execute.', null) ->addOption('write-sql', null, InputOption::VALUE_NONE, 'The path to output the migration SQL file instead of executing it.') ->addOption('dry-run', null, InputOption::VALUE_NONE, 'Execute the migration as a dry run.') ->addOption('up', null, InputOption::VALUE_NONE, 'Execute the migration up.') ->addOption('down', null, InputOption::VALUE_NONE, 'Execute the migration down.') ->addOption('query-time', null, InputOption::VALUE_NONE, 'Time all the queries individually.') ->setHelp(<<%command.name% command executes a single migration version up or down manually: %command.full_name% YYYYMMDDHHMMSS If no --up or --down option is specified it defaults to up: %command.full_name% YYYYMMDDHHMMSS --down You can also execute the migration as a --dry-run: %command.full_name% YYYYMMDDHHMMSS --dry-run You can output the would be executed SQL statements to a file with --write-sql: %command.full_name% YYYYMMDDHHMMSS --write-sql Or you can also execute the migration without a warning message which you need to interact with: %command.full_name% --no-interaction EOT ); parent::configure(); } public function execute(InputInterface $input, OutputInterface $output) { $version = $input->getArgument('version'); $direction = $input->getOption('down') ? 'down' : 'up'; $configuration = $this->getMigrationConfiguration($input, $output); $version = $configuration->getVersion($version); $timeAllqueries = $input->getOption('query-time'); if ($path = $input->getOption('write-sql')) { $path = is_bool($path) ? getcwd() : $path; $version->writeSqlFile($path, $direction); } else { if ($input->getOption('no-interaction')) { $execute = true; } else { $execute = $this->getHelper('dialog')->askConfirmation($output, 'WARNING! You are about to execute a database migration that could result in schema changes and data lost. Are you sure you wish to continue? (y/n)', false); } if ($execute) { $version->execute($direction, (boolean) $input->getOption('dry-run')); } else { $output->writeln('Migration cancelled!'); } } } }