setName('orm:validate-schema')
->setDescription('Validate the mapping files')
->addOption('em', null, InputOption::VALUE_REQUIRED, 'Name of the entity manager to operate on')
->addOption('skip-mapping', null, InputOption::VALUE_NONE, 'Skip the mapping validation check')
->addOption('skip-sync', null, InputOption::VALUE_NONE, 'Skip checking if the mapping is in sync with the database')
->addOption('skip-property-types', null, InputOption::VALUE_NONE, 'Skip checking if property types match the Doctrine types')
->setHelp('Validate that the mapping files are correct and in sync with the database.');
}
protected function execute(InputInterface $input, OutputInterface $output): int
{
$ui = (new SymfonyStyle($input, $output))->getErrorStyle();
$em = $this->getEntityManager($input);
$validator = new SchemaValidator($em, ! $input->getOption('skip-property-types'));
$exit = 0;
$ui->section('Mapping');
if ($input->getOption('skip-mapping')) {
$ui->text('[SKIPPED] The mapping was not checked.');
} else {
$errors = $validator->validateMapping();
if ($errors) {
foreach ($errors as $className => $errorMessages) {
$ui->text(
sprintf(
'[FAIL] The entity-class %s mapping is invalid:',
$className,
),
);
$ui->listing($errorMessages);
$ui->newLine();
}
++$exit;
} else {
$ui->success('The mapping files are correct.');
}
}
$ui->section('Database');
if ($input->getOption('skip-sync')) {
$ui->text('[SKIPPED] The database was not checked for synchronicity.');
} elseif (! $validator->schemaInSyncWithMetadata()) {
$ui->error('The database schema is not in sync with the current mapping file.');
if ($output->getVerbosity() >= OutputInterface::VERBOSITY_VERBOSE) {
$sqls = $validator->getUpdateSchemaList();
$ui->comment(sprintf('%d schema diff(s) detected:', count($sqls)));
foreach ($sqls as $sql) {
$ui->text(sprintf(' %s;', $sql));
}
}
$exit += 2;
} else {
$ui->success('The database schema is in sync with the mapping files.');
}
return $exit;
}
}