Wandu\Database\Query\Expression\LimitExpression

Complexity

Total Complexity

11

Size/Duplication

Total Lines	73
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

83.33%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	take()	0	5	1
A	offset()	0	5	1
A	limit()	0	6	1
B	toSql()	0	14	5
A	getBindings()	0	11	3

<?php
namespace Wandu\Database\Query\Expression;

use Wandu\Database\Contracts\ExpressionInterface;

class LimitExpression implements ExpressionInterface
{
    /** @var int */
    protected $take;

    /** @var int */
    protected $offset;

    /**
     * @param int $take
     * @return static
     */
    public function take($take = null)
    {
        $this->take = $take;
        return $this;
    }

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

    /**
     * @param int $offset
     * @param int $take
     * @return static
     */
    public function limit($offset, $take)
    {
        $this->offset = $offset;
        $this->take = $take;
        return $this;
    }
    
    /**
     * {@inheritdoc}
     */
    public function toSql()
    {
        if (!isset($this->take) && !isset($this->offset)) {
            return '';
        }
        $sqlParts = [];
        if (isset($this->take)) {
            $sqlParts[] = "LIMIT ?";
        }
        if (isset($this->offset)) {
            $sqlParts[] = "OFFSET ?";
        }
        return implode(" ", $sqlParts);
    }

    /**
     * {@inheritdoc}
     */
    public function getBindings()
    {
        $bindings = [];
        if (isset($this->take)) {
            $bindings[] = $this->take;
        }
        if (isset($this->offset)) {
            $bindings[] = $this->offset;
        }
        return $bindings;
    }
}