Doctrine Json Functions Laravel Package

What's Changed

• Fix #138 and use symfony/polyfill for overrides by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/139

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/6.4.0...6.5.0

What's Changed

• Add tests, documentation and workflow by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/128
• Added code-coverage for phpunit by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/129
• Fix coverage for master branch by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/131
• Expand tests and up the code-coverage by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/130
• Add integration-test coverage by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/132
• Up the integration-test code coverage by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/133
• Add mssql with json_value query and tests by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/134
• Tests json functions in where queries by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/135
• Clarify postgres wrong column type by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/136

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/6.3.0...6.4.0

What's Changed

• Add phpstan and fix some related issues by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/121
• Correctly rename MysqlMariadb shared node as such by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/123
• Added JSON_VALUE for mysql platform by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/122
• Make JSON_VALUE() RETURNING arg for mysql optional by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/124

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/6.2.0...6.3.0

What's Changed

• Compatibility with DBAL4 for MAriaDB functions by @Lustmored in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/120
• fix: typo in README by @victor-prdh in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/118

New Contributors

• @Lustmored made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/120
• @victor-prdh made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/118

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/6.1.0...6.2.0

What's Changed

• Suggest Composer command for installation by @mbrodala in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/110
• ci: migrate phpunit config (v10+) by @simPod in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/102
• update postgres function names in readme by @dbu in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/111
• Add unit tests for psql JsonbExists functions by @ttk in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/112
• Fix validatePlatform for MariaDB, check for instance of MariaDBPlatform by @annervisser in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/114

New Contributors

• @mbrodala made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/110
• @dbu made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/111
• @ttk made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/112
• @annervisser made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/114

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/6.0.0...6.1.0

BC-break: Require php 8.1 and higher

What's Changed

• Added psalm and phpcs checks by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/96
• Trigger ci on pull-request by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/99
• ci: add testing matrix by @simPod in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/98
• Prepare for 6.x releases and php ^8.1 by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/101
• Add Support for PostgreSQL jsonb_insert Function by @scottfalkingham in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/107
• Support ORM 3 to master by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/108
• Dbal4 by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/109

New Contributors

• @simPod made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/98
• @scottfalkingham made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/107

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/5.4.0...6.0.0

What's Changed

• Added psalm and phpcs checks by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/96
• Trigger ci on pull-request by @Hikariii in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/99
• ci: add testing matrix by @simPod in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/98
• Support ORM 3 by @derrabus in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/105

New Contributors

• @simPod made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/98
• @derrabus made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/105

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/5.4.0...5.5.0

What's Changed

• Fix doctrine/lexer deprecations by @norkunas in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/95

New Contributors

• @norkunas made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/95

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/5.3.0...5.4.0

What's Changed

• Use PostgreSQLPlatform instead of PostgreSQL94Platform by @SherinBloemendaal in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/89

New Contributors

• @SherinBloemendaal made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/89

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/5.2.0...5.3.0

What's Changed

• Add JsonArrayAgg and JsonObjectAgg by @willemverspyck in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/84

New Contributors

• @willemverspyck made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/84

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/5.1.0...5.2.0

What's Changed

• Implement missing MariaDB and update doc to indicate MySQL is compatible by @nyroDev in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/83

New Contributors

• @nyroDev made their first contribution in https://github.com/ScientaNL/DoctrineJsonFunctions/pull/83

Full Changelog: https://github.com/ScientaNL/DoctrineJsonFunctions/compare/5.0.0...5.1.0

BC break

• Update to Doctrine DBAL 3.* https://github.com/ScientaNL/DoctrineJsonFunctions/pull/76

• Updated Postgresql JsonGet: https://github.com/ScientaNL/DoctrineJsonFunctions/pull/72
• Updated README.md: https://github.com/ScientaNL/DoctrineJsonFunctions/pull/73
• Require correct doctrine/orm and doctrine/dbal versions (~2.*): https://github.com/ScientaNL/DoctrineJsonFunctions/pull/78

New JSON_OVERLAPS function for mysql added. See https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-overlaps

• Php8 compatibility
• Php7 and php8 testing
• Updated phpunit in composer.json to ^8.0 || ^9.0
• Updated doctrine dbal in composer.json to ^2.7

Added JSON_PRETTY: https://github.com/ScientaNL/DoctrineJsonFunctions/pull/66

• Merged #58 to accept value arguments for the the postgresql JSON_GET_TEXT function

• Fixed https://github.com/ScientaNL/DoctrineJsonFunctions/issues/48 and tested the postgresql JSON_GET_TEXT function

• fixed JSON_MERGE_PATCH tests
• Added SQLite functions

• Added test for double quote quirk of DQL: https://github.com/doctrine/orm/issues/5613
• Added readme for testing with docker and phpunit
• Added editorconfig for correct spacing

Bugfix #39 JSON_QUOTE accepts a value argument.

Added testcases for all mysql functions Renamed Syslogic\ namespace to Scienta\

Tested all mysql functions Also updated some argument types when StringPrimary was insufficient

• Functions restructured for better agument parsing
• Unit tests added (not everything tested yet)
• Dockerfiles added

Mariadb JSON_VALUE added

Readme updated to reflect new functions

• BC break: better Postgres function names:
  • GT renamed to JSON_GET
  • GT_GT renamed to JSON_GET_TEXT
• Added JSONB operators: ?, ?|, ?&, @>, <@
• Fixed issues with negative indices.
• Added support for parametrizing queries that use JSON functions.
• Fixed #17 which broke JSON_MERGE

Postgres function and className fixes Fixed https://github.com/SyslogicNL/DoctrineJsonFunctions/issues/15 which also broke the composer install.

Minor readme changes

After a lot more usage and testing the first minor bugs are resolved. It seemed time to release this version as a first stable, also because it is used in production by many people already.

If your software is being used in production, it should probably already be 1.0.0. If you have a stable API on which users have come to depend, you should be 1.0.0.

Thanks everyone for your contributions.