setName('orm:schema-tool:create') ->setDescription('Processes the schema and either create it directly on EntityManager Storage Connection or generate the SQL output') ->addOption('em', null, InputOption::VALUE_REQUIRED, 'Name of the entity manager to operate on') ->addOption('dump-sql', null, InputOption::VALUE_NONE, 'Instead of trying to apply generated SQLs into EntityManager Storage Connection, output them.') ->setHelp(<<<'EOT' Processes the schema and either create it directly on EntityManager Storage Connection or generate the SQL output. Hint: If you have a database with tables that should not be managed by the ORM, you can use a DBAL functionality to filter the tables and sequences down on a global level: $config->setFilterSchemaAssetsExpression($regexp); EOT ); } /** * {@inheritdoc} */ protected function executeSchemaCommand(InputInterface $input, OutputInterface $output, SchemaTool $schemaTool, array $metadatas, SymfonyStyle $ui) { $dumpSql = $input->getOption('dump-sql') === true; if ($dumpSql) { $sqls = $schemaTool->getCreateSchemaSql($metadatas); $ui->text('The following SQL statements will be executed:'); $ui->newLine(); foreach ($sqls as $sql) { $ui->text(sprintf(' %s;', $sql)); } return 0; } $ui->caution('This operation should not be executed in a production environment!'); $ui->text('Creating database schema...'); $ui->newLine(); $schemaTool->createSchema($metadatas); $ui->success('Database schema created successfully!'); return 0; } }