Skip to content

Releases: yiisoft/db-pgsql

Version 2.0.0

05 Dec 14:56
Immutable release. Only release title and notes can be modified.
2.0.0
e30ea3f

Choose a tag to compare

  • New #307: Add range and multirange columns support (@vjik, @Gerych1984)
  • New #315, #432: Implement ColumnInterface classes according to the data type of database table columns
    for type casting performance. Related with yiisoft/db#752 (@Tigrov)
  • New #350, #449: Add array overlaps and JSON overlaps condition builders (@Tigrov)
  • New #355, #368, #370, #399: Implement ColumnFactory class (@Tigrov)
  • New #360, #460: Realize ColumnBuilder class (@Tigrov, @vjik)
  • New #364, #372: Add ColumnDefinitionBuilder class (@Tigrov)
  • New #373: Override QueryBuilder::prepareBinary() method (@Tigrov)
  • New #384: Add IndexMethod class (@Tigrov)
  • New #391: Add caseSensitive option to like condition (@vjik)
  • New #397: Realize Schema::loadResultColumn() method (@Tigrov)
  • New #407: Use DateTimeColumn class for datetime column types (@Tigrov)
  • New #408, #410: Implement DMLQueryBuilder::upsertReturning() method (@Tigrov)
  • New #439, #446: Implement ArrayMergeBuilder class (@Tigrov)
  • New #440: Add Connection::getColumnBuilderClass() method (@Tigrov)
  • New #465: Add enumeration column type support (@vjik)
  • New #471: Add source of column information (@Tigrov)
  • Chg #348: Replace call of SchemaInterface::getRawTableName() to QuoterInterface::getRawTableName() (@Tigrov)
  • Chg #375: Update QueryBuilder constructor (@Tigrov)
  • Chg #388, #469: Change supported PHP versions to 8.1 - 8.5 (@Tigrov, @vjik)
  • Chg #390: Remove yiisoft/json dependency (@Tigrov)
  • Chg #414: Rename DMLQueryBuilder::insertWithReturningPks() to DMLQueryBuilder::insertReturningPks() (@Tigrov)
  • Chg #416: Use \InvalidArgumentException instead of Yiisoft\Db\Exception\InvalidArgumentException (@DikoIbragimov)
  • Chg #447: Update expression namespaces according to changes in yiisoft/db package (@Tigrov)
  • Chg #460: Throw exception on "unsigned" column usage (@vjik)
  • Enh #336, #405: Implement and use SqlParser class (@Tigrov)
  • Enh #349: Add method chaining for column classes (@Tigrov)
  • Enh #353: Update bit type according to main PR yiisoft/db#860 (@Tigrov)
  • Enh #354: Refactor PHP type of ColumnSchemaInterface instances (@Tigrov)
  • Enh #356: Raise minimum PHP version to ^8.1 with minor refactoring (@Tigrov)
  • Enh #359: Separate column type constants (@Tigrov)
  • Enh #359: Remove Schema::TYPE_ARRAY and Schema::TYPE_STRUCTURED constants (@Tigrov)
  • Enh #362: Update according changes in ColumnSchemaInterface (@Tigrov)
  • Enh #365, #427: Refactor Dsn class (@Tigrov)
  • Enh #366: Use constructor to create columns and initialize properties (@Tigrov)
  • Enh #370: Refactor Schema::normalizeDefaultValue() method and move it to ColumnFactory class (@Tigrov)
  • Enh #374: Use ColumnDefinitionBuilder to generate table column SQL representation (@Tigrov)
  • Enh #378: Improve loading schemas of views (@Tigrov)
  • Enh #379: Remove ColumnInterface (@Tigrov)
  • Enh #380: Rename ColumnSchemaInterface to ColumnInterface (@Tigrov)
  • Enh #381, #383: Add ColumnDefinitionParser class (@Tigrov)
  • Enh #382: Replace DbArrayHelper::getColumn() with array_column() (@Tigrov)
  • Enh #386, #449: Refactor array, structured and JSON expression builders (@Tigrov)
  • Enh #388: Minor refactoring (@Tigrov)
  • Enh #393, #430: Refactor according changes in db package (@Tigrov)
  • Enh #396: Remove getCacheKey() and getCacheTag() methods from Schema class (@Tigrov)
  • Enh #403, #404: Use DbArrayHelper::arrange() instead of DbArrayHelper::index() method (@Tigrov)
  • Enh #411, #426: Refactor constraints (@Tigrov)
  • Enh #412: Reduce binding parameters (@Tigrov)
  • Enh #415, #448, #451: Implement CaseXBuilder class (@Tigrov)
  • Enh #420: Provide yiisoft/db-implementation virtual package (@vjik)
  • Enh #424, #425, #428: Adapt to conditions refactoring in yiisoft/db package (@vjik)
  • Enh #431: Remove TableSchema class and refactor Schema class (@Tigrov)
  • Enh #433: Support column's collation (@Tigrov)
  • Enh #442: Refactor DMLQueryBuilder::upsert() method (@Tigrov)
  • Enh #444: Improve ArrayExpressionBuilder and JsonExpressionBuilder classes (@Tigrov)
  • Enh #464: Load column's check expressions for table schema (@Tigrov)
  • Bug #387: Explicitly mark nullable parameters (@vjik)
  • Bug #456: Fix typecasting bit columns' values with big size (@Tigrov)
  • Bug #467: Fix column definition parsing in cases with parentheses (@vjik)

Full changelog

Version 1.3.0

21 Mar 07:28
1.3.0
6c65269

Choose a tag to compare

  • Enh #303, #338: Support structured type (@Tigrov)
  • Enh #324: Change property Schema::$typeMap to constant Schema::TYPE_MAP (@Tigrov)
  • Enh #330: Create instance of ArrayParser directly (@Tigrov)
  • Enh #333: Resolve deprecated methods (@Tigrov)
  • Enh #334: Minor DDLQueryBuilder refactoring (@Tigrov)
  • Bug #316, #6: Support table view constraints (@Tigrov)
  • Bug #331: Exclude from index column names fields specified in INCLUDE clause (@Tigrov)

Version 1.2.0

12 Nov 16:20
1.2.0
70a1f89

Choose a tag to compare

Version 1.1.0

24 Jul 16:06
1.1.0
e5de2fc

Choose a tag to compare

  • Chg #288: Typecast refactoring (@Tigrov)
  • Chg #291: Update phpTypecast for bool type (@Tigrov)
  • Enh #282: Support numeric arrays, improve support of domain types and int and varchar array types (@Tigrov)
  • Enh #284: Add tests for binary type and fix casting of default value (@Tigrov)
  • Enh #289: Array parser refactoring (@Tigrov)
  • Enh #294: Refactoring of Schema::normalizeDefaultValue() method (@Tigrov)
  • Bug #287: Fix bit type (@Tigrov)
  • Bug #295: Fix multiline and single quote in default string value, add support for PostgreSQL 9.4 parentheses around negative numeric default values (@Tigrov)
  • Bug #296: Prevent posible issues with array default values ('{one,two}'::text[])::varchar[], remove ArrayParser::parseString() (@Tigrov)

Version 1.0.0

12 Apr 07:20
1.0.0
3cd4d76

Choose a tag to compare

  • Initial release.