v2.11.0

2.11.0 (2024-06-11)

Features

• add INTERSECT and EXCEPT operators (#204) (b3cc5a3)
• add the ability to specify the full name of the join type (0fa0adf)

Bug Fixes

• add parameter consideration when hashing the query part with orderBy (c874f7d)
• triggering changelog build (4002820)

Documentation

• add issue templates (75086af)
• added security.md file (17aefde)
• move COC to .github directory (08cadcb)
• removing failing ci issue template (7200063)
• update CONTRIBUTING.md (f6a9722)
• updating contribution guide (ad3fbf0)

Styles

• apply yamllint (0506fb1)

Dependencies

• composer: added ergebnis/composer-normalize (1dddad4)

Tests

• add tests using fragments in orderBy (239b061)
• fix tests (56edfd4)

Continuous Integration

• add cycle/gh-actions (2507324)
• add default CODEOWNERS file (c080e0c)
• added coding-standards initial CI job (9725b49)
• auto apply labels based on files and branches (86971f0)
• do not include v prefix in tag (d9587c3)
• fixes in commit linting (ca925bd)
• push composer.lock to enable cache locks (726a0fe)
• switch to github changelog type (8275f0c)
• use actions/labeler directly (a9fa3b8)
• use fixed versions for actions instead of master (bd4d708)

2.10.0

What's Changed

Features

• Add support JSON columns in orderBy statement by @msmakouz (#184)
• Add mediumText column type by @msmakouz (#178)
• Add support for the NOT operator in SQL queries. Add new methods whereNot, andWhereNot, and orWhereNot by @msmakouz (#185)

Bug Fixes

• Fix caching of SQL insert query with Fragment values by @msmakouz (#177)
• Fix detection of enum values in PostgreSQL when a enum field has only one value by @msmakouz (#181)
• Fix psalm type for DatabaseInterface::transaction() method by @roxblnfk (#186)

Continuous Integration

• Automate changelog and release management @lotyp (#189)

2.9.0

What's Changed

Improved orderBy method by @butschster in #167

• Now the method can accept null as a parameter for the sorting direction, providing more flexibility when constructing queries.
• Added support for PostgreSQL-specific directions NULLS FIRST and NULLS LAST for more control over null value ordering in result sets.

Improved logging of SQL queries by @lotyp in #165

• Added logInterpolatedQueries for detailed query logging and refined logQueryParameters to accurately log query parameters as arrays, enhancing ORM debugging and monitoring.
• Improved logging with enriched context in driver, including driver details and query parameters.

Other changes

• Improved Psalm types for DatabaseInterface::transaction() by @vjik in #163

New Contributors

• @lotyp made their first contribution in #165

Full Changelog: 2.8.1...2.9.0

2.8.1

What's Changed

• Fix compiling of Fragment with parameters in the returning() definition by @msmakouz (#161)
• Fix comparison of Fragment in Column default value by @msmakouz (#162)

Full Changelog: 2.8.0...2.8.1

2.8.0

What's Changed

• The withDatetimeMicroseconds option now affects the interpolator by @msmakouz in #155
• Postgres: support for multiple returning columns by @roxblnfk and @msmakouz in #157
• MSSQL: support for multiple returning columns by @msmakouz in #160

Full Changelog: 2.7.1...2.8.0

2.7.1

What's Changed

• Fix setting precision and scale through attributes by @msmakouz (#148)
• Fix quoting with an underscore at the beginning by @msmakouz (#151)
• Fix behavior of the Column::type() method by adding default size to column type mappings by @msmakouz (#150)

Full Changelog: 2.7.0...2.7.1

2.7.0

What's Changed

• Add varbinary support in MySQL; optimize size attribute by @msmakouz (#146)
• Add the ability to use WHERE IN and WHERE NOT IN with array values
  The value sequence may contain FragmentInterface objets by @msmakouz and @roxblnfk (#147)

Full Changelog: 2.6.1...2.7.0

2.6.1

What's Changed

• Remove @internal from queries by @msmakouz in #142
• Fix whereJsonContains and whereJsonDoesntContain methods with a single column name in an argument by @msmakouz in #143

Full Changelog: 2.6.0...2.6.1

2.6.0

What's Changed

• Fix incorrect parameters processing for JOIN subqueries by @smelesh (#133)
• MySQL driver:
  • Add the type smallInteger by @gam6itko (#128)
  • Change mapping of the JSON type from text to json by @romanpravda (#121)
• Postgres driver:
  • Add the restartIdentity parameter to the eraseTable method by @msmakouz (#132)
  • Change mapping of the JSON type from text to json by @msmakouz (#134)
• All the drivers:
  • Add enableForeignKeyConstraints and disableForeignKeyConstraints methods in Driver Handlers by @msmakouz (#130)
  • Add an ability to disable the query cache before query using withoutCache() by @msmakouz and @roxblnfk (#137)
• JSON support:
  • Add methods to work with JSON columns by @msmakouz and @roxblnfk (#135)
  • Add an ability to set JSON default value as an array by @msmakouz and @roxblnfk (#138)

New Contributors

• @romanpravda made their first contribution in #121
• @smelesh made their first contribution in #133

Full Changelog: 2.5.2...2.6.0

2.5.2

What's Changed

• Fix Postgres schema restoring after reconnect by @msmakouz in #126

Full Changelog: 2.5.1...2.5.2