Version 4.9.1

• Fixed getTable returning raw-query instead of null on subQuery-tables.
• Replaced alias-name in aggregate to generic one.

Version 4.9.0

• Added new joinUsing method to QueryBuilderHandler class (issue #85 - thanks to @Fishy49).
• Added new using and orUsing to JoinBuilder class.
• Added support for columns (column1, columns2 etc.) in buildCriteria method in BaseAdapter class.
• Optimized and simplified buildCriteria method in BaseAdapter class.
• Fixed behavior for join method which was incorrectly using LEFT JOIN as default type.
• Added unit tests for new joinUsing functionality.
• Removed orUsing as it's not supported by sql.
• Added unit test for JoinBuilder.
• Minor optimisations.
• Updated documentation to reflect new changes.

Release notes

Please read this section carefully before updating in a production environment:

This version corrects the default behavior for the $qb->join() method. The default join behavior is now JOIN instead of LEFT JOIN. Please change all references in your code to use the leftJoin method instead, or specify the join-type using the $type parameter.

Version 4.8.1

• Fixed events not firing as $storedConnection was overwritten in Connection class.

Version 4.8.0

• Feature: added better database connection handling.
• Updated unit-tests.
• Updated documentation.

Release notes

Added better control for database connections. A connection to the database will now only be established when a new instance of QueryBuilderHandler is created or when $connection->connect(); has been called manually.

This will ensure that projects that sets the connection in the bootstrap, won't connect to the database unless a query has been created or if the connect() method has been called has been called specifically.

Example:

This will no longer automatically establish a database connection:

$connection = (new \Pecee\Pixie\Connection('mysql', $config));

Unless $connection->connect() or $connection->getQueryBuilder() or new QueryBuilderHandler() is called.

Version 4.7.2

• Cleanup and optimisations.

Version 4.7.1

• Fixed table method not returning instance when argument is null.
• Minor optimisations (simplified code).

Version 4.7.0

• Added new overwriting feature to QueryBuilderHandler.
• Added test.sql for custom unit-test tables.
• Updated readme to with new query-overwriting feature.
• Changed required PHP version from 7.2 to 7.1.
• Added proper PDOStatement closing in QueryBuilderHandler.
• Optimisations.

Release notes

PHP version has been changed from version 7.2 to 7.1

Version 4.6.0

• Fixed count method so it counts all rows in query with no exceptions (issue: #75 - thanks @mrcnpdlk)
• Added new aggregate-methods (sum, average, min and max) to QueryBuilderHandler.
• Simplified aggregate method in QueryBuilderHandler.
• Updated code-syntax to PHP 7.2.
• Added unit-tests for new functionality.
• Updated composer dependencies.
• Updated documentation to reflect new changes.

Release notes

This release requires PHP 7.2 or higher

Version 4.5.1

• Cleaned up Transaction class and simplified the statement method.
• Changed QueryObject to contain instance of Connection instead of instance of the Pdo class as this has more features.
• Cleaned up files and removed newlines.

Version 4.5.0

• Added better ExceptionHandling thanks to @mrcnpdlk - pecee-pixie will now try to parse the error code and throw a matching Exception, which may help out when debugging. This will not cause any chances to existing code, as they all inherit from the base Exception class from earlier versions.

• Added better connection handling. It's now possible to close the connection using the close method in the Connection class. The library will try to reconnect using stored credentials if the connection is established afterwords. This is especially useful for controlling open connections in beanstalkd scripts or long-running scripts where open connections can cause issues.

• Added new unit tests for new ExceptionHandling feature.

• Updated and cleaned the documentation.

• A bunch of optimisations and bugfixes.