All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
Added
for new features.Changed
for changes in existing functionality.Deprecated
for soon-to-be removed features.Removed
for now removed features.Fixed
for any bug fixes.Security
in case of vulnerabilities
- Tested up to PHP v8.4.
- Added support for MySQL functions in query builder conditions.
- Added support for
NULL
in values and conditions ofDb
class methods.
- Added
startGroup
andendGroup
methods.
- Added
groupBy
method.
- Updated documentation.
- Added
aggregate
method and related constants. - Added the following operators:
OPERATOR_STARTS_WITH_INSENSITIVE
OPERATOR_DOES_NOT_START_WITH_INSENSITIVE
OPERATOR_ENDS_WITH_INSENSITIVE
OPERATOR_DOES_NOT_END_WITH_INSENSITIVE
OPERATOR_HAS_INSENSITIVE
OPERATOR_DOES_NOT_HAVE_INSENSITIVE
OPERATOR_NOT_NULL
- Depreciated
getTotalRows
method in favor ofaggregate
.
- Added
orWhere
method.
- Added
setQueryTime
method.
- Updated method for calculating query durations to be more accurate.
- Updated
getQueryTime
andgetTotalQueries
methods to accept a specific database name. - Updated
DbFactory::create
method to not require a specificdefault
database.
- Removed concept of "default" and "current" database in favor of simply using "current".
- Removed
getDefaultConnectionName
method.
- Fixed bug in
DbFactory
using old namespace.
- Added
DB_DEFAULT
constant. - Added
getCurrentConnection
method. - Added constants to be used with the query builder.
- Added support for multiple
INNER
,LEFT
andRIGHT
joins with the query builder.
- Renamed
add
method toaddConnection
. - Renamed
use
method touseConnection
. - Renamed
get
method togetConnection
. - Renamed
getDefault
method togetDefaultConnectionName
. - Renamed
getCurrent
method togetCurrentConnectionName
. - Renamed
getConnections
method togetConnectionNames
. - Renamed
isConnected
method toconnectionExists
. - Changed namespace from
Bayfront\PDO
toBayfront\SimplePdo
- Updated documentation.
- Removed need for
php-string-helpers
dependency.
- Added ability to select, search and order by
json
data type columns using the query builder.
- Removed needless exceptions rethrown on
PDOException
.
- Added ability to utilize some native MySQL functions in the
where
method of the query builder.
- Added
getLastQuery
method forQuery
class. - Added
getLastParameters
method.
- Added support for PHP 8.
- Fixed bug in MySQL adapter when passing options.
- Initial release.