dibi

• PdoDriver: check for misconfigured PDO connections resource (#294)
• Connection: added config option onConnect (#303)
• Connection::update() Support updating multiple tables at once (#316)
• Connection: accepts Driver instance (fixes 51fa3b9) #315
• fix: setType should accept null as type (#309)
• fix TypeError: substr() expects parameter 1 to be string, null given (#306)
• OdbcDriver: added option 'microseconds'
• Dibi\Fluent: add annotations for methods and(), asc(), desc() #298 (#299)
• drivers: config is not passed via reference (BC break)
• Firebird: Add escapeLike() (#300,#305)
• DibiExtension: compatibility with Nette DI 3.x (#297)
• PdoDriver::getInsertId() fixed
• Sqlite3Driver becomes alias for SqliteDriver

For the details you can have a look at the diff.

• PdoDriver: check for misconfigured PDO connections resource (#294)
• loader: added missing classes #310
• OdbcDriver: added option 'microseconds'
• DibiExtension: compatibility with Nette DI 3.x (#297)
• PdoDriver::getInsertId() fixed

For the details you can have a look at the diff.

• Result: added getColumnCount()
• added dibi::stripMicroseconds
• type improvements and fixes
• Sqlite3Driver: for SQLite 3 is not needed to strip [] from column names
• examples: dibi:: replaced with $dibi->

For the details you can have a look at the diff.

Please make a donation at https://nette.org/make-donation?to=dibi

• Revert "loader: uses only Composer's autoloader"
• Translator: improved Expression usage
• PdoDriver: improved detection of query result #279
• Firebird: fix datetime precision (#277) (#273)

For the details you can have a look at the diff.

Please make a donation at https://nette.org/make-donation?to=dibi

New features

• requires PHP 7.1
• added declare(strict_types=1)
• added PHP 7.1 scalar and return type hints
• added JSON support [Closes #269]
• added Dibi\Expression and shortcut Connection::expression() (should be used instead of arrays in queries) [Closes #264]
• used safe casting to int
• Translator: %i %f throws exception when value is not numeric
• Dibi\Exception: Previous exception can now be passed to constructor (#275)
• PdoDriver: improved detection of query result [Closes #279]
• PdoDriver: returns OracleReflector, PostgreReflector, SqlsrvReflector
• added interface IConnection (#274)
• added Result::getColumnCount()

Deprecations

• deprecated insertId() (use getInsertId), affectedRows() (use getAffectedRows) and DateTime::modifyClone() (use modify)
• extension methods are deprecated
• Connection::__construct() parameter config should be array

Changes, BC breaks

• Connection::query() and Fluent::execute() always return Result, not the number of affected rows
• fetch(), fetchSingle(), getAffectedRows(), getInsertId() return NULL instead of FALSE on error
• removed support for old class names without namespaces (it also applies to v3.2)
• installable only via Composer, removed minified version
• automatically decodes JSON columns see
• DateTime extends DateTimeImmutable instead of DateTime
• also note, that support for microseconds (since Dibi 3.1) can lead to BC break, see this
• all drivers divided into Driver, ResultDriver and Reflector
• reflection: removed Column::isUnsigned()
• removed support for obsolete FirePHP browser plugin and MSSQL driver (there is a new SQLSRV driver)
• Sqlite3Driver: removed support for charset conversion
• OracleDriver: by default uses native date format
• removed dibi::$defaultDriver
• removed Dibi\IDriver::connect()

Support for old class names without namespace ended.

Be sure to change every catch (DibiException $e) to catch (Dibi\Exception $e)

• loader: old class names like DibiConnection triggers E_USER_DEPRECATED
• loader: removed old class preloading
• loader: uses only Composer's autoloader

This is the last 3.1 release.

• Previous exception can now be passed to Dibi\Exception constructor (#276)
• Microsoft SQL Server and MSSQL support for microseconds fix cont.
• Microsoft SQL Server and MSSQL support for microseconds fix (#249)
• loader: fixed missing class 'dibi.php'
• drivers: changed self:: to static::

For the details you can have a look at the diff.

This is the last 3.0 release.

• loader: fixed missing class 'dibi.php'
• Translator: fixed %dt with DateTimeInterface object #263

For the details you can have a look at the diff.

• requires PHP 5.4 and supports PHP up to 7.2
• added Dibi\Expression [Closes #264]
• Support for microseconds (#246) (BC break)
• Translator: fixed %dt with DateTimeInterface object [Closes #263]
• OdbcDriver, OracleDriver, SqlsrvDriver, Sqlite3Driver: query() returns ResultSet only when contains columns
• Connection, dibi: deprecated insertId() & affectedRows() in favor getInsertId() & getAffectedRows()
• Translator: %i %f throws exception when value is not numeric (BC break)
• OracleDriver: added 'nativeDate' option, formatDate & formatDateTime are deprecated (#232)
• Helpers::loadFromFile improved, added $onProgress
• support for 64bit numbers on 32bit platform [Closes #253] (BC break)
• coding style: TRUE/FALSE/NULL -> true/false/null
• removed bridges for Nette < 2.2
• removed folder /dibi

Warning: support for microseconds can lead to BC break in PHP 7.1, see this

For the details you can have a look at the diff.

• Tracy\Panel: dump() may fail
• Tracy\Panel: host added to tracy panel #250 (#251)
• Tracy\Panel: one panel is used per connection
• Tracy\Panel: better typography
• fixed phpDoc

For the details you can have a look at the diff.

• PostgreSQL: add support for more than one schema in search_path (#239)
• Result, Row: added support for datetime like 'Jun 17 2015 12:00:00:000AM' #180
• Implemented OracleDriver::getColumns() (#233)
• FirebirdDriver: Fixed DriverException throw (#231)
• Connection::translateArgs() is protected #237

For the details you can have a look at the diff.

• Bridges\Tracy\Panel: silenced PHP warning
• FirebirdDriver: silenced PHP warning
• Dibi\DateTime::__wakeup() doesn't call parent after 8e8e6dfd #228

For the details you can have a look at the diff.

• Dibi\DateTime: provides BC for serialized older versions #226 (#227)
• Disconnect on not connected driver not fail (#222)
• Correct limit and offset for Firebird Driver (#221)
• Implemented OracleDriver::getAffectedRows()
• Translator, Fluent: preserve dot in name after AS #224
• Translator: added %N
• composer.json: replaces all dg/dibi versions
• tests/travis: reports code coverage to Coveralls

For the details you can have a look at the diff.

• SqlsrvDriver::getInsertId() last inserted id is from last statement instead of last inserted row regardless of the table that produced the value
• SqlsrvDriver: php7 compatibility
• removed Strict from exceptions [Closes #216]

For the details you can have a look at the diff.

• Helpers::detectType() detects VAR_STRING as Type::TEXT
• DibiExtension22: added options 'explain' & 'filter' [Closes #203]
• SqlsrvDriver: fixed: sql server does not respond on non-string credentials
• FirebirdDriver::delimite - Quotation marks for escaping identifiers

For the details you can have a look at the diff.

• appveyor: testing with SQL Server 2012 & 2014
• SqlsrvReflector::getTables(): gets list of all tables from dbo schema only
• SqlsrvDriver::applyLimit(): fixed limit and offset behaviour for odbc 11+
• SqlsrvReflector: changed constrains metadata loading to sys schema
• added MsSqlDriver
• PdoDriver::applyLimit() is the same as SqlsrvDriver

For the details you can have a look at the diff.

• PdoDriver: unset remaining references to PDO to allow disconnection
• Helpers::detectType resolves tinyint as integer
• Translator: added modifier %dt #198
• Connection::substitute() fixed #197
• Strict: added support for the old way of adding extension methods #195
• MySqliDriver::createException() removed undefined ConnectionException #194

For the details you can have a look at the diff.

This release marks the end of life of 2.3 series. All users are encouraged to upgrade to the current stable version.

• Helpers::detectType resolves tinyint as integer
• PdoDriver: unset remaining references to PDO to allow disconnection
• DibiFluent: fixed combination of modifier and inner fluent [Closes #192]
• DibiResultInfo: fixed case insensitivity

For the details you can have a look at the diff.

• DibiFluent::fetch() uses limit only when there is no LIMIT & OFFSET (fixes 2.2.4 on MSSQL)
• DibiFluent: prevents doubled processing
• DibiConnection: option 'driver' can contain driver instance or class name #153
• added DibiSqlsrvDriver as alias for DibiMsSql2005Driver

For the details you can have a look at the diff.

This release marks the end of life of 2.2 series. All users are encouraged to upgrade to the current stable version.

• DibiFluent::fetch() uses limit only when there is no LIMIT & OFFSET (fixes 2.2.4 on MSSQL)
• DibiFluent: prevents doubled processing

For the details you can have a look at the diff.