schemaProvider = $schemaProvider; parent::__construct(); } protected function configure() : void { parent::configure(); $this ->setAliases(['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( 'editor-cmd', null, InputOption::VALUE_OPTIONAL, 'Open file with this command upon creation.' ) ->addOption( 'filter-expression', null, InputOption::VALUE_OPTIONAL, 'Tables which are filtered by Regular Expression.' ) ->addOption( 'formatted', null, InputOption::VALUE_NONE, 'Format the generated SQL.' ) ->addOption( 'line-length', null, InputOption::VALUE_OPTIONAL, 'Max line length of unformatted lines.', 120 ) ->addOption( 'check-database-platform', null, InputOption::VALUE_OPTIONAL, 'Check Database Platform to the generated code.', true ) ->addOption( 'allow-empty-diff', null, InputOption::VALUE_NONE, 'Do not throw an exception when no changes are detected.' ) ->addOption( 'from-empty-schema', null, InputOption::VALUE_NONE, 'Generate a full migration as if the current database was empty.' ); } /** * @throws InvalidOptionUsage */ public function execute( InputInterface $input, OutputInterface $output ) : ?int { $filterExpression = $input->getOption('filter-expression') ?? null; $formatted = (bool) $input->getOption('formatted'); $lineLength = (int) $input->getOption('line-length'); $allowEmptyDiff = (bool) $input->getOption('allow-empty-diff'); $checkDbPlatform = filter_var($input->getOption('check-database-platform'), FILTER_VALIDATE_BOOLEAN); $fromEmptySchema = (bool) $input->getOption('from-empty-schema'); if ($formatted) { if (! class_exists('SqlFormatter')) { throw InvalidOptionUsage::new( 'The "--formatted" option can only be used if the sql formatter is installed. Please run "composer require jdorn/sql-formatter".' ); } } $versionNumber = $this->configuration->generateVersionNumber(); try { $path = $this->createMigrationDiffGenerator()->generate( $versionNumber, $filterExpression, $formatted, $lineLength, $checkDbPlatform, $fromEmptySchema ); } catch (NoChangesDetected $exception) { if ($allowEmptyDiff) { $output->writeln($exception->getMessage()); return 0; } throw $exception; } $editorCommand = $input->getOption('editor-cmd'); if ($editorCommand !== null) { $this->procOpen($editorCommand, $path); } $output->writeln([ sprintf('Generated new migration class to "%s"', $path), '', sprintf( 'To run just this migration for testing purposes, you can use migrations:execute --up %s', $versionNumber ), '', sprintf( 'To revert the migration you can use migrations:execute --down %s', $versionNumber ), ]); return 0; } protected function createMigrationDiffGenerator() : DiffGenerator { return new DiffGenerator( $this->connection->getConfiguration(), $this->connection->getSchemaManager(), $this->getSchemaProvider(), $this->connection->getDatabasePlatform(), $this->dependencyFactory->getMigrationGenerator(), $this->dependencyFactory->getMigrationSqlGenerator(), $this->getEmptySchemaProvider() ); } private function getSchemaProvider() : SchemaProviderInterface { if ($this->schemaProvider === null) { $this->schemaProvider = new OrmSchemaProvider( $this->getHelper('entityManager')->getEntityManager() ); } return $this->schemaProvider; } private function getEmptySchemaProvider() : EmptySchemaProvider { if ($this->emptySchemaProvider === null) { $this->emptySchemaProvider = new EmptySchemaProvider( $this->connection->getSchemaManager() ); } return $this->emptySchemaProvider; } }