. */ namespace Doctrine\DBAL\Migrations\Tools\Console\Command; use Doctrine\DBAL\Migrations\Configuration\Configuration; use Doctrine\DBAL\Version as DbalVersion; use Doctrine\ORM\Tools\SchemaTool; use Symfony\Component\Console\Input\InputInterface; use Symfony\Component\Console\Output\OutputInterface; use Symfony\Component\Console\Input\InputOption; /** * Command for generate migration classes by comparing your current database schema * to your mapping information. * * @license http://www.opensource.org/licenses/lgpl-license.php LGPL * @link www.doctrine-project.org * @since 2.0 * @author Jonathan Wage */ class DiffCommand extends GenerateCommand { protected function configure() { parent::configure(); $this ->setName('migrations:diff') ->setDescription('Generate a migration by comparing your current database to your mapping information.') ->setHelp(<<%command.name% command generates a migration by comparing your current database to your mapping information: %command.full_name% You can optionally specify a --editor-cmd option to open the generated file in your favorite editor: %command.full_name% --editor-cmd=mate EOT ) ->addOption('filter-expression', null, InputOption::VALUE_OPTIONAL, 'Tables which are filtered by Regular Expression.'); } public function execute(InputInterface $input, OutputInterface $output) { $isDbalOld = (DbalVersion::compare('2.2.0') > 0); $configuration = $this->getMigrationConfiguration($input, $output); $em = $this->getHelper('em')->getEntityManager(); $conn = $em->getConnection(); $platform = $conn->getDatabasePlatform(); $metadata = $em->getMetadataFactory()->getAllMetadata(); if (empty($metadata)) { $output->writeln('No mapping information to process.', 'ERROR'); return; } if ($filterExpr = $input->getOption('filter-expression')) { if ($isDbalOld) { throw new \InvalidArgumentException('The "--filter-expression" option can only be used as of Doctrine DBAL 2.2'); } $conn->getConfiguration() ->setFilterSchemaAssetsExpression($filterExpr); } $tool = new SchemaTool($em); $fromSchema = $conn->getSchemaManager()->createSchema(); $toSchema = $tool->getSchemaFromMetadata($metadata); //Not using value from options, because filters can be set from config.yml if ( ! $isDbalOld && $filterExpr = $conn->getConfiguration()->getFilterSchemaAssetsExpression()) { $tableNames = $toSchema->getTableNames(); foreach ($tableNames as $tableName) { $tableName = substr($tableName, strpos($tableName, '.') + 1); if ( ! preg_match($filterExpr, $tableName)) { $toSchema->dropTable($tableName); } } } $up = $this->buildCodeFromSql($configuration, $fromSchema->getMigrateToSql($toSchema, $platform)); $down = $this->buildCodeFromSql($configuration, $fromSchema->getMigrateFromSql($toSchema, $platform)); if (! $up && ! $down) { $output->writeln('No changes detected in your mapping information.', 'ERROR'); return; } $version = date('YmdHis'); $path = $this->generateMigration($configuration, $input, $version, $up, $down); $output->writeln(sprintf('Generated new migration class to "%s" from schema differences.', $path)); } private function buildCodeFromSql(Configuration $configuration, array $sql) { $currentPlatform = $configuration->getConnection()->getDatabasePlatform()->getName(); $code = array(); foreach ($sql as $query) { if (stripos($query, $configuration->getMigrationsTableName()) !== false) { continue; } $code[] = sprintf("\$this->addSql(%s);", var_export($query, true)); } if ($code) { array_unshift( $code, sprintf( "\$this->abortIf(\$this->connection->getDatabasePlatform()->getName() != %s, %s);", var_export($currentPlatform, true), var_export(sprintf("Migration can only be executed safely on '%s'.", $currentPlatform), true) ), "" ); } return implode("\n", $code); } }