3 namespace Wallabag\CoreBundle\Command
;
5 use FOS\UserBundle\Event\UserEvent
;
6 use FOS\UserBundle\FOSUserEvents
;
7 use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand
;
8 use Symfony\Component\Console\Helper\Table
;
9 use Symfony\Component\Console\Input\ArrayInput
;
10 use Symfony\Component\Console\Input\InputInterface
;
11 use Symfony\Component\Console\Input\InputOption
;
12 use Symfony\Component\Console\Output\BufferedOutput
;
13 use Symfony\Component\Console\Output\OutputInterface
;
14 use Symfony\Component\Console\Question\ConfirmationQuestion
;
15 use Symfony\Component\Console\Question\Question
;
16 use Wallabag\CoreBundle\Entity\Config
;
17 use Craue\ConfigBundle\Entity\Setting
;
19 class InstallCommand
extends ContainerAwareCommand
24 protected $defaultInput;
27 * @var OutputInterface
29 protected $defaultOutput;
34 protected $functionExists = [
39 protected function configure()
42 ->setName('wallabag:install')
43 ->setDescription('wallabag installer.')
47 InputOption
::VALUE_NONE
,
48 'Reset current database'
53 protected function execute(InputInterface
$input, OutputInterface
$output)
55 $this->defaultInput
= $input;
56 $this->defaultOutput
= $output;
58 $output->writeln('<info>Installing wallabag...</info>');
69 $output->writeln('<info>wallabag has been successfully installed.</info>');
70 $output->writeln('<comment>Just execute `php bin/console server:run --env=prod` for using wallabag: http://localhost:8000</comment>');
73 protected function checkRequirements()
75 $this->defaultOutput
->writeln('<info><comment>Step 1 of 5.</comment> Checking system requirements.</info>');
76 $doctrineManager = $this->getContainer()->get('doctrine')->getManager();
80 // testing if database driver exists
82 $label = '<comment>PDO Driver (%s)</comment>';
83 $status = '<info>OK!</info>';
86 if (!extension_loaded($this->getContainer()->getParameter('database_driver'))) {
88 $status = '<error>ERROR!</error>';
89 $help = 'Database driver "'.$this->getContainer()->getParameter('database_driver').'" is not installed.';
92 $rows[] = [sprintf($label, $this->getContainer()->getParameter('database_driver')), $status, $help];
94 // testing if connection to the database can be etablished
95 $label = '<comment>Database connection</comment>';
96 $status = '<info>OK!</info>';
100 $conn = $this->getContainer()->get('doctrine')->getManager()->getConnection();
102 } catch (\Exception
$e) {
103 if (false === strpos($e->getMessage(), 'Unknown database')
104 && false === strpos($e->getMessage(), 'database "'.$this->getContainer()->getParameter('database_name').'" does not exist')) {
106 $status = '<error>ERROR!</error>';
107 $help = 'Can\'t connect to the database: '.$e->getMessage();
111 $rows[] = [$label, $status, $help];
113 // check MySQL & PostgreSQL version
114 $label = '<comment>Database version</comment>';
115 $status = '<info>OK!</info>';
118 // now check if MySQL isn't too old to handle utf8mb4
119 if ($conn->isConnected() && 'mysql' === $conn->getDatabasePlatform()->getName()) {
120 $version = $conn->query('select version()')->fetchColumn();
121 $minimalVersion = '5.5.4';
123 if (false === version_compare($version, $minimalVersion, '>')) {
125 $status = '<error>ERROR!</error>';
126 $help = 'Your MySQL version ('.$version.') is too old, consider upgrading ('.$minimalVersion.'+).';
130 // testing if PostgreSQL > 9.1
131 if ($conn->isConnected() && 'postgresql' === $conn->getDatabasePlatform()->getName()) {
132 // 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"
133 $version = $doctrineManager->getConnection()->query('SELECT version();')->fetchColumn();
135 preg_match('/PostgreSQL ([0-9\.]+)/i', $version, $matches);
137 if (isset($matches[1]) & version_compare($matches[1], '9.2.0', '<')) {
139 $status = '<error>ERROR!</error>';
140 $help = 'PostgreSQL should be greater than 9.1 (actual version: '.$matches[1].')';
144 $rows[] = [$label, $status, $help];
146 foreach ($this->functionExists
as $functionRequired) {
147 $label = '<comment>'.$functionRequired.'</comment>';
148 $status = '<info>OK!</info>';
151 if (!function_exists($functionRequired)) {
153 $status = '<error>ERROR!</error>';
154 $help = 'You need the '.$functionRequired.' function activated';
157 $rows[] = [$label, $status, $help];
160 $table = new Table($this->defaultOutput
);
162 ->setHeaders(['Checked', 'Status', 'Recommendation'])
167 throw new \
RuntimeException('Some system requirements are not fulfilled. Please check output messages and fix them.');
170 $this->defaultOutput
->writeln('<info>Success! Your system can run wallabag properly.</info>');
172 $this->defaultOutput
->writeln('');
177 protected function setupDatabase()
179 $this->defaultOutput
->writeln('<info><comment>Step 2 of 5.</comment> Setting up database.</info>');
181 // user want to reset everything? Don't care about what is already here
182 if (true === $this->defaultInput
->getOption('reset')) {
183 $this->defaultOutput
->writeln('Dropping database, creating database and schema, clearing the cache');
186 ->runCommand('doctrine:database:drop', ['--force' => true])
187 ->runCommand('doctrine:database:create')
188 ->runCommand('doctrine:schema:create')
189 ->runCommand('cache:clear')
192 $this->defaultOutput
->writeln('');
197 if (!$this->isDatabasePresent()) {
198 $this->defaultOutput
->writeln('Creating database and schema, clearing the cache');
201 ->runCommand('doctrine:database:create')
202 ->runCommand('doctrine:schema:create')
203 ->runCommand('cache:clear')
206 $this->defaultOutput
->writeln('');
211 $questionHelper = $this->getHelper('question');
212 $question = new ConfirmationQuestion('It appears that your database already exists. Would you like to reset it? (y/N)', false);
214 if ($questionHelper->ask($this->defaultInput
, $this->defaultOutput
, $question)) {
215 $this->defaultOutput
->writeln('Dropping database, creating database and schema');
218 ->runCommand('doctrine:database:drop', ['--force' => true])
219 ->runCommand('doctrine:database:create')
220 ->runCommand('doctrine:schema:create')
222 } elseif ($this->isSchemaPresent()) {
223 $question = new ConfirmationQuestion('Seems like your database contains schema. Do you want to reset it? (y/N)', false);
224 if ($questionHelper->ask($this->defaultInput
, $this->defaultOutput
, $question)) {
225 $this->defaultOutput
->writeln('Dropping schema and creating schema');
228 ->runCommand('doctrine:schema:drop', ['--force' => true])
229 ->runCommand('doctrine:schema:create')
233 $this->defaultOutput
->writeln('Creating schema');
236 ->runCommand('doctrine:schema:create')
240 $this->defaultOutput
->writeln('Clearing the cache');
241 $this->runCommand('cache:clear');
243 $this->defaultOutput
->writeln('');
248 protected function setupAdmin()
250 $this->defaultOutput
->writeln('<info><comment>Step 3 of 5.</comment> Administration setup.</info>');
252 $questionHelper = $this->getHelperSet()->get('question');
253 $question = new ConfirmationQuestion('Would you like to create a new admin user (recommended) ? (Y/n)', true);
255 if (!$questionHelper->ask($this->defaultInput
, $this->defaultOutput
, $question)) {
259 $em = $this->getContainer()->get('doctrine.orm.entity_manager');
261 $userManager = $this->getContainer()->get('fos_user.user_manager');
262 $user = $userManager->createUser();
264 $question = new Question('Username (default: wallabag) :', 'wallabag');
265 $user->setUsername($questionHelper->ask($this->defaultInput
, $this->defaultOutput
, $question));
267 $question = new Question('Password (default: wallabag) :', 'wallabag');
268 $user->setPlainPassword($questionHelper->ask($this->defaultInput
, $this->defaultOutput
, $question));
270 $question = new Question('Email:', '');
271 $user->setEmail($questionHelper->ask($this->defaultInput
, $this->defaultOutput
, $question));
273 $user->setEnabled(true);
274 $user->addRole('ROLE_SUPER_ADMIN');
278 // dispatch a created event so the associated config will be created
279 $event = new UserEvent($user);
280 $this->getContainer()->get('event_dispatcher')->dispatch(FOSUserEvents
::USER_CREATED
, $event);
282 $this->defaultOutput
->writeln('');
287 protected function setupConfig()
289 $this->defaultOutput
->writeln('<info><comment>Step 4 of 5.</comment> Config setup.</info>');
290 $em = $this->getContainer()->get('doctrine.orm.entity_manager');
292 // cleanup before insert new stuff
293 $em->createQuery('DELETE FROM CraueConfigBundle:Setting')->execute();
295 foreach ($this->getContainer()->getParameter('wallabag_core.default_internal_settings') as $setting) {
296 $newSetting = new Setting();
297 $newSetting->setName($setting['name']);
298 $newSetting->setValue($setting['value']);
299 $newSetting->setSection($setting['section']);
300 $em->persist($newSetting);
305 $this->defaultOutput
->writeln('');
310 protected function runMigrations()
312 $this->defaultOutput
->writeln('<info><comment>Step 5 of 5.</comment> Run migrations.</info>');
315 ->runCommand('doctrine:migrations:migrate', ['--no-interaction' => true]);
323 * @param string $command
324 * @param array $parameters Parameters to this command (usually 'force' => true)
326 protected function runCommand($command, $parameters = [])
328 $parameters = array_merge(
329 ['command' => $command],
332 '--no-debug' => true,
333 '--env' => $this->defaultInput
->getOption('env') ?: 'dev',
337 if ($this->defaultInput
->getOption('no-interaction')) {
338 $parameters = array_merge($parameters, ['--no-interaction' => true]);
341 $this->getApplication()->setAutoExit(false);
343 $output = new BufferedOutput();
344 $exitCode = $this->getApplication()->run(new ArrayInput($parameters), $output);
346 // PDO does not always close the connection after Doctrine commands.
347 // See https://github.com/symfony/symfony/issues/11750.
348 $this->getContainer()->get('doctrine')->getManager()->getConnection()->close();
350 if (0 !== $exitCode) {
351 $this->getApplication()->setAutoExit(true);
353 throw new \
RuntimeException(
354 'The command "'.$command."\" generates some errors: \n\n"
362 * Check if the database already exists.
366 private function isDatabasePresent()
368 $connection = $this->getContainer()->get('doctrine')->getManager()->getConnection();
369 $databaseName = $connection->getDatabase();
372 $schemaManager = $connection->getSchemaManager();
373 } catch (\Exception
$exception) {
375 if (false !== strpos($exception->getMessage(), sprintf("Unknown database '%s'", $databaseName))) {
380 if (false !== strpos($exception->getMessage(), sprintf('database "%s" does not exist', $databaseName))) {
387 // custom verification for sqlite, since `getListDatabasesSQL` doesn't work for sqlite
388 if ('sqlite' === $schemaManager->getDatabasePlatform()->getName()) {
389 $params = $this->getContainer()->get('doctrine.dbal.default_connection')->getParams();
391 if (isset($params['path']) && file_exists($params['path'])) {
399 return in_array($databaseName, $schemaManager->listDatabases());
400 } catch (\Doctrine\DBAL\Exception\DriverException
$e) {
401 // it means we weren't able to get database list, assume the database doesn't exist
408 * Check if the schema is already created.
409 * If we found at least oen table, it means the schema exists.
413 private function isSchemaPresent()
415 $schemaManager = $this->getContainer()->get('doctrine')->getManager()->getConnection()->getSchemaManager();
417 return count($schemaManager->listTableNames()) > 0 ? true : false;