Ivory\Query\LimitedRelationDefinition

Complexity

Total Complexity

6

Size/Duplication

Total Lines	33
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	10	3
A	toSql()	0	10	3

<?php
namespace Ivory\Query;

use Ivory\Type\ITypeDictionary;

class LimitedRelationDefinition extends RelationDefinition implements IRelationDefinition
{
    private $baseRelDef;
    private $limit;
    private $offset;

    /**
     * @param IRelationDefinition $relationDefinition definition of relation to limit
     * @param int|null $limit maximal number of rows to return; <tt>null</tt> for unlimited number of rows
     * @param int $offset a non-negative offset - the number of original rows to skip
     */
    public function __construct(IRelationDefinition $relationDefinition, $limit, int $offset = 0)
    {
        if ($offset < 0) {
            throw new \InvalidArgumentException('$offset is negative');
        }

        $this->baseRelDef = $relationDefinition;
        $this->limit = ($limit !== null ? (int)$limit : null); // PHP 7.1: declare the type as ?int
        $this->offset = $offset;
    }

    public function toSql(ITypeDictionary $typeDictionary): string
    {
        $relSql = $this->baseRelDef->toSql($typeDictionary);
        return sprintf(
            "SELECT *\nFROM (\n%s\n) t%s%s",
            $relSql,
            ($this->limit !== null ? "\nLIMIT {$this->limit}" : ''),
            ($this->offset ? "\nOFFSET {$this->offset}" : '')
        );
    }
}