Skip to content

Latest commit

 

History

History
368 lines (279 loc) · 12.1 KB

CHANGELOG.md

File metadata and controls

368 lines (279 loc) · 12.1 KB
Raw

Change Log

All notable changes to this project will be documented in this file. This project adheres to Semantic Versioning.

v4.3.0 - 2024-09-29

Added

  • Support for PHP 8

v4.2.1 - 2021-04-14

Fixed

  • Bug in mid function

v4.2.0 - 2020-05-24

Added

  • nop function (no operation) to where conditions

v4.1.1 - 2020-02-03

Fixed

  • SQLite compatibility issue

v4.1.0 - 2019-03-25

Added

  • Better support for expressions in column expressions and aggregate functions
  • Support for expressions in the following clauses: WHERE, HAVING, GROUP BY, ORDER BY, JOIN and ON
  • Support for aliased expressions in SELECT statement
  • CROSS JOIN support in Opis\Database\SQL\BaseStatement::crossJoin (there is no ON clause)
  • Static method Opis\Database\SQL\Expression::fromClosure

Fixed

  • HAVING statements not working
  • Array of column expressions not working

v4.0.1 - 2018-12-13

Added

  • Dependency to PDO extension in composer.json file

Fixed

  • Fixed a bug related to boolean values

v4.0.0 - 2018-06-05

Removed

  • Support for PHP 5.x
  • ORM - see opis/orm library

Changed

In this major release many classes were refactored or entirely removed, in order to improve the library.

v3.6.7 - 2016.06.14

Fixed

  • Bugfix

v3.6.6 - 2016.06.07

Fixed

  • Fixed a bug related to PHP 7

v3.6.5 - 2016.05.29

Fixed

  • Bugfix

v3.6.4 - 2016.05.20

Added

  • Added object casting type

v3.6.3 - 2016.05.19

Changed

  • Rollback. Opis\Database\Connection::count is no longer deprecated and is used again.

v3.6.2 - 2016.05.19

Changed

  • Method Opis\Database\Connection::count is now deprecated and Opis\Database\Connection::command method is used instead.

v3.6.1 - 2016.05.19

Fixed

  • Fixed a bug in Opis\Database\Model::__set method

v3.6.0 - 2016.03.21

Added

  • Added throwExceptions flag on Opis\Database\Model class

Changed

  • Changed exception message in Opis\Database\Model::__get

Fixed

  • Fixed a bug in Opis\Database\Model::__set method

v3.5.1 - 2016.03.08

Fixed

  • Fixed a bug in Opis\Database\ORM\BaseQuery that prevented proper using of grouped conditions

v3.5.0 - 2016.03.02

Added

  • Added support for soft deletes
  • Opis\Database\Model::softDelete, Opis\Database\Model::supportsSoftDeletes, Opis\Database\ORM\Query::softDelete, Opis\Database\ORM\Query::restore, Opis\Database\ORM\BaseQuery::withSoftDeleted, Opis\Database\ORM\BaseQuery::onlySoftDeleted methods were added.
  • Opis\Database\Model::destroy and Opis\Database\Model::softDestroy methods were added
  • The following methods were added to Opis\Database\ORM\Relation class: column, count, sum, avg, min, max, update, restore, delete and softDelete
  • Added support for timestamps
  • Added timestamps and softDelete methods to Opis\Database\Schema\CreateTable
  • Added update and updateAll methods to Opis\Database\Model class

Changed

  • Now you can count, update, delete, soft delete and restore related models
  • Opis\Database\Model::getDateFormat method is now public
  • The Opis\Database\Model::assign method now returns the current model instance

v3.4.2 - 2016.02.23

Fixed

  • Fixed a bug in Opis\Database\Model::__set method

v3.4.1 - 2016.02.22

Added

  • Added isNewRecord property to Opis\Database\Model class in order to fix a bug that might occur when using custom values for primary key.

Changed

  • The __set, save and delete methods were updated to use the newly added isNewRecord property.

v3.4.0 - 2016.02.22

Added

  • Added Opis\Database\Schema\BaseColumn::length method
  • Added Opis\Database\Schema\Compiler\SQLServer::handleTypeDecimal method

