Bosnadev\Database\Query\Grammars\PostgresGrammar

Complexity

Total Complexity

7

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

86.67%

Importance

Changes	4
Bugs	0	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
B	wrapValue()	0	21	5
A	whereNull()	0	4	1
A	whereNotNull()	0	4	1

<?php
namespace Bosnadev\Database\Query\Grammars;

use Illuminate\Database\Query\Builder;
use Illuminate\Database\Query\Grammars\PostgresGrammar as LaravelPostgresGrammar;

/**
 * Class PostgresGrammar
 *
 * @package Bosnadev\Database\Query\Grammars
 */
class PostgresGrammar extends LaravelPostgresGrammar
{
    /**
     * @var array
     */
    protected $jsonOperators = [
        '->',
        '->>',
        '#>',
        '#>>',
    ];

    /**
     * @param string $value
     *
     * @return string
     */
    protected function wrapValue($value)
    {
        if ($value === '*') {
            return $value;
        }

        // If querying hstore
        if (preg_match('/\[(.*?)\]/', $value, $match)) {
            return (string)str_replace(array('[', ']'), '', $match[1]);
        }

        // If querying json column
        foreach ($this->jsonOperators as $operator) {
            if (stripos($value, $operator)) {
                list($value, $key) = explode($operator, $value, 2);
                return parent::wrapValue($value) . $operator . $key;
            }
        }

        return parent::wrapValue($value);
    }

    /**
     * Compile a "where null" clause.
     *
     * @param  Builder $query
     * @param  array   $where
     *
     * @return string
     */
    protected function whereNull(Builder $query, $where)
    {
        return '(' . $this->wrap($where['column']) . ') is null';
    }

    /**
     * Compile a "where not null" clause.
     *
     * @param  Builder $query
     * @param  array   $where
     *
     * @return string
     */
    protected function whereNotNull(Builder $query, $where)
    {
        return '(' . $this->wrap($where['column']) . ') is not null';
    }
}