ConditionParser::setKeyValues() - Code Metrics - Inspection of "Update composer.json for tests" - phpMv/ubiquity - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — master ( 4c5444...c0dc60 )

by Jean-Christophe

created 2019-06-27 01:10 UTC

ConditionParser::setKeyValues() A

↳ Parent: ConditionParser

Complexity

Conditions	3
Paths	3

Size

Total Lines	7
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	3
CRAP Score	3.1406

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	6
c	1
b	0
f	0
dl	0
loc	7
ccs	3
cts	4
cp	0.75
rs	10
cc	3
nc	3
nop	1
crap	3.1406

<?php

namespace Ubiquity\orm\parser;

use Ubiquity\utils\base\UArray;
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.1
 *
 */
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 (! UArray::isAssociative ( $keyValues )) {
				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 ];
		} else {
			$this->params = [ ];
			foreach ( $values as $val ) {
				$this->addParams ( $val );
			}
		}
	}

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

phpMv / ubiquity

Push — master ( 4c5444...c0dc60 )

ConditionParser::setKeyValues() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like