v6.37.3

6.37.3 (2024-04-13)

Bug Fixes

• postgres: use schema for foreign key constrains of a table (#17099) (6aba382)

v7.0.0-alpha.40

7.0.0-alpha.40 (2024-04-11)

Highlights

• Dialects have been moved to their own packages. Please see our upgrade guide to see how to initialize Sequelize

Bug Fixes

• parse the url option based on the dialect (#17252) (f05281c)
• update bulkDeleteQuery supported options (#17191) (c53fd01)

Features

• add ModelRepository#_UNSTABLE_bulkDestroy and manual ON DELETE handling (#17078) (45ac01a)
• cli: create @sequelize/cli as a replacement for sequelize-cli (#17195) (ec00aed)
• cli: add seed generate command (#17262) (b07ad40)
• db2: move db2 to the @sequelize/db2 package (#17197) (6aa4ced)
• move postgres to the @sequelize/postgres package (#17190) (721d560)
• mssql: upgrade to tedious 18 (#17137) (65e19a1)
• type options per dialect, add "url" option, remove alternative Sequelize constructor signatures (#17222) (b605bb3)
• mssql: move mssql to the @sequelize/mssql package (#17206) (8631f5a), closes #17206
• ibmi: move ibmi to the @sequelize/db2-ibmi package (#17209) (21772a5), closes #17209
• mysql: move mysql to the @sequelize/mysql package (#17202) (5c7830e), closes #17202
• mariadb: move mariadb to the @sequelize/mariadb package (#17198) (46ea159), closes #17198

BREAKING CHANGES

• db2, ibmi, snowflake and sqlite do not accept the url option anymore
• The sequelize constructor only accepts a single parameter: the option bag. All other signatures have been removed.
• Setting the sequelize option to a string representing a URL has been replaced with the "url" option.
• The dialectOptions option has been removed. All options that were previously in that object can now be set at the root of the option bag, like all other options.
• All dialect-specific options changed. This includes at least some credential options that changed.
• Which dialect-specific option can be used is allow-listed to ensure they do not break Sequelize
• The sequelize pool is not on the connection manager anymore. It is now directly on the sequelize instance and can be accessed via sequelize.pool
• The sequelize.config field has been removed. Everything related to connecting to the database has been normalized to sequelize.options.replication.write (always present) and sequelize.options.replication.read (only present if read-replication is enabled)
• sequelize.options is now fully frozen. It is no longer possible to modify the Sequelize options after the instance has been created.
• sequelize.options is a normalized list of option. If you wish to access the options that were used to create the sequelize instance, use sequelize.rawOptions
• The default sqlite database is not ':memory:' anymore, but sequelize.sqlite in your current working directory.
• Setting the sqlite database to a temporary database like ':memory:' or '' requires configuring the pool to behave like a singleton, and disallowed read replication
• The match option is no longer supported by sequelize.sync. If you made use of this feature, let us know so we can design a better alternative.
• The dialectModulePath has been fully removed to improve compatibility with bundlers.
• The dialectModule option has been split into multiple options. Each option is named after the npm library that is being replaced. For instance, @sequelize/postgres now accepts pgModule. @sequelize/mssql now accepts tediousModule
• Instead of installing the pg package, users need to install @sequelize/postgres.
• Instead of installing the tedious package, users need to install @sequelize/mssql.
• Instead of installing the odbc package, users need to install @sequelize/db-ibmi.
• Instead of installing mysql2, users need to install @sequelize/mysql.
• Instead of installing the mariadb package, users need to install @sequelize/mariadb.
• Instead of installing the ibm_db package, users need to install @sequelize/db2.
• Instead of installing the snowflake-sdk package, users need to install @sequelize/snowflake.

v6.37.2

6.37.2 (2024-03-29)

Bug Fixes

• add readOnly to the transaction options types and docs (#17226) (7c8972f)

v7.0.0-alpha.39

7.0.0-alpha.39 (2024-03-22)

Bug Fixes

• fix package.json exports TypeScript resolution (#17181) (23a0cb4)
• sqlite: mark the bigint datatype as not supported (#17154) (47cd0e5)
• throw when using upsert in ibmi or snowflake (#17155) (2054802)

Features

• support TypeScript 5.4, drop TypeScript 5.0 (#17171) (8e3e007)

v7.0.0-alpha.38

7.0.0-alpha.38 (2024-03-19)

Bug Fixes

• mysql: use public TypeCastField type (#17136) (7ab30dc)
• reduce internal usages of deprecated APIs (#17112) (f1db523)

Features

• add @sequelize/utils package. This package still needs to be improved but is meant to be a general-purpose utility library, not specific to Sequelize (#17168) (1d96a59)
• implement Model._UNSTABLE_destroyMany (#17031) (1fead8a)
• postgres: add MACADDR8 DataType (#17059) (c64b3c2)

Breaking Changes

• remove TableNameOrModel in favor of TableOrModel (#17080) (dfc90b8)
• refactor transaction methods (#16903) (ed47bcb)
• Many internal utilities that were previously exposed have been moved to the @sequelize/utils package as part of their public API.

v7.0.0-alpha.37

7.0.0-alpha.37 (2024-02-10)

Bug Fixes

• fix NOT operator sometimes producing incorrect queries (#17044) (63ba367)
• make importModels support non-default CJS exports (#16844) (bf53c9f)

Features

• postgres: add MACADDR8 DataType (#17059) (c64b3c2)

v6.37.1

6.37.1 (2024-02-18)

Bug Fixes

• types: Add definition of returning in SaveOptions. (#16954) (505467b)

v6.37.0

6.37.0 (2024-02-11)

Features

• postgres: support connectionTimeoutMillis dialectOption (#14119) (e81200e)

v6.36.0

6.36.0 (2024-02-02)

Features

• postgres: backport stream dialectOption to v6 (#16868) (a250058)

v7.0.0-alpha.36

7.0.0-alpha.36 (2024-02-01)

Features

• add support for generating uuids in SQL (#16864) (2df575b)
• migrate bulkDelete, delete & truncate methods to typescript (#15934) (693c0fc)
• migrate schema queries to typescript (#16932) (12ad4f1)
• parse URLs using WHATWG URL API instead of legacy URL API (#16927) (9cc6ca9)
• types: support TypeScript 5.3.3 (#17017) (20eb84f)

Breaking Changes

• drop support TS 4.9 (#17023) (85e84cd)