DoctrineJsonFunctions
DoctrineJsonFunctions copied to clipboard
ScientaNL
Doctrine DQL functions for SQL JSON data type
## How to reproduce in the database field I store this JSON document ````json { "site": "2dbc9c35-bf39-433c-b596-6b08aa941bac", "bitrix24": 123456, "mobile_backend": "5624" } ```` In read model I try to fetch...
I noticed that `JSON_VALUE()` is available for MariaDB - according to the MySQL docs, it is already available in MySQL ( https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-value ) starting from `8.0.21`. Is it worth replicating...
This abandoned package: [https://packagist.org/packages/syslogic/doctrine-json-functions](https://packagist.org/packages/syslogic/doctrine-json-functions), which seems to be [https://packagist.org/packages/scienta/doctrine-json-functions](https://packagist.org/packages/scienta/doctrine-json-functions) now, prevents me from packaging [`syslogic/php-hms`](https://github.com/syslogic/php-hms); it's a vendor name `syslogic` conflict. Could you please suggest the above repository URL (this...
JSONB_CONTAINS is included in the codebase under the Postgres section, but isn't mentioned in the documentation. It appears to generate the correct SQL with the exception of not casting either...
it would really make a great DX (developer experience) if we would have some kind of DBAL for all this different json functions. this would be awesome. it can happen...
Test untested commit https://github.com/ScientaNL/DoctrineJsonFunctions/pull/58.
Phpunit is used to test a subset of functions. This must be expanded to include all the json functions available.
Mysql 8.0 is on it's way and a developer release is already available. This includes new JSON features. When mysql reaches GA these new statements need to be implemented: http://mysqlserverteam.com/mysql-8-0-labs-json-aggregation-functions/
