database

What's Changed

• Use row_number window function on MariaDB >= 11
• Adding ability to zip export of multiple tables
• Cleanup non-release related files
• Improve PHP 8.4 compatibility
• Add testcoverage for PHP 8.3

Full Changelog: https://github.com/joomla-framework/database/compare/3.1.0...3.2.0

What's Changed

• getTableList() return only tables not views
• Add support for duplicate named query parameters for the mysqli and sqlsrv driver

Full Changelog: https://github.com/joomla-framework/database/compare/3.0.0...3.1.0

What's Changed

• Raised minimum PHP version to 8.1
• Switched to PSR-12 codestyle
• add createQuery() as replacement for getQuery(true)
• DatabaseExporter/Importer: handle NULL values properly

Full Changelog: https://github.com/joomla-framework/database/compare/2.1.1...3.0.0

What's Changed

• Drone by @nibra in https://github.com/joomla-framework/database/pull/269

Full Changelog: https://github.com/joomla-framework/database/compare/2.1.0...2.1.1

What's Changed

• Fix deprecated null parameter for string functions in the escape method of the drivers by @richard67 in https://github.com/joomla-framework/database/pull/260
• Introduce DatabaseAware trait and interface by @laoneo in https://github.com/joomla-framework/database/pull/262

Full Changelog: https://github.com/joomla-framework/database/compare/2.0.2...2.1.0

What's Changed

• Only check types of postgres default values if set by @wilsonge in https://github.com/joomla-framework/database/pull/259
  Fix preg_match gives a PHP deprecation warning in PHP 8.1, when a PostgreSQL column's default is null

Full Changelog: https://github.com/joomla-framework/database/compare/2.0.1...2.0.2

• Reliable Camel Case of function variables for PHP 8
• Bug Fix for for the database importer
• DatabaseQuery::castAsChar now has a len param that allows defining the length of the char
• PHP 7.4 fixes for the Oracle Driver
• Allow other schema than "public" on PostgreSQL databases

• Fixed PHP 7.4 compatibility
• Improve return type hints that previously documented mixed to be more specific
• Various test setup improvements

The following are pertinent changes made with this release:

• [META] Added test coverage with MariaDB as a backend MySQL server
• https://github.com/joomla-framework/database/pull/138 - Remove explicit quoting of values given to DatabaseQuery::dateAdd()
• https://github.com/joomla-framework/database/pull/142 - Add QueryElement::getName() method
• https://github.com/joomla-framework/database/pull/149 - Add support for quoting binary values
• Miscellaneous code structure improvements and optimizations

The following are pertinent changes made with this release:

• [META] Expanded test integrations for additional platform coverage
• Deprecated PDO Oracle Driver
• Deprecated native PostgreSQL Driver, use PDO PostgreSQL instead
• https://github.com/joomla-framework/database/pull/84 - Correct loading of table columns in MySQL import class
• https://github.com/joomla-framework/database/pull/89 - Add ability to clear offset from query builder
• https://github.com/joomla-framework/database/commit/a332b876a14f01b64878c8774e55e91860c87b27 - Fix issue with updating rows when using DatabaseDriver::updateObject()
• Miscellaneous code structure improvements and optimizations

The following are pertinent changes made with this release:

• [META] Added AppVeyor CI support for the repository
• https://github.com/joomla-framework/database/pull/38 - Prepared statement support for MySQLi
• https://github.com/joomla-framework/database/pull/39 - Prepared statement support for PostgreSQL
• https://github.com/joomla-framework/database/pull/40 - New PostgreSQL driver supporting PDO
• https://github.com/joomla-framework/database/pull/78 - Prepared statement support for SQL Server
• https://github.com/joomla-framework/database/commit/66035e44f523bb0259aadb0e544fc8cf63e686d2 - Prepared statement support for the PDO MySQL driver
• https://github.com/joomla-framework/database/commit/3cb4670ab1a9992dcaad6f12550efe8994bd6326 - Allow defining a custom port and socket for MySQLi
• https://github.com/joomla-framework/database/commit/b5746dcf6f8a5a22bc533418620d253232b42e9e - Extended group() function for the SQL Server query object
• https://github.com/joomla-framework/database/commit/12342836bec1bbfd286e53bdb15af5822bcdbcaf - Fix handling of default values in SqlsrvDriver::getTableColumns()
• https://github.com/joomla-framework/database/commit/48e5395d773d45042d57961a8faafe0a2da68c21 - Escape comments in MySQL exporters
• https://github.com/joomla-framework/database/commit/2ad24c11a8dd2708b0a59a6810051d3026f55ccb - Fix limit handling in MySQL query objects
• https://github.com/joomla-framework/database/commit/2533e8cb62c9dbccc078bd48e98f906ee2baf83d - Add Exception subclasses for different error conditions (NOTE: This removes the failed SQL query from the Exception message; if it is needed check either the log attached to your database driver or call the getQuery() method of the thrown ExecutionFailureException object
• https://github.com/joomla-framework/database/commit/5cc71aa2a128a3dd389082cf0067e5f9142b1fe6 - Correct error code detection for SQL Server driver

