WhereJsonTrait::whereJsonContainsKey() - 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 Aleksei
created 2023-10-23 17:02 UTC
WhereJsonTrait::whereJsonContainsKey() A

↳ Parent: WhereJsonTrait
Complexity

Conditions	1
Paths	1
Size

Total Lines	10
Code Lines	6
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	6
c	0
b	0
f	0
nc	1
nop	1
dl	0
loc	10
rs	10
<?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\MySQL\Query\Traits;

use Cycle\Database\Driver\MySQL\Injection\CompileJson;
use Cycle\Database\Driver\MySQL\Injection\CompileJsonContains;
use Cycle\Database\Driver\MySQL\Injection\CompileJsonContainsKey;
use Cycle\Database\Driver\MySQL\Injection\CompileJsonDoesntContain;
use Cycle\Database\Driver\MySQL\Injection\CompileJsonDoesntContainKey;
use Cycle\Database\Driver\MySQL\Injection\CompileJsonLength;

/**
 * @internal
 */
trait WhereJsonTrait
{
    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function whereJson(string $column, mixed $value): self
    {
        $this->registerToken(
               registerToken(
            'AND',
            [new CompileJson($column), $value],
            $this->whereTokens,
            $this->whereWrapper()
                   whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function andWhereJson(string $column, mixed $value): self
    {
        return $this->whereJson($column, $value);
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function orWhereJson(string $column, mixed $value): self
    {
        $this->registerToken(
            'OR',
            [new CompileJson($column), $value],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function whereJsonContains(string $column, mixed $value): self
    {
        $this->registerToken(
            'AND',
            [new CompileJsonContains($column, json_validate($value) ? $value : \json_encode($value))],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function andWhereJsonContains(string $column, mixed $value): self
    {
        return $this->whereJsonContains($column, $value);
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function orWhereJsonContains(string $column, mixed $value): self
    {
        $this->registerToken(
            'OR',
            [new CompileJsonContains($column, json_validate($value) ? $value : \json_encode($value))],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function whereJsonDoesntContain(string $column, mixed $value): self
    {
        $this->registerToken(
            'AND',
            [new CompileJsonDoesntContain($column, json_validate($value) ? $value : \json_encode($value))],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function andWhereJsonDoesntContain(string $column, mixed $value): self
    {
        return $this->whereJsonDoesntContain($column, $value);
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function orWhereJsonDoesntContain(string $column, mixed $value): self
    {
        $this->registerToken(
            'OR',
            [new CompileJsonDoesntContain($column, json_validate($value) ? $value : \json_encode($value))],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function whereJsonContainsKey(string $column): self
    {
        $this->registerToken(
            'AND',
            [new CompileJsonContainsKey($column)],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function andWhereJsonContainsKey(string $column): self
    {
        return $this->whereJsonContainsKey($column);
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function orWhereJsonContainsKey(string $column): self
    {
        $this->registerToken(
            'OR',
            [new CompileJsonContainsKey($column)],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function whereJsonDoesntContainKey(string $column): self
    {
        $this->registerToken(
            'AND',
            [new CompileJsonDoesntContainKey($column)],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function andWhereJsonDoesntContainKey(string $column): self
    {
        return $this->whereJsonDoesntContainKey($column);
    }

    /**
     * @param non-empty-string $column

     *
     * @return $this|self
     */
    public function orWhereJsonDoesntContainKey(string $column): self
    {
        $this->registerToken(
            'OR',
            [new CompileJsonDoesntContainKey($column)],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     * @param int<0, max> $length
     * @param non-empty-string $operator
     *
     * @return $this|self
     */
    public function whereJsonLength(string $column, int $length, string $operator = '='): self
    {
        $this->registerToken(
            'AND',
            [new CompileJsonLength($column, $length, $operator)],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }

    /**
     * @param non-empty-string $column

     * @param int<0, max> $length
     * @param non-empty-string $operator
     *
     * @return $this|self
     */
    public function andWhereJsonLength(string $column, int $length, string $operator = '='): self
    {
        return $this->whereJsonLength($column, $length, $operator);
    }

    /**
     * @param non-empty-string $column

     * @param int<0, max> $length
     * @param non-empty-string $operator
     *
     * @return $this|self
     */
    public function orWhereJsonLength(string $column, int $length, string $operator = '='): self
    {
        $this->registerToken(
            'OR',
            [new CompileJsonLength($column, $length, $operator)],
            $this->whereTokens,
            $this->whereWrapper()
        );

        return $this;
    }
}

cycle / database

Pull Request — 2.x (#135)

WhereJsonTrait::whereJsonContainsKey() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
