Cycle\Database\Driver\SQLServer\Injection\CompileJsonContainsKey::compile()

Complexity

Conditions	2
Paths	2

Size

Total Lines	21
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    protected function compile(string $statement): string
    {
        $path = \explode('->', $statement);
        $key = $this->parseJsonPathArrayKeys(\array_pop($path));

        if (\count($key) === 1) {
            return \sprintf(
                '\'%s\' IN (SELECT [key] FROM openjson(%s%s))',
                \array_shift($key),
                $this->getField($statement),
                $this->getPath(\implode('->', $path))
            );
        }

        $path[] = \array_shift($key);

        return \sprintf(
            '%s IN (SELECT [key] FROM openjson(%s%s))',
            \array_pop($key),
            $this->getField($statement),
            $this->getPath(\implode('->', $path))
        );