Umbrellio\Postgres\Compilers\Traits\WheresBuilder

Complexity

Total Complexity

16

Size/Duplication

Total Lines	103
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	wrapValue()	0	6	2
A	whereBetween()	0	8	2
A	whereNull()	0	3	1
A	whereNotNull()	0	3	1
A	removeLeadingBoolean()	0	3	1
A	whereColumn()	0	6	1
A	whereRaw()	0	5	1
A	whereBasic()	0	6	1
A	wrapValues()	0	5	1
A	whereIn()	0	10	2
A	whereNotIn()	0	10	2
A	build()	0	10	1

<?php

declare(strict_types=1);

namespace Umbrellio\Postgres\Compilers\Traits;

use Illuminate\Database\Schema\Grammars\Grammar;
use Illuminate\Support\Fluent;
use Umbrellio\Postgres\Schema\Blueprint;

trait WheresBuilder
{
    protected static function whereRaw(Grammar $grammar, Blueprint $blueprint, array $where = []): string
    {
        return call_user_func_array('sprintf', array_merge(
            [str_replace('?', '%s', $where['sql'])],
            static::wrapValues($where['bindings'])
        ));
    }

    protected static function whereBasic(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [
            $grammar->wrap($where['column']),
            $where['operator'],
            static::wrapValue($where['value']),
        ]);
    }

    protected static function whereColumn(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [
            $grammar->wrap($where['first']),
            $where['operator'],
            $grammar->wrap($where['second']),
        ]);
    }

    protected static function whereIn(Grammar $grammar, Blueprint $blueprint, array $where = []): string
    {
        if (! empty($where['values'])) {
            return implode(' ', [
                $grammar->wrap($where['column']),
                'in',
                '(' . implode(',', static::wrapValues($where['values'])) . ')',
            ]);
        }
        return '0 = 1';
    }

    protected static function whereNotIn(Grammar $grammar, Blueprint $blueprint, array $where = []): string
    {
        if (! empty($where['values'])) {
            return implode(' ', [
                $grammar->wrap($where['column']),
                'not in',
                '(' . implode(',', static::wrapValues($where['values'])) . ')',
            ]);
        }
        return '1 = 1';
    }

    protected static function whereNull(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [$grammar->wrap($where['column']), 'is null']);
    }

    protected static function whereNotNull(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [$grammar->wrap($where['column']), 'is not null']);
    }

    protected static function whereBetween(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [
            $grammar->wrap($where['column']),
            $where['not'] ? 'not between' : 'between',
            static::wrapValue(reset($where['values'])),
            'and',
            static::wrapValue(end($where['values'])),
        ]);
    }

    protected static function wrapValues(array $values = []): array
    {
        return collect($values)->map(function ($value) {

$values of type array is incompatible with the type Illuminate\Contracts\Support\Arrayable expected by parameter $value of collect().

            return static::wrapValue($value);
        })->toArray();
    }

    protected static function wrapValue($value)
    {
        if (is_string($value)) {
            return "'{$value}'";
        }
        return (int) $value;
    }

    protected static function removeLeadingBoolean(string $value): string
    {
        return preg_replace('/and |or /i', '', $value, 1);
    }

    private static function build(Grammar $grammar, Blueprint $blueprint, Fluent $command): array
    {
        return collect($command->get('wheres'))
            ->map(function ($where) use ($grammar, $blueprint) {
                return implode(' ', [
                    $where['boolean'],
                    '(' . static::{"where{$where['type']}"}($grammar, $blueprint, $where) . ')',
                ]);
            })
            ->all();
    }
}