This is the initial stable release of the Database package.

The following are pertinent changes made with this release:

• https://github.com/joomla/joomla-framework/pull/292 - Deprecated PostgresqlDriver::test() in favor of PostgresqlDriver::isSupported()
• https://github.com/joomla/joomla-framework/pull/321 - Added charLength and concatenate methods to SqliteQuery

The following are pertinent changes made with this release:

• Restructure package for PSR-4 support

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/6 - Skip fields in an object that aren't part of a table in insertObject and updateObject methods
• https://github.com/joomla-framework/database/pull/7 - PostgreSQL driver's insertObject method will now ignore primary keys with a zero value
• https://github.com/joomla-framework/database/pull/8 - PostgreSQL driver's getTableColumns return now emulates the return from the MySQL drivers
• https://github.com/joomla-framework/database/commit/a745ad02f18f1ff7afb2b6ae0418af31cbb1b096 - PDO MySQL driver's lockTable() method issued an empty query

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/13 - Fix PHP warning in MySQLi driver's destructor
• https://github.com/joomla-framework/database/commit/bad8825c32de50430884b96a059515a45c034fbd - Cleaning up duplicated logic in the database importers, deprecated PostgresqlImporter::getIdxLookup() in favor of PostgresqlImporter::getKeyLookup() for API consistency

This release fixes one bug:

• https://github.com/joomla-framework/database/commit/775d5c058f4d17fb3de64750167bb6f19ec70bef - Missing truncateTable() implementation for SQLite driver

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/21 - Use existing API to replace table prefix in the database importer
• https://github.com/joomla-framework/database/pull/22 - Use logging from the database driver in the database importer
• https://github.com/joomla-framework/database/pull/27 - Make sure the database exporter's __toString() method doesn't throw an Exception
• https://github.com/joomla-framework/database/pull/31 - Add logging on database connection errors
• https://github.com/joomla-framework/database/pull/35 - Add andWhere, orWhere, and extendWhere methods to DatabaseQuery
• https://github.com/joomla-framework/database/commit/663b59491212fcf953801fe7dd47fedc5b9215da - Made mergeStructure() method of the database importer public

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/24 - Add missing method in MySQL importer
• https://github.com/joomla-framework/database/pull/25 - Remove hardcoded default character set in MySQL importer
• https://github.com/joomla-framework/database/pull/32 - Remove duplicate connection error checks
• https://github.com/joomla-framework/database/pull/36 - Don't set the sql_mode to empty in MySQLi
• https://github.com/joomla-framework/database/pull/37 - Add support for MySQL's utf8mb4 charset
• https://github.com/joomla-framework/database/commit/02fe1106c960a4ed288d16e5dd27fe20bfef1ef5 - Move tests to autoload-dev in Composer
• https://github.com/joomla-framework/database/commit/327f6f0ec103a5fea13c1eec09b4261e8203a19f - Deprecated the singleton instance of DatabaseFactory
• https://github.com/joomla-framework/database/commit/38e3e738bd8d35af9d9b9248527446bbf6de1fcd - Improve database collation checks for MySQL drivers
• https://github.com/joomla-framework/database/commit/1b0e757bbf57657fb7a4e99199c42e45a354611f - Fix handling for some comment types in splitSql(), backports https://github.com/joomla/joomla-cms/pull/9137
• https://github.com/joomla-framework/database/commit/d82d629615b4e607d264a235818d8db5ad1f7e6c - Additional comment handling in splitSql(), backports https://github.com/joomla/joomla-cms/pull/9369
• https://github.com/joomla-framework/database/commit/007fafb4123e4021e1d184d67df498381ad7c9b7 - Added server type detection

This release fixes one bug:

• https://github.com/joomla-framework/database/commit/c8e6bf9b3c7ad04d205b563d6e5f012ec5cb9a9b - Missing global namespace declarations for PDO MySQL driver