SelectBuilder::applyLimit() - Code Metrics - Inspection of "Extract builder logic to separate classes" - auraphp/Aura.SqlQuery - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — 3.x (#131)

by Paul

created 2017-03-18 15:09 UTC

SelectBuilder::applyLimit() B

↳ Parent: SelectBuilder

Complexity

Conditions	5
Paths	3

Size

Total Lines	21
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	21
rs	8.7624
c	0
b	0
f	0
cc	5
eloc	10
nc	3
nop	3

<?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 SelectBuilder extends Common\SelectBuilder
{
    /**
     *
     * Override so that LIMIT equivalent will be applied by applyLimit().
     *
     * @see build()
     *
     * @see applyLimit()
     *
     */
    public function buildLimitOffset($limit, $offset)
    {
        return '';
    }

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

        // limit but no offset?
        if ($limit && ! $offset) {
            // use TOP in place
            return preg_replace(
                '/^(SELECT( DISTINCT)?)/',
                "$1 TOP {$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 {$offset} ROWS "
                    . "FETCH NEXT {$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 SelectBuilder extends Common\SelectBuilder
21			{
22			/**
23			*
24			* Override so that LIMIT equivalent will be applied by applyLimit().
25			*
26			* @see build()
27			*
28			* @see applyLimit()
29			*
30			*/
31			public function buildLimitOffset($limit, $offset)
32			{
33			return '';
34			}
35
36			/**
37			*
38			* Modify the statement applying limit/offset equivalent portions to it.
39			*
40			* @param string $stm SQL statement
41			* @return string SQL statement with limit/offset applied
42			*
43			*/
44			public function applyLimit($stm, $limit, $offset)
45			{
46			if (! $limit && ! $offset) {
47			return $stm; // no limit or offset
48			}
49
50			// limit but no offset?
51			if ($limit && ! $offset) {
52			// use TOP in place
53			return preg_replace(
54			'/^(SELECT( DISTINCT)?)/',
55			"$1 TOP {$limit}",
56			$stm
57			);
58			}
59
60			// both limit and offset. must have an ORDER clause to work; OFFSET is
61			// a sub-clause of the ORDER clause. cannot use FETCH without OFFSET.
62			return $stm . PHP_EOL . "OFFSET {$offset} ROWS "
63			. "FETCH NEXT {$limit} ROWS ONLY";
64			}
65			}
66

auraphp / Aura.SqlQuery

Pull Request — 3.x (#131)

SelectBuilder::applyLimit() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like