function init(Master $master, DBAL $adapter)
{
if (!$master->getJobs()->findByPk(array('id_job' => 0))) {
$job = $master->create('job', array('name' => 'Scheduler', 'status' => 'A', 'system' => true));
$job->save();
$adapter->commit();
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$fs = new Filesystem();
$schema = $this->application->getStorage()->getSchema();
// create.sql
$dbalToSchema = $this->dbalConverter->convert($schema);
$dbalFromSchema = $schema = new \Doctrine\DBAL\Schema\Schema();
$this->generator->setToSchema($dbalToSchema);
$this->generator->setFromSchema($dbalFromSchema);
$queries = $this->generator->migrate();
$debug = $input->getArgument('debug') == true;
$create = $this->application->getProject()->getPath('build sql create.sql');
if ($debug) {
echo "- build create.sql" . PHP_EOL;
}
$output->writeln('Create ' . $create);
$fs->dumpFile($create, implode(";\n", $queries) . ';');
// migrate.sql
$dbalFromSchema = $this->dbal->getSchemaManager()->createSchema();
$this->generator->setFromSchema($dbalFromSchema);
$queries = $this->generator->migrate();
$migrate = $this->application->getProject()->getPath('build sql migrate.sql');
if ($debug) {
echo "- build migrate.sql" . PHP_EOL;
}
$output->writeln('Create ' . $migrate);
$fs->dumpFile($migrate, implode(";\n", $queries) . (count($queries) ? ';' : ''));
if (!$debug) {
echo implode(";\n", $queries) . ';';
}
if ($input->getOption('test') != true) {
foreach ($queries as $query) {
$this->dbal->executeQuery($query);
}
if ($input->getOption('commit') == true) {
$this->dbal->commit();
}
}
}
function deleteJob($id_job, JobRepository $repository)
{
$repository->findByPk(array('id_job' => $id_job))->delete();
$this->database->commit();
}
