staudenmeir / eloquent-json-relations

src/Grammars/Traits/CompilesMySqlJsonQueries.php

<?php

namespace Staudenmeir\EloquentJsonRelations\Grammars\Traits;

use Illuminate\Contracts\Database\Query\Expression;
use Illuminate\Database\ConnectionInterface;

trait CompilesMySqlJsonQueries
{
    /**
     * Compile a "JSON array" statement into SQL.
     *
     * @param string $column
     * @return string
     */
    public function compileJsonArray($column)
    {
        return 'json_array('.$this->wrap($column).')';

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

    }

    /**
     * Compile a "JSON object" statement into SQL.
     *
     * @param string $column
     * @param int $levels
     * @return string
     */
    public function compileJsonObject($column, $levels)
    {
        return str_repeat('json_object(?, ', $levels)
            .$this->wrap($column)
            .str_repeat(')', $levels);
    }

    /**
     * Compile a "JSON value select" statement into SQL.
     *
     * @param string $column
     * @return string
     */
    public function compileJsonValueSelect(string $column): string
    {
        return $this->wrap($column);
    }

    /**
     * Determine whether the database supports the "member of" operator.
     *
     * @param \Illuminate\Database\ConnectionInterface $connection
     * @return bool
     */
    public function supportsMemberOf(ConnectionInterface $connection): bool
    {
        if ($connection->isMaria()) {
            return false;
        }

        return version_compare($connection->getServerVersion(), '8.0.17') >= 0;
    }

    /**
     * Compile a "member of" statement into SQL.
     *
     * @param string $column
     * @param mixed $value
     * @return string
     */
    public function compileMemberOf(string $column, ?string $objectKey, mixed $value): string
    {
        $columnWithKey = $objectKey ? $column . (str_contains($column, '->') ? '[*]' : '') . "->$objectKey" : $column;

        [$field, $path] = $this->wrapJsonFieldAndPath($columnWithKey);

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

        if ($objectKey && !str_contains($column, '->')) {
            $path = ", '$[*]" . substr($path, 4);
        }

        $sql = $path ? "json_extract($field$path)" : $field;

        if ($value instanceof Expression) {
            return $value->getValue($this) . " member of($sql)";

$this of type Staudenmeir\EloquentJsonRelations\Grammars\Traits\CompilesMySqlJsonQueries is incompatible with the type Illuminate\Database\Grammar expected by parameter $grammar of Illuminate\Database\Query\Expression::getValue().

        }

        return "? member of($sql)";
    }

    /**
     * Prepare the bindings for a "member of" statement.
     *
     * @param mixed $value
     * @return array
     */
    public function prepareBindingsForMemberOf(mixed $value): array
    {
        return $value instanceof Expression ? [] : [$value];
    }
}