JsonExpressionBuilder::build() - Code Metrics - Inspection of "Check and fix all todo in code (#131)" - yiisoft/db-mysql - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 1f4c93...dcd4be )

by Alexander

created 2022-06-19 16:23 UTC

JsonExpressionBuilder::build() A

↳ Parent: JsonExpressionBuilder

Complexity

Conditions	2
Paths	2

Size

Total Lines	18
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	2

Importance

Changes

Metric	Value
cc	2
eloc	7
c	0
b	0
f	0
nc	2
nop	2
dl	0
loc	18
ccs	8
cts	8
cp	1
crap	2
rs	10

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Mysql\Builder;

use JsonException;
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\Expression\JsonExpression;
use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
use Yiisoft\Db\Query\QueryInterface;
use Yiisoft\Json\Json;

use function count;

/**
 * The class JsonExpressionBuilder builds {@see JsonExpression} for Mysql database.
 */
final class JsonExpressionBuilder implements ExpressionBuilderInterface
{
    public const PARAM_PREFIX = ':qp';

    public function __construct(private QueryBuilderInterface $queryBuilder)
    {
    }

    /**
     * @throws Exception|InvalidArgumentException|InvalidConfigException|JsonException|NotSupportedException
     */
    public function build(ExpressionInterface $expression, array &$params = []): string
    {
        /**
         * @var JsonExpression $expression
         * @var mixed|QueryInterface $value
         */
        $value = $expression->getValue();

        if ($value instanceof QueryInterface) {
            [$sql, $params] = $this->queryBuilder->build($value, $params);

            return "($sql)";
        }

        $placeholder = self::PARAM_PREFIX . count($params);
        $params[$placeholder] = Json::encode($value);

        return "CAST($placeholder AS JSON)";
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Yiisoft\Db\Mysql\Builder;
6
7		use JsonException;
8		use Yiisoft\Db\Exception\Exception;
9		use Yiisoft\Db\Exception\InvalidArgumentException;
10		use Yiisoft\Db\Exception\InvalidConfigException;
11		use Yiisoft\Db\Exception\NotSupportedException;
12		use Yiisoft\Db\Expression\ExpressionBuilderInterface;
13		use Yiisoft\Db\Expression\ExpressionInterface;
14		use Yiisoft\Db\Expression\JsonExpression;
15		use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
16		use Yiisoft\Db\Query\QueryInterface;
17		use Yiisoft\Json\Json;
18
19		use function count;
20
21		/**
22		* The class JsonExpressionBuilder builds {@see JsonExpression} for Mysql database.
23		*/
24		final class JsonExpressionBuilder implements ExpressionBuilderInterface
25		{
26		public const PARAM_PREFIX = ':qp';
27
28	11	public function __construct(private QueryBuilderInterface $queryBuilder)
29		{
30		}
31
32		/**
33		* @throws Exception\|InvalidArgumentException\|InvalidConfigException\|JsonException\|NotSupportedException
34		*/
35	11	public function build(ExpressionInterface $expression, array &$params = []): string
36		{
37		/**
38		* @var JsonExpression $expression
39		* @var mixed\|QueryInterface $value
40		*/
41	11	$value = $expression->getValue();
42
43	11	if ($value instanceof QueryInterface) {
44	2	[$sql, $params] = $this->queryBuilder->build($value, $params);
45
46	2	return "($sql)";
47		}
48
49	9	$placeholder = self::PARAM_PREFIX . count($params);
50	9	$params[$placeholder] = Json::encode($value);
51
52	9	return "CAST($placeholder AS JSON)";
53		}
54		}
55

yiisoft / db-mysql

Push — master ( 1f4c93...dcd4be )

JsonExpressionBuilder::build() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like