LikeConditionBuilder::build() - Code Metrics - Inspection of "Fix 10: Use singular namespaces. (#394)" - yiisoft/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( c65027...a39d50 )

by Wilmer

created 2022-11-22 12:32 UTC

LikeConditionBuilder::build() B

↳ Parent: LikeConditionBuilder

Complexity

Conditions	10
Paths	44

Size

Total Lines	43
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	25
dl	0
loc	43
rs	7.6666
c	0
b	0
f	0
cc	10
nc	44
nop	2

How to fix Complexity

<?php

declare(strict_types=1);

namespace Yiisoft\Db\QueryBuilder\Condition\Builder;

use Yiisoft\Db\Exception\Exception;
use Yiisoft\Db\Exception\InvalidArgumentException;
use Yiisoft\Db\Exception\InvalidConfigException;
use Yiisoft\Db\Exception\NotSupportedException;
use Yiisoft\Db\Expression\ExpressionBuilderInterface;
use Yiisoft\Db\Expression\ExpressionInterface;
use Yiisoft\Db\QueryBuilder\Condition\Interface\LikeConditionInterface;
use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;

use function implode;
use function is_array;
use function preg_match;
use function strtoupper;

/**
 * Class LikeConditionBuilder builds objects of {@see LikeCondition}.
 */
class LikeConditionBuilder implements ExpressionBuilderInterface
{
    public function __construct(
        private QueryBuilderInterface $queryBuilder,
        private string|null $escapeSql = null
    ) {
    }

    /**
     * @var array map of chars to their replacements in LIKE conditions. By default, it's configured to escape
     * `%`, `_` and `\` with `\`.
     */
    protected array $escapingReplacements = [
        '%' => '\%',
        '_' => '\_',
        '\\' => '\\\\',
    ];

    /**
     * @throws Exception|InvalidArgumentException|InvalidConfigException|NotSupportedException
     */
    public function build(LikeConditionInterface $expression, array &$params = []): string
    {
        $operator = strtoupper($expression->getOperator());
        $column = $expression->getColumn();
        $values = $expression->getValue();
        $escape = $expression->getEscapingReplacements();

        if ($escape === []) {
            $escape = $this->escapingReplacements;
        }

        [$andor, $not, $operator] = $this->parseOperator($operator);

        if (!is_array($values)) {
            $values = [$values];
        }

        if (empty($values)) {
            return $not ? '' : '0=1';
        }

        if ($column instanceof ExpressionInterface) {
            $column = $this->queryBuilder->buildExpression($column, $params);
        } elseif (!str_contains($column, '(')) {
            $column = $this->queryBuilder->quoter()->quoteColumnName($column);
        }

        $parts = [];

        /** @psalm-var string[] $values */
        foreach ($values as $value) {
            if ($value instanceof ExpressionInterface) {
                $phName = $this->queryBuilder->buildExpression($value, $params);
            } else {
                $phName = $this->queryBuilder->bindParam(
                    $escape === null ? $value : ('%' . strtr($value, $escape) . '%'),
                    $params
                );
            }
            $parts[] = "{$column} {$operator} {$phName}{$this->escapeSql}";
        }

        return implode($andor, $parts);
    }

    /**
     * @throws InvalidArgumentException
     *
     * @psalm-return array{0: string, 1: bool, 2: string}
     */
    protected function parseOperator(string $operator): array
    {
        if (!preg_match('/^(AND |OR |)((NOT |)I?LIKE)/', $operator, $matches)) {
            throw new InvalidArgumentException("Invalid operator in like condition: \"{$operator}\"");
        }

        $andor = ' ' . (!empty($matches[1]) ? $matches[1] : 'AND ');
        $not = !empty($matches[3]);
        $operator = $matches[2];

        return [$andor, $not, $operator];
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Yiisoft\Db\QueryBuilder\Condition\Builder;
6
7			use Yiisoft\Db\Exception\Exception;
8			use Yiisoft\Db\Exception\InvalidArgumentException;
9			use Yiisoft\Db\Exception\InvalidConfigException;
10			use Yiisoft\Db\Exception\NotSupportedException;
11			use Yiisoft\Db\Expression\ExpressionBuilderInterface;
12			use Yiisoft\Db\Expression\ExpressionInterface;
13			use Yiisoft\Db\QueryBuilder\Condition\Interface\LikeConditionInterface;
14			use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
15
16			use function implode;
17			use function is_array;
18			use function preg_match;
19			use function strtoupper;
20
21			/**
22			* Class LikeConditionBuilder builds objects of {@see LikeCondition}.
23			*/
24			class LikeConditionBuilder implements ExpressionBuilderInterface
25			{
26			public function __construct(
27			private QueryBuilderInterface $queryBuilder,
28			private string\|null $escapeSql = null
29			) {
30			}
31
32			/**
33			* @var array map of chars to their replacements in LIKE conditions. By default, it's configured to escape
34			* `%`, `_` and `\` with `\`.
35			*/
36			protected array $escapingReplacements = [
37			'%' => '\%',
38			'_' => '\_',
39			'\\' => '\\\\',
40			];
41
42			/**
43			* @throws Exception\|InvalidArgumentException\|InvalidConfigException\|NotSupportedException
44			*/
45			public function build(LikeConditionInterface $expression, array &$params = []): string
46			{
47			$operator = strtoupper($expression->getOperator());
48			$column = $expression->getColumn();
49			$values = $expression->getValue();
50			$escape = $expression->getEscapingReplacements();
51
52			if ($escape === []) {
53			$escape = $this->escapingReplacements;
54			}
55
56			[$andor, $not, $operator] = $this->parseOperator($operator);
57
58			if (!is_array($values)) {
59			$values = [$values];
60			}
61
62			if (empty($values)) {
63			return $not ? '' : '0=1';
64			}
65
66			if ($column instanceof ExpressionInterface) {
67			$column = $this->queryBuilder->buildExpression($column, $params);
68			} elseif (!str_contains($column, '(')) {
69			$column = $this->queryBuilder->quoter()->quoteColumnName($column);
70			}
71
72			$parts = [];
73
74			/** @psalm-var string[] $values */
75			foreach ($values as $value) {
76			if ($value instanceof ExpressionInterface) {
77			$phName = $this->queryBuilder->buildExpression($value, $params);
78			} else {
79			$phName = $this->queryBuilder->bindParam(
80			$escape === null ? $value : ('%' . strtr($value, $escape) . '%'),
81			$params
82			);
83			}
84			$parts[] = "{$column} {$operator} {$phName}{$this->escapeSql}";
85			}
86
87			return implode($andor, $parts);
88			}
89
90			/**
91			* @throws InvalidArgumentException
92			*
93			* @psalm-return array{0: string, 1: bool, 2: string}
94			*/
95			protected function parseOperator(string $operator): array
96			{
97			if (!preg_match('/^(AND \|OR \|)((NOT \|)I?LIKE)/', $operator, $matches)) {
98			throw new InvalidArgumentException("Invalid operator in like condition: \"{$operator}\"");
99			}
100
101			$andor = ' ' . (!empty($matches[1]) ? $matches[1] : 'AND ');
102			$not = !empty($matches[3]);
103			$operator = $matches[2];
104
105			return [$andor, $not, $operator];
106			}
107			}
108

yiisoft / db

Push — master ( c65027...a39d50 )

LikeConditionBuilder::build() B

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like