namespace Wallabag\CoreBundle\Command;
use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
+use Symfony\Component\Console\Helper\Table;
+use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Input\InputOption;
+use Symfony\Component\Console\Output\NullOutput;
use Symfony\Component\Console\Output\OutputInterface;
-use Wallabag\CoreBundle\Entity\User;
-use Wallabag\CoreBundle\Entity\UsersConfig;
+use Symfony\Component\Console\Question\ConfirmationQuestion;
+use Symfony\Component\Console\Question\Question;
+use Wallabag\CoreBundle\Entity\Config;
+use Craue\ConfigBundle\Entity\Setting;
class InstallCommand extends ContainerAwareCommand
{
+ /**
+ * @var InputInterface
+ */
+ protected $defaultInput;
+
+ /**
+ * @var OutputInterface
+ */
+ protected $defaultOutput;
+
+ /**
+ * @var array
+ */
+ protected $functionExists = [
+ 'curl_exec',
+ 'curl_multi_init',
+ ];
+
protected function configure()
{
$this
->setName('wallabag:install')
->setDescription('Wallabag installer.')
+ ->addOption(
+ 'reset',
+ null,
+ InputOption::VALUE_NONE,
+ 'Reset current database'
+ )
;
}
protected function execute(InputInterface $input, OutputInterface $output)
{
- $output->writeln('<info>Installing Wallabag.</info>');
+ $this->defaultInput = $input;
+ $this->defaultOutput = $output;
+
+ $output->writeln('<info>Installing Wallabag...</info>');
$output->writeln('');
$this
- ->checkStep($output)
- ->setupStep($input, $output)
+ ->checkRequirements()
+ ->setupDatabase()
+ ->setupAdmin()
+ ->setupConfig()
+ ->setupAsset()
;
$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>');
+ $output->writeln('<comment>Just execute `php bin/console server:run --env=prod` for using wallabag: http://localhost:8000</comment>');
}
- protected function checkStep(OutputInterface $output)
+ protected function checkRequirements()
{
- $output->writeln('<info>Checking system requirements.</info>');
+ $this->defaultOutput->writeln('<info><comment>Step 1 of 5.</comment> Checking system requirements.</info>');
$fulfilled = true;
- // @TODO: find a better way to check requirements
- $output->writeln('<comment>Check PCRE</comment>');
- if (extension_loaded('pcre')) {
- $output->writeln(' <info>OK</info>');
- } else {
+ $label = '<comment>PDO Driver</comment>';
+ $status = '<info>OK!</info>';
+ $help = '';
+
+ if (!extension_loaded($this->getContainer()->getParameter('database_driver'))) {
$fulfilled = false;
- $output->writeln(' <error>ERROR</error>');
- $output->writeln('<comment>You should enabled PCRE extension</comment>');
+ $status = '<error>ERROR!</error>';
+ $help = 'Database driver "'.$this->getContainer()->getParameter('database_driver').'" is not installed.';
}
- $output->writeln('<comment>Check DOM</comment>');
- if (extension_loaded('DOM')) {
- $output->writeln(' <info>OK</info>');
- } else {
- $fulfilled = false;
- $output->writeln(' <error>ERROR</error>');
- $output->writeln('<comment>You should enabled DOM extension</comment>');
+ $rows = [];
+ $rows[] = [$label, $status, $help];
+
+ foreach ($this->functionExists as $functionRequired) {
+ $label = '<comment>'.$functionRequired.'</comment>';
+ $status = '<info>OK!</info>';
+ $help = '';
+
+ if (!function_exists($functionRequired)) {
+ $fulfilled = false;
+ $status = '<error>ERROR!</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.');
+ throw new \RuntimeException('Some system requirements are not fulfilled. Please check output messages and fix them.');
}
- $output->writeln('');
+ $this->defaultOutput->writeln('<info>Success! Your system can run Wallabag properly.</info>');
+
+ $this->defaultOutput->writeln('');
return $this;
}
- protected function setupStep(InputInterface $input, OutputInterface $output)
+ protected function setupDatabase()
{
- $output->writeln('<info>Setting up database.</info>');
+ $this->defaultOutput->writeln('<info><comment>Step 2 of 5.</comment> Setting up database.</info>');
- $this->setupDatabase($input, $output);
+ // 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');
- // if ($this->getHelperSet()->get('dialog')->askConfirmation($output, '<question>Load fixtures (Y/N)?</question>', false)) {
- // $this->setupFixtures($input, $output);
- // }
+ $this
+ ->runCommand('doctrine:database:drop', ['--force' => true])
+ ->runCommand('doctrine:database:create')
+ ->runCommand('doctrine:schema:create')
+ ->runCommand('cache:clear')
+ ;
- $output->writeln('');
- $output->writeln('<info>Administration setup.</info>');
+ $this->defaultOutput->writeln('');
- $this->setupAdmin($output);
+ return $this;
+ }
- $output->writeln('');
+ if (!$this->isDatabasePresent()) {
+ $this->defaultOutput->writeln('Creating database and schema, clearing the cache');
- return $this;
- }
+ $this
+ ->runCommand('doctrine:database:create')
+ ->runCommand('doctrine:schema:create')
+ ->runCommand('cache:clear')
+ ;
- protected function setupDatabase(InputInterface $input, OutputInterface $output)
- {
- if ($this->getHelperSet()->get('dialog')->askConfirmation($output, '<question>Drop current database (Y/N)?</question>', true)) {
- $connection = $this->getContainer()->get('doctrine')->getConnection();
- $params = $connection->getParams();
+ $this->defaultOutput->writeln('');
- $name = isset($params['path']) ? $params['path'] : (isset($params['dbname']) ? $params['dbname'] : false);
- unset($params['dbname']);
+ return $this;
+ }
- if (!isset($params['path'])) {
- $name = $connection->getDatabasePlatform()->quoteSingleIdentifier($name);
+ $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')
+ ;
}
-
- $connection->getSchemaManager()->dropDatabase($name);
} else {
- throw new \Exception("Install setup stopped, database need to be dropped. Please backup your current one and re-launch the install command.");
+ $this->defaultOutput->writeln('Creating schema');
+
+ $this
+ ->runCommand('doctrine:schema:create')
+ ;
}
- $this
- ->runCommand('doctrine:database:create', $input, $output)
- ->runCommand('doctrine:schema:create', $input, $output)
- ->runCommand('cache:clear', $input, $output)
- ->runCommand('assets:install', $input, $output)
- ->runCommand('assetic:dump', $input, $output)
- ;
- }
+ $this->defaultOutput->writeln('Clearing the cache');
+ $this->runCommand('cache:clear');
- protected function setupFixtures(InputInterface $input, OutputInterface $output)
- {
- $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', $input, $output);
- $doctrineConfig->setSQLLogger($logger);
+ $this->defaultOutput->writeln('');
+
+ return $this;
}
- protected function setupAdmin(OutputInterface $output)
+ protected function setupAdmin()
{
- $dialog = $this->getHelperSet()->get('dialog');
+ $this->defaultOutput->writeln('<info><comment>Step 3 of 5.</comment> Administration setup.</info>');
+
+ $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');
- $user = new User();
- $user->setUsername($dialog->ask($output, '<question>Username</question> <comment>(default: wallabag)</comment> :', 'wallabag'));
- $user->setPassword($dialog->ask($output, '<question>Password</question> <comment>(default: wallabag)</comment> :', 'wallabag'));
- $user->setEmail($dialog->ask($output, '<question>Email:</question>', ''));
+ $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);
- $pagerConfig = new UsersConfig();
- $pagerConfig->setUserId($user->getId());
- $pagerConfig->setName('pager');
- $pagerConfig->setValue(10);
+ $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('');
- $em->persist($pagerConfig);
+ return $this;
+ }
- // $languageConfig = new LanguageConfig();
- // $languageConfig->setUserId($user->getId());
- // $languageConfig->setName('language');
- // $languageConfig->setValue('en_EN.UTF8');
+ protected function setupConfig()
+ {
+ $this->defaultOutput->writeln('<info><comment>Step 4 of 5.</comment> Config setup.</info>');
+ $em = $this->getContainer()->get('doctrine.orm.entity_manager');
- // $em->persist($languageConfig);
+ // 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 runCommand($command, InputInterface $input, OutputInterface $output)
+ protected function setupAsset()
{
+ $this->defaultOutput->writeln('<info><comment>Step 5 of 5.</comment> Installing assets.</info>');
+
$this
- ->getApplication()
- ->find($command)
- ->run($input, $output)
+ ->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("<error>$errorMessage</error>");
+ $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\ConnectionException $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;
+ }
}