LimitOffsetTrait::buildLimit() - Code Metrics - Inspection of "Merge pull request #120 from pavarnos/limitoffsett..." - auraphp/Aura.SqlQuery - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 3.x ( 9be43c...53c3d5 )

by Paul

created 2017-02-19 15:34 UTC

LimitOffsetTrait::buildLimit() A

↳ Parent: LimitOffsetTrait

Complexity

Conditions	4
Paths	8

Size

Total Lines	19
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	13
CRAP Score	4

Importance

Changes

Metric	Value
dl	0
loc	19
ccs	13
cts	13
cp	1
rs	9.2
c	0
b	0
f	0
cc	4
eloc	10
nc	8
nop	0
crap	4

<?php
/**
 *
 * This file is part of Aura for PHP.
 *
 * @license http://opensource.org/licenses/bsd-license.php BSD
 *
 */
namespace Aura\SqlQuery\Common;

/**
 *
 * An interface for LIMIT...OFFSET clauses.
 *
 * @package Aura.SqlQuery
 *
 */
trait LimitOffsetTrait
{
    use LimitTrait;

    private $offset = 0;

    /**
     *
     * Sets a limit offset on the query.
     *
     * @param int $offset Start returning after this many rows.
     *
     * @return $this
     *
     */
    public function offset($offset)
    {
        $this->offset = (int) $offset;
        return $this;
    }

    /**
     *
     * Returns the OFFSET value.
     *
     * @return int
     *
     */
    public function getOffset()
    {
        return $this->offset;
    }

    /**
     *
     * Builds the `LIMIT ... OFFSET` clause of the statement.
     *
     * @return string
     *
     */
    protected function buildLimit()
    {
        $clause = '';

        $limit = $this->getLimit();
        if (!empty($limit)) {
            $clause .= "LIMIT {$limit}";
        }

        if (!empty($this->offset)) {
            $clause .= " OFFSET {$this->offset}";
        }

        if (!empty($clause)) {
            $clause = PHP_EOL . trim($clause);
        }

        return $clause;
    }
}


1		<?php
2		/**
3		*
4		* This file is part of Aura for PHP.
5		*
6		* @license http://opensource.org/licenses/bsd-license.php BSD
7		*
8		*/
9		namespace Aura\SqlQuery\Common;
10
11		/**
12		*
13		* An interface for LIMIT...OFFSET clauses.
14		*
15		* @package Aura.SqlQuery
16		*
17		*/
18		trait LimitOffsetTrait
19		{
20		use LimitTrait;
21
22		private $offset = 0;
23
24		/**
25		*
26		* Sets a limit offset on the query.
27		*
28		* @param int $offset Start returning after this many rows.
29		*
30		* @return $this
31		*
32		*/
33	44	public function offset($offset)
34		{
35	44	$this->offset = (int) $offset;
36	44	return $this;
37		}
38
39		/**
40		*
41		* Returns the OFFSET value.
42		*
43		* @return int
44		*
45		*/
46	47	public function getOffset()
47		{
48	47	return $this->offset;
49		}
50
51		/**
52		*
53		* Builds the `LIMIT ... OFFSET` clause of the statement.
54		*
55		* @return string
56		*
57		*/
58	159	protected function buildLimit()
59		{
60	159	$clause = '';
61
62	159	$limit = $this->getLimit();
63	159	if (!empty($limit)) {
64	15	$clause .= "LIMIT {$limit}";
65	15	}
66
67	159	if (!empty($this->offset)) {
68	10	$clause .= " OFFSET {$this->offset}";
69	10	}
70
71	159	if (!empty($clause)) {
72	15	$clause = PHP_EOL . trim($clause);
73	15	}
74
75	159	return $clause;
76		}
77		}
78

auraphp / Aura.SqlQuery

Push — 3.x ( 9be43c...53c3d5 )

LimitOffsetTrait::buildLimit() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like