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

LimitBuilder::buildLimit() B
last analyzed 2026-01-11 13:55 UTC

↳ Parent: LimitBuilder

Complexity

Conditions	9
Paths	12

Size

Total Lines	23
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	16
dl	0
loc	23
rs	8.0555
c	1
b	0
f	0
cc	9
nc	12
nop	2

<?php

namespace Kir\MySQL\Builder\Traits;

use Kir\MySQL\Builder\InvalidValueException;
use Kir\MySQL\Builder\Value\OptionalValue;

trait LimitBuilder {
	private null|int|OptionalValue $limit = null;

	/**
	 * @return null|int
	 */
	protected function getLimit(): ?int {
		if($this->limit instanceof OptionalValue) {
			$value = $this->limit->getValue();
			if(is_numeric($value)) {
				return (int) $value;
			}

			return null;
		}

		return $this->limit;
	}

	/**
	 * @param null|int|OptionalValue $limit
	 * @return $this
	 */
	public function limit($limit) {
		$this->limit = $limit;

		return $this;
	}

	/**
	 * @param string $query
	 * @param int|null $offset
	 * @return string
	 */
	protected function buildLimit(string $query, ?int $offset = null) {
		$limit = $this->getLimit();
		if($limit === null && $offset !== null) {
			$limit = '18446744073709551615';
		}
		if($this->limit instanceof OptionalValue) {
			if($this->limit->isValid()) {
				$value = $this->limit->getValue();
				if($value === null || is_scalar($value)) {
					$value = (string) $value;
				} else {
					throw new InvalidValueException('Value for OFFSET has to be a number');
				}
				if(!preg_match('{^\\d+$}', $value)) {
					throw new InvalidValueException('Value for OFFSET has to be a number');
				}
				$query .= "LIMIT\n\t{$value}\n";
			}
		} elseif($limit !== null) {
			$query .= "LIMIT\n\t{$limit}\n";
		}

		return $query;
	}
}


1			<?php
2
3			namespace Kir\MySQL\Builder\Traits;
4
5			use Kir\MySQL\Builder\InvalidValueException;
6			use Kir\MySQL\Builder\Value\OptionalValue;
7
8			trait LimitBuilder {
9			private null\|int\|OptionalValue $limit = null;
10
11			/**
12			* @return null\|int
13			*/
14			protected function getLimit(): ?int {
15			if($this->limit instanceof OptionalValue) {
16			$value = $this->limit->getValue();
17			if(is_numeric($value)) {
18			return (int) $value;
19			}
20
21			return null;
22			}
23
24			return $this->limit;
25			}
26
27			/**
28			* @param null\|int\|OptionalValue $limit
29			* @return $this
30			*/
31			public function limit($limit) {
32			$this->limit = $limit;
33
34			return $this;
35			}
36
37			/**
38			* @param string $query
39			* @param int\|null $offset
40			* @return string
41			*/
42			protected function buildLimit(string $query, ?int $offset = null) {
43			$limit = $this->getLimit();
44			if($limit === null && $offset !== null) {
45			$limit = '18446744073709551615';
46			}
47			if($this->limit instanceof OptionalValue) {
48			if($this->limit->isValid()) {
49			$value = $this->limit->getValue();
50			if($value === null \|\| is_scalar($value)) {
51			$value = (string) $value;
52			} else {
53			throw new InvalidValueException('Value for OFFSET has to be a number');
54			}
55			if(!preg_match('{^\\d+$}', $value)) {
56			throw new InvalidValueException('Value for OFFSET has to be a number');
57			}
58			$query .= "LIMIT\n\t{$value}\n";
59			}
60			} elseif($limit !== null) {
61			$query .= "LIMIT\n\t{$limit}\n";
62			}
63
64			return $query;
65			}
66			}
67

rkrx / php-mysql-query-builder

LimitBuilder::buildLimit() B last analyzed 2026-01-11 13:55 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

LimitBuilder::buildLimit() B
last analyzed 2026-01-11 13:55 UTC