SelectAbstract::orderby() - Code Metrics - Inspection of ":octocat:" - chillerlan/php-database - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( d508c6...ead087 )

by smiley

created 2017-06-16 01:17 UTC

SelectAbstract::orderby() B

↳ Parent: SelectAbstract

Complexity

Conditions	4
Paths	4

Size

Total Lines	22
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	22
rs	8.9197
c	0
b	0
f	0
cc	4
eloc	11
nc	4
nop	1

<?php
/**
 * Class SelectAbstract
 *
 * @filesource   SelectAbstract.php
 * @created      03.06.2017
 * @package      chillerlan\Database\Query\Dialects
 * @author       Smiley <[email protected]>
 * @copyright    2017 Smiley
 * @license      MIT
 */

namespace chillerlan\Database\Query;


use chillerlan\Database\Query\Traits\WhereTrait;

abstract class SelectAbstract extends StatementAbstract implements SelectInterface{
	use WhereTrait;

	protected $distinct = false;

	protected $cols = [];
	protected $from = [];
	protected $where = [];
	protected $orderby = [];
	protected $groupby = [];

	public function where($val1, $val2, $operator = '=', $bind = true, $join = 'AND'):SelectInterface{
		return $this->_addWhere($val1, $val2, $operator, $bind, $join);
	}

	public function openBracket($join = null):SelectInterface{
		return $this->_openBracket($join);
	}

	public function closeBracket():SelectInterface{
		return $this->_closeBracket();
	}

	/**
	 * @return \chillerlan\Database\Query\SelectInterface
	 */
	public function distinct():SelectInterface{
		$this->distinct = true;

		return $this;
	}

	/**
	 * @param      $expr1
	 * @param null $expr2
	 * @param null $func
	 *
	 * @return void
	 */
	protected function addColumn($expr1, $expr2 = null, $func = null){
		// @todo: quotes
		switch(true){
			case  $expr2 && $func:
switch (true) {
    case!isset($a):  //wrong
        doSomething();
        break;
    case !isset($b):  //right
        doSomething();
        break;
}
				$col = sprintf('%s(%s) AS %s', strtoupper($func), $this->quote($expr1), $this->quote($expr2)); break;
switch ($expr) {
     case "A":
         doSomething();
         break; //wrong
     case "B":
         doSomething();
         break; //right
     case "C:":
         doSomething();
         return true; //right
 }
			case  $expr2 && !$func:
switch (true) {
    case!isset($a):  //wrong
        doSomething();
        break;
    case !isset($b):  //right
        doSomething();
        break;
}
				$col = sprintf('%s AS %s', $this->quote($expr1), $this->quote($expr2)); break;
switch ($expr) {
     case "A":
         doSomething();
         break; //wrong
     case "B":
         doSomething();
         break; //right
     case "C:":
         doSomething();
         return true; //right
 }
			case !$expr2 && $func:

				$col = sprintf('%s(%s)', strtoupper($func), $this->quote($expr1)); break;
switch ($expr) {
     case "A":
         doSomething();
         break; //wrong
     case "B":
         doSomething();
         break; //right
     case "C:":
         doSomething();
         return true; //right
 }
			case !$expr2 && !$func:
			default:
				$col = $this->quote($expr1);
		}

		$this->cols[$expr2 ?? $expr1] = $col;
	}

	/**
	 * @param array $expressions
	 *
	 * @return \chillerlan\Database\Query\SelectInterface
	 */
	public function cols(array $expressions):SelectInterface{

		foreach($expressions as $k => $ref){

			if(is_string($k)){
				is_array($ref)
					? $this->addColumn($ref[0], $k, $ref[1] ?? null)
					: $this->addColumn($ref ,$k);
			}
			else{
				is_array($ref)
					? $this->addColumn($ref[0], null, $ref[1] ?? null)
					: $this->addColumn($ref);
			}

		}

		return $this;
	}

	/**
	 * @param string      $table
	 * @param string|null $ref
	 */
	protected function _addFrom(string $table, string $ref = null){
		// @todo: quotes
		$from = $this->quote($table);

		if($ref){
''   == false // true
''   == null  // true
'ab' == false // false
'ab' == null  // false

// It is often better to use strict comparison
'' === false // false
'' === null  // false
			$from = sprintf('%s AS %s', $this->quote($ref), $this->quote($table));// @todo: index hint
		}

		$this->from[$ref ?? $table] = $from;
	}

	/**
	 * @param array $expressions
	 *
	 * @return \chillerlan\Database\Query\SelectInterface
	 */
	public function from(array $expressions):SelectInterface{

		foreach($expressions as $k => $ref){

			if(is_string($k)){
				$this->_addFrom($k, $ref);
			}
			else{
				$x = explode(' ', $ref);

				if(count($x) === 2){
					$this->_addFrom($x[0], $x[1]);
				}
				else{
					$this->_addFrom($ref);
				}
			}

		}

		return $this;
	}

