DB\Query

Complexity

Total Complexity

14

Size/Duplication

Total Lines	73
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getName()	0	4	1
A	getValue()	0	4	1
A	getDirection()	0	4	2
D	getString()	0	28	9
A	__toString()	0	4	1

<?php

/**
 * @package Framework\DB
 * @author Anton Romanov
 * @copyright Copyright (c) 2015-2016, Anton Romanov
 * @link http://cadmium-cms.com
 */

namespace DB {

	abstract class Query {

		protected $query = '';

		/**
		 * Get a field/table name
		 */

		protected function getName(string $name) : string {

			return preg_replace('/[^a-zA-Z0-9_]/', '_', trim($name));
		}

		/**
		 * Get a field value
		 */

		protected function getValue(string $value) : string {

			return ('\'' . addslashes($value) . '\'');
		}

		/**
		 * Get a field sorting direction
		 */

		protected function getDirection(string $direction) : string {

			return ((strtoupper($direction) !== 'DESC') ? 'ASC' : 'DESC');
		}

		/**
		 * Convert a data array to a string
		 */

		protected function getString($source = null, string $pattern = '', string $separator = '') : string {

			if (!is_array($source)) return (is_scalar($source) ? strval($source) : '');

			$regexs = ['key' => '/\^([a-z]+)/', 'value' => '/\$([a-z]+)/']; $matches = ['key' => [], 'value' => []];

			$parsers = ['name' => 'getName', 'value' => 'getValue', 'direction' => 'getDirection']; $output = []; $count = 0;

			# Parse pattern

			foreach ($regexs as $name => $regex) preg_match($regex, $pattern, $matches[$name]);

			# Process replacements

			foreach ($source as $key => $value) if (is_scalar($value)) {

				$output[$count] = $pattern; $item = &$output[$count++];

				foreach ($matches as $name => $match) if (isset($match[1]) && isset($parsers[$match[1]])) {

					$item = str_replace($match[0], [$this, $parsers[$match[1]]]($$name), $item);
				}
			};

			# ------------------------

			return implode($separator, $output);
		}

		/**
		 * Convert the object to a string
		 */

		public function __toString() : string {

			return $this->query;
		}
	}
}