UnionBuilder::buildUnions() - Code Metrics - rkrx/php-mysql-query-builder - Measure and Improve Code Quality continuously with Scrutinizer

UnionBuilder::buildUnions() A
last analyzed 2025-05-25 17:17 UTC

↳ Parent: UnionBuilder

Complexity

Conditions	4
Paths	6

Size

Total Lines	19
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	14
c	1
b	0
f	0
dl	0
loc	19
rs	9.7998
cc	4
nc	6
nop	1

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

use Kir\MySQL\Builder\Select;

trait UnionBuilder {
	use AbstractDB;

	/** @var array<int, array{''|'ALL', string|Select}> */

	private $unions = [];

	/**
	 * @param string|Select ...$queries
	 * @return $this
	 */
	public function union(...$queries) {
		foreach($queries as $query) {
			$this->unions[] = ['', $query];
		}
		return $this;
	}

	/**
	 * @param string|Select ...$queries
	 * @return $this
	 */
	public function unionAll(...$queries) {
		foreach($queries as $query) {
			$this->unions[] = ['ALL', $query];
		}
		return $this;
	}

	/**
	 * @param string $query
	 * @return string
	 */
	protected function buildUnions(string $query): string {
		$wrap = static function ($query) {
			$query = trim($query);
			$query = implode("\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 implode(' ', $queries);
		}
		return $query;
	}
}


1			<?php
2			namespace Kir\MySQL\Builder\Traits;
3
4			use Kir\MySQL\Builder\Select;
5
6			trait UnionBuilder {
7			use AbstractDB;
8
9			/** @var array<int, array{''\|'ALL', string\|Select}> */
			0 ignored issues – show Documentation Bug introduced 2021-05-06 14:34 UTC by Report Bug Copy Issue Report The doc comment `array<int, array{''\|'ALL', string\|Select}>` at position `6` could not be parsed: Expected ':' at position 6, but found ''''. Loading history...
10			private $unions = [];
11
12			/**
13			* @param string\|Select ...$queries
14			* @return $this
15			*/
16			public function union(...$queries) {
17			foreach($queries as $query) {
18			$this->unions[] = ['', $query];
19			}
20			return $this;
21			}
22
23			/**
24			* @param string\|Select ...$queries
25			* @return $this
26			*/
27			public function unionAll(...$queries) {
28			foreach($queries as $query) {
29			$this->unions[] = ['ALL', $query];
30			}
31			return $this;
32			}
33
34			/**
35			* @param string $query
36			* @return string
37			*/
38			protected function buildUnions(string $query): string {
39			$wrap = static function ($query) {
40			$query = trim($query);
41			$query = implode("\n\t", explode("\n", $query));
42			return sprintf("(\n\t%s\n)", $query);
43			};
44			$queries = [$wrap($query)];
45			foreach($this->unions as $unionQuery) {
46			if($unionQuery[0] === 'ALL') {
47			$queries[] = 'UNION ALL';
48			} else {
49			$queries[] = 'UNION';
50			}
51			$queries[] = $wrap($unionQuery[1]);
52			}
53			if(count($queries) > 1) {
54			return implode(' ', $queries);
55			}
56			return $query;
57			}
58			}
59

rkrx / php-mysql-query-builder

UnionBuilder::buildUnions() A last analyzed 2025-05-25 17:17 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

UnionBuilder::buildUnions() A
last analyzed 2025-05-25 17:17 UTC