ConditionParser::addKeyValues() - Code Metrics - Inspection of "[ci-tests] Fix typo" - phpMv/ubiquity - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 99686f...b494ba )

by Jean-Christophe

created 2020-08-31 11:06 UTC

ConditionParser::addKeyValues() B

↳ Parent: ConditionParser

Complexity

Conditions	7
Paths	13

Size

Total Lines	19
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	13
CRAP Score	7

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	13
c	1
b	0
f	0
dl	0
loc	19
ccs	13
cts	13
cp	1
rs	8.8333
cc	7
nc	13
nop	3
crap	7

<?php
namespace Ubiquity\orm\parser;

use Ubiquity\orm\OrmUtils;
use Ubiquity\db\SqlUtils;

/**
 * Represents a query condition.
 *
 * Ubiquity\orm\parser$ConditionParser
 * This class is part of Ubiquity
 *
 * @author jcheron <[email protected]>
 * @version 1.0.2
 *
 */
class ConditionParser {

	private $firstPart;

	private $condition;

	private $parts = [];

	private $params;

	private $invertedParams = true;

	public function __construct($condition = null, $firstPart = null, $params = null) {
		$this->condition = $condition;
		$this->firstPart = $firstPart;
		if (\is_array($params)) {
			$this->setParams($params);
		}
	}

	public function addKeyValues($keyValues, $classname, $separator = ' AND ') {
		if (! \is_array($keyValues)) {
			$this->condition = $this->parseKey($keyValues, $classname);
		} else {
			if ((\array_keys($keyValues) === \range(0, \count($keyValues) - 1))) { // Not associative array
				if (isset($classname)) {
					$keys = OrmUtils::getKeyFields($classname);
					if (\is_array($keys)) {
						$keyValues = \array_combine($keys, $keyValues);
					}
				}
			}
			$retArray = array();
			foreach ($keyValues as $key => $value) {
				if ($this->addParams($value)) {
					$retArray[] = SqlUtils::$quote . $key . SqlUtils::$quote . ' = ?';
				}
			}
			$this->condition = \implode($separator, $retArray);
		}
	}

	public function setKeyValues($values) {
		if (! \is_array($values)) {
			$this->params = [
				$values => true
			];
			return [
				$values
			];
		} else {
			$this->params = [];
			$ret = [];
			foreach ($values as $val) {
				$this->params[$val] = true;
				$ret[] = $val;
			}
			return $ret;
		}
	}

	private function addParams($value) {
		if (! isset($this->params[$value])) {
			return $this->params[$value] = true;
		}
		return false;
	}

	public function addPart($condition, $value) {
		if ($this->addParams($value)) {
			$this->parts[] = $condition;
			return true;
		}
		return false;
	}

	public function addParts($condition, $values) {
		foreach ($values as $value) {
			if ($this->addParams($value)) {
				$this->parts[] = $condition;
			}
		}
	}

	public function compileParts($separator = ' OR ') {
		if ($separator == ' OR ' && \sizeof($this->parts) > 3) {
			$parts = $this->refactorParts();
			$conditions = [];
			foreach ($parts as $part => $values) {
				$values[0] = 'SELECT ? as _id';
				$conditions[] = ' INNER JOIN (' . \implode(' UNION ALL SELECT ', $values) . ') as _tmp ON ' . $part . '=_tmp._id';
			}
			$this->condition = \implode(' ', $conditions);
		} else {
			$this->condition = \implode($separator, $this->parts);
		}
	}

	private function refactorParts() {
		$result = [];
		foreach ($this->parts as $part) {
			$part = \str_replace('= ?', '', $part);
			$result[$part][] = '?';
		}
		return $result;
	}

	private function parseKey($keyValues, $className) {
		$condition = $keyValues;
		if (\strrpos($keyValues, '=') === false && \strrpos($keyValues, '>') === false && \strrpos($keyValues, '<') === false) {
			if ($this->addParams($keyValues)) {
				$condition = SqlUtils::$quote . OrmUtils::getFirstKey($className) . SqlUtils::$quote . '= ?';
			}
		}
		return $condition;
	}

