Version 4.1.2

• Fixed issues with whereBetween and orWhereBetween and appropriate unit tests.

Version 3.6.4

• Removed PDOException error-code as it's not an integer which is what exceptions espect.

Version 3.6.3

Re-release due to packagist.org error.

• Exception fixes.

Version 3.6.1

• Removed PHP7 stuff.

Version 3.6.0

• PdoException has been replaced with Pecee\Pixie\Exception that includes methods for fetching query-object for easier debugging.
• Last-query is now set before query is executed.
• Fixed issues with using $qb->raw() with bindings as field name.
• Removed Pecee\Pixie\ConnectionAdapters\Exception class.
• Optimisations + bugfixes.

Version 3.5.2

• Fixed issues with whereBetween and orWhereBetween and appropriate unit tests.
• Added option to get QueryObject from last executed query (issue: #44)

Version 4.1.1

• Reverted auto PDO parameters and now manually determinates right parameter type.

Version 4.1.0

• Removed usmanhalalit/viocon composer dependency (Container support) to increase library performance.
• Moved event-types constants to EventHandler from QueryBuilderHandler.
• Added return-types to more methods.
• Added IQueryBuilderHandler interface for more implementations of return-types.
• Added more return-types to methods.
• Fixed return-type for some phpDoc blocks and methods.
• Fixed insert so it uses Transactions when inserting multiple/batch.
• Fixed issue where bindings with null-value was unavailable/missing from query (issue: #35).
• Added unit tests for bindings with null-value (issue: #35)
• Changed PDO-parameter behavior so it automatically parses correct parameter-type.
• Simplified PDO-parameter bindings on queries.
• Transactions are now working correctly for batch-insert (issue: #31).
• Fixed nested transactions not working and added unit-tests (issue: #31).
• Added very basic unit-tests for Transactions.
• Minor optimisation, cleanup and bug-fixes.
• Updated existing unit-tests.
• Updated documentation.

Release note

This version contains breaking changes. Before upgrading, please read the read the release notes carefully.

Removed usmanhalalit/viocon composer dependency (Container support) to increase library performance.
If you are currently using containers in your projects, please note that this feature is no longer supported in the pecee-pixie library. To create custom connection-adapter, you need to inherit the IConnectionAdapter interface and use it as a driver on your Connection object instead.

Moved event-type constant from QueryBuilderHandler to EventHandler class.
Event-type constant has been moved to the EventHandler class. Please change all references to QueryBuilderHandler::EVENT_BEFORE_UPDATE etc. to EventHandler::EVENT_BEFORE_UPDATE.

Version 3.5.1

• Reverted auto PDO parameters and now manually determinates right parameter type.

Version 3.5.0

• [!!!] Removed usmanhalalit/viocon composer dependency (Container support) to increase library performance.
• [!!!] Changed parameter order on alias method in QueryBuilderHandler.
• [!!!] Removed deprecated prefix method.
• Added support for nested transactions.
• Batch insert now uses transactions correctly.
• Fixed where unable to insert params with NULL value.
• Changed parameter-binding so data-type are now parsed by PDO.
• Alias will now automatically determine table-name if missing parameter.
• Added event-type constants to EventHandler class.
• Updated return-types and PHP Docs.
• Optimisations and bugfixes.
• Updated documentation.

Release note

This version contains breaking changes. Before upgrading, please read the read the release notes carefully.

Removed usmanhalalit/viocon composer dependency (Container support) to increase library performance.
If you are currently using containers in your projects, please note that this feature is no longer supported in the pecee-pixie library. To create custom connection-adapter, you need to inherit the IConnectionAdapter interface and use it as a driver on your Connection object instead.

Removed deprecated prefix method.
The deprecated method $qb->prefix($table, $alias) has been removed. Please change all references to $qb->alias($alias, $table);.

Changed parameter order on alias method in QueryBuilderHandler.
$qb->alias($alias) no longer requires you to enter $table - that argument has been moved to the end of the method. If no argument exists, pecee-pixie will try to determine the table from any table() calls. Please change all references to $qb->alias($alias, $table);.