UnionBuilder::union() - Code Metrics - Inspection of "- Fixed: Non-static method Kir\MySQL\Builder\Helpe..." - rkrx/php-mysql-query-builder - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( aef970...c04073 )

by Ron

created 2016-01-01 00:55 UTC

UnionBuilder::union() A

↳ Parent: UnionBuilder

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	4
rs	10
cc	1
eloc	3
nc	1
nop	1

<?php
namespace Kir\MySQL\Builder\Traits;

trait UnionBuilder {
	use AbstractDB;

	/** @var array */
	private $unions = [];

	/**
	 * @param string $query
	 * @return $this
	 */
	public function union($query) {
		$this->unions[] = array('', $query);
		return $this;
	}

	/**
	 * @param string $query
	 * @return $this
	 */
	public function unionAll($query) {
		$this->unions[] = array('ALL', $query);
		return $this;
	}

	/**
	 * @param string $query
	 * @return string
	 */
	protected function buildUnions($query) {
		$wrap = function ($query) {
			$query = trim($query);
			$query = join("\n\t", explode("\n", $query));
			return sprintf("(\n\t%s\n)", $query);
		};
		$queries = [$wrap($query)];
		foreach($this->unions as $unionQuery) {
			if($unionQuery[0] === 'ALL') {
				$queries[] = 'UNION ALL';
			} else {
				$queries[] = 'UNION';
			}
			$queries[] = $wrap($unionQuery[1]);
		}
		if(count($queries) > 1) {
			return join(" ", $queries);
		}
		return $query;
	}
}


1			<?php
2			namespace Kir\MySQL\Builder\Traits;
3
4			trait UnionBuilder {
5			use AbstractDB;
6
7			/** @var array */
8			private $unions = [];
9
10			/**
11			* @param string $query
12			* @return $this
13			*/
14			public function union($query) {
15			$this->unions[] = array('', $query);
16			return $this;
17			}
18
19			/**
20			* @param string $query
21			* @return $this
22			*/
23			public function unionAll($query) {
24			$this->unions[] = array('ALL', $query);
25			return $this;
26			}
27
28			/**
29			* @param string $query
30			* @return string
31			*/
32			protected function buildUnions($query) {
33			$wrap = function ($query) {
34			$query = trim($query);
35			$query = join("\n\t", explode("\n", $query));
36			return sprintf("(\n\t%s\n)", $query);
37			};
38			$queries = [$wrap($query)];
39			foreach($this->unions as $unionQuery) {
40			if($unionQuery[0] === 'ALL') {
41			$queries[] = 'UNION ALL';
42			} else {
43			$queries[] = 'UNION';
44			}
45			$queries[] = $wrap($unionQuery[1]);
46			}
47			if(count($queries) > 1) {
48			return join(" ", $queries);
49			}
50			return $query;
51			}
52			}
53

rkrx / php-mysql-query-builder

Push — master ( aef970...c04073 )

UnionBuilder::union() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like