Cycle\Database\Driver\MySQL\Query\Traits\WhereJsonTrait

Complexity

Total Complexity

16

Size/Duplication

Total Lines	182
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	whereJsonContains()	0	10	2
A	orWhereJsonContains()	0	10	2
A	whereJson()	0	10	1
A	andWhereJson()	0	3	1
A	orWhereJson()	0	10	1
A	andWhereJsonLength()	0	3	1
A	orWhereJsonDoesntContain()	0	10	2
A	andWhereJsonContains()	0	3	1
A	orWhereJsonLength()	0	10	1
A	whereJsonLength()	0	10	1
A	andWhereJsonDoesntContain()	0	3	1
A	whereJsonDoesntContain()	0	10	2

<?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\CompileJsonDoesntContain;
use Cycle\Database\Driver\MySQL\Injection\CompileJsonLength;

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

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.

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

It seems like registerToken() must be provided by classes using this trait. How about adding it as abstract method to this trait?

            'AND',
            [new CompileJson($column), $value],
            $this->whereTokens,
            $this->whereWrapper()

It seems like whereWrapper() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        );

        return $this;
    }

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

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.

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

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

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.

     *
     * @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

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.

     *
     * @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

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.

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

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

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.

     *
     * @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

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.

     *
     * @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

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.

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

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

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.

     *
     * @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

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.

     * @param 0|positive-int $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

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.

     * @param 0|positive-int $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

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.

     * @param 0|positive-int $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;
    }
}