	/**
	 *
	 * @return string
	 */
	public function getCondition() {
		if ($this->firstPart == null)
			return $this->condition;
		$ret = $this->firstPart;
		if (isset($this->condition)) {
			$ret .= ' WHERE ' . $this->condition;
		}
		return $ret;
	}

	/**
	 *
	 * @return mixed
	 */
	public function getParams() {
		if (\is_array($this->params)) {
			if ($this->invertedParams) {
				return \array_keys($this->params);
			}
			return $this->params;
		}
		return;
	}

	/**
	 *
	 * @return mixed
	 */
	public function hasParam($value) {
		if (\is_array($this->params)) {
			if ($this->invertedParams) {
				return isset($this->params[$value]);
			}
			return \array_search($value, $this->params) !== false;
		}
		return false;
	}

	public function countParts() {
		if (\is_array($this->params))
			return \sizeof($this->params);
		return 0;
	}

	/**
	 *
	 * @param string $condition
	 */
	public function setCondition($condition) {
		$this->condition = $condition;
		return $this;
	}

	/**
	 *
	 * @param mixed $params
	 */
	public function setParams($params) {
		$this->params = $params;
		$this->invertedParams = false;
		return $this;
	}

	public function limitOne() {
		$limit = '';
		if (\stripos($this->condition, ' limit ') === false) {
			$limit = ' limit 1';
		}
		$this->condition .= $limit;
	}

	public static function simple($condition, $params) {
		$cParser = new ConditionParser($condition);
		$cParser->addParams($params);
		return $cParser;
	}
}



