Jackalope Doctrine Dbal Laravel Package

• Allow installation with Symfony 8.
• Test with PHP 8.5.

• Fixed cache key sanitize for UUID map of referenceable nodes.

• Fixed cache key sanitize for UUID map of referenceable nodes.

• Fixed cache key sanitize for PSR-16 cache.
• Fixed not found detection for PSR-16 cache.

• Fixed cache key sanitize for PSR-16 cache.
• Fixed not found detection for PSR-16 cache.

• Added static typing wherever possible. This should not change anything, but the added strictness. might trigger errors where it was more tolerant for incorrect types before.
• Renamed cli-config.php.dist to cli-config.dist.php and cleaned up to be better documented.
• [BC Break]: CachedClient now expects a PSR-16 cache rather than the abandoned doctrine/cache. When instantiating the client, you need to provide at least the cache instance for metadata, as CachedClient does not know which implementation to pick.
• Support for new Symfony versions.
• Support for doctrine/dbal 4.
• For MySQL/MariaDB, it is now required to configure defaultTableOptions.collate or charset in the Doctrine connection, or alternatively set the encoding explicitly with Client::setCaseSensitiveEncoding() (e.g. utf8mb4_bin).
• If you are on PHP 8.0 and install Jackalope with symfony/cache, you need to restrict psr/simple-cache to ^1.0 || ^2.0 in your application because Symfony 5 does not declare a conflict with it, but fails at runtime.
• Drop support for PHP 7.
• Fixed: While it is allowed to call Repository::login with null credentials, there used to be an error. It now correctly works. If you use jcr:createdBy or jcr:lastModifiedBy in node types, those properties are not set if the credentials are null.
• Improving the performance of deleteProperties (#421)
• Deleting dangling binary references when a property is removed or the whole node with a binary property is deleted (#426) - See UPGRADE.md for the recommended database changes.
• Allow installation with Symfony 7.

• Added: Factory now accepts an optional parameter jackalope.case_sensitive_encoding to set Client::setCaseSensitiveEncoding.
• Bugfix: Factory now actually accepts the optional parameter jackalope.uuid_generator

Changes since 2.0.0-beta3

• Allow dbal 4
• Require charset or collation to be configured on the dbal connection

• Fix: Sanitize cache key of entries with workspace name.

• Allow installation with Symfony 7.
• Changes from 1.x since 2.0.0-beta2

• Fix regression of 1.11.0: Reference deletion should work regardless of upper or lowercase of the type names in XML data.

• Improve delete properties performance by replace DOMDocument with xml_parse.

• Bugfix: Correctly handle cache fetches in CachedClient BC layer.

• Support for new Symfony versions.
• If you are on PHP 8.0 and install Jackalope with symfony/cache, you need to restrict psr/simple-cache to ^1.0 || ^2.0 in your application because Symfony 5 does not declare a conflict with it, but fails at runtime.
• Drop support for PHP 7.
• Fixed: While it is allowed to call Repository::login with null credentials, there used to be an error. It now correctly works. If you use jcr:createdBy or jcr:lastModifiedBy in node types, those properties are not set if the credentials are null.
• Improving the performance of deleteProperties (#421)
• Deleting dangling binary references when a property is removed or the whole node with a binary property is deleted (#426) - See UPGRADE.md for the recommended database changes.

• CachedClient also supports PSR-16 simple cache instances instead of the doctrine cache. Support for doctrine/cache will be removed in version 2.

• Added static typing wherever possible. This should not change anything, but the added strictness might trigger errors where it was more tolerant for incorrect types before.
• Renamed cli-config.php.dist to cli-config.dist.php and cleaned up to be better documented.
• [BC Break]: CachedClient now expects a PSR-16 cache rather than the abandoned doctrine/cache. When instantiating the client, you need to provide at least the cache instance for metadata, as CachedClient does not know which implementation to pick.
• If you are on PHP 8.0 and install Jackalope with symfony/cache, you need to restrict psr/simple-cache to ^1.0 || ^2.0 in your application because Symfony 5 does not declare a conflict with it, but fails at runtime.
• Drop support for PHP 7.
• Fixed: While it is allowed to call Repository::login with null credentials, there used to be an error. It now correctly works. If you use jcr:createdBy or jcr:lastModifiedBy in node types, those properties are not set if the credentials are null.
• Improving the performance of deleteProperties (#421)
• Deleting dangling binary references when a property is removed or the whole node with a binary property is deleted (#426) - See UPGRADE.md for the recommended database changes.

• Allow installation with doctrine/cache 2.*. Cache 1.* is EOL. If you use doctrine/cache 2, you need a PSR implementation, e.g. symfony/cache, and need to pass a cache instance to the CachedClient.

• Bugfix: Use single quotes for SQL queries. Double quotes are not part of ANSI SQL.

• Automatically add the portability middleware to lowercase all fields when using Oracle.

• Fix to correctly handle SQLite connections when middleware is used by dbal.

• Fix an edge case with postgres when searching for a node name with a double quote " in the search expression. Note that with MySQL, searching for a node name with double quote no longer works due to wrong XPath handling in MySQL.

• Fix SQL injection in SQL2 queries: Escape xpaths in queries. See security advisory
• Test with PHP 8.1

• Improve performance for deleting properties of nodes by using xpath. #390

• Allow installation with PHP 7.2
• Limit to doctrine/cache 1 as the code relies on code that was removed in doctrine/cache 2.

• Fixed DBAL 3 compatibility bug.

• Improve performance for xml parsing by using the PHP ext-xml instead of ext-dom.

  Jackalope\Transport\DoctrineDBALClient::mapPropertyFromElement is no longer called within the client. If you extended the client and call the method, things will still work as before, but it is recommended to refactor your code to use the XmlToPropsParser.

  If you overwrote the method behaviour, your changes will no longer be applied because the method is not called anymore. We are not aware of any use case to overwrite the method - if you are affected, let us know in a github issue so that we can discuss how the problem can be fixed.

• Fixed query cache to not treat 0 or null as cache misses.

• Support PHP 8 and Doctrine DBAL 3
• Dropped support for PHP < 7.3

• Early return in getNodeReferences if system id for path is not found.

Fixed

• add primary keys to all tables (https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html#tables-without-primary-keys)