Staudenmeir\EloquentEagerLimit\Grammars\Traits\CompilesGroupLimit

Complexity

Total Complexity

7

Size/Duplication

Total Lines	75
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	compileSelect()	0	11	3
A	compileRowNumber()	0	7	1
A	compileGroupLimit()	0	32	3

<?php

namespace Staudenmeir\EloquentEagerLimit\Grammars\Traits;

use Illuminate\Database\Query\Builder;

trait CompilesGroupLimit
{
    /**
     * Compile a select query into SQL.
     *
     * @param \Illuminate\Database\Query\Builder $query
     * @return string
     */
    public function compileSelect(Builder $query)
    {
        if (isset($query->groupLimit)) {
            if (is_null($query->columns)) {

The condition is_null($query->columns) is always false.

                $query->columns = ['*'];
            }

            return $this->compileGroupLimit($query);
        }

        return parent::compileSelect($query);
    }

    /**
     * Compile a group limit clause.
     *
     * @param \Illuminate\Database\Query\Builder $query
     * @return string
     */
    protected function compileGroupLimit(Builder $query)
    {
        $selectBindings = array_merge($query->getRawBindings()['select'], $query->getRawBindings()['order']);

        $query->setBindings($selectBindings, 'select');
        $query->setBindings([], 'order');

        $limit = (int) $query->groupLimit['value'];

The property groupLimit does not seem to exist on Illuminate\Database\Query\Builder.

        $offset = $query->offset;

        if (isset($offset)) {
            $limit += (int) $offset;

            $query->offset = null;
        }

        $components = $this->compileComponents($query);

It seems like compileComponents() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $components['columns'] .= $this->compileRowNumber($query->groupLimit['column'], $components['orders'] ?? '');

        unset($components['orders']);

        $sql = $this->concatenate($components);

It seems like concatenate() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $sql = 'select * from ('.$sql.') as laravel_table where laravel_row <= '.$limit;

        if (isset($offset)) {
            $sql .= ' and laravel_row > '.(int) $offset;
        }

        return $sql.' order by laravel_row';
    }

    /**
     * Compile a row number clause.
     *
     * @param string $partition
     * @param string $orders
     * @return string
     */
    protected function compileRowNumber($partition, $orders)
    {
        $partition = 'partition by '.$this->wrap($partition);

It seems like wrap() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $over = trim($partition.' '.$orders);

        return ', row_number() over ('.$over.') as laravel_row';
    }
}