setName('wallabag:install') ->setDescription('wallabag installer.') ->addOption( 'reset', null, InputOption::VALUE_NONE, 'Reset current database' ) ; } protected function execute(InputInterface $input, OutputInterface $output) { $this->defaultInput = $input; $this->io = new SymfonyStyle($input, $output); $this->io->title('Wallabag installer'); $this ->checkRequirements() ->setupDatabase() ->setupAdmin() ->setupConfig() ; $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->io->section('Step 1 of 4: Checking system requirements.'); $doctrineManager = $this->getContainer()->get('doctrine')->getManager(); $rows = []; // testing if database driver exists $fulfilled = true; $label = 'PDO Driver (%s)'; $status = 'OK!'; $help = ''; if (!\extension_loaded($this->getContainer()->getParameter('database_driver'))) { $fulfilled = false; $status = 'ERROR!'; $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 = 'Database connection'; $status = 'OK!'; $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!'; $help = 'Can\'t connect to the database: ' . $e->getMessage(); } } $rows[] = [$label, $status, $help]; // check MySQL & PostgreSQL version $label = 'Database version'; $status = 'OK!'; $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!'; $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!'; $help = 'PostgreSQL should be greater than 9.1 (actual version: ' . $matches[1] . ')'; } } $rows[] = [$label, $status, $help]; foreach ($this->functionExists as $functionRequired) { $label = '' . $functionRequired . ''; $status = 'OK!'; $help = ''; if (!\function_exists($functionRequired)) { $fulfilled = false; $status = 'ERROR!'; $help = 'You need the ' . $functionRequired . ' function activated'; } $rows[] = [$label, $status, $help]; } $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.'); } $this->io->success('Success! Your system can run wallabag properly.'); return $this; } protected function setupDatabase() { $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->io->text('Dropping database, creating database and schema, clearing the cache'); $this ->runCommand('doctrine:database:drop', ['--force' => true]) ->runCommand('doctrine:database:create') ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true]) ->runCommand('cache:clear') ; $this->io->newLine(); return $this; } if (!$this->isDatabasePresent()) { $this->io->text('Creating database and schema, clearing the cache'); $this ->runCommand('doctrine:database:create') ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true]) ->runCommand('cache:clear') ; $this->io->newLine(); return $this; } 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', ['--force' => true]) ->runCommand('doctrine:database:create') ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true]) ; } elseif ($this->isSchemaPresent()) { 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', ['--force' => true]) ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true]) ; } } else { $this->io->text('Creating schema...'); $this ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true]) ; } $this->io->text('Clearing the cache...'); $this->runCommand('cache:clear'); $this->io->newLine(); $this->io->text('Database successfully setup.'); return $this; } protected function setupAdmin() { $this->io->section('Step 3 of 4: Administration setup.'); if (!$this->io->confirm('Would you like to create a new admin user (recommended)?', true)) { return $this; } $em = $this->getContainer()->get('doctrine.orm.entity_manager'); $userManager = $this->getContainer()->get('fos_user.user_manager'); $user = $userManager->createUser(); $user->setUsername($this->io->ask('Username', 'wallabag')); $question = new Question('Password', 'wallabag'); $question->setHidden(true); $user->setPlainPassword($this->io->askQuestion($question)); $user->setEmail($this->io->ask('Email', '')); $user->setEnabled(true); $user->addRole('ROLE_SUPER_ADMIN'); $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('Administration successfully setup.'); return $this; } protected function setupConfig() { $this->io->section('Step 4 of 4: Config setup.'); $em = $this->getContainer()->get('doctrine.orm.entity_manager'); // 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->io->text('Config successfully setup.'); return $this; } /** * Run a command. * * @param string $command * @param array $parameters Parameters to this command (usually 'force' => true) */ protected function runCommand($command, $parameters = []) { $parameters = array_merge( ['command' => $command], $parameters, [ '--no-debug' => true, '--env' => $this->defaultInput->getOption('env') ?: 'dev', ] ); if ($this->defaultInput->getOption('no-interaction')) { $parameters = array_merge($parameters, ['--no-interaction' => true]); } $this->getApplication()->setAutoExit(false); $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; } /** * Check if the database already exists. * * @return bool */ private function isDatabasePresent() { $connection = $this->getContainer()->get('doctrine')->getManager()->getConnection(); $databaseName = $connection->getDatabase(); 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()) { $params = $this->getContainer()->get('doctrine.dbal.default_connection')->getParams(); if (isset($params['path']) && file_exists($params['path'])) { return true; } return false; } 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; } } /** * Check if the schema is already created. * If we found at least oen table, it means the schema exists. * * @return bool */ private function isSchemaPresent() { $schemaManager = $this->getContainer()->get('doctrine')->getManager()->getConnection()->getSchemaManager(); return \count($schemaManager->listTableNames()) > 0 ? true : false; } }