/**
* @param InputInterface $input
* @param OutputInterface $output
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$this->output = $output;
$this->verbose = !empty($input->getOption('output'));
$this->outputLine('', true);
$this->outputLine('<info>PHP MySQL Diff</info> <comment>1.0.0</comment>');
$this->outputLine('----------------------------------------');
$this->outputLine();
$from = $input->getArgument('from');
$to = $input->getArgument('to');
if (!file_exists($from)) {
$this->outputLine('<error>' . sprintf('File not found: %s', $from) . '</error>');
exit(1);
}
if (!file_exists($to)) {
$this->outputLine('<error>' . sprintf('File not found: %s', $to) . '</error>');
exit(1);
}
$ignoreTables = [];
if ($input->getOption('ignore')) {
$ignoreListFile = $input->getOption('ignore');
if (!file_exists($ignoreListFile)) {
$this->outputLine('<error>' . sprintf('File not found: %s', $ignoreListFile) . '</error>');
exit(1);
}
$ignoreTables = file($ignoreListFile);
}
$parser = new Parser();
$this->outputString('• Parsing initial database ......');
$fromDatabase = $parser->parseDatabase(file_get_contents($from));
$this->outputLine(' <info>✓</info>');
$this->outputString('• Parsing target database .......');
$toDatabase = $parser->parseDatabase(file_get_contents($to));
$this->outputLine(' <info>✓</info>');
$this->outputString('• Comparing databases ...........');
$differ = new Differ();
$databaseDiff = $differ->diffDatabases($fromDatabase, $toDatabase, $ignoreTables);
$this->outputLine(' <info>✓</info>');
if ($databaseDiff->isEmptyDifferences()) {
$this->outputLine();
$this->outputLine('<comment>The databases have the same schema!</comment>');
exit;
}
$this->outputString('• Generating migration script ...');
$migrationScript = $differ->generateMigrationScript($databaseDiff, (bool) $input->getOption('progress'));
$this->outputLine(' <info>✓</info>');
if ($this->verbose) {
$this->outputString('• Writing output file ...........');
$outputFile = $input->getOption('output');
file_put_contents($outputFile, $migrationScript);
$this->outputLine(' <info>✓</info>');
$this->outputLine();
$this->outputLine('<comment>Migration script generated!</comment>');
} else {
$this->outputLine($migrationScript, true);
}
}
public function testIsGeneratingMigrationScript()
{
$parser = new Parser();
$fromDatabase = $parser->parseDatabase($this->getDatabaseFixture('sakila.sql'));
$toDatabase = $parser->parseDatabase($this->getDatabaseFixture('sakila_new.sql'));
$differ = new Differ();
$databaseDiff = $differ->diffDatabases($fromDatabase, $toDatabase);
$result = $differ->generateMigrationScript($databaseDiff);
$this->assertEquals($this->getDatabaseFixture('sakila_migration.sql'), $result);
}