Aura.Sql

What's Changed

• Add failing test for #183 by @harikt in https://github.com/auraphp/Aura.Sql/pull/210
• sqlite parser update by @harikt in https://github.com/auraphp/Aura.Sql/pull/212
• Enable PHP 8.2 compat by @koriym in https://github.com/auraphp/Aura.Sql/pull/218
• Fix missing properties by @koriym in https://github.com/auraphp/Aura.Sql/pull/219
• Allow using psr/log v3 by @Qrzysio in https://github.com/auraphp/Aura.Sql/pull/223
• Fix illegal space (0xE38080) in composer.json by @koriym in https://github.com/auraphp/Aura.Sql/pull/224

New Contributors

• @Qrzysio made their first contribution in https://github.com/auraphp/Aura.Sql/pull/223

Full Changelog: https://github.com/auraphp/Aura.Sql/compare/5.0.1...5.0.2

• Continous Integration Improvements via #184, #197 by @koriym
• PHP 8.x support via #185, #209, #214 by @koriym, @harikt
• Support psr/log v1 and v2 via #191 by @r4ndsen
• Fixed #183 (Bug in sqlite query parser to support : in column name) via #203, #211 by @r4ndsen, @harikt

• Fix broken return types #204 by @r4ndsen
• Fix scrutinizer.yml #206 by @harikt

Version 5.x supports PHP 8.1 and up.

What's Changed

• remove unused param in queryparser by @r4ndsen in https://github.com/auraphp/Aura.Sql/pull/180
• PHP 8 Support by @koriym in https://github.com/auraphp/Aura.Sql/pull/185
• allow psr/log v2 by @r4ndsen in https://github.com/auraphp/Aura.Sql/pull/191
• Compatibility with PHP 8.1 by @srjlewis in https://github.com/auraphp/Aura.Sql/pull/193
• Update PHPDoc by @kenjis in https://github.com/auraphp/Aura.Sql/pull/196
• Migrate Travis to GitHub Actions by @koriym in https://github.com/auraphp/Aura.Sql/pull/197
• Update GitHub Actions for 5.x by @kenjis in https://github.com/auraphp/Aura.Sql/pull/198
• docs: update README for 5.x by @kenjis in https://github.com/auraphp/Aura.Sql/pull/200

New Contributors

• @r4ndsen made their first contribution in https://github.com/auraphp/Aura.Sql/pull/180
• @srjlewis made their first contribution in https://github.com/auraphp/Aura.Sql/pull/193
• @kenjis made their first contribution in https://github.com/auraphp/Aura.Sql/pull/196

Full Changelog: https://github.com/auraphp/Aura.Sql/compare/3.0.0...5.0.0

Version 4.x supports PHP 7.2 and up.

What's Changed

• Add 7.2, 7.3 and 7.4 to test targets by @koriym in https://github.com/auraphp/Aura.Sql/pull/184
• remove unused param in queryparser by @r4ndsen in https://github.com/auraphp/Aura.Sql/pull/180
• PHP 8 Support by @koriym in https://github.com/auraphp/Aura.Sql/pull/185
• allow psr/log v2 by @r4ndsen in https://github.com/auraphp/Aura.Sql/pull/191
• Compatibility with PHP 8.1 by @srjlewis in https://github.com/auraphp/Aura.Sql/pull/193
• Update PHPDoc by @kenjis in https://github.com/auraphp/Aura.Sql/pull/196
• Migrate Travis to GitHub Actions by @koriym in https://github.com/auraphp/Aura.Sql/pull/197
• Update GitHub Actions for 5.x by @kenjis in https://github.com/auraphp/Aura.Sql/pull/198
• Enable PHP 7.2-8.1 compat by @iansltx in https://github.com/auraphp/Aura.Sql/pull/202

New Contributors

• @r4ndsen made their first contribution in https://github.com/auraphp/Aura.Sql/pull/180
• @srjlewis made their first contribution in https://github.com/auraphp/Aura.Sql/pull/193

Full Changelog: https://github.com/auraphp/Aura.Sql/compare/3.0.0...4.0.0

This release adds two new off-interface methods to ConnectionLocator:

• setProfiling() to activate profiling across all connections

• getProfiles() to get the profiles from all connections

• ExtendedPdo::bindValue() method now binds PDO::PARAM_BOOL values as string '0' and string '1'; this addresses a not-a-bug-but-still-surprising behavior in PDO; cf. https://bugs.php.net/bug.php?id=49255.

• Other hygiene fixes to docs, docblocks, etc.

• Fixed issue #163: Add getAttribute and setAttribute functions to make sure pdo is connected before calling the functions

• Merged pull request #170: fixes error "Class 'Aura\Sql\PDO' not found"

• Merged pull request #174: fixes bug with null value.

• Fix #111 : Binding variables conflicts with some Postgres SQL queries
• Added phpunit to composer.json
• Fix #166 : PHPStorm exception handling check

First beta release.

• Updated documentation, and added a Bookdown JSON file.

• The sqlsrv driver now defaults to exceptions like all other drivers.

First alpha release.

Hygiene release: update documentation and testing.

This release adds new yield*() methods to ExtendedPdo; these return
iterators to generate one result row at a time, which can reduce memory usage
with very large result sets.

This release modifies the testing structure and updates other support files.

This is a hygiene release to update support files.

• FIX: #96: Allow first bind value of query with numbered placeholders to be null.

The previous release changed the ExtendedPdoInterface by adding a new disconnect() method. That was an unintentional BC break to existing implementations of the interface. This release corrects that break by removing the disconnect() method from the interface, while leaving it in the implementation.

• ADD: ExtendedPdo::disconnect() method to close connections explicitly. This does not work for injected PDO connection objects, which should be managed from their creation point, not as part of ExtendedPdo. Thanks to both Jacob Emerick and Jacques Woodcock for their initial implementations.
• CHG: ExtendedPdo::bindValue() now throws Exception\CannotBindValue when it encounters a non-bindable value. This helps with debugging values that make their way down to the PDO layer, which PDO cannot bind.

• CHG: ExtendedPdo::prepare() now profiles the query-preparation time

• SEC: ExtendedPdo no longer enables self::ATTR_EMULATE_PREPARES by default; this is to avoid security holes when using emulation.
• REF: Extract the statement-rebuilding logic to its own Rebuilder class
• ADD: ExtendedPdo::fetchGroup() functionality.
• ADD: When binding values via perform(), add the self::PARAM_* type based on the value being bound.
• TST: Update testing structure