pecee-pixie

• Bugfixes

• Bugfixes

• Fixed bindings not casted as array before merge.

• Fixed binding issues on nested raw statements.

• Fixed params with ? not escaped correctly

• Make sure select doesn't pick the same fields (select columns unique).

• Exception class: Fixed issue causing notice when error has no message defined.

• Skip sanitation if first character contains ".

• Fixed raw bindings not working as expected for join + generally optimised raw-bindings.

• Fixed Raw not working correctly for join statements, for example:

$query->join('hostnames', 'host', '=', $this->raw('?', [$host]))

• Changed references for SqlServer class.

• Fixed bindings on for where key statements.

• Fixed issue with raw when used in conjunction with alias (issue: #137 - thanks to @mrcnpdlk)

• [!!!] Moved EventHandler::registerEvent so optional $table parameter comes after required.
• Fixed Raw bindings not set properly when using within select statement like: select($this->builder->raw('CONCAT(simple, ?)', ['criteria'])).
• Changed $table parameter in EventHandler::registerEvent to use EventHandler::ANY constant instead of null.
• Simplified duplicate select-statement code in BaseAdapter & SqlServerAdapter.
• Tests: Updated PHP-unit to version 8 for compatibility with PHP8.
• Tests: Fixed changed PHP-unit references to work with changes in version 8.
• Updated documentation to reflect changes.

• Fixed Raw bindings not being set properly on some occasions for instance update(['alias' => $query->raw('?',['value'])]).
• Beatified queries. Queries now have the correct spacing between values.
• Simplified BaseAdapter code by using arrayStr instead of foreach loops.
• Tests: Added QueryBuilderBehaviorTest::testRawStatementsWithinCriteria.
• Tests: Updated unit-tests to work with new queries.

• Feature: Added better overwrite of where/whereNull etc if enabled.
• Issue #123: Added better phpDoc
• Feature: Added phpstan.
• Updated phpUnit.

Changelog

• Fixed alias not checking if key is of closure/callable type.
• Updated readme

Changelog

• Fixed alias-prefix property not being set properly.
• Renamed prefix property to aliasPrefix in QueryBuilderHandler

Changelog

• Feature: Added support for object with __toString magic methods.
• Feature: Added support for changing alias mid-way. Columns will now inherit the change.
• Feature: Added SQL Server adapter class (thanks to @advicente).
• Feature: Added more advanced type parsing for objects.
• Feature #109: Added support for FOR UPDATE using the QueryBuilderHandler::for method.
• Fixed: Object not quoted correctly as strings.
• Fixed: Problem with event arguments using wrong parameters (thanks to @Kemekaze).
• Fixed: error-codes for sqlite.
• Fixed: Fixed bug with select that was defaulting to MySQL sanitisation, should now work for Postgres and others (thanks to @lakesta).
• Fixed #110: Changed return-type to self to support ide's that doesn't parse phpDocs properly.
• Fixed #113: Aliasing table support for update stmt (thanks to @mrcnpdlk).
• Fixed #117: nullable return-type for Connection::getStoredConnection.
• Cleanup & optimisations.

• Fix error handling for SQLite adapter (issue: #104)
• Changed PDO-SQLite to suggested and dev composer extension.
• Unit-tests for SQLite exceptions + optimisation.
• CI (Scrutnizer & Travis) MySQL support (ver 5.7) & PHP (ver 7.2).
• CI Sqlite support (in memory mode).

• Fixed wrong return-type when using COUNT (issue #91).
• Fixed only strict names taken into account with no wildcard * and/or Raw instances (issue: #92).
• Added Travis-ci with MySQL support (issue: #97)
• Added PDO extension to composer file and added PDO extension as requirement in README.
• Added SQLite extension to composer file and added PDO extension as requirement in README.
• Fixed connections overlapping when using multiple connections (issue #98)
• Added support for more advanced query-statements when using update and delete (issue: #93)
• Added optional $columns argument to delete method in QueryBuilderHandler to specify which columns to delete.
• Join now supports empty key and value, which will remove the ON statement from the query.
• Added unit-tests for new features.
• Added unit tests for multiple connections.
• Minor optimisations.