LikeConditionBuilder::build() - Code Metrics - yiisoft/db-oracle - Measure and Improve Code Quality continuously with Scrutinizer

LikeConditionBuilder::build() A
last analyzed 2024-04-27 02:31 UTC

↳ Parent: LikeConditionBuilder

Complexity

Conditions	2
Paths	2

Size

Total Lines	11
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	4
CRAP Score	2

Importance

Changes

Metric	Value
cc	2
eloc	3
nc	2
nop	2
dl	0
loc	11
ccs	4
cts	4
cp	1
crap	2
rs	10
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Oracle\Builder;

use Exception;
use Yiisoft\Db\QueryBuilder\Condition\Interface\LikeConditionInterface;
use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
use Yiisoft\Db\Schema\Quoter;

use function substr;

/**
 * Build an object of {@see `\Yiisoft\Db\QueryBuilder\Condition\LikeCondition`} into SQL expressions for Oracle Server.
 */
final class LikeConditionBuilder extends \Yiisoft\Db\QueryBuilder\Condition\Builder\LikeConditionBuilder
{
    private string $escapeCharacter = '!';

    /**
     * `\` is initialized in {@see buildLikeCondition()} method since there is a need to choose replacement value
     * based on {@see Quoter::quoteValue()}.
     */
    protected array $escapingReplacements = [
        '%' => '!%',
        '_' => '!_',
        '!' => '!!',
    ];

    public function __construct(private QueryBuilderInterface $queryBuilder)
    {
        parent::__construct($queryBuilder, $this->getEscapeSql());
    }

    /**
     * @throws Exception
     */
    public function build(LikeConditionInterface $expression, array &$params = []): string
    {
        if (!isset($this->escapingReplacements['\\'])) {
            /*
             * Different pdo_oci8 versions may or may not implement `PDO::quote()`, so {@see Quoter::quoteValue()} may or
             * may not quote `\`.
             */
            $this->escapingReplacements['\\'] = substr((string) $this->queryBuilder->quoter()->quoteValue('\\'), 1, -1);
        }

        return parent::build($expression, $params);
    }

    /**
     * @return string Character used to escape special characters in `LIKE` conditions. By default, it's assumed to be
     * `!`.
     */
    private function getEscapeSql(): string
    {
        return $this->escapeCharacter !== '' ? " ESCAPE '$this->escapeCharacter'" : '';
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Yiisoft\Db\Oracle\Builder;
6
7		use Exception;
8		use Yiisoft\Db\QueryBuilder\Condition\Interface\LikeConditionInterface;
9		use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
10		use Yiisoft\Db\Schema\Quoter;
11
12		use function substr;
13
14		/**
15		* Build an object of {@see `\Yiisoft\Db\QueryBuilder\Condition\LikeCondition`} into SQL expressions for Oracle Server.
16		*/
17		final class LikeConditionBuilder extends \Yiisoft\Db\QueryBuilder\Condition\Builder\LikeConditionBuilder
18		{
19		private string $escapeCharacter = '!';
20
21		/**
22		* `\` is initialized in {@see buildLikeCondition()} method since there is a need to choose replacement value
23		* based on {@see Quoter::quoteValue()}.
24		*/
25		protected array $escapingReplacements = [
26		'%' => '!%',
27		'_' => '!_',
28		'!' => '!!',
29		];
30
31	33	public function __construct(private QueryBuilderInterface $queryBuilder)
32		{
33	33	parent::__construct($queryBuilder, $this->getEscapeSql());
34		}
35
36		/**
37		* @throws Exception
38		*/
39	33	public function build(LikeConditionInterface $expression, array &$params = []): string
40		{
41	33	if (!isset($this->escapingReplacements['\\'])) {
42		/*
43		* Different pdo_oci8 versions may or may not implement `PDO::quote()`, so {@see Quoter::quoteValue()} may or
44		* may not quote `\`.
45		*/
46	33	$this->escapingReplacements['\\'] = substr((string) $this->queryBuilder->quoter()->quoteValue('\\'), 1, -1);
47		}
48
49	33	return parent::build($expression, $params);
50		}
51
52		/**
53		* @return string Character used to escape special characters in `LIKE` conditions. By default, it's assumed to be
54		* `!`.
55		*/
56	33	private function getEscapeSql(): string
57		{
58	33	return $this->escapeCharacter !== '' ? " ESCAPE '$this->escapeCharacter'" : '';
59		}
60		}
61

yiisoft / db-oracle

LikeConditionBuilder::build() A last analyzed 2024-04-27 02:31 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

LikeConditionBuilder::build() A
last analyzed 2024-04-27 02:31 UTC