- Fixes more type hints in some statement classes
- Where clause hints were not expansive enough
- Fixes type hints in some statement classes
- Some parameters only allowed null and needed string|null
- Reverts change to
DeleteStatement
constructor$table
argument made nullable again- Only calling
setTable()
now if$table
exists
- Updated
README
and docs contents- Cleaned up the php examples and content
- Updated internal tools php-cs-fixer and phpstan
- Cleared all phpstan errors up to level 8 (max)
- Changed (corrected) some return types for functions
- These were all from phpstan errors
- Increased minor version number because of compatibility
- Fixes bug with having
- Removed backticks from
having()
method - These were not needed and they caused downstream issues
- Removed backticks from
- Updated
GroupClause
class with:- For backwards compatibility,
groupBy()
accepts botharray
andstring
- For backwards compatibility,
- Updated
GroupClause
class with:array
type is required ingroupBy()
function- Values can still be appended with multiple calls
- Added
InsertMultiStatement
class with:- Support to insert multiple rows at once
- Support for
ON DUPLICATE KEY UPDATE
- Refactored code formatting to PSR-2/Symfony
- Set up PHP CS Fixer and config file with rules
- Removed unnecessary PHP doc tags and comments
- Changed namespaces and updated all documentation
- Moved code out of
PDO
sub-folder and intosrc
- Updated
Database
class with:- Allow user provided PDO options to overwrite default values
- Updated
StatementContainer
class with:- Added check to stop executing when field value is not expected
- Updated
LimitClause
class with:- Fixed
LIMIT/OFFSET
format - Changed default offset value
- Added check whether offset is null (before checking if is integer)
- Fixed
- Updated
StatementContainer
class with:- Added transactional
commit()
method - Added transactional
rollBack()
method - Added transactional
beginTransaction()
method
- Added transactional
- Updated
LimitClause
class with:- Added validation to check if parameters are casted to expected integers
- Updated
OffsetClause
class with:- Added validation to check if parameter is casted to expected integer
- Added ability to insert associative arrays (#35)
- Updated
Database
class with:- Renamed
$columns
argument ininsert()
method
- Renamed
- Updated
StatementContainer
class with:- Added
isAssociative()
method - Fixed
getPlaceholders()
method
- Added
Proposed by Raistlfiren. Thanks!
- Updated
SelectStatement
class with:- Fixed
getColumns()
method
- Fixed
- Updated
WhereClause
class with:- Reverted
__toString()
method
- Reverted
- Updated
HavingClause
class with:- Reverted
__toString()
method
- Reverted
- Updated
WhereClause
class with:- Fixed some weird bug in
__toString()
method
- Fixed some weird bug in
- Updated
HavingClause
class with:- Fixed the same weird bug in
__toString()
method
- Fixed the same weird bug in
Mentioned by EliaRigo. Thanks!
- Updated
LimitClause
class with:- Fixed
limit()
method
- Fixed
- Updated documentation
- Added protected override allowed
- Better parameter naming
- Revised documentation (WIP)
- Updated
InsertStatement
class with:- Fixed
execute()
method
- Fixed
- Updated
InsertStatement
class with:- Added
$insertId
argument inexecute()
method
- Added
- Updated
Database
class with:- Fixed
$options
argument in__construct()
method
- Fixed
- Updated
SelectStatement
class with:- Fixed all aggregates
- Added
whereMany()
method - Updated
limit()
method
- Updated
Database
class with:- Minor change
__construct()
method - Minor change
insert()
method - Minor change
update()
method
- Minor change
- Updated
LimitClause
class with:- Minor change
__toString()
method
- Minor change
- Updated
OffsetClause
class with:- Minor change
__toString()
method
- Minor change
- Updated
StatementContainer
class with:- Minor fix
setPlaceholders()
method
- Minor fix
- PSR-2 coding style guide adopted
- Updated
InsertStatement
class with:- Added
columns()
method
- Added
- Updated
UpdateStatement
class with:- Added
set()
method
- Added
- Updated
StatementContainer
class with:- Added
$table
argument indelete()
method
- Added
- Updated
WhereClause
class with:- Fixed
orWhereLike()
method
- Fixed
- Updated
SelectStatement
class with:- Minor fix
select()
method (working fix)
- Minor fix
- Updated
SelectStatement
class with:- Minor fix
select()
method
- Minor fix
- Removed old changelog notes
- Revised release version