- Added missing interface for AdvancedStatement
- Fixed orderBy issue when direction is omitted
- Added interfaces for all classes
- Added Insert::priority() support
- Added Select::unionAll() support
- Updated constructors to depend on Database instead of PDO
- Updated execute() to match the PDO::execute() signature
- Updated limit / offset to be more compatible
- Improved type hints for all classes
- Major documentation updates
- Added Insert::onDuplicateUpdate support
- Fixed TypeError with Update constructor
- Fixed Conditional issues with QueryInterface values
- Fixed Limit null offset argument
- Removed support for the DatabaseException
- Complete rewrite focusing on objects
- PHP 7.2 minimum version requirement
- Adding unit testing via PHPUnit 8
- 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