public function __construct(TranslatorInterface $translator, EventDispatcherInterface $dispatcher = null, LoggerInterface $logger = null, GuzzleClient $httpClient = null)
{
parent::__construct($translator, $dispatcher, $logger);
$this->httpClient = $httpClient ?: new GuzzleClient();
$version = new Version();
$this->httpClient->setUserAgent(sprintf('Phraseanet/%s (%s)', $version->getNumber(), $version->getName()));
}
protected function doExecute(InputInterface $input, OutputInterface $output)
{
$interactive = !$input->getOption('yes');
$dialog = $this->getHelperSet()->get('dialog');
if (!$this->container['phraseanet.configuration']->isSetup()) {
throw new RuntimeException(sprintf('Phraseanet is not setup. You can run <info>bin/setup system::install</info> command to install Phraseanet.'));
}
// get dbs
$conf = $this->container['phraseanet.configuration']->getConfig();
$dbs = array('ab' => $conf['main']['database']['dbname'], 'dbs' => array(), 'setup_dbs' => array());
foreach ($this->container->getDataboxes() as $databox) {
$dbs['dbs'][] = $databox;
}
if (count($dbs['dbs']) > 1) {
if ($input->getOption('db-name')) {
$dbName = $input->getOption('db-name');
} else {
$dialog = $this->getHelperSet()->get('dialog');
$dbName = $dialog->ask($output, _('Please enter the databox name to reset or create'));
}
} else {
if ($input->getOption('db-name')) {
$dbName = $input->getOption('db-name');
} else {
$dbName = current($dbs['dbs'])->get_dbname();
}
}
$continue = 'y';
if (count($dbs['dbs']) > 1 && in_array($dbName, array_map(function ($db) {
return $db->get_dbname();
}, $dbs['dbs']))) {
if ($interactive) {
do {
$continue = mb_strtolower($dialog->ask($output, '<question>' . $dbName . ' database is going to be truncated, do you want to continue ? (Y/n)</question>', 'Y'));
} while (!in_array($continue, array('y', 'n')));
}
}
if ('y' !== $continue) {
return;
}
$unmountedDbs = $dbToMount = array_diff(array_map(function ($db) {
return $db->get_dbname();
}, $dbs['dbs']), array($dbName));
if (count($unmountedDbs) > 1 && $interactive) {
array_unshift($unmountedDbs, 'all');
$selected = $dialog->select($output, 'Choose Dbs to mount', $unmountedDbs, 0, false, 'Invalid choice', true);
$dbToMount = array_map(function ($c) use($unmountedDbs) {
return $unmountedDbs[$c];
}, $selected);
}
if ($input->getOption('dependencies') || !SemVer::eq($this->container->getApplicationBox()->get_version(), $this->container['phraseanet.version']->getNumber())) {
$this->getApplication()->find('dependencies:all')->run(new ArrayInput(array('command' => 'dependencies:all')), $output);
}
// get data paths
$dataPath = $this->container['conf']->get(['main', 'storage', 'subdefs'], $this->container['root.path'] . '/datas');
$schema = $this->container['orm.em']->getConnection()->getSchemaManager();
$output->writeln('Creating database "' . $dbs['ab'] . '"...<info>OK</info>');
$schema->dropAndCreateDatabase($dbs['ab']);
$output->writeln('Creating database "' . $dbName . '"...<info>OK</info>');
$schema->dropAndCreateDatabase($dbName);
// inject v3.1 fixtures
if ($input->getOption('run-patches')) {
$content = file_get_contents($this->container['root.path'] . '/resources/hudson/connexion.inc');
$content = str_replace('{{dbname}}', $conf['main']['database']['dbname'], $content);
$content = str_replace('{{hostname}}', $conf['main']['database']['host'], $content);
$content = str_replace('{{port}}', $conf['main']['database']['port'], $content);
$content = str_replace('{{user}}', $conf['main']['database']['user'], $content);
$content = str_replace('{{password}}', $conf['main']['database']['password'], $content);
$tmpFile = tempnam(sys_get_temp_dir(), 'connexion.inc-v3.1-');
$this->container['filesystem']->dumpFile($tmpFile, $content);
$this->container['filesystem']->copy($tmpFile, $this->container['root.path'] . '/config/connexion.inc');
$this->container['filesystem']->copy($this->container['root.path'] . '/resources/hudson/_GV.php', $this->container['root.path'] . '/config/_GV.php');
$content = file_get_contents($this->container['root.path'] . '/resources/hudson/fixtures.sql');
$content = str_replace('{{APPLICATION_BOX}}', $dbs['ab'], $content);
$content = str_replace('{{DATA_BOX}}', $dbName, $content);
$content = str_replace('{{DB_HOST}}', $conf['main']['database']['host'], $content);
$content = str_replace('{{DB_PORT}}', $conf['main']['database']['port'], $content);
$content = str_replace('{{DB_USER}}', $conf['main']['database']['user'], $content);
$content = str_replace('{{DB_PASSWORD}}', $conf['main']['database']['password'], $content);
$content = str_replace('{{DATA_BOX}}', $dbName, $content);
$content = str_replace('{{USER_EMAIL}}', $input->getOption('email'), $content);
$content = str_replace('{{USER_PASSWORD}}', hash('sha256', $input->getOption('password')), $content);
$tmpFile = tempnam(sys_get_temp_dir(), 'fixtures-v3.1-');
$this->container['filesystem']->dumpFile($tmpFile, $content);
$verbosity = $output->getVerbosity();
$output->setVerbosity(OutputInterface::VERBOSITY_QUIET);
$this->getApplication()->find('dbal:import')->run(new ArrayInput(array('command' => 'dbal:import', 'file' => $tmpFile)), $output);
$output->setVerbosity($verbosity);
$output->writeln('Importing Phraseanet v3.1 fixtures...<info>OK</info>');
} else {
$this->getApplication()->find('system:uninstall')->run(new ArrayInput(array('command' => 'system:uninstall')), $output);
$cmd = sprintf('php ' . __DIR__ . '/../../../../../bin/setup system:install --email=%s --password=%s --db-user=%s --db-template=%s --db-password=%s --databox=%s --appbox=%s --server-name=%s --db-host=%s --db-port=%s -y', $input->getOption('email'), $input->getOption('password'), $conf['main']['database']['user'], 'en', $conf['main']['database']['password'], $dbName, $dbs['ab'], $conf['servername'], $conf['main']['database']['host'], $conf['main']['database']['port']);
$process = new Process($cmd);
$process->setTimeout(300);
$process->run(function ($type, $buffer) {
if ('err' === $type) {
echo 'ERR > ' . $buffer;
}
});
if (false === $process->isSuccessful()) {
$output->writeln('<error>Failed to execute the following command "' . $cmd . '"</error>');
return 1;
}
$output->writeln("<info>Install successful !</info>");
}
foreach ($dbs['dbs'] as $databox) {
if (!in_array($databox->get_dbname(), $dbToMount) && !in_array('all', $dbToMount)) {
continue;
}
$credentials = $databox->get_connection()->get_credentials();
\databox::mount($this->container, $credentials['hostname'], $credentials['port'], $credentials['user'], $credentials['password'], $databox->get_dbname());
$output->writeln('Mounting database "' . $databox->get_dbname() . '"...<info>OK</info>');
}
if ($input->getOption('run-patches') || false === $this->container['phraseanet.configuration']->isUpToDate()) {
$version = new Version();
if ($input->getOption('run-patches')) {
$output->write(sprintf('Upgrading... from version <info>3.1.21</info> to <info>%s</info>', $version->getNumber()), true);
} else {
$output->write(sprintf('Upgrading... from version <info>%s</info> to <info>%s</info>', $this->app->getApplicationBox()->get_version(), $version->getNumber()), true);
}
$cmd = 'php ' . __DIR__ . '/../../../../../bin/setup system:upgrade -y -f -v';
$process = new Process($cmd);
$process->setTimeout(600);
$process->run(function ($type, $buffer) {
if ('err' === $type) {
echo 'ERR > ' . $buffer;
}
});
if (false === $process->isSuccessful()) {
$output->writeln('<error>Failed to execute the following command "' . $cmd . '"</error>');
return 1;
}
}
if (!$input->getOption('no-setup-dbs')) {
// create setup dbs
$command = $this->getApplication()->find('ini:setup-tests-dbs');
$input = new ArrayInput(array('command' => 'ini:setup-tests-dbs'));
$command->run($input, $output);
}
$this->container['conf']->set(['main', 'storage', 'subdefs'], $dataPath);
return 0;
}
public function testGetName()
{
$this->assertTrue(is_string(Version::getName()));
$this->assertTrue(strlen(Version::getName()) > 3);
}
/**
* @param Version $version
* @return bool
* @throws \Doctrine\DBAL\DBALException
*/
public function saveVersion(Version $version)
{
$this->connection->exec("DELETE FROM pref WHERE prop='version'");
$statement = $this->connection->executeQuery('INSERT INTO pref (prop, value, locale, updated_on) VALUES ("version", :version, "", NOW())', [':version' => $version->getNumber()]);
return $statement->rowCount() == 1;
}
protected function setVersion(PhraseaVersion $version)
{
try {
$sql = '';
if ($this->get_base_type() === self::APPLICATION_BOX) {
$sql = 'UPDATE sitepreff SET version = "' . $version->getNumber() . '"';
}
if ($this->get_base_type() === self::DATA_BOX) {
$sql = 'DELETE FROM pref WHERE prop="version" AND locale IS NULL';
$this->get_connection()->query($sql);
$sql = 'REPLACE INTO pref (id, prop, value,locale, updated_on) VALUES (null, "version", :version,"", NOW())';
}
if ($sql !== '') {
$stmt = $this->get_connection()->prepare($sql);
$stmt->execute([':version' => $version->getNumber()]);
$stmt->closeCursor();
$this->version = $version->getNumber();
return true;
}
} catch (\Exception $e) {
throw new Exception('Unable to set the database version : ' . $e->getMessage());
}
return;
}
/**
* @param Version $version
* @return bool
*/
public function saveVersion(Version $version)
{
$statement = $this->connection->executeQuery('UPDATE sitepreff SET version = :version WHERE id = 1', [':version' => $version->getNumber()]);
return $statement->rowCount() == 1;
}
public function testGetName()
{
$version = new Version();
$this->assertTrue(is_string($version->getName()));
$this->assertTrue(strlen($version->getName()) > 3);
}
protected function doExecute(InputInterface $input, OutputInterface $output)
{
$interactive = !$input->getOption('yes');
while ($migrations = $this->container['phraseanet.configuration-tester']->getMigrations()) {
foreach ($migrations as $migration) {
$migration->migrate();
}
}
if (!$this->getService('phraseanet.configuration-tester')->isInstalled()) {
throw new \RuntimeException('Phraseanet must be set-up');
}
$output->write('Phraseanet is going to be upgraded', true);
if ($interactive) {
$dialog = $this->getHelperSet()->get('dialog');
do {
$continue = mb_strtolower($dialog->ask($output, '<question>' . $this->container->trans('Continuer ?') . ' (Y/n)</question>', 'Y'));
} while (!in_array($continue, ['y', 'n']));
} else {
$continue = 'y';
}
if ($continue == 'y') {
$output->write(sprintf('Upgrading... from version <info>%s</info> to <info>%s</info>', $this->container['phraseanet.appbox']->get_version(), Version::getNumber()), true);
try {
$upgrader = new Setup_Upgrade($this->container, $input->getOption('force'));
} catch (\Exception_Setup_FixBadEmailAddresses $e) {
return $output->writeln(sprintf('<error>You have to fix your database before upgrade with the system:mailCheck command </error>'));
}
$queries = $this->getService('phraseanet.appbox')->forceUpgrade($upgrader, $this->container);
if ($input->getOption('dump') || $input->getOption('stderr')) {
if (0 < count($queries)) {
$output->writeln("Some SQL queries can be executed to optimize\n");
$stderr = $input->getOption('stderr');
if ($stderr) {
$handle = fopen('php://stderr', 'a');
}
foreach ($queries as $query) {
if ($stderr) {
fwrite($handle, $query['sql'] . "\n");
} else {
$output->writeln(" " . $query['sql']);
}
}
if ($stderr) {
fclose($handle);
}
$output->writeln("\n");
} else {
$output->writeln("No SQL queries to execute to optimize\n");
}
}
foreach ($upgrader->getRecommendations() as $recommendation) {
list($message, $command) = $recommendation;
$output->writeln(sprintf('<info>%s</info>', $message));
$output->writeln("");
$output->writeln(sprintf("\t\t%s", $command));
$output->writeln("");
$output->writeln("");
}
if (null !== $this->getApplication()) {
$command = $this->getApplication()->find('crossdomain:generate');
$command->run(new ArrayInput(array('command' => 'crossdomain:generate')), $output);
}
} else {
$output->write('<info>Canceled</info>', true);
}
$output->write('Finished !', true);
return 0;
}
