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

OffsetBuilder::buildOffset() A
last analyzed 2025-09-30 18:12 UTC

↳ Parent: OffsetBuilder

Complexity

Conditions	5
Paths	5

Size

Total Lines	14
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	10
c	1
b	0
f	0
dl	0
loc	14
rs	9.6111
cc	5
nc	5
nop	1

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

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

trait OffsetBuilder {
	private null|int|OptionalValue $offset = null;

	/**
	 * @return null|int
	 */
	protected function getOffset(): ?int {
		if($this->offset instanceof OptionalValue) {
			return $this->offset->getValue();
		}
		return $this->offset;
	}

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

	/**
	 * @param string $query
	 * @return string
	 */
	protected function buildOffset(string $query): string {
		$offset = $this->getOffset();
		if($this->offset instanceof OptionalValue) {
			if($this->offset->isValid()) {
				$value = $this->offset->getValue();
				if(!preg_match('{\\d+}', $value)) {
					throw new InvalidValueException('Value for OFFSET has to be a number');
				}
				$query .= "OFFSET\n\t{$this->offset->getValue()}\n";
			}
		} elseif($offset !== null) {
			$query .= "OFFSET\n\t{$this->offset}\n";
		}
		return $query;
	}
}


1			<?php
2			namespace Kir\MySQL\Builder\Traits;
3
4			use Kir\MySQL\Builder\InvalidValueException;
5			use Kir\MySQL\Builder\Value\OptionalValue;
6
7			trait OffsetBuilder {
8			private null\|int\|OptionalValue $offset = null;
9
10			/**
11			* @return null\|int
12			*/
13			protected function getOffset(): ?int {
14			if($this->offset instanceof OptionalValue) {
15			return $this->offset->getValue();
16			}
17			return $this->offset;
18			}
19
20			/**
21			* @param null\|int\|OptionalValue $offset
22			* @return $this
23			*/
24			public function offset($offset = 0) {
25			$this->offset = $offset;
26			return $this;
27			}
28
29			/**
30			* @param string $query
31			* @return string
32			*/
33			protected function buildOffset(string $query): string {
34			$offset = $this->getOffset();
35			if($this->offset instanceof OptionalValue) {
36			if($this->offset->isValid()) {
37			$value = $this->offset->getValue();
38			if(!preg_match('{\\d+}', $value)) {
39			throw new InvalidValueException('Value for OFFSET has to be a number');
40			}
41			$query .= "OFFSET\n\t{$this->offset->getValue()}\n";
42			}
43			} elseif($offset !== null) {
44			$query .= "OFFSET\n\t{$this->offset}\n";
45			}
46			return $query;
47			}
48			}
49

rkrx / php-mysql-query-builder

OffsetBuilder::buildOffset() A last analyzed 2025-09-30 18:12 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

OffsetBuilder::buildOffset() A
last analyzed 2025-09-30 18:12 UTC