LimitExpression::toSql() - Code Metrics - Inspection of "fix HHVM Array List" - Wandu/Framework - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 5df011...747e00 )

by Changwan

created 2016-12-10 16:12 UTC

LimitExpression::toSql() B

↳ Parent: LimitExpression

Complexity

Conditions	5
Paths	5

Size

Total Lines	14
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	5.0342

Importance

Changes

Metric	Value
cc	5
eloc	9
nc	5
nop	0
dl	0
loc	14
ccs	8
cts	9
cp	0.8889
crap	5.0342
rs	8.8571
c	0
b	0
f	0

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


1		<?php
2		namespace Wandu\Database\Query\Expression;
3
4		use Wandu\Database\Contracts\ExpressionInterface;
5
6		class LimitExpression implements ExpressionInterface
7		{
8		/** @var int */
9		protected $take;
10
11		/** @var int */
12		protected $offset;
13
14		/**
15		* @param int $take
16		* @return static
17		*/
18	7	public function take($take = null)
19		{
20	7	$this->take = $take;
21	7	return $this;
22		}
23
24		/**
25		* @param int $offset
26		* @return static
27		*/
28	5	public function offset($offset = null)
29		{
30	5	$this->offset = $offset;
31	5	return $this;
32		}
33
34		/**
35		* @param int $offset
36		* @param int $take
37		* @return static
38		*/
39		public function limit($offset, $take)
40		{
41		$this->offset = $offset;
42		$this->take = $take;
43		return $this;
44		}
45
46		/**
47		* {@inheritdoc}
48		*/
49	9	public function toSql()
50		{
51	9	if (!isset($this->take) && !isset($this->offset)) {
52		return '';
53		}
54	9	$sqlParts = [];
55	9	if (isset($this->take)) {
56	9	$sqlParts[] = "LIMIT ?";
57		}
58	9	if (isset($this->offset)) {
59	5	$sqlParts[] = "OFFSET ?";
60		}
61	9	return implode(" ", $sqlParts);
62		}
63
64		/**
65		* {@inheritdoc}
66		*/
67	9	public function getBindings()
68		{
69	9	$bindings = [];
70	9	if (isset($this->take)) {
71	9	$bindings[] = $this->take;
72		}
73	9	if (isset($this->offset)) {
74	5	$bindings[] = $this->offset;
75		}
76	9	return $bindings;
77		}
78		}
79

Wandu / Framework

Push — master ( 5df011...747e00 )

LimitExpression::toSql() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like