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->defaultOutput = $output; $output->writeln('Installing Wallabag...'); $output->writeln(''); $this ->checkRequirements() ->setupDatabase() ->setupAdmin() ->setupConfig() ->setupAsset() ; $output->writeln('Wallabag has been successfully installed.'); $output->writeln('Just execute `php bin/console server:run --env=prod` for using wallabag: http://localhost:8000'); } protected function checkRequirements() { $this->defaultOutput->writeln('Step 1 of 5. Checking system requirements.'); $fulfilled = true; $label = 'PDO Driver'; $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 = []; $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]; } $table = new Table($this->defaultOutput); $table ->setHeaders(['Checked', 'Status', 'Recommendation']) ->setRows($rows) ->render(); if (!$fulfilled) { throw new \RuntimeException('Some system requirements are not fulfilled. Please check output messages and fix them.'); } $this->defaultOutput->writeln('Success! Your system can run Wallabag properly.'); $this->defaultOutput->writeln(''); return $this; } protected function setupDatabase() { $this->defaultOutput->writeln('Step 2 of 5. 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, clearing the cache'); $this ->runCommand('doctrine:database:drop', ['--force' => true]) ->runCommand('doctrine:database:create') ->runCommand('doctrine:schema:create') ->runCommand('cache:clear') ; $this->defaultOutput->writeln(''); return $this; } if (!$this->isDatabasePresent()) { $this->defaultOutput->writeln('Creating database and schema, clearing the cache'); $this ->runCommand('doctrine:database:create') ->runCommand('doctrine:schema:create') ->runCommand('cache:clear') ; $this->defaultOutput->writeln(''); return $this; } $questionHelper = $this->getHelper('question'); $question = new ConfirmationQuestion('It appears that your database already exists. Would you like to reset it? (y/N)', false); if ($questionHelper->ask($this->defaultInput, $this->defaultOutput, $question)) { $this->defaultOutput->writeln('Droping database, creating database and schema'); $this ->runCommand('doctrine:database:drop', ['--force' => true]) ->runCommand('doctrine:database:create') ->runCommand('doctrine:schema:create') ; } elseif ($this->isSchemaPresent()) { $question = new ConfirmationQuestion('Seems like your database contains schema. Do you want to reset it? (y/N)', false); if ($questionHelper->ask($this->defaultInput, $this->defaultOutput, $question)) { $this->defaultOutput->writeln('Droping schema and creating schema'); $this ->runCommand('doctrine:schema:drop', ['--force' => true]) ->runCommand('doctrine:schema:create') ; } } else { $this->defaultOutput->writeln('Creating schema'); $this ->runCommand('doctrine:schema:create') ; } $this->defaultOutput->writeln('Clearing the cache'); $this->runCommand('cache:clear'); $this->defaultOutput->writeln(''); return $this; } protected function setupAdmin() { $this->defaultOutput->writeln('Step 3 of 5. Administration setup.'); $questionHelper = $this->getHelperSet()->get('question'); $question = new ConfirmationQuestion('Would you like to create a new admin user (recommended) ? (Y/n)', true); if (!$questionHelper->ask($this->defaultInput, $this->defaultOutput, $question)) { return $this; } $em = $this->getContainer()->get('doctrine.orm.entity_manager'); $userManager = $this->getContainer()->get('fos_user.user_manager'); $user = $userManager->createUser(); $question = new Question('Username (default: wallabag) :', 'wallabag'); $user->setUsername($questionHelper->ask($this->defaultInput, $this->defaultOutput, $question)); $question = new Question('Password (default: wallabag) :', 'wallabag'); $user->setPlainPassword($questionHelper->ask($this->defaultInput, $this->defaultOutput, $question)); $question = new Question('Email:', ''); $user->setEmail($questionHelper->ask($this->defaultInput, $this->defaultOutput, $question)); $user->setEnabled(true); $user->addRole('ROLE_SUPER_ADMIN'); $em->persist($user); $config = new Config($user); $config->setTheme($this->getContainer()->getParameter('wallabag_core.theme')); $config->setItemsPerPage($this->getContainer()->getParameter('wallabag_core.items_on_page')); $config->setRssLimit($this->getContainer()->getParameter('wallabag_core.rss_limit')); $config->setReadingSpeed($this->getContainer()->getParameter('wallabag_core.reading_speed')); $config->setLanguage($this->getContainer()->getParameter('wallabag_core.language')); $em->persist($config); $this->defaultOutput->writeln(''); return $this; } protected function setupConfig() { $this->defaultOutput->writeln('Step 4 of 5. Config setup.'); $em = $this->getContainer()->get('doctrine.orm.entity_manager'); // cleanup before insert new stuff $em->createQuery('DELETE FROM CraueConfigBundle:Setting')->execute(); $settings = [ [ 'name' => 'carrot', 'value' => '1', 'section' => 'entry', ], [ 'name' => 'share_diaspora', 'value' => '1', 'section' => 'entry', ], [ 'name' => 'diaspora_url', 'value' => 'http://diasporapod.com', 'section' => 'entry', ], [ 'name' => 'share_shaarli', 'value' => '1', 'section' => 'entry', ], [ 'name' => 'shaarli_url', 'value' => 'http://myshaarli.com', 'section' => 'entry', ], [ 'name' => 'share_mail', 'value' => '1', 'section' => 'entry', ], [ 'name' => 'share_twitter', 'value' => '1', 'section' => 'entry', ], [ 'name' => 'export_epub', 'value' => '1', 'section' => 'export', ], [ 'name' => 'export_mobi', 'value' => '1', 'section' => 'export', ], [ 'name' => 'export_pdf', 'value' => '1', 'section' => 'export', ], [ 'name' => 'export_csv', 'value' => '1', 'section' => 'export', ], [ 'name' => 'export_json', 'value' => '1', 'section' => 'export', ], [ 'name' => 'export_txt', 'value' => '1', 'section' => 'export', ], [ 'name' => 'export_xml', 'value' => '1', 'section' => 'export', ], [ 'name' => 'pocket_consumer_key', 'value' => null, 'section' => 'import', ], [ 'name' => 'show_printlink', 'value' => '1', 'section' => 'entry', ], [ 'name' => 'wallabag_support_url', 'value' => 'https://www.wallabag.org/pages/support.html', 'section' => 'misc', ], [ 'name' => 'wallabag_url', 'value' => 'http://v2.wallabag.org', 'section' => 'misc', ], [ 'name' => 'piwik_enabled', 'value' => '0', 'section' => 'analytics', ], [ 'name' => 'piwik_host', 'value' => 'http://v2.wallabag.org', 'section' => 'analytics', ], [ 'name' => 'piwik_site_id', 'value' => '1', 'section' => 'analytics', ], [ 'name' => 'demo_mode_enabled', 'value' => '0', 'section' => 'misc', ], [ 'name' => 'demo_mode_username', 'value' => 'wallabag', 'section' => 'misc', ], ]; foreach ($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(''); return $this; } protected function setupAsset() { $this->defaultOutput->writeln('Step 5 of 5. Installing assets.'); $this ->runCommand('assets:install') ->runCommand('assetic:dump') ; $this->defaultOutput->writeln(''); 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); $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("$errorMessage"); $exception = new \Exception($errorMessage, $exitCode); throw $exception; } // 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(); 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()); } 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; } }