0 follower

Final Class Yiisoft\Db\Sqlite\Builder\JsonOverlapsBuilder

All Classes | Methods

Inheritance	Yiisoft\Db\Sqlite\Builder\JsonOverlapsBuilder
Implements	Yiisoft\Db\Expression\ExpressionBuilderInterface

Builds expressions for {@see JsonOverlapsCondition} for SQLite Server.

Public Methods

Hide inherited methods

Method	Description	Defined By
__construct()		Yiisoft\Db\Sqlite\Builder\JsonOverlapsBuilder
build()	Build SQL for {@see JsonOverlaps}.	Yiisoft\Db\Sqlite\Builder\JsonOverlapsBuilder

Method Details

Hide inherited methods

__construct() public method

public mixed __construct ( \Yiisoft\Db\QueryBuilder\QueryBuilderInterface $queryBuilder )
$queryBuilder	\Yiisoft\Db\QueryBuilder\QueryBuilderInterface

Source code

                public function __construct(
    private readonly QueryBuilderInterface $queryBuilder,
) {}

build() public method

Build SQL for {@see JsonOverlaps}.

public string build ( \Yiisoft\Db\QueryBuilder\Condition\JsonOverlaps $expression, array &$params = [] )
$expression	\Yiisoft\Db\QueryBuilder\Condition\JsonOverlaps	The {@see \Yiisoft\Db\QueryBuilder\Condition\JsonOverlaps} to be built.
$params	array
throws	\Yiisoft\Db\Exception\Exception
throws	InvalidArgumentException
throws	\Yiisoft\Db\Exception\InvalidConfigException
throws	\Yiisoft\Db\Exception\NotSupportedException

Source code

                public function build(ExpressionInterface $expression, array &$params = []): string
{
    $column = $expression->column instanceof ExpressionInterface
        ? $this->queryBuilder->buildExpression($expression->column)
        : $this->queryBuilder->getQuoter()->quoteColumnName($expression->column);
    $values = $expression->values;
    if (!$values instanceof ExpressionInterface) {
        $values = new JsonValue($values);
    }
    $values = $this->queryBuilder->buildExpression($values, $params);
    return "EXISTS(SELECT value FROM json_each($column) INTERSECT SELECT value FROM json_each($values))=1";
}