. */ namespace Doctrine\DBAL\Migrations\Tools\Console\Command; use Symfony\Component\Console\Input\InputInterface; use Symfony\Component\Console\Output\OutputInterface; use Symfony\Component\Console\Input\InputOption; /** * Command to view the status of a set of migrations. * * @license http://www.opensource.org/licenses/lgpl-license.php LGPL * @link www.doctrine-project.org * @since 2.0 * @author Jonathan Wage */ class StatusCommand extends AbstractCommand { protected function configure() { $this ->setName('migrations:status') ->setDescription('View the status of a set of migrations.') ->addOption('show-versions', null, InputOption::VALUE_NONE, 'This will display a list of all available migrations and their status') ->setHelp(<<%command.name% command outputs the status of a set of migrations: %command.full_name% You can output a list of all available migrations and their status with --show-versions: %command.full_name% --show-versions EOT ); parent::configure(); } public function execute(InputInterface $input, OutputInterface $output) { $configuration = $this->getMigrationConfiguration($input, $output); $formattedVersions = array(); foreach (array('prev', 'current', 'next', 'latest') as $alias) { $version = $configuration->resolveVersionAlias($alias); if ($version === null) { if ($alias == 'next') { $formattedVersions[$alias] = 'Already at latest version'; } elseif ($alias == 'prev') { $formattedVersions[$alias] = 'Already at first version'; } } elseif ($version === '0') { $formattedVersions[$alias] = '0'; } else { $formattedVersions[$alias] = $configuration->formatVersion($version) . ' (' . $version . ')'; } } $executedMigrations = $configuration->getMigratedVersions(); $availableMigrations = $configuration->getAvailableVersions(); $executedUnavailableMigrations = array_diff($executedMigrations, $availableMigrations); $numExecutedUnavailableMigrations = count($executedUnavailableMigrations); $newMigrations = count(array_diff($availableMigrations, $executedMigrations)); $output->writeln("\n == Configuration\n"); $info = array( 'Name' => $configuration->getName() ? $configuration->getName() : 'Doctrine Database Migrations', 'Database Driver' => $configuration->getConnection()->getDriver()->getName(), 'Database Name' => $configuration->getConnection()->getDatabase(), 'Configuration Source' => $configuration instanceof \Doctrine\DBAL\Migrations\Configuration\AbstractFileConfiguration ? $configuration->getFile() : 'manually configured', 'Version Table Name' => $configuration->getMigrationsTableName(), 'Migrations Namespace' => $configuration->getMigrationsNamespace(), 'Migrations Directory' => $configuration->getMigrationsDirectory(), 'Previous Version' => $formattedVersions['prev'], 'Current Version' => $formattedVersions['current'], 'Next Version' => $formattedVersions['next'], 'Latest Version' => $formattedVersions['latest'], 'Executed Migrations' => count($executedMigrations), 'Executed Unavailable Migrations' => $numExecutedUnavailableMigrations > 0 ? ''.$numExecutedUnavailableMigrations.'' : 0, 'Available Migrations' => count($availableMigrations), 'New Migrations' => $newMigrations > 0 ? '' . $newMigrations . '' : 0 ); foreach ($info as $name => $value) { $output->writeln(' >> ' . $name . ': ' . str_repeat(' ', 50 - strlen($name)) . $value); } if ($input->getOption('show-versions')) { if ($migrations = $configuration->getMigrations()) { $output->writeln("\n == Available Migration Versions\n"); $migratedVersions = $configuration->getMigratedVersions(); foreach ($migrations as $version) { $isMigrated = in_array($version->getVersion(), $migratedVersions); $status = $isMigrated ? 'migrated' : 'not migrated'; $migrationName = $version->getMigration()->getDescription(); if ($migrationName) { $migrationName = str_repeat(' ', 10) . $migrationName; } $output->writeln(' >> ' . $configuration->formatVersion($version->getVersion()) . ' (' . $version->getVersion() . ')' . str_repeat(' ', 30 - strlen($name)) . $status . $migrationName); } } if ($executedUnavailableMigrations) { $output->writeln("\n == Previously Executed Unavailable Migration Versions\n"); foreach ($executedUnavailableMigrations as $executedUnavailableMigration) { $output->writeln(' >> ' . $configuration->formatVersion($executedUnavailableMigration) . ' (' . $executedUnavailableMigration . ')'); } } } } }