Spiral\Database\Drivers\SQLServer\SQLServerCompiler

Complexity

Total Complexity

4

Size/Duplication

Total Lines	23
Duplicated Lines	65.22 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	compileLimit()	15	15	4

<?php
/**
 * components
 *
 * @author    Wolfy-J
 */
namespace Spiral\Database\Drivers\SQLServer;

use Spiral\Database\Entities\QueryCompiler;

/**
 * Microsoft SQL server specific syntax compiler.
 */
class SQLServerCompiler extends QueryCompiler
{
    /**
     * {@inheritdoc}
     *
     * @link http://stackoverflow.com/questions/2135418/equivalent-of-limit-and-offset-for-sql-server
     */
    protected function compileLimit(int $limit, int $offset): string

This method seems to be duplicated in your project.

    {
        if (empty($limit) && empty($offset)) {
            return '';
        }

        //Modern SQLServer are easier to work with
        $statement = "OFFSET {$offset} ROWS ";

        if (!empty($limit)) {
            $statement .= "FETCH NEXT {$limit} ROWS ONLY";
        }

        return trim($statement);
    }
}