Kdyby\Doctrine\Console\ColoredSqlOutput

Complexity

Total Complexity

14

Size/Duplication

Total Lines	160
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	1
Bugs	0	Features	1

14 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	write()	0	4	1
A	writeln()	0	4	1
A	setVerbosity()	0	4	1
A	getVerbosity()	0	4	1
A	setDecorated()	0	4	1
A	isDecorated()	0	4	1
A	formatSqls()	0	21	1
A	isQuiet()	0	4	1
A	isVerbose()	0	4	1
A	isVeryVerbose()	0	4	1
A	isDebug()	0	4	1
A	setFormatter()	0	4	1
A	getFormatter()	0	4	1

<?php

/**
 * This file is part of the Kdyby (http://www.kdyby.org)
 *
 * Copyright (c) 2008 Filip Procházka (filip@prochazka.su)
 *
 * For the full copyright and license information, please view the file license.txt that was distributed with this source code.
 */

namespace Kdyby\Doctrine\Console;

use Kdyby;
use Nette;
use Symfony\Component\Console\Formatter\OutputFormatterInterface;
use Symfony\Component\Console\Output\OutputInterface;



/**
 * @author Filip Procházka <filip@prochazka.su>
 */
class ColoredSqlOutput extends Nette\Object implements OutputInterface
{

	/**
	 * @var \Symfony\Component\Console\Output\OutputInterface
	 */
	private $output;



	public function __construct(OutputInterface $output)
	{
		$this->output = $output;
	}



	protected function formatSqls($message)
	{
		$message = Nette\Utils\Strings::replace($message, "~((?:CREATE|ALTER|DROP)\\s+TABLE|(?:DROP|CREATE)\\s+INDEX)[^;]+;~i", function (array $match) {
			$output = Nette\Utils\Strings::replace($match[0], '~(?<=\b)([^\s]*[a-z]+[^\s]*)(?=\b)~', function ($id) {
				return '<info>' . $id[0] . '</info>';
			});
			$output = Nette\Utils\Strings::replace($output, '~(?<=\b)(CREATE|ALTER|DROP|TABLE|INDEX|ADD|CHANGE|PRIMARY\s+KEY|UNIQUE|CONSTRAINT|FOREIGN\s+KEY|REFERENCES|COMMENT|ENGINE)(?=\b)~', function ($id) {
				return '<fg=cyan>' . $id[0] . '</fg=cyan>';
			});

			return $output;
		});
		$message = Nette\Utils\Strings::replace($message, '~(?<=\b)(INSERT|UPDATE|SELECT|DELETE|INTO|VALUES|ON\s+DUPLICATE\s+KEY\s+UPDATE|SET|FROM|JOIN|LEFT|RIGHT|INNER|OUTER|NATURAL|CROSS|FULL|ON|WHERE|GROUP\s+BY|HAVING|ORDER\s+BY|LIMIT|OFFSET|UNION)(?=\b)~', function ($id) {
			return '<comment>' . $id[0] . '</comment>';
		});
		$message = Nette\Utils\Strings::replace($message, '~(?<=\b)(AS|ASC|DESC|USING|DEFAULT|DISTINCT|AND|OR|IN|BETWEEN|IS|LIKE|NOT|NULL|ALL|ANY|SOME|EXISTS|SET\s+NULL|AUTO_INCREMENT|CASCADE|RESTRICT|INT|SMALLINT|TINYINT|NUMERIC|VARCHAR|DATETIME|TIMESTAMP|TEXT)(?=\b)~', function ($id) {
			return '<fg=magenta>' . $id[0] . '</fg=magenta>';
		});

		return $message;
	}



	/**
	 * {@inheritdoc}
	 */
	public function write($messages, $newline = false, $type = self::OUTPUT_NORMAL)
	{
		return $this->output->write($this->formatSqls($messages), $newline, $type);
	}



	/**
	 * {@inheritdoc}
	 */
	public function writeln($messages, $type = self::OUTPUT_NORMAL)
	{
		return $this->output->writeln($this->formatSqls($messages), $type);
	}



	/**
	 * {@inheritdoc}
	 */
	public function setVerbosity($level)
	{
		return $this->output->setVerbosity($level);
	}



	/**
	 * {@inheritdoc}
	 */
	public function getVerbosity()
	{
		return $this->output->getVerbosity();
	}



	/**
	 * {@inheritdoc}
	 */
	public function setDecorated($decorated)
	{
		return $this->output->setDecorated($decorated);
	}



	/**
	 * {@inheritdoc}
	 */
	public function isDecorated()
	{
		return $this->output->isDecorated();
	}



	/**
	 * {@inheritdoc}
	 */
	public function isQuiet()
	{
		return $this->output->isQuiet();
	}



	/**
	 * {@inheritdoc}
	 */
	public function isVerbose()
	{
		return $this->output->isVerbose();
	}



	/**
	 * {@inheritdoc}
	 */
	public function isVeryVerbose()
	{
		return $this->output->isVeryVerbose();
	}



	/**
	 * {@inheritdoc}
	 */
	public function isDebug()
	{
		return $this->output->isDebug();
	}



	/**
	 * {@inheritdoc}
	 */
	public function setFormatter(OutputFormatterInterface $formatter)
	{
		return $this->output->setFormatter($formatter);
	}



	/**
	 * {@inheritdoc}
	 */
	public function getFormatter()
	{
		return $this->output->getFormatter();
	}

}