Released version 3.0.6

• Helpers: Fix dumpSql() for bool parameters (#251)
• SqlPreprocessor: recoginzes (SELECT) UNION (SELECT) as parameteric command #248
• SqlPreprocessor: correctly escapes scalars when parameters are not used
• ConnectionPanel: uses capturing
• Revert "ConnectionPanel: params are useless for EXPLAIN"
• SqlPreprocessor: multi-insert accepts Row objects #247
• ResultSet: muted warnings
• Row: compatibility with operator ??

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

Released version 3.0.5

• ConnectionPanel: params are useless for EXPLAIN
• DriverException: added params, ConnectionPanel shows them
• DriverException: mimics original file&line of PDOException
• PgSqlDriver: stop using adsrc column (#242)

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

Released version 3.0.4

• supports PHP 7.4
• SqlPreprocessor: INSERT with multiple arrays is key-dependent #238
• ConnectionPanel - highlight INSERT|UPDATE|DELETE (#237)

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

Released version 2.4.9

• supports PHP 7.4
• Revert "DatabaseExtension: better detection of single/multiple definitions" #219

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

Released version 3.0.3

• SqlPreprocessor: fixed casting to string
• Structure: foreign keys with less columns have bigger priority (#170)
• Structure tests: driver should return also name of foreign key constraint
• fixed typehint (#236)

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

Released version 3.0.2

• ResultSet: added workaround for PDO bug #38546 (#231)
• SqlPreprocessor: generates IS NOT NULL (#226)
• Revert "Table: moved caching related functionality to separate classes (#185)"
• Structure::getBelongsToReference() return value fix
• Selection: typefix for referencing table primary key
• ResultSet: only format strings as floats (#228)
• SqlBuilder: Fixed loading arguments for left join conditions (#224)
• Use phpstan callable format (#220)

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

Released version 3.0.1

• DatabaseExtension: uses configuration Schema
• Revert "DatabaseExtension: better detection of single/multiple definitions" #219
• ConnectionPanel: fixed bad source file nette/tracy#346

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

Released version 3.0.0 🎉

Features

• requires PHP 7.1
• uses declare(strict_types=1)
• uses PHP 7.1 scalar and return type hints
• Helpers::loadFromFile added $onProgress
• SqlBuilder::tryDelimite() ignores casting ::int
• MsSql support for tables, columns, indexes, foreign keys (#215)
• Selection: fixed insert spoiling PDO:lastInsertId (#217)
• SqlBuilder: fixed compatiblity with PCRE2 used in PHP 7.3 [Closes #210]

Changes

• SqlPreprocessor: scalar are always passed via bindValue() (BC break)
• ResultSet: changed empty result return type of fetch() and fetchField() methods from FALSE to NULL [BC Break]
• removed unused ISupplementalDriver::normalizeRow() (BC break)
• removed unused ISupplementalDriver::formatBool()
• ISupplementalDriver: uncommented formatDateInterval() & getPrimaryAutoincrementKey()
• added ISupplementalDriver::initialize(), is used instead of constructor (BC break!)
• IRowContainer: Added method fetchField() (BC break)
• remove old sqlite2 driver (#155)
• removed meta info unsigned, onDelete, onUpdate
• Table: moved caching related functionality to separate classes (#185)

Released version 2.4.8

• SqlBuilder: fixed compatiblity with PCRE2 used in PHP 7.3 #208 #210
• PgSqlDriver: uses cache for getColumnTypes() to avoid excessive number of queries #212
• SqlPreprocessor: enables database parameters only for SELECT, INSERT, UPDATE, DELETE, REPLACE and EXPLAIN #211
• Connection::quote() throws exception on error (related to #202)

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

Released version 2.4.7

• Selection: Fixed accidental deletion of referenced cached rows when emptyResultSet is called (#187)(#207)
• SqlBuilder: added method resetSelect (#146)
• Fixed Helpers::dumpResult with non-string values (#204)
• Connection, Context: added fetchFields()
• SqlPreprocessor: strings are always passed via bindValue() (possible BC break)
• SqlPreprocessor: PDO::quote() returns false for ODBC driver #202
• OdbcDriver: doesn't support meta
• MySqlDriver: Fix PDO::ATTR_CASE (#199)
• added Connection::getLastQueryString()
• appveyor: is unable to start MSSQL 2008, 2012 & 2014 together

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