Database Laravel Package

Features

• OnConflict: index-inference predicate for ON CONFLICT (Postgres/SQLite) (#258) (bdd2cea)

Bug Fixes

• MySQL: omit row alias on upsert DO NOTHING — the alias made the no-op col = col ambiguous at runtime (bdd2cea)
• Postgres: unquote EXCLUDED in upsert DO UPDATE — quoted "EXCLUDED" broke every update-branch upsert at runtime (bdd2cea)

Features

• SelectQuery: refine Psalm integer types on query bounds (#257) (2cae328)

Bug Fixes

• SelectQuery: process the last partial chunk in runChunks() (#255) (38c3403)

Features

• Add wrapOnWhere() method to group JOIN ON conditions (#253) (aafa2f6)

Tests

• OnConflict: add tests for cache key generation with update parameters (a064944)

Features

• Add InsertQuery::onConflict() method (#249) (395a7ff)
• Add SelectQuery::wrapWhere() to group WHERE conditions (#250) (8f7c03a)

Features

• Add server-side cursors for streaming SELECT results (#247) (2acc10e)

Code Refactoring

• Rename CursorableInterface to CursorInterface (89dbfda)

Features

• Add charset and collation support for MySQL columns (#246) (26e33ef)
• Added $distinct parameter to SelectQuery::count (#242) (23842c0)
• update PHP version requirement to 8.1 (#244) (16e0874)

Styles

• php-cs-fixer: fix coding standards (16e0874)

Bug Fixes

• Replace deprecated MySQL constant with scalar (#237) (b1a9cd7)

Bug Fixes

• correct condition check for named parameters in Interpolator (#238) (283709e)

Features

• add snowflake column type alias (#235) (49a90c7)

Features

• add parameters to SubQuery (74dbd7c)
• add SubQuery injection (8079759)
• add ULID column type (#233) (f8b3a87)
• MySQL: add first and after into column declaration (#226) (7ad2df1)

Bug Fixes

• MySQL: unsigned boolean Columns comparison (#234) (82378ea)

Documentation

• cover SubQuery with comments (8579419)

Styles

• fix code style; rename SubQueryInjection to SubQuery (b9cf08e)
• improve code formatting and consistency in Compiler, Jsoner, and SubQuery (02484a6)

Code Refactoring

• rename selectSubQuery to subQuery and update related query logic (727ca0e)

Tests

• enhance subquery tests with additional conditions and parameters (09013c6)
• MySQL: Added a test case proving bug with boolean columns (c2c05d1)
• MySQL: enhance boolean column configuration tests with zerofill and nullable checks (0129e7f)

Features

• add getComment() method annotation into ColumnInterface (02c4962)
• Add getComment() method to AbstractColumn (9e780d8)
• add public Driver::clearCache() method (3cc2757)

Continuous Integration

• update workflow actions (d55b36f)

Features

• Reconnect on MySQL disconnected by inactivity (3f776ab)

Tests

• update MSSQL config (14ec20e)

Continuous Integration

• add ODBC driver to tests with codecov (7dfd98e)

Bug Fixes

• improve compatibility with PHP 8.4 (#214) (a6b860e)

Styles

• apply Code Style to tests (02c2437)
• php-cs-fixer: fix coding standards (3822f76)

Styles

• apply new code style (89a7c57)
• php-cs-fixer: fix coding standards (1eae6db)

Continuous Integration

• add Spiral CS fixer (a72e1ae)
• normalize DB passwords in tests; fix style in cs-fix workflow (b514009)
• use common MSSQL workflow (5c434ec)
• use common MySQL workflow (c5aa164)
• use common Postgres workflow (8c17e52)

Bug Fixes

• typecasting of an integer to a boolean in SQLite (32c29c7)

Continuous Integration

• fix MSSQL initialization in CI (678c049)
• replace docker-compose with docker compose (914ed58)

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)

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

• Fixed caching of SQL insert query with Fragment values by @msmakouz (#177)
• Fixed 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)

Features

• Added logInterpolatedQueries for detailed query logging and refined logQueryParameters to accurately log query parameters as arrays, enhancing ORM debugging and monitoring. @lotyp (#165)
• Improved logging with enriched context in Driver.php, including driver details and query parameters. @lotyp (#165)
• Improved orderBy method to accept a null direction parameter, providing more flexibility when constructing queries by @butschster (#167)
• Added support for PostgreSQL-specific directions NULLS FIRST and NULLS LAST for more control over null value ordering in result sets by @butschster (#167)

Bug Fixes

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

Features

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

Bug Fixes

• 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)

Features

• 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)

Features

• 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)

Bug Fixes

• Fix incorrect parameters processing for JOIN subqueries by @smelesh (#133)

Bug Fixes

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

Bug Fixes

• Fix drastic increase of insert statements on pg driver with complex primary keys by @wolfy-j (#122)

Features

• Add ability to use non-primary serial column by @msmakouz (#106)
• Add ability to configure DB port passing a string by @msmakouz (#109)
• Add ability to define a custom type column by @msmakouz (#104)
• Add the ability to define readonlySchema for columns by @msmakouz (#116)
• Add AbstractForeignKey::$index property to enable/disable index creation by @msmakouz (#119)

Bug Fixes

• Fix inserting an array of rowsets without calling the columns method by @msmakouz (#120)

Miscellaneous

• Improve types for TableInterface and ColumnInterface by @vjik (#108)
• Fix typos by @arogachev (#110, #111)

Bug Fixes

• Fix: add schema to Postgres dependency table names by @msmakouz (#102)
• Fix: don't add a table prefix when a column is quoting by @msmakouz (#103)

⚠ BREAKING CHANGES

• Since v2.4.0, interpolation in logs is disabled by default

Features

• Add option logQueryParameters in the driver options to enable interpolation in SQL query logs by @msmakouz (#95)
• Add PostgreSQL specific data types by @msmakouz (#93)
• Add MySQL SET type support by @msmakouz (#92)

Bug Fixes

• Fix Interpolator performance by @msmakouz (#94) thx @hustlahusky

Features

• Add support for array values in the IN and NOT IN operators by @roxblnfk (#69, #70, #71)
• Add PdoInterface as a possible return type for the Driver::getPDO() method by @roxblnfk (#76)
• Add the options array parameter to all driver configs to pass additional driver options. The withDatetimeMicroseconds option can be set to true to store a DateTime with microseconds by @msmakouz (#86)
• Add a config recovery mechanism via __set_state() by @wakebit (#83)
• Add the ability to define the size of a datetime column by @msmakouz (#86)
• Add support for the unsigned and zerofill properties in MySQL Integer types by @roxblnfk (#88)

Bug Fixes

• Fix transaction level changing on disconnect when transaction is starting by @roxblnfk (#76)

Bug Fixes

• Hotfix: make the $config parameter of the DatabaseConfig constructor optional again by @roxblnfk

Features

• Add supporting for PHP 8.1 Enumerations by @roxblnfk (#67)
• Add supporting for smallint column type by @gam6itko (#58)

Bug Fixes

• Fix typo in the \Cycle\Database\Schema\State::forgerForeignKey method by @BeMySlaveDarlin (#53)
• Fix compatibility with Spiral Framework 3 packages:
  • Remove overriding of the $config property in the DatabaseConfig class by @roxblnfk (#64)
  • Update composer.json dependencies

Bug Fixes

• Fix query interpolation by @roxblnfk (#60)

Bug Fixes

• Fix wrong bind parameter order in a select query with join by @roxblnfk (#48)
• Fix access to unitialized driver property on ActiveQuery::__debugInfo() call by @roxblnfk (#46)

Miscellaneous

• Fix phpdoc for the SelectQuery::orderBy method by @butschster (#45)
• Fix problem with driver cloning by @butschster (#44)

Features

• Added psr/log dependency by @thgs (#35)
• Add ability to get/set driver name by @butschster (#38)
• Optimize fetching indexes and primary keys in Postgres driver by @hustlahusky (#37)

Bug Fixes

• Fix type casting for column size value in the PG Column class by @rauanmayemir (#34)

Miscellaneous

• Add psr/log dependency by @thgs (#35)
• Downgrade spiral dependencies to stable by @roxblnfk (#40)

⚠ BREAKING CHANGES

• Namespace Spiral\Database replaced with Cycle\Database @butschster (#1)
• Minimal PHP version is 8.0

Features

• Added supporting for postgres schemas @butschster (#2)
• Added DTO configs @SerafimArts, @msmakouz (#10, #14)
• Added method to get transaction level @msmakouz (#23)
• Added ColumnReturnableInterface for database drivers @butschster (#25)

Miscellaneous

• The package moved from spiral/database to cycle/database
• Improvements to join methods @butschster
• Tests have been restructured @butschster (#21)