Select::applyLimit() - Code Metrics - Inspection of "Add reset functionality on the Select class" - auraphp/Aura.SqlQuery - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — 2.x (#95)

by Paul

created 2016-05-19 17:03 UTC

Select::applyLimit() B

↳ Parent: Select

Complexity

Conditions	5
Paths	3

Size

Total Lines	21
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	9
CRAP Score	5

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	21
ccs	9
cts	9
cp	1
rs	8.7624
cc	5
eloc	10
nc	3
nop	1
crap	5

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

use Aura\SqlQuery\Common;

/**
 *
 * An object for Sqlsrv SELECT queries.
 *
 * @package Aura.SqlQuery
 *
 */
class Select extends Common\Select
{
    /**
     *
     * Builds this query object into a string.
     *
     * @return string
     *
     */
    protected function build()
    {
        return $this->applyLimit(parent::build());
    }

    /**
     *
     * Override so that LIMIT equivalent will be applied by applyLimit().
     *
     * @see build()
     *
     * @see applyLimit()
     *
     */
    protected function buildLimit()
    {
        return '';
    }

    /**
     *
     * Modify the statement applying limit/offset equivalent portions to it.
     *
     * @param string $stm SQL statement
     * @return string SQL statement with limit/offset applied
     *
     */
    protected function applyLimit($stm)
    {
        if (! $this->limit && ! $this->offset) {
            return $stm; // no limit or offset
        }

        // limit but no offset?
        if ($this->limit && ! $this->offset) {
            // use TOP in place
            return preg_replace(
                '/^(SELECT( DISTINCT)?)/',
                "$1 TOP {$this->limit}",
                $stm
            );
        }

        // both limit and offset. must have an ORDER clause to work; OFFSET is
        // a sub-clause of the ORDER clause. cannot use FETCH without OFFSET.
        return $stm . PHP_EOL . "OFFSET {$this->offset} ROWS "
                    . "FETCH NEXT {$this->limit} ROWS ONLY";
    }
}


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\Sqlsrv;
10
11		use Aura\SqlQuery\Common;
12
13		/**
14		*
15		* An object for Sqlsrv SELECT queries.
16		*
17		* @package Aura.SqlQuery
18		*
19		*/
20		class Select extends Common\Select
21		{
22		/**
23		*
24		* Builds this query object into a string.
25		*
26		* @return string
27		*
28		*/
29	33	protected function build()
30		{
31	33	return $this->applyLimit(parent::build());
32		}
33
34		/**
35		*
36		* Override so that LIMIT equivalent will be applied by applyLimit().
37		*
38		* @see build()
39		*
40		* @see applyLimit()
41		*
42		*/
43	32	protected function buildLimit()
44		{
45	32	return '';
46		}
47
48		/**
49		*
50		* Modify the statement applying limit/offset equivalent portions to it.
51		*
52		* @param string $stm SQL statement
53		* @return string SQL statement with limit/offset applied
54		*
55		*/
56	32	protected function applyLimit($stm)
57		{
58	32	if (! $this->limit && ! $this->offset) {
59	30	return $stm; // no limit or offset
60		}
61
62		// limit but no offset?
63	2	if ($this->limit && ! $this->offset) {
64		// use TOP in place
65	1	return preg_replace(
66	1	'/^(SELECT( DISTINCT)?)/',
67	1	"$1 TOP {$this->limit}",
68		$stm
69		);
70		}
71
72		// both limit and offset. must have an ORDER clause to work; OFFSET is
73		// a sub-clause of the ORDER clause. cannot use FETCH without OFFSET.
74	2	return $stm . PHP_EOL . "OFFSET {$this->offset} ROWS "
75	2	. "FETCH NEXT {$this->limit} ROWS ONLY";
76		}
77		}
78

auraphp / Aura.SqlQuery

Pull Request — 2.x (#95)

Select::applyLimit() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like