	/**
	 * @param int $limit
	 *
	 * @return \chillerlan\Database\Query\SelectInterface
	 */
	public function limit(int $limit):SelectInterface{
		$this->limit = $limit;

		return $this;
	}

	/**
	 * @param int $offset
	 *
	 * @return \chillerlan\Database\Query\SelectInterface
	 */
	public function offset(int $offset):SelectInterface{
		$this->offset = $offset;

		return $this;
	}

	/**
	 * @param array $expressions
	 *
	 * @return \chillerlan\Database\Query\SelectInterface
	 */
	public function orderby(array $expressions):SelectInterface{

		foreach($expressions as $k => $expression){

			if(is_string($k)){
				$orderby = $this->quote($k);
				$expression = strtoupper($expression);

				if(in_array($expression, ['ASC', 'DESC'])){
					$orderby .= ' '.$expression;
				}

				$this->orderby[] = $orderby;
			}
			else{
				$this->orderby[] = $this->quote($expression);
			}

		}

		return $this;
	}

	public function groupBy(array $expressions):SelectInterface{

		foreach($expressions as $expression){
			$this->groupby[] = $expression;
		}

		return $this;
	}

	public function union():SelectInterface{
		// TODO: Implement union() method.
	}

}


1		<?php
2		/**
3		* Class SelectAbstract
4		*
5		* @filesource SelectAbstract.php
6		* @created 03.06.2017
7		* @package chillerlan\Database\Query\Dialects
8		* @author Smiley <[email protected]>
9		* @copyright 2017 Smiley
10		* @license MIT
11		*/
12
13		namespace chillerlan\Database\Query;
14
15
16		use chillerlan\Database\Query\Traits\WhereTrait;
17
18		abstract class SelectAbstract extends StatementAbstract implements SelectInterface{
19		use WhereTrait;
20
21		protected $distinct = false;
22
23		protected $cols = [];
24		protected $from = [];
25		protected $where = [];
26		protected $orderby = [];
27		protected $groupby = [];
28
29		public function where($val1, $val2, $operator = '=', $bind = true, $join = 'AND'):SelectInterface{
30		return $this->_addWhere($val1, $val2, $operator, $bind, $join);
31		}
32
33		public function openBracket($join = null):SelectInterface{
34		return $this->_openBracket($join);
35		}
36
37		public function closeBracket():SelectInterface{
38		return $this->_closeBracket();
39		}
40
41		/**
42		* @return \chillerlan\Database\Query\SelectInterface
43		*/
44		public function distinct():SelectInterface{
45		$this->distinct = true;
46
47		return $this;
48		}
49
50		/**
51		* @param $expr1
52		* @param null $expr2
53		* @param null $func
54		*
55		* @return void
56		*/
57		protected function addColumn($expr1, $expr2 = null, $func = null){
58		// @todo: quotes
59		switch(true){
60	View Code Duplication	case $expr2 && $func:
		0 ignored issues – show Duplication introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history... Coding Style introduced 2017-06-06 00:26 UTC by Report Bug Copy Issue Report As per coding-style, `case` should be followed by a single space. As per the PSR-2 coding standard, there must be a space after the `case` keyword, instead of the test immediately following it. switch (true) { case!isset($a): //wrong doSomething(); break; case !isset($b): //right doSomething(); break; } To learn more about the PSR-2 coding standard, please refer to the PHP-Fig. Loading history...
61		$col = sprintf('%s(%s) AS %s', strtoupper($func), $this->quote($expr1), $this->quote($expr2)); break;
		0 ignored issues – show Coding Style introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report Terminating statement must be on a line by itself As per the PSR-2 coding standard, the `break` (or other terminating) statement must be on a line of its own. switch ($expr) { case "A": doSomething(); break; //wrong case "B": doSomething(); break; //right case "C:": doSomething(); return true; //right } To learn more about the PSR-2 coding standard, please refer to the PHP-Fig. Loading history...
62	View Code Duplication	case $expr2 && !$func:
		0 ignored issues – show Duplication introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history... Coding Style introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report As per coding-style, `case` should be followed by a single space. As per the PSR-2 coding standard, there must be a space after the `case` keyword, instead of the test immediately following it. switch (true) { case!isset($a): //wrong doSomething(); break; case !isset($b): //right doSomething(); break; } To learn more about the PSR-2 coding standard, please refer to the PHP-Fig. Loading history...
63		$col = sprintf('%s AS %s', $this->quote($expr1), $this->quote($expr2)); break;
		0 ignored issues – show Coding Style introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report Terminating statement must be on a line by itself As per the PSR-2 coding standard, the `break` (or other terminating) statement must be on a line of its own. switch ($expr) { case "A": doSomething(); break; //wrong case "B": doSomething(); break; //right case "C:": doSomething(); return true; //right } To learn more about the PSR-2 coding standard, please refer to the PHP-Fig. Loading history...
64	View Code Duplication	case !$expr2 && $func:
		0 ignored issues – show Duplication introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
65		$col = sprintf('%s(%s)', strtoupper($func), $this->quote($expr1)); break;
		0 ignored issues – show Coding Style introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report Terminating statement must be on a line by itself As per the PSR-2 coding standard, the `break` (or other terminating) statement must be on a line of its own. switch ($expr) { case "A": doSomething(); break; //wrong case "B": doSomething(); break; //right case "C:": doSomething(); return true; //right } To learn more about the PSR-2 coding standard, please refer to the PHP-Fig. Loading history...
66		case !$expr2 && !$func:
67		default:
68		$col = $this->quote($expr1);
69		}
70
71		$this->cols[$expr2 ?? $expr1] = $col;
72		}
73
74		/**
75		* @param array $expressions
76		*
77		* @return \chillerlan\Database\Query\SelectInterface
78		*/
79		public function cols(array $expressions):SelectInterface{
80
81		foreach($expressions as $k => $ref){
82
83		if(is_string($k)){
84		is_array($ref)
85		? $this->addColumn($ref[0], $k, $ref[1] ?? null)
86		: $this->addColumn($ref ,$k);
87		}
88		else{
89		is_array($ref)
90		? $this->addColumn($ref[0], null, $ref[1] ?? null)
91		: $this->addColumn($ref);
92		}
93
94		}
95
96		return $this;
97		}
98
99		/**
100		* @param string $table
101		* @param string\|null $ref
102		*/
103		protected function _addFrom(string $table, string $ref = null){
104		// @todo: quotes
105		$from = $this->quote($table);
106
107		if($ref){
		0 ignored issues – show Bug Best Practice introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report The expression `$ref` of type `null\|string` is loosely compared to `true`; this is ambiguous if the string can be empty. You might want to explicitly use `!== null` instead. In PHP, under loose comparison (like `==`, or `!=`, or `switch` conditions), values of different types might be equal. For `string` values, the empty string `''` is a special case, in particular the following results might be unexpected: '' == false // true '' == null // true 'ab' == false // false 'ab' == null // false // It is often better to use strict comparison '' === false // false '' === null // false Loading history...
108		$from = sprintf('%s AS %s', $this->quote($ref), $this->quote($table));// @todo: index hint
109		}
110
111		$this->from[$ref ?? $table] = $from;
112		}
113
114		/**
115		* @param array $expressions
116		*
117		* @return \chillerlan\Database\Query\SelectInterface
118		*/
119		public function from(array $expressions):SelectInterface{
120
121		foreach($expressions as $k => $ref){
122
123		if(is_string($k)){
124		$this->_addFrom($k, $ref);
125		}
126		else{
127		$x = explode(' ', $ref);
128
129		if(count($x) === 2){
130		$this->_addFrom($x[0], $x[1]);
131		}
132		else{
133		$this->_addFrom($ref);
134		}
135		}
136
137		}
138
139		return $this;
140		}
141
142		/**
143		* @param int $limit
144		*
145		* @return \chillerlan\Database\Query\SelectInterface
146		*/
147		public function limit(int $limit):SelectInterface{
148		$this->limit = $limit;
149
150		return $this;
151		}
152
153		/**
154		* @param int $offset
155		*
156		* @return \chillerlan\Database\Query\SelectInterface
157		*/
158		public function offset(int $offset):SelectInterface{
159		$this->offset = $offset;
160
161		return $this;
162		}
163
164		/**
165		* @param array $expressions
166		*
167		* @return \chillerlan\Database\Query\SelectInterface
168		*/
169		public function orderby(array $expressions):SelectInterface{
170
171		foreach($expressions as $k => $expression){
172
173		if(is_string($k)){
174		$orderby = $this->quote($k);
175		$expression = strtoupper($expression);
176
177		if(in_array($expression, ['ASC', 'DESC'])){
178		$orderby .= ' '.$expression;
179		}
180
181		$this->orderby[] = $orderby;
182		}
183		else{
184		$this->orderby[] = $this->quote($expression);
185		}
186
187		}
188
189		return $this;
190		}
191
192		public function groupBy(array $expressions):SelectInterface{
193
194		foreach($expressions as $expression){
195		$this->groupby[] = $expression;
196		}
197
198		return $this;
199		}
200
201		public function union():SelectInterface{
202		// TODO: Implement union() method.
203		}
204
205		}
206

chillerlan / php-database

Push — master ( d508c6...ead087 )

SelectAbstract::orderby() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like