Changed

  • Updated Opis\Database\Schema\Compiler\MySQL::handleTypeDecimal method
  • Updated Opis\Database\Schema\Compiler\PostgreSQL::handleTypeDecimal method

v3.3.3 - 2016.02.13

Fixed

  • Fixed a bug in Opis\Database\Model::__set method

v3.3.2 - 2016.02.04

Added

  • Added missing use statement for DateTime class in Opis\Database\Model
  • Added support for custom cast handling

v3.3.1 - 2016.02.04

Fixed

  • Fixed a bug in Opis\Database\Model::__get and Opis\Database\Model::__set

v3.3.0 - 2016.02.03

Added

  • Added link and unlink methods to Opis\Database\ORM\Relation\BelongsToMany class

Fixed

  • Fixed a potential bug in Opis\Database\Model::delete method

v3.2.3 - 2016.01.31

Added

  • Nothing

Changed

  • Casting types can now be declared nullable by adding a ? mark at the end of the type name

Fixed

  • Fixed a bug related to nullable column handling in Opis\Colibri\Module::__get

v3.2.2 - 2016.01.29

Fixed

  • Fixed a bug in Opis\Database\Transaction class. See issue #22.

v3.2.1 - 2015.12.19

Added

  • Nothing

Changed

  • Moved Opis\Database\ModelInterface into a separate file

Fixed

  • Fixed a bug in Opis\Database\Transaction::onError
  • Fixed CS

v3.2.0 - 2015.12.09

Added

  • Added Opis\Database\Model::using method
  • Added an optional Opis\Database\Connection argument to the Opis\Database\Model::create method

Removed

  • Removed unused artifacts Opis\Database\SQL\WhereInterface and Opis\Database\SQL\SelectStatement::addHavingClause. See issue #19 and issue #18.

Changed

  • Opis\Database\Model::getConnection method was moved to Opis\Database\ModelInterface::getConnection
  • Model class implements ModelInterface interface and you must provide an implementation for the Opis\Database\ModelInterface::getConnection method
  • The constructor of the Opis\Database\Model class accepts an optional Opis\Database\Connection argument

Fixed

v3.1.0 - 2015.11.20

Added

  • Added Opis\Database\ResultSet::column method. See issue #10

Changed

  • The Opis\Database\Model::getConnection method is not abstract anymore. See issue issue #11

v3.0.1 - 2015.11.09

Changed

  • The second argument of the Opis\Database\Connection::column method is now optional.

v3.0.0 - 2015.10.29

Added

  • Added Opis\Database\SQL\Compiler::getDateFormat method
  • Added support for ORM
  • Addes support for joins in UPDATE statementes
  • Added .gitattributes file
  • Added Opis\Database\Connection::setDateFormat method. The method allows you to set the date format used by the compiler.
  • Added Opis\Database\Connection::setWrapperFormat method. The method allows you to set the identifier wrapper used by the compiler.
  • Added support for NULL values ordering

Removed

  • Removed deprecated Opis\Database\Schema\AlterTable::addPrimary method
  • Removed deprecated Opis\Database\Schema\AlterTable::addUnique method
  • Removed deprecated Opis\Database\Schema\AlterTable::addIndex method
  • Removed deprecated Opis\Database\Schema\AlterTable::addForeign method
  • Removed Opis\Database\DSN class and all other classes that were under the Opis\Database\DSN namespace

Changed

  • Moved classes that were under the Opis\Database\Compiler namespace to Opis\Database\SQL\Compiler namespace

v2.3.1 - 2015.10.21

Fixed

  • Fixed a bug in Opis\Database\SQL\Compiler::sqlFunctionROUND
  • Fixed some bugs in Opis\Database\Compiler\MySQL compiler class

v2.3.0 - 2015.10.19

Added

  • Added primary, unique, index and foreign methods to Opis\Database\Schema\AlterTable class
  • Added Opis\Database\Connection::schema method
  • Added Opis\Database\Schema::getColumns method

Removed

  • The third argument of the Opis\Database\Schema\AlterTable::renameColumn method was removed

