Kir\MySQL\Builder\Traits\OffsetBuilder

Complexity

Total Complexity

8

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getOffset()	0	5	2
A	offset()	0	3	1
A	buildOffset()	0	14	5

<?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;
	}
}