Releases: skipperbent/pecee-pixie
Releases · skipperbent/pecee-pixie
Version 4.15.2
- Fixed bindings on for where key statements.
Version 4.15.1
Version 4.15.0
- [!!!] 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 inEventHandler::registerEvent
to useEventHandler::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.
Version 4.14.0
- Fixed
Raw
bindings not being set properly on some occasions for instanceupdate(['alias' => $query->raw('?',['value'])])
. - Beatified queries. Queries now have the correct spacing between values.
- Simplified
BaseAdapter
code by usingarrayStr
instead of foreach loops. - Tests: Added
QueryBuilderBehaviorTest::testRawStatementsWithinCriteria
. - Tests: Updated unit-tests to work with new queries.
Version 4.13.0
- Feature: Added better overwrite of where/whereNull etc if enabled.
- Issue #123: Added better phpDoc
- Feature: Added phpstan.
- Updated phpUnit.
Version 4.12.2
Changelog
- Fixed alias not checking if key is of closure/callable type.
- Updated readme
Version 4.12.1
Changelog
- Fixed alias-prefix property not being set properly.
- Renamed
prefix
property toaliasPrefix
inQueryBuilderHandler
Version 4.12.0
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 theQueryBuilderHandler::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.
Version 4.11.0
- 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).
Version 4.10.0
- 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 todelete
method inQueryBuilderHandler
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.