How to access grammar from query builder?

Question

I'm trying to convert a json column name with path 'foo->bar' to be compatible with mysql/postgresql using Laravel's wrapJsonSelector() method.

How can I access this method from the query builder calling getGrammar throws error:

Method Illuminate\Database\Query\Grammars\MySqlGrammar::isJsonSelector does not exist.

Eg

$query->where(function (Builder $query) use ($searchColumn): Builder {
    if ($query->getGrammar()->isJsonSelector($searchColumn)) {
        $searchColumn = $query->getGrammar()->wrapJsonSelector($searchColumn);
    }
    // ...
})

"How can I access this method" It's protected, so you can't. — Olivier
– Olivier, Commented Oct 13, 2023 at 20:09
Gosh I hadn't realised that usually get a different error. Is there a way of opening it up via a macro? — John Magnolia
– John Magnolia, Commented Oct 13, 2023 at 21:11

dumbass · Accepted Answer · 2023-10-14 13:00:28Z

1

+300

isJsonSelector and wrapJsonSelector are protected methods, which means you cannot access them from outside the class. However, you don’t need to invoke either of them directly in the first place. You can just use the wrap method, which will invoke wrapJsonSelector in the case you want to cover here.

edited Oct 14, 2023 at 13:00

answered Oct 14, 2023 at 10:06

dumbass

27.2k4 gold badges42 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cetver · Accepted Answer · 2023-10-16 06:24:06Z

1

The wrapJsonSelector method is not accessible (protected), but it is called in the wrap method.

$expression = $query->getGrammar()->wrap("table.column->?"); // "table"."column"->>'?'
$query->whereRaw($expression, ['value']);

answered Oct 16, 2023 at 6:24

cetver

11.9k6 gold badges42 silver badges59 bronze badges

Comments

Jamie Burton · Accepted Answer · 2023-10-09 12:39:49Z

0

DB::table('your_table')
->selectRaw('your_json_column->"$.foo->bar" as modified_column')
->get();

The selectRaw method allows you to write raw SQL expressions within your query.

answered Oct 9, 2023 at 12:39

Jamie Burton

5152 silver badges7 bronze badges

1 Comment

John Magnolia Over a year ago

Not looking to do this manually due to needing to support MySQL and Postgresql reason for wanting to access wrapJsonSelector where Laravel handles json_unquote & json_extract

Collectives™ on Stack Overflow

How to access grammar from query builder?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related