namespace Wallabag\CoreBundle\Command;
+use Craue\ConfigBundle\Entity\Setting;
+use FOS\UserBundle\Event\UserEvent;
+use FOS\UserBundle\FOSUserEvents;
use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
+use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Input\InputOption;
-use Symfony\Component\Console\Input\ArrayInput;
+use Symfony\Component\Console\Output\BufferedOutput;
use Symfony\Component\Console\Output\OutputInterface;
-use Symfony\Component\Console\Output\NullOutput;
-use Wallabag\UserBundle\Entity\User;
-use Wallabag\CoreBundle\Entity\Config;
+use Symfony\Component\Console\Question\Question;
+use Symfony\Component\Console\Style\SymfonyStyle;
class InstallCommand extends ContainerAwareCommand
{
protected $defaultInput;
/**
- * @var OutputInterface
+ * @var SymfonyStyle
+ */
+ protected $io;
+
+ /**
+ * @var array
*/
- protected $defaultOutput;
+ protected $functionExists = [
+ 'curl_exec',
+ 'curl_multi_init',
+ ];
protected function configure()
{
$this
->setName('wallabag:install')
- ->setDescription('Wallabag installer.')
+ ->setDescription('wallabag installer.')
->addOption(
'reset',
null,
protected function execute(InputInterface $input, OutputInterface $output)
{
$this->defaultInput = $input;
- $this->defaultOutput = $output;
- $output->writeln('<info>Installing Wallabag...</info>');
- $output->writeln('');
+ $this->io = new SymfonyStyle($input, $output);
+
+ $this->io->title('Wallabag installer');
$this
->checkRequirements()
->setupDatabase()
->setupAdmin()
- ->setupAsset()
+ ->setupConfig()
;
- $output->writeln('<info>Wallabag has been successfully installed.</info>');
- $output->writeln('<comment>Just execute `php app/console server:run` for using wallabag: http://localhost:8000</comment>');
+ $this->io->success('Wallabag has been successfully installed.');
+ $this->io->success('You can now configure your web server, see https://doc.wallabag.org');
}
protected function checkRequirements()
{
- $this->defaultOutput->writeln('<info><comment>Step 1 of 4.</comment> Checking system requirements.</info>');
+ $this->io->section('Step 1 of 4: Checking system requirements.');
+
+ $doctrineManager = $this->getContainer()->get('doctrine')->getManager();
+
+ $rows = [];
+ // testing if database driver exists
$fulfilled = true;
+ $label = '<comment>PDO Driver (%s)</comment>';
+ $status = '<info>OK!</info>';
+ $help = '';
- // @TODO: find a better way to check requirements
- $label = '<comment>PCRE</comment>';
- if (extension_loaded('pcre')) {
- $status = '<info>OK!</info>';
- $help = '';
- } else {
+ if (!\extension_loaded($this->getContainer()->getParameter('database_driver'))) {
$fulfilled = false;
$status = '<error>ERROR!</error>';
- $help = 'You should enabled PCRE extension';
+ $help = 'Database driver "' . $this->getContainer()->getParameter('database_driver') . '" is not installed.';
+ }
+
+ $rows[] = [sprintf($label, $this->getContainer()->getParameter('database_driver')), $status, $help];
+
+ // testing if connection to the database can be etablished
+ $label = '<comment>Database connection</comment>';
+ $status = '<info>OK!</info>';
+ $help = '';
+
+ try {
+ $conn = $this->getContainer()->get('doctrine')->getManager()->getConnection();
+ $conn->connect();
+ } catch (\Exception $e) {
+ if (false === strpos($e->getMessage(), 'Unknown database')
+ && false === strpos($e->getMessage(), 'database "' . $this->getContainer()->getParameter('database_name') . '" does not exist')) {
+ $fulfilled = false;
+ $status = '<error>ERROR!</error>';
+ $help = 'Can\'t connect to the database: ' . $e->getMessage();
+ }
+ }
+
+ $rows[] = [$label, $status, $help];
+
+ // check MySQL & PostgreSQL version
+ $label = '<comment>Database version</comment>';
+ $status = '<info>OK!</info>';
+ $help = '';
+
+ // now check if MySQL isn't too old to handle utf8mb4
+ if ($conn->isConnected() && 'mysql' === $conn->getDatabasePlatform()->getName()) {
+ $version = $conn->query('select version()')->fetchColumn();
+ $minimalVersion = '5.5.4';
+
+ if (false === version_compare($version, $minimalVersion, '>')) {
+ $fulfilled = false;
+ $status = '<error>ERROR!</error>';
+ $help = 'Your MySQL version (' . $version . ') is too old, consider upgrading (' . $minimalVersion . '+).';
+ }
+ }
+
+ // testing if PostgreSQL > 9.1
+ if ($conn->isConnected() && 'postgresql' === $conn->getDatabasePlatform()->getName()) {
+ // return version should be like "PostgreSQL 9.5.4 on x86_64-apple-darwin15.6.0, compiled by Apple LLVM version 8.0.0 (clang-800.0.38), 64-bit"
+ $version = $doctrineManager->getConnection()->query('SELECT version();')->fetchColumn();
+
+ preg_match('/PostgreSQL ([0-9\.]+)/i', $version, $matches);
+
+ if (isset($matches[1]) & version_compare($matches[1], '9.2.0', '<')) {
+ $fulfilled = false;
+ $status = '<error>ERROR!</error>';
+ $help = 'PostgreSQL should be greater than 9.1 (actual version: ' . $matches[1] . ')';
+ }
}
- $rows[] = array($label, $status, $help);
- $label = '<comment>DOM</comment>';
- if (extension_loaded('DOM')) {
+ $rows[] = [$label, $status, $help];
+
+ foreach ($this->functionExists as $functionRequired) {
+ $label = '<comment>' . $functionRequired . '</comment>';
$status = '<info>OK!</info>';
$help = '';
- } else {
- $fulfilled = false;
- $status = '<error>ERROR!</error>';
- $help = 'You should enabled DOM extension';
+
+ if (!\function_exists($functionRequired)) {
+ $fulfilled = false;
+ $status = '<error>ERROR!</error>';
+ $help = 'You need the ' . $functionRequired . ' function activated';
+ }
+
+ $rows[] = [$label, $status, $help];
}
- $rows[] = array($label, $status, $help);
- $this->getHelper('table')
- ->setHeaders(array('Checked', 'Status', 'Recommendation'))
- ->setRows($rows)
- ->render($this->defaultOutput);
+ $this->io->table(['Checked', 'Status', 'Recommendation'], $rows);
if (!$fulfilled) {
throw new \RuntimeException('Some system requirements are not fulfilled. Please check output messages and fix them.');
- } else {
- $this->defaultOutput->writeln('<info>Success! Your system can run Wallabag properly.</info>');
}
- $this->defaultOutput->writeln('');
+ $this->io->success('Success! Your system can run wallabag properly.');
return $this;
}
protected function setupDatabase()
{
- $this->defaultOutput->writeln('<info><comment>Step 2 of 4.</comment> Setting up database.</info>');
+ $this->io->section('Step 2 of 4: Setting up database.');
// user want to reset everything? Don't care about what is already here
if (true === $this->defaultInput->getOption('reset')) {
- $this->defaultOutput->writeln('Droping database, creating database and schema');
+ $this->io->text('Dropping database, creating database and schema, clearing the cache');
$this
- ->runCommand('doctrine:database:drop', array('--force' => true))
+ ->runCommand('doctrine:database:drop', ['--force' => true])
->runCommand('doctrine:database:create')
- ->runCommand('doctrine:schema:create')
+ ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true])
+ ->runCommand('cache:clear')
;
+ $this->io->newLine();
+
return $this;
}
if (!$this->isDatabasePresent()) {
- $this->defaultOutput->writeln('Creating database and schema, clearing the cache');
+ $this->io->text('Creating database and schema, clearing the cache');
$this
->runCommand('doctrine:database:create')
- ->runCommand('doctrine:schema:create')
+ ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true])
->runCommand('cache:clear')
;
+ $this->io->newLine();
+
return $this;
}
- $dialog = $this->getHelper('dialog');
-
- if ($dialog->askConfirmation($this->defaultOutput, '<question>It appears that your database already exists. Would you like to reset it? (y/N)</question> ', false)) {
- $this->defaultOutput->writeln('Droping database, creating database and schema');
+ if ($this->io->confirm('It appears that your database already exists. Would you like to reset it?', false)) {
+ $this->io->text('Dropping database, creating database and schema...');
$this
- ->runCommand('doctrine:database:drop', array('--force' => true))
+ ->runCommand('doctrine:database:drop', ['--force' => true])
->runCommand('doctrine:database:create')
- ->runCommand('doctrine:schema:create')
+ ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true])
;
} elseif ($this->isSchemaPresent()) {
- if ($dialog->askConfirmation($this->defaultOutput, '<question>Seems like your database contains schema. Do you want to reset it? (y/N)</question> ', false)) {
- $this->defaultOutput->writeln('Droping schema and creating schema');
+ if ($this->io->confirm('Seems like your database contains schema. Do you want to reset it?', false)) {
+ $this->io->text('Dropping schema and creating schema...');
$this
- ->runCommand('doctrine:schema:drop', array('--force' => true))
- ->runCommand('doctrine:schema:create')
+ ->runCommand('doctrine:schema:drop', ['--force' => true])
+ ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true])
;
}
} else {
- $this->defaultOutput->writeln('Creating schema');
+ $this->io->text('Creating schema...');
$this
- ->runCommand('doctrine:schema:create')
+ ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true])
;
}
- $this->defaultOutput->writeln('Clearing the cache');
+ $this->io->text('Clearing the cache...');
$this->runCommand('cache:clear');
- /*
- if ($this->getHelperSet()->get('dialog')->askConfirmation($this->defaultOutput, '<question>Load fixtures (Y/N)?</question>', false)) {
- $doctrineConfig = $this->getContainer()->get('doctrine.orm.entity_manager')->getConnection()->getConfiguration();
- $logger = $doctrineConfig->getSQLLogger();
- // speed up fixture load
- $doctrineConfig->setSQLLogger(null);
- $this->runCommand('doctrine:fixtures:load');
- $doctrineConfig->setSQLLogger($logger);
- }
- */
-
- $this->defaultOutput->writeln('');
+ $this->io->newLine();
+ $this->io->text('<info>Database successfully setup.</info>');
return $this;
}
protected function setupAdmin()
{
- $this->defaultOutput->writeln('<info><comment>Step 3 of 4.</comment> Administration setup.</info>');
-
- $dialog = $this->getHelperSet()->get('dialog');
+ $this->io->section('Step 3 of 4: Administration setup.');
- if (false === $dialog->askConfirmation($this->defaultOutput, '<question>Would you like to create a new user ? (y/N)</question>', true)) {
+ if (!$this->io->confirm('Would you like to create a new admin user (recommended)?', true)) {
return $this;
}
$userManager = $this->getContainer()->get('fos_user.user_manager');
$user = $userManager->createUser();
- $user->setUsername($dialog->ask($this->defaultOutput, '<question>Username</question> <comment>(default: wallabag)</comment> :', 'wallabag'));
- $user->setPlainPassword($dialog->ask($this->defaultOutput, '<question>Password</question> <comment>(default: wallabag)</comment> :', 'wallabag'));
- $user->setEmail($dialog->ask($this->defaultOutput, '<question>Email:</question>', ''));
- $user->setEnabled(true);
- $em->persist($user);
+ $user->setUsername($this->io->ask('Username', 'wallabag'));
- $config = new Config($user);
- $config->setTheme($this->getContainer()->getParameter('theme'));
- $config->setItemsPerPage($this->getContainer()->getParameter('items_on_page'));
- $config->setRssLimit($this->getContainer()->getParameter('rss_limit'));
- $config->setLanguage($this->getContainer()->getParameter('language'));
+ $question = new Question('Password', 'wallabag');
+ $question->setHidden(true);
+ $user->setPlainPassword($this->io->askQuestion($question));
- $em->persist($config);
+ $user->setEmail($this->io->ask('Email', ''));
- $em->flush();
+ $user->setEnabled(true);
+ $user->addRole('ROLE_SUPER_ADMIN');
- $this->defaultOutput->writeln('');
+ $em->persist($user);
+
+ // dispatch a created event so the associated config will be created
+ $event = new UserEvent($user);
+ $this->getContainer()->get('event_dispatcher')->dispatch(FOSUserEvents::USER_CREATED, $event);
+
+ $this->io->text('<info>Administration successfully setup.</info>');
return $this;
}
- protected function setupAsset()
+ protected function setupConfig()
{
- $this->defaultOutput->writeln('<info><comment>Step 4 of 4.</comment> Installing assets.</info>');
+ $this->io->section('Step 4 of 4: Config setup.');
+ $em = $this->getContainer()->get('doctrine.orm.entity_manager');
- $this
- ->runCommand('assets:install')
- ->runCommand('assetic:dump')
- ;
+ // cleanup before insert new stuff
+ $em->createQuery('DELETE FROM CraueConfigBundle:Setting')->execute();
+
+ foreach ($this->getContainer()->getParameter('wallabag_core.default_internal_settings') as $setting) {
+ $newSetting = new Setting();
+ $newSetting->setName($setting['name']);
+ $newSetting->setValue($setting['value']);
+ $newSetting->setSection($setting['section']);
+ $em->persist($newSetting);
+ }
+
+ $em->flush();
- $this->defaultOutput->writeln('');
+ $this->io->text('<info>Config successfully setup.</info>');
return $this;
}
* @param string $command
* @param array $parameters Parameters to this command (usually 'force' => true)
*/
- protected function runCommand($command, $parameters = array())
+ protected function runCommand($command, $parameters = [])
{
$parameters = array_merge(
- array('command' => $command),
+ ['command' => $command],
$parameters,
- array(
+ [
'--no-debug' => true,
'--env' => $this->defaultInput->getOption('env') ?: 'dev',
- )
+ ]
);
if ($this->defaultInput->getOption('no-interaction')) {
- $parameters = array_merge($parameters, array('--no-interaction' => true));
+ $parameters = array_merge($parameters, ['--no-interaction' => true]);
}
$this->getApplication()->setAutoExit(false);
- $exitCode = $this->getApplication()->run(new ArrayInput($parameters), new NullOutput());
-
- if (0 !== $exitCode) {
- $this->getApplication()->setAutoExit(true);
-
- $errorMessage = sprintf('The command "%s" terminated with an error code: %u.', $command, $exitCode);
- $this->defaultOutput->writeln("<error>$errorMessage</error>");
- $exception = new \Exception($errorMessage, $exitCode);
- throw $exception;
- }
+ $output = new BufferedOutput();
+ $exitCode = $this->getApplication()->run(new ArrayInput($parameters), $output);
// PDO does not always close the connection after Doctrine commands.
// See https://github.com/symfony/symfony/issues/11750.
$this->getContainer()->get('doctrine')->getManager()->getConnection()->close();
+ if (0 !== $exitCode) {
+ $this->getApplication()->setAutoExit(true);
+
+ throw new \RuntimeException(
+ 'The command "' . $command . "\" generates some errors: \n\n"
+ . $output->fetch());
+ }
+
return $this;
}
try {
$schemaManager = $connection->getSchemaManager();
} catch (\Exception $exception) {
+ // mysql & sqlite
if (false !== strpos($exception->getMessage(), sprintf("Unknown database '%s'", $databaseName))) {
return false;
}
+ // pgsql
+ if (false !== strpos($exception->getMessage(), sprintf('database "%s" does not exist', $databaseName))) {
+ return false;
+ }
+
throw $exception;
}
// custom verification for sqlite, since `getListDatabasesSQL` doesn't work for sqlite
- if ('sqlite' == $schemaManager->getDatabasePlatform()->getName()) {
+ if ('sqlite' === $schemaManager->getDatabasePlatform()->getName()) {
$params = $this->getContainer()->get('doctrine.dbal.default_connection')->getParams();
if (isset($params['path']) && file_exists($params['path'])) {
return false;
}
- return in_array($databaseName, $schemaManager->listDatabases());
+ try {
+ return \in_array($databaseName, $schemaManager->listDatabases(), true);
+ } catch (\Doctrine\DBAL\Exception\DriverException $e) {
+ // it means we weren't able to get database list, assume the database doesn't exist
+
+ return false;
+ }
}
/**
{
$schemaManager = $this->getContainer()->get('doctrine')->getManager()->getConnection()->getSchemaManager();
- return count($schemaManager->listTableNames()) > 0 ? true : false;
+ return \count($schemaManager->listTableNames()) > 0 ? true : false;
}
}
projects / github / wallabag / wallabag.git / blobdiff