search

martin-georgiev / postgresql-for-doctrine

PostgreSQL enhancements for Doctrine. Provides support for advanced data types (json, jssnb, arrays), text search, array operators and jsonb specific functions.
https://packagist.org/packages/martin-georgiev/postgresql-for-doctrine
MIT License
343 stars 40 forks source link

Add support for JSONB operators `?`, `?|`, `?&`, `@?` and `#-` #170

Closed martin-georgiev closed 6 months ago

martin-georgiev commented 6 months ago

Add support for some missing JSONB operators.

Register for DQL as Implemented by
? RIGHT_EXISTS_ON_LEFT MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\TheRightExistsOnTheLeft
?& ALL_ON_RIGHT_EXIST_ON_LEFT MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\AllOnTheRightExistOnTheLeft
?| ANY_ON_RIGHT_EXISTS_ON_LEFT MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\AnyOnTheRightExistsOnTheLeft
@? RETURNS_VALUE_FOR_JSON_VALUE MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\ReturnsValueForJsonValue
#- DELETE_AT_PATH MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\DeleteAtPath