Borobudur\Cqrs\ReadModel\Storage\Pdo\Parser\PostgresParser

Complexity

Total Complexity

9

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	comparison()	0	9	1
A	transformComparison()	0	12	3
B	transformField()	0	12	5

<?php

namespace Borobudur\Cqrs\ReadModel\Storage\Pdo\Parser;

/**
 * @author      Iqbal Maulana <iq.bluejack@gmail.com>
 * @created     4/18/16
 */
class PostgresParser extends DefaultParser
{
    /**
     * {@inheritdoc}
     */
    public function comparison($field, $comparison, $value)
    {
        return sprintf(
            '%s %s %s',
            $this->transformField($comparison, $this->quote . $field . $this->quote),
            $this->transformComparison($comparison, $value),
            $this->normalizeValue($value)
        );
    }

    /**
     * @param string $comparison
     * @param mixed  $value
     *
     * @return string
     */
    protected function transformComparison($comparison, $value)
    {
        $comparison = parent::transformComparison($comparison, $value);
        switch (strtoupper($comparison)) {
            case 'LIKE':
                return 'ILIKE';
            case 'NOT LIKE':
                return 'NOT ILIKE';
        }

        return $comparison;
    }

    /**
     * @param string $comparison
     * @param string $field
     *
     * @return string
     */
    protected function transformField($comparison, $field)
    {
        switch (strtoupper($comparison)) {
            case 'LIKE':
            case 'NOT LIKE':
            case 'ILIKE':
            case 'NOT ILIKE':
                return sprintf('cast(%s as varchar)', $field);
        }

        return $field;
    }
}