v7.0.0-alpha.21

7.0.0-alpha.21 (2023-01-19)

Features

• feat: improve typedoc & remove Optional, Error exports (#15495)
• feat: move validator decorators to @sequelize/validator.js (#15561)
• feat: rollback workaround #13347, improve stack traces using async stack traces instead (#15559)

Breaking changes

• The Optional type has been removed. Use a type library like type-fest's SetOptional if you need this type
• Removed Sequelize.Error and the Error export. Use the BaseError export instead.

v7.0.0-alpha.20

7.0.0-alpha.20 (2022-12-22)

Bug Fixes

• align QueryInterface type export with value exports (042a565)
• always escape string attributes (#15374) (344c404)
• fix parameters not being replaced when after $$ strings (#15306) (1a47fea)
• migrate describeTableQuery and showIndexesQuery to TS (#15299) (e1ba925)
• migrate removeIndexQuery to TypeScript (#15406) (b44f9e0)
• mssql: allow bulkCreate to insert more than 1000 rows in mssql (#14689) (ed5f63d)
• mssql: force transactions if attempting to insert more than 1,000 rows (#15458) (cda75b9)
• postgres: invalidate connection after client-side timeout (#15144) (ff43e8d), closes /github.com/brianc/node-postgres/blob/5538df6b446f4b4f921947b460fe38acb897e579/packages/pg/lib/client.js#L529
• prevent model attribute being shadowed by class properties (#15480) (bb4d401)
• remove options.model overwrite on bulkUpdate (#15231) (c620469)
• support TS 4.9 and drop support TS 4.5 (#15284) (3b1ba33)
• throw on invalid where (#15375) (6c71dbd)
• types: add instance.dataValues property to model.d.ts (#15208) (81b1667)
• types: add to cast to projection alias (#15210) (5034f64)
• types: tableHint is missing for FindOptions (#15153) (b28ca6d)
• types: typo in typings (#15176) (c6bed01)
• unify and fix tests queryGenerator.arithmeticQuery/dropTableQuery/showIndexesQuery/describeTableQuery (#15235) (c68f8c8)
• use different default schema per dialect, escape quotes in identifiers instead of removing them, normalize Model.getTableName (#15274) (778c6dc)

Features

• add @Index, createIndexDecorator (#15482) (ab9aaba)
• add @AllowNull, @AutoIncrement, @Comment, @Default, @PrimaryKey, and validation decorators (#15384) (08eb398)
• add @Attribute & @Table decorators (#15336) (fb8603b)
• add @Unique decorator, support specifying multiple unique indexes on the same attribute (#15342) (43bca57)
• add association decorators (#15483) (3770827)
• add model hook decorators (#15333) (bd037c8)
• add new postgres JSONB operators ?| and ?& (#15073) (98dc4c2)
• add support for add/drop column IF [NOT] EXISTS for mssql and mariadb (#15261) (096ed3a)
• added support for index include (#14900) (dacc806)
• allow using calculations in upsert on duplicate key by using literal values instead of VALUES() in mysql & mariadb (#14437) (9c2ae3c)
• improved error reporting on associations (#14901) (8e3c626), closes #14161
• Migrate createSchema() to TypeScript (#15339) (a3d164f)
• migrate hooks to TypeScript (#15131) (9cd8d89)
• migrate model definitions to TypeScript (#15431) (f57e5a0)
• postgres: add support for lock_timeout [#15345] (#15347) (5e7cbe6)
• postgres: support for ADD COLUMN IF NOT EXISTS and DROP COLUMN IF EXISTS (#15119) (76cc97f)
• remove Utils export (#15305) (a4f8e62)
• rename ALS back to CLS (#15427) (766b2ea)
• replace CLS with ALS, enable ALS by default, discourage unmanaged transactions (#15292) (4cd43a4)
• restrict instance methods if no primary key (#15108) (3095d99)
• rewrite Data Types (#14505) (68b64f8)
• throw if accessing databaseVersion before it is loaded (#15346) (151a458)
• types: use retry-as-promised types for retry options to match documentation (#15400) (f2574ae)

BREAKING CHANGES

• Type ModelAttributeColumnOptions has been renamed AttributeOptions
• setterMethods and getterMethods model options, which were deprecated in a previous major version, have been removed. See https://sequelize.org/docs/v6/core-concepts/getters-setters-virtuals/#deprecated-in-sequelize-v7-gettermethods-and-settermethods for alternatives.
• In the "references" attribute option, the "model" option has been split in two options:...

v6.28.0

6.28.0 (2022-12-20)

Features

• types: use retry-as-promised types for retry options to match documentation (#15484) (fd4afa6)

v6.27.0

6.27.0 (2022-12-12)

Features

• add support for bigints (backport of #14485) (#15413) (1247c01)

v6.26.0

6.26.0 (2022-11-29)

Features

• postgres: add support for lock_timeout [#15345] (#15355) (94beace)

v6.25.8

6.25.8 (2022-11-22)

Bug Fixes

• oracle: remove hardcoded maxRows value (#15323) (7885000)

v6.25.7

6.25.7 (2022-11-19)

Bug Fixes

• fix parameters not being replaced when after $$ strings (#15307) (bc39fd6)

v6.25.6

6.25.6 (2022-11-15)

Bug Fixes

• postgres: invalidate connection after client-side timeout (#15283) (a205765), closes /github.com/brianc/node-postgres/blob/5538df6b446f4b4f921947b460fe38acb897e579/packages/pg/lib/client.js#L529

v6.25.5

6.25.5 (2022-11-07)

Bug Fixes

• remove options.model overwrite on bulkUpdate (#15252) (67e69cd), closes #15231

v6.25.4

6.25.4 (2022-11-05)

Bug Fixes

• types: add instance.dataValues property to model.d.ts (#15240) (00c6da3)