CompileJsonContainsKey::compile() - Code Metrics - Inspection of "Add support for fetching from JSON columns" - cycle/database - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — 2.x (#135)

by Maxim

created 2023-10-23 13:01 UTC

CompileJsonContainsKey::compile() A

↳ Parent: CompileJsonContainsKey

Complexity

Conditions	3
Paths	4

Size

Total Lines	16
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	3
eloc	10
c	1
b	0
f	0
nc	4
nop	1
dl	0
loc	16
rs	9.9332

<?php

/**
 * This file is part of Cycle ORM package.
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

declare(strict_types=1);

namespace Cycle\Database\Driver\Postgres\Injection;

class CompileJsonContainsKey extends PostgresJsonExpression
{
    /**
     * @param non-empty-string $statement

     *
     * @return non-empty-string

     */
    protected function compile(string $statement): string
    {
        $wrappedPath = $this->getWrappedPath($statement);
        $attribute = \array_pop($wrappedPath);
        $path = $this->getField($statement);
        if ($wrappedPath !== []) {
            $path .= '->' . \implode('->', $wrappedPath);
        }

        if (!\filter_var($attribute, FILTER_VALIDATE_INT)) {
            return \sprintf('coalesce((%s)::jsonb ?? %s, false)', $path, $attribute);
        }

        return \vsprintf('CASE WHEN %s THEN %s ELSE false END', [
            \sprintf('jsonb_typeof((%s)::jsonb) = \'array\'', $path),
            \sprintf('jsonb_array_length((%s)::jsonb) >= %s', $path, $attribute + 1),
        ]);
    }
}


1			<?php
2
3			/**
4			* This file is part of Cycle ORM package.
5			*
6			* For the full copyright and license information, please view the LICENSE
7			* file that was distributed with this source code.
8			*/
9
10			declare(strict_types=1);
11
12			namespace Cycle\Database\Driver\Postgres\Injection;
13
14			class CompileJsonContainsKey extends PostgresJsonExpression
15			{
16			/**
17			* @param non-empty-string $statement
			0 ignored issues – show Documentation Bug introduced 2023-10-23 09:29 UTC by Report Bug Copy Issue Report The doc comment `non-empty-string` at position `0` could not be parsed: Unknown type name 'non-empty-string' at position 0 in non-empty-string. Loading history...
18			*
19			* @return non-empty-string
			0 ignored issues – show Documentation Bug introduced 2023-10-17 09:47 UTC by Report Bug Copy Issue Report The doc comment `non-empty-string` at position `0` could not be parsed: Unknown type name 'non-empty-string' at position 0 in non-empty-string. Loading history...
20			*/
21			protected function compile(string $statement): string
22			{
23			$wrappedPath = $this->getWrappedPath($statement);
24			$attribute = \array_pop($wrappedPath);
25			$path = $this->getField($statement);
26			if ($wrappedPath !== []) {
27			$path .= '->' . \implode('->', $wrappedPath);
28			}
29
30			if (!\filter_var($attribute, FILTER_VALIDATE_INT)) {
31			return \sprintf('coalesce((%s)::jsonb ?? %s, false)', $path, $attribute);
32			}
33
34			return \vsprintf('CASE WHEN %s THEN %s ELSE false END', [
35			\sprintf('jsonb_typeof((%s)::jsonb) = \'array\'', $path),
36			\sprintf('jsonb_array_length((%s)::jsonb) >= %s', $path, $attribute + 1),
37			]);
38			}
39			}
40

cycle / database

Pull Request — 2.x (#135)

CompileJsonContainsKey::compile() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like