pecee-pixie

• Fixed parameter errors on Exception.

• 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.

• 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 ConnectionAdapters\Exception.
• Optimisations + bugfixes.

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

• Added option to get QueryObject from last executed query (issue: #44)

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

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

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

• 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.

• [!!!] 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);.

• Added support for PHP 7-support only (thanks to @mrcnpdlk).
• Removed deprecated prefix method in QueryBuilderHandler.
• Made table parameter in alias method optional.
• Added better support for Transactions (thanks to @mrcnpdlk).
• Better syntax and PHPDoc documentation.
• Optimisations + bugfixes.
• Updated documentation.

Release notes

This version requires PHP 7.0 or higher. Any references to $queryHandler->prefix() should be changed to $queryHandler->alias() before updating.

• Fixed PHP-issue with PDO not supporting bool parameters (issue: #27 - thanks to @mrcnpdlk).
• Optimized phpDoc (thanks to @mrcnpdlk).
• Changed required PHP-version in documentation.

• Fixed issue with null values and added unit-test for it.

• Fixed issue with wrong usage of join function (thanks to @mrcnpdlk)
• Minimum PHP version raised to >=5.5.0 (thanks to @mrcnpdlk)
• Added many new PHP-docs hint types and fixed data-types and description in many of the existing.
• Changed code style to comply with more with PSR-2.
• Added better data-type handling for PDO parameters.
• Loads of cleanup and optimizations which should be more memory efficient.
• Fixed homepage-url in composer.json.
• Updated documentation.

• Better codeinspection (thanks to @mrcnpdlk)
• Fixed issues related to groupBy functionality in combination with Raw and Closures objects.

• Fixed notice when calling $qb->first() method by reverting to old behavior (issue: #12)
• Fixed documentation so it uses getQueryBuilder() when creating new connection.

• Added quotation to alias names.
• Fixed failing unit tests.
• Minor optimisations.

• Fixed alias method.

• Changed event behavior so it always fires with $queryObject available. This makes it possible to get the raw-query before and after each events.

• Renamed prefix method to alias in QueryBuilderHandler.
• Added testPrefix unit-test in QueryBuilderBehaviorTest.
• Fixed table aliasing error (issue: #4 - thanks to @mrcnpdlk).
• Fixed correct return-type (issue: #3 - thanks to @mrcnpdlk).
• Optimized alias-handling.
• Added depricated alias method (prefix) in QueryBuilderHandler to avoid compability issues.
• Fixed method parameter naming in alias method in QueryBuilderHandler.
• Renamed testPrefix to testAlias in QueryBuilderBehaviorTest class.
• Updated documentation.