Joomla\StatsServer\Commands\InstallCommand

Complexity

Total Complexity

16

Size/Duplication

Total Lines	189
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	6

Test Coverage

Coverage

0%

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
B	execute()	0	70	6
A	cleanDatabase()	0	21	2
B	processSql()	0	37	5
A	getDescription()	0	4	1
A	getTitle()	0	4	1

<?php
/**
 * Joomla! Statistics Server
 *
 * @copyright  Copyright (C) 2013 - 2017 Open Source Matters, Inc. All rights reserved.
 * @license    http://www.gnu.org/licenses/gpl-2.0.txt GNU General Public License Version 2 or Later
 */

namespace Joomla\StatsServer\Commands;

use Joomla\Controller\AbstractController;
use Joomla\Database\DatabaseDriver;
use Joomla\Database\Mysql\MysqlDriver;
use Joomla\StatsServer\CommandInterface;

/**
 * Install command
 *
 * @method         \Joomla\StatsServer\CliApplication  getApplication()  Get the application object.
 * @property-read  \Joomla\StatsServer\CliApplication  $app              Application object
 */
class InstallCommand extends AbstractController implements CommandInterface
{
	/**
	 * Database driver.
	 *
	 * @var  DatabaseDriver
	 */
	private $db = null;

	/**
	 * Constructor.
	 *
	 * @param   DatabaseDriver  $db  Database driver.
	 */
	public function __construct(DatabaseDriver $db)
	{
		$this->db = $db;
	}

	/**
	 * Execute the controller.
	 *
	 * @return  boolean
	 */
	public function execute()
	{
		$this->getApplication()->outputTitle('Installer');

		// Check for PDO MySQL support
		if (!MysqlDriver::isSupported())
		{
			$this->getApplication()->out('<error>PDO with MySQL support is not available on this server!</error>');

			return false;
		}

		try
		{
			// Check if the database "exists"
			$tables = $this->db->getTableList();

			if (!$this->getApplication()->input->getBool('reinstall', false))
			{
				$this->getApplication()->out()
					->out('<fg=black;bg=yellow>WARNING: A database has been found !!</fg=black;bg=yellow>')
					->out()
					->out('Do you want to reinstall ?')
					->out()
					->out('1) Yes')
					->out('2) No')
					->out()
					->out('<question>' . g11n3t('Select:') . '</question>', false);

				$in = trim($this->getApplication()->in());

				if ((int) $in !== 1)
				{
					$this->getApplication()->out('<info>Aborting installation.</info>');

					return true;
				}
			}

			$this->cleanDatabase($tables);
		}
		catch (\RuntimeException $e)
		{
			// Check if the message is "Could not connect to database."  Odds are, this means the DB isn't there or the server is down.
			if (strpos($e->getMessage(), 'Could not connect to database.') !== false)
			{
				$this->getApplication()->out('No database found.')
					->out('Creating the database...', false);

				$this->db->setQuery('CREATE DATABASE ' . $this->db->quoteName($this->getApplication()->get('database.name')))
					->execute();

				$this->db->select($this->getApplication()->get('database.name'));

				$this->getApplication()->out('<info>Database created.</info>');
			}
			else
			{
				throw $e;
			}
		}

		// Perform the installation
		$this->processSql()
			->getApplication()
			->out()
			->out('<fg=green;options=bold>Installation has been completed successfully.</fg=green;options=bold>');

		return true;
	}

	/**
	 * Cleanup the database.
	 *
	 * @param   array  $tables  Tables to remove.
	 *
	 * @return  $this
	 */
	private function cleanDatabase(array $tables) : InstallCommand
	{
		$this->getApplication()->out('Removing existing tables...', false);

		// Foreign key constraint fails fix
		$this->db->setQuery('SET FOREIGN_KEY_CHECKS=0')
			->execute();

		foreach ($tables as $table)
		{
			$this->db->dropTable($table, true);
			$this->getApplication()->out('.', false);
		}

		$this->db->setQuery('SET FOREIGN_KEY_CHECKS=1')
			->execute();

		$this->getApplication()->out('<info>Tables removed.</info>');

		return $this;
	}

	/**
	 * Process the main SQL file.
	 *
	 * @return  $this
	 *
	 * @throws  \UnexpectedValueException
	 */
	private function processSql() : InstallCommand
	{
		$fName = APPROOT . '/etc/mysql.sql';

		if (!file_exists($fName))
		{
			throw new \UnexpectedValueException('Install SQL file for MySQL not found.');
		}

		$sql = file_get_contents($fName);

		if (!$sql)
		{
			throw new \UnexpectedValueException('SQL file corrupted.');
		}

		$this->out(sprintf('Creating tables from file %s', realpath($fName)), false);

The method out() does not seem to exist on object<Joomla\StatsServer\Commands\InstallCommand>.

		foreach ($this->db->splitSql($sql) as $query)
		{
			$q = trim($this->db->replacePrefix($query));

			if ('' == trim($q))
			{
				continue;
			}

			$this->db->setQuery($q)
				->execute();

			$this->getApplication()->out('.', false);
		}

		$this->getApplication()->out('<info>Database tables created successfully.</info>');

		return $this;
	}

	/**
	 * Get the command's description
	 *
	 * @return  string
	 */
	public function getDescription() : string
	{
		return 'Installs the application.';
	}

	/**
	 * Get the command's title
	 *
	 * @return  string
	 */
	public function getTitle() : string
	{
		return 'Install Application';
	}
}