setAliases(['dump-schema']) ->setDescription('Dump the schema for your database to a migration.') ->setHelp(<<%command.name% command dumps the schema for your database to a migration: %command.full_name% After dumping your schema to a migration, you can rollup your migrations using the migrations:rollup command. EOT ) ->addOption( 'editor-cmd', null, InputOption::VALUE_OPTIONAL, 'Open file with this command upon creation.' ) ->addOption( 'formatted', null, InputOption::VALUE_NONE, 'Format the generated SQL.' ) ->addOption( 'line-length', null, InputOption::VALUE_OPTIONAL, 'Max line length of unformatted lines.', 120 ); } /** * @throws SchemaDumpRequiresNoMigrations */ public function execute( InputInterface $input, OutputInterface $output ) : ?int { $formatted = (bool) $input->getOption('formatted'); $lineLength = (int) $input->getOption('line-length'); $schemaDumper = $this->dependencyFactory->getSchemaDumper(); $versions = $this->migrationRepository->getVersions(); if (count($versions) > 0) { throw SchemaDumpRequiresNoMigrations::new(); } 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(); $path = $schemaDumper->dump( $versionNumber, $formatted, $lineLength ); $editorCommand = $input->getOption('editor-cmd'); if ($editorCommand !== null) { $this->procOpen($editorCommand, $path); } $output->writeln([ sprintf('Dumped your schema to a new migration class at "%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 ), '', 'To use this as a rollup migration you can use the migrations:rollup command.', ]); return 0; } }