InConditionBuilder::buildCompositeInCondition() - Code Metrics - Inspection of "Fix composer.json." - yiisoft/db-mssql - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#15)

by Wilmer

created 2020-08-26 20:38 UTC

InConditionBuilder::buildCompositeInCondition() B

↳ Parent: InConditionBuilder

Complexity

Conditions	10
Paths	18

Size

Total Lines	23
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	10
eloc	15
c	1
b	0
f	0
nc	18
nop	4
dl	0
loc	23
rs	7.6666

How to fix Complexity

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Mssql\Condition;

use Traversable;
use Yiisoft\Db\Exception\Exception;
use Yiisoft\Db\Exception\InvalidConfigException;
use Yiisoft\Db\Exception\NotSupportedException;
use Yiisoft\Db\Query\Conditions\InConditionBuilder as AbstractInConditionBuilder;
use Yiisoft\Db\Query\Query;

use function implode;
use function is_array;
use function strpos;

final class InConditionBuilder extends AbstractInConditionBuilder
{
    /**
     * Builds SQL for IN condition.
     *
     * @param string $operator
     * @param array|string $columns
     * @param Query $values
     * @param array $params
     *
     * @return string SQL
     *
     * @throws NotSupportedException
     */
    protected function buildSubqueryInCondition(string $operator, $columns, Query $values, array &$params = []): string
    {
        if (is_array($columns)) {
            throw new NotSupportedException(__METHOD__ . ' is not supported by MSSQL.');
        }

        return parent::buildSubqueryInCondition($operator, $columns, $values, $params);
    }

    /**
     * Builds SQL for IN condition.
     *
     * @param string $operator
     * @param array|Traversable $columns
     * @param array $values
     * @param array $params
     *
     * @return string SQL
     *
     * @throws NotSupportedException
     * @throws Exception
     * @throws InvalidConfigException
     */
    protected function buildCompositeInCondition(?string $operator, $columns, $values, array &$params = []): string
    {
        $quotedColumns = [];
        foreach ($columns as $i => $column) {
            $quotedColumns[$i] = strpos($column, '(') === false
                ? $this->queryBuilder->getDb()->quoteColumnName($column) : $column;
        }

        $vss = [];
        foreach ($values as $value) {
            $vs = [];
            foreach ($columns as $i => $column) {
                if (isset($value[$column])) {
                    $phName = $this->queryBuilder->bindParam($value[$column], $params);
                    $vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' = ' : ' != ') . $phName;
                } else {
                    $vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' IS' : ' IS NOT') . ' NULL';
                }
            }
            $vss[] = '(' . implode($operator === 'IN' ? ' AND ' : ' OR ', $vs) . ')';
        }

        return '(' . implode($operator === 'IN' ? ' OR ' : ' AND ', $vss) . ')';
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Yiisoft\Db\Mssql\Condition;
6
7			use Traversable;
8			use Yiisoft\Db\Exception\Exception;
9			use Yiisoft\Db\Exception\InvalidConfigException;
10			use Yiisoft\Db\Exception\NotSupportedException;
11			use Yiisoft\Db\Query\Conditions\InConditionBuilder as AbstractInConditionBuilder;
12			use Yiisoft\Db\Query\Query;
13
14			use function implode;
15			use function is_array;
16			use function strpos;
17
18			final class InConditionBuilder extends AbstractInConditionBuilder
19			{
20			/**
21			* Builds SQL for IN condition.
22			*
23			* @param string $operator
24			* @param array\|string $columns
25			* @param Query $values
26			* @param array $params
27			*
28			* @return string SQL
29			*
30			* @throws NotSupportedException
31			*/
32			protected function buildSubqueryInCondition(string $operator, $columns, Query $values, array &$params = []): string
33			{
34			if (is_array($columns)) {
35			throw new NotSupportedException(__METHOD__ . ' is not supported by MSSQL.');
36			}
37
38			return parent::buildSubqueryInCondition($operator, $columns, $values, $params);
39			}
40
41			/**
42			* Builds SQL for IN condition.
43			*
44			* @param string $operator
45			* @param array\|Traversable $columns
46			* @param array $values
47			* @param array $params
48			*
49			* @return string SQL
50			*
51			* @throws NotSupportedException
52			* @throws Exception
53			* @throws InvalidConfigException
54			*/
55			protected function buildCompositeInCondition(?string $operator, $columns, $values, array &$params = []): string
56			{
57			$quotedColumns = [];
58			foreach ($columns as $i => $column) {
59			$quotedColumns[$i] = strpos($column, '(') === false
60			? $this->queryBuilder->getDb()->quoteColumnName($column) : $column;
61			}
62
63			$vss = [];
64			foreach ($values as $value) {
65			$vs = [];
66			foreach ($columns as $i => $column) {
67			if (isset($value[$column])) {
68			$phName = $this->queryBuilder->bindParam($value[$column], $params);
69			$vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' = ' : ' != ') . $phName;
70			} else {
71			$vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' IS' : ' IS NOT') . ' NULL';
72			}
73			}
74			$vss[] = '(' . implode($operator === 'IN' ? ' AND ' : ' OR ', $vs) . ')';
75			}
76
77			return '(' . implode($operator === 'IN' ? ' OR ' : ' AND ', $vss) . ')';
78			}
79			}
80

yiisoft / db-mssql

Pull Request — master (#15)

InConditionBuilder::buildCompositeInCondition() B

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like