Changed

  • Improved schema compilers
  • The addPrimary, addUnique, addIndex and addForeign methods were deprecated in Opis\Database\Schema\AlterTable class
  • Changed Opis\Database\Database::schema method. The schema object is now returned from the connection object.
  • Schema compilers now takes as an argument the current connection

Fixed

  • Various bugs

v2.2.0 - 2015.10.19

Added

  • Added an optional parameter to Opis\Database\Connection's constructor method. The parameter can be used to specify a the driver used by the current connection
  • Added Opis\Database\Connection::driver method
  • Added Opis\Database\Schema\Compiler\SQLite class. This class provides schema support for SQLite

Changed

  • Newly added increment and decrement methods can now be used when a row is updated
  • Improvements

Fixed

  • Bugfixes

v2.1.2 - 2015.10.01

Removed

  • branch-alias from composer.json file

Fixed

  • Fixed a bug that prevented boolean values to be as default value for a table's column.
  • Fixed a bug where text and binary types were not mapped correctly.

v2.1.1 - 2015.02.02

Fixed

  • Fixed a bug (see #4)

v2.1.0 - 2014.12.12

Fixed

  • Modified persistent method in Opis\Database\Connection. The method accepts now an optional boolean argument that specify if the connection should pe persistent or not.
  • Added disconnect method in Opis\Database\Connection
  • Added renameTable method in Opis\Database\Schema\Compiler
  • Added renameTable method in Opis\Database\Schema
  • The Opis\Database\Schema\BaseTable's nullable method was deprecated.
  • Fixed several bugs in Opis\Database\Schema\Compiler
  • Modified the pdo method in Opis\Database\Transaction. The PDO object is no longer stored as a property, in order to avoid keeping the connection alive after the disconnect method was called.

v2.0.1 - 2014.11.26

Fixed

  • Fixed a bug in Opis\Database\Schema\Complier class.

v2.0.0 - 2014.10.15

Added

  • Added is, eq, isNot, ne, lessThan, lt, greaterThan, gt, atLeast, gte, atMost, lte, between, notBetween, in, notIn, like, notLike, isNull and notNull methods. This methods are used in conjunction with the where, andWhere and orWhere methods.
  • Added schema method to the Opis\Database\Database class.

Removed

  • Removed whereBetween, andWhereBetween, orWhereBetween, whereNotBetween, andWhereNotBetween and orWhereNotBetween methods from Opis\Database\SQL\WhereCondition class.
  • Removed whereIn, andWhereIn, orWhereIn, whereNotIn, andWhereNotIn and orWhereNotIn methods from Opis\Database\SQL\WhereCondition class.
  • Removed whereLike, andWhereLike, orWhereLike, whereNotLike, andWhereNotLike and orWhereNotLike methods from Opis\Database\SQL\WhereCondition class.
  • Removed whereNull, andWhereNull, orWhereNull, whereNotNull, andWhereNotNull and orWhereNotNull methods from Opis\Database\SQL\WhereCondition class.
  • Removed execute method from Opis\Database\SQL\Update class.

Changed

  • This is a full API change
  • Changed where, andWhere and orWhere methods of the Opis\Database\SQL\WhereCondition class. The methods accepts now a single argument, representing a column or a closure used to group conditions.
  • Modified join, leftJoin, rightJoin, fullJoin methods of the Opis\Database\SQL\WhereJoinCondition class.
  • Modified having method of the Opis\Database\SQL\SelectStatement class.
  • Changed set method of the Opis\Database\SQL\Update class.
  • The schema builder is now officially supported, although it is still marked as experimental.

v1.4.0 - 2014.07.04

Changed

  • insert command

v1.3.2 - 2014.07.03

Added

  • Autoload file

v1.3.1 - 2014.07.01

Fixed

  • Fixed a bug in Opis\Database\SQL\Where class.

v1.3.0 - 2014.06.26

Added

  • An extra optional argument to the server method of Opis\Database\DSN\SQLServer class
  • Code comments

Removed

  • port method from Opis\Database\DSN\SQLServer class

Fixed

  • Fixed a bug in Opis\Database\DSN\SQLite class

v1.2.2

Added

  • Changelog