1		<?php
2		namespace Ubiquity\orm\parser;
3
4		use Ubiquity\orm\OrmUtils;
5		use Ubiquity\db\SqlUtils;
6
7		/**
8		* Represents a query condition.
9		*
10		* Ubiquity\orm\parser$ConditionParser
11		* This class is part of Ubiquity
12		*
13		* @author jcheron <[email protected]>
14		* @version 1.0.2
15		*
16		*/
17		class ConditionParser {
18
19		private $firstPart;
20
21		private $condition;
22
23		private $parts = [];
24
25		private $params;
26
27		private $invertedParams = true;
28
29	81	public function __construct($condition = null, $firstPart = null, $params = null) {
30	81	$this->condition = $condition;
31	81	$this->firstPart = $firstPart;
32	81	if (\is_array($params)) {
33	8	$this->setParams($params);
34		}
35	81	}
36
37	53	public function addKeyValues($keyValues, $classname, $separator = ' AND ') {
38	53	if (! \is_array($keyValues)) {
39	25	$this->condition = $this->parseKey($keyValues, $classname);
40		} else {
41	37	if ((\array_keys($keyValues) === \range(0, \count($keyValues) - 1))) { // Not associative array
42	35	if (isset($classname)) {
43	35	$keys = OrmUtils::getKeyFields($classname);
44	35	if (\is_array($keys)) {
45	35	$keyValues = \array_combine($keys, $keyValues);
46		}
47		}
48		}
49	37	$retArray = array();
50	37	foreach ($keyValues as $key => $value) {
51	37	if ($this->addParams($value)) {
52	37	$retArray[] = SqlUtils::$quote . $key . SqlUtils::$quote . ' = ?';
53		}
54		}
55	37	$this->condition = \implode($separator, $retArray);
56		}
57	53	}
58
59	17	public function setKeyValues($values) {
60	17	if (! \is_array($values)) {
61	11	$this->params = [
62	11	$values => true
63		];
64		return [
65	11	$values
66		];
67		} else {
68	7	$this->params = [];
69	7	$ret = [];
70	7	foreach ($values as $val) {
71	7	$this->params[$val] = true;
72	7	$ret[] = $val;
73		}
74	7	return $ret;
75		}
76		}
77
78	69	private function addParams($value) {
79	69	if (! isset($this->params[$value])) {
80	69	return $this->params[$value] = true;
81		}
82	13	return false;
83		}
84
85	43	public function addPart($condition, $value) {
86	43	if ($this->addParams($value)) {
87	43	$this->parts[] = $condition;
88	43	return true;
89		}
90		return false;
91		}
92
93	23	public function addParts($condition, $values) {
94	23	foreach ($values as $value) {
95	23	if ($this->addParams($value)) {
96	23	$this->parts[] = $condition;
97		}
98		}
99	23	}
100
101	46	public function compileParts($separator = ' OR ') {
102	46	if ($separator == ' OR ' && \sizeof($this->parts) > 3) {
103	24	$parts = $this->refactorParts();
104	24	$conditions = [];
105	24	foreach ($parts as $part => $values) {
106	24	$values[0] = 'SELECT ? as _id';
107	24	$conditions[] = ' INNER JOIN (' . \implode(' UNION ALL SELECT ', $values) . ') as _tmp ON ' . $part . '=_tmp._id';
108		}
109	24	$this->condition = \implode(' ', $conditions);
110		} else {
111	39	$this->condition = \implode($separator, $this->parts);
112		}
113	46	}
114
115	24	private function refactorParts() {
116	24	$result = [];
117	24	foreach ($this->parts as $part) {
118	24	$part = \str_replace('= ?', '', $part);
119	24	$result[$part][] = '?';
120		}
121	24	return $result;
122		}
123
124	25	private function parseKey($keyValues, $className) {
125	25	$condition = $keyValues;
126	25	if (\strrpos($keyValues, '=') === false && \strrpos($keyValues, '>') === false && \strrpos($keyValues, '<') === false) {
127	11	if ($this->addParams($keyValues)) {
128	11	$condition = SqlUtils::$quote . OrmUtils::getFirstKey($className) . SqlUtils::$quote . '= ?';
129		}
130		}
131	25	return $condition;
132		}
133
134		/**
135		*
136		* @return string
137		*/
138	83	public function getCondition() {
139	83	if ($this->firstPart == null)
140	83	return $this->condition;
141	3	$ret = $this->firstPart;
142	3	if (isset($this->condition)) {
143	3	$ret .= ' WHERE ' . $this->condition;
144		}
145	3	return $ret;
146		}
147
148		/**
149		*
150		* @return mixed
151		*/
152	70	public function getParams() {
153	70	if (\is_array($this->params)) {
154	63	if ($this->invertedParams) {
155	58	return \array_keys($this->params);
156		}
157	9	return $this->params;
158		}
159	43	return;
160		}
161
162		/**
163		*
164		* @return mixed
165		*/
166	43	public function hasParam($value) {
167	43	if (\is_array($this->params)) {
168	20	if ($this->invertedParams) {
169	20	return isset($this->params[$value]);
170		}
171		return \array_search($value, $this->params) !== false;
172		}
173	43	return false;
174		}
175
176	43	public function countParts() {
177	43	if (\is_array($this->params))
178	20	return \sizeof($this->params);
179	43	return 0;
180		}
181
182		/**
183		*
184		* @param string $condition
185		*/
186	28	public function setCondition($condition) {
187	28	$this->condition = $condition;
188	28	return $this;
189		}
190
191		/**
192		*
193		* @param mixed $params
194		*/
195	9	public function setParams($params) {
196	9	$this->params = $params;
197	9	$this->invertedParams = false;
198	9	return $this;
199		}
200
201	62	public function limitOne() {
202	62	$limit = '';
203	62	if (\stripos($this->condition, ' limit ') === false) {
204	54	$limit = ' limit 1';
205		}
206	62	$this->condition .= $limit;
207	62	}
208
209	11	public static function simple($condition, $params) {
210	11	$cParser = new ConditionParser($condition);
211	11	$cParser->addParams($params);
212	11	return $cParser;
213		}
214		}
215
216

phpMv / ubiquity

Push — master ( 99686f...b494ba )

ConditionParser::addKeyValues() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like