sequelize
4.3/5209

sequelize

npm i sequelize

600 Versions

6.27.0

latest
2 months ago
6.27.0 (2022-12-12) Features

6.26.0

2 months ago
6.26.0 (2022-11-29) Features

6.25.8

3 months ago
6.25.8 (2022-11-22) Bug Fixes

6.25.7

3 months ago
6.25.7 (2022-11-19) Bug Fixes
  • fix parameters not being replaced when after $$ strings (#15307) (bc39fd6)

6.25.6

3 months ago
6.25.6 (2022-11-15) Bug Fixes

6.25.5

3 months ago
6.25.5 (2022-11-07) Bug Fixes

6.25.4

3 months ago
6.25.4 (2022-11-05) Bug Fixes
  • types: add instance.dataValues property to model.d.ts (#15240) (00c6da3)

6.25.3

4 months ago
6.25.3 (2022-10-19) Bug Fixes
  • don't treat \ as escape in standard strings, support E-strings, support vars after ->> operator, treat lowercase e as valid e-string prefix (#15139) (7990095), closes #14700

6.25.2

4 months ago
6.25.2 (2022-10-15) Bug Fixes
  • types: fix TS 4.9 excessive depth error on InferAttributes (v6) (#15135) (851daaf)

6.25.1

4 months ago
6.25.1 (2022-10-13) Bug Fixes
  • types: expose legacy "types" folder in export alias ( #15123) (9dd93b8)

6.25.0

4 months ago
6.25.0 (2022-10-11) Features
  • oracle: add support for dialectOptions.connectString (#15042) (06ad05d)

6.24.0

4 months ago
6.24.0 (2022-10-04) Features
  • snowflake: Add support for QueryGenerator#tableExistsQuery (#15087) (a44772e)

6.23.2

4 months ago
6.23.2 (2022-09-27) Bug Fixes
  • postgres: add custom order direction to subQuery ordering with minified alias (#15056) (7203b66)

6.23.1

4 months ago
6.23.1 (2022-09-22) Bug Fixes

6.23.0

5 months ago
6.23.0 (2022-09-17) Features

6.22.1

5 months ago
6.22.1 (2022-09-16) Bug Fixes

6.22.0

5 months ago
6.22.0 (2022-09-15) Features

6.21.6

5 months ago
6.21.6 (2022-09-09) Bug Fixes

6.21.5

5 months ago
6.21.5 (2022-09-08) Bug Fixes
  • mariadb: do not automatically parse JSON fields (#14800) (d047f32)

6.21.4

6 months ago
6.21.4 (2022-08-18) Bug Fixes
  • minified aliases are now properly referenced in subqueries (v6) (#14852) (5a257bc), closes #14804

6.21.3

7 months ago
6.21.3 (2022-07-11) Bug Fixes
  • postgres: attach postgres error-handler earlier in lifecycle (v6) (#14731) (90bb694)

6.21.2

7 months ago
6.21.2 (2022-06-28) Bug Fixes

6.21.1

7 months ago
6.21.1 (2022-06-25) Bug Fixes
  • postgres: use schema set in sequelize config by default (#14665) (2f3b924)

6.21.0

8 months ago
6.21.0 (2022-06-16) Features
  • exports types to support typescript >= 4.5 nodenext module (#14620) (cbdf73e)

6.20.1

8 months ago
6.20.1 (2022-05-27) Bug Fixes

6.20.0

8 months ago
6.20.0 (2022-05-23) Features

6.19.2

9 months ago
6.19.2 (2022-05-18) Bug Fixes
  • accept replacements in ARRAY[] & followed by ; (#14518) (e37c572)

6.19.1

9 months ago
6.19.1 (2022-05-17) Bug Fixes
  • do not replace :replacements inside of strings (#14472) (ccaa399)

āš ļø BREAKING CHANGE: This change is a security fix that patches a serious SQL injection vulnerability, however it is possible that your application made use of it and broke as a result of this change. Please see this issue for more information.


6.19.0

10 months ago
6.19.0 (2022-04-12) Bug Fixes Features
  • types: make Model.init aware of pre-configured foreign keys (#14370) (5954d2c)

6.18.0

10 months ago
6.18.0 (2022-04-03) Features
  • add whereScopeStrategy to merge where scopes with Op.and (#14152) (8349c02)

6.17.0

1 year ago
6.17.0 (2022-02-25) Bug Fixes Features
  • types: infer nullable creation attributes as optional (#14147) (f5c06bd)
  • types: make Model.getAttributes stricter (#14017) (e974e20)

6.16.3

1 year ago
6.16.3 (2022-02-24) Bug Fixes

6.16.2

1 year ago
6.16.2 (2022-02-18) Bug Fixes

7.0.0-alpha.9

alpha
1 year ago
7.0.0-alpha.9 (2022-02-15) Features
  • forbid using attr names that are ambiguous with $nested.syntax$ (#13992) (b3c2270)

7.0.0-alpha.8

1 year ago
7.0.0-alpha.8 (2022-02-11) Features
  • forbid using attr names that are ambiguous with $nested.syntax$ (#13992) (bd96cb8)

7.0.0-alpha.7

1 year ago
7.0.0-alpha.7 (2022-02-10) Features

6.16.1

1 year ago
6.16.1 (2022-02-09) Bug Fixes
  • correct path to package.json in Sequelize.version (#14073) (b95c213)

6.16.0

1 year ago
6.16.0 (2022-02-08) Features
  • gen /lib & /types from /src & drop /dist (v6) (#14063) (6b8fbb4)

7.0.0-alpha.6

1 year ago
7.0.0-alpha.6 (2022-02-07) Bug Fixes
  • don't call overloaded versions of find functions internally (#13951) (e5d02ef)
  • fix typings for queries with {plain: true} option (#13899) (d139b2e)
  • model.d: fix type for count and findAndCountAll (#13786) (cf27c66)
  • types: accept $nested.syntax$ in WhereAttributeHash (#13983) (f72bb1e)
  • types: add hooks to InstanceDestroyOptions type (#13491) (6d4b553)
  • types: add missing fields to FindOr{Create,Build}Options (#13389) (81b0b9d)
  • types: correct typing definitions for Sequelize.where (#14018) (308ace0)
  • types: deduplicate error typings (#14002) (3f75880)
  • types: fix QueryInterface#bulkInsert attribute arg type (#13945) (36ad644)
  • types: improve branded types (#13990) (940060a)
Features

6.15.1

1 year ago
6.15.1 (2022-02-06) Bug Fixes

6.15.0

1 year ago
6.15.0 (2022-01-29) Bug Fixes Features
  • add options.rawErrors to Sequelize#query method (#13881) (7c58851)

6.14.1

1 year ago
6.14.1 (2022-01-25) Bug Fixes

6.14.0

1 year ago
6.14.0 (2022-01-22) Bug Fixes
  • don't call overloaded versions of find functions internally (#13951) (fc53cdb)
  • don't call overloaded versions of find functions internally (#13951) (b253d8e)
  • model.d: fix type for count and findAndCountAll (#13786) (b06c1fc)
  • types: add hooks to InstanceDestroyOptions type (#13491) (dbd9ea8)
  • types: add missing fields to FindOr{Create,Build}Options (#13389) (ef63f8f)
  • types: fix QueryInterface#bulkInsert attribute arg type (#13945) (9e108e3)
Features

6.13.0

1 year ago
6.13.0 (2022-01-10) Bug Fixes
  • fix typings for queries with {plain: true} option (#13899) (308d017)
Features

7.0.0-alpha.5

1 year ago
7.0.0-alpha.5 (2022-01-04) Bug Fixes
  • dialect: sequelize pool doesn't take effect in dialect "mssql" (#13880) (1e2b771)
  • model: fix count with grouping typing (#13884) (c206337), closes #13871
  • types: improve ModelCtor / ModelStatic typing (#13890) (d355822)
  • types: omit FK and scope keys in HasManyCreateAssociationMixin (#13892) (e23e422)
Reverts
  • Revert "ci: temporarily disable tests" (0ed16e9)

7.0.0-alpha2.2

1 year ago
7.0.0-alpha2.2 (2022-01-04) Bug Fixes
  • dialect: sequelize pool doesn't take effect in dialect "mssql" (#13880) (1e2b771)
  • model: fix count with grouping typing (#13884) (c206337), closes #13871
  • types: improve ModelCtor / ModelStatic typing (#13890) (d355822)
  • types: omit FK and scope keys in HasManyCreateAssociationMixin (#13892) (e23e422)
Reverts
  • Revert "ci: temporarily disable tests" (0ed16e9)
  • Revert "ci: disable all test steps temporarily" (a699e6f)

6.12.5

1 year ago
6.12.5 (2022-01-04) Bug Fixes
  • dialect: sequelize pool doesn't take effect in dialect "mssql" (#13880) (fc155b6)
  • model: fix count with grouping typing (#13884) (49beb29), closes #13871
  • types: improve ModelCtor / ModelStatic typing (#13890) (34aa808)
  • types: omit FK and scope keys in HasManyCreateAssociationMixin (#13892) (b315ce8)

7.0.0-alpha2.1

1 year ago
7.0.0-alpha2.1 (2022-01-04) Bug Fixes
  • data-types: moment object throwing error (#13818) (cdd1760)
  • mssql/async-queue: fix unable to start mysql due to circular ref (#13823) (2a2cc05)
  • semantic-release should not push beta or alpha to default channel (#13863) (250a315)
Continuous Integration
  • releases: prepare v7 alpha releases (6e597c6)
  • releases: prepare v7 alpha releases (98ad525)
BREAKING CHANGES
  • releases: This commit prepares the new v7 alpha development branch.
  • releases: This commit prepares the new v7 alpha development branch.

7.0.0-alpha.4

1 year ago
7.0.0-alpha.4 (2022-01-01) Bug Fixes
  • mssql/async-queue: fix unable to start mysql due to circular ref (#13823) (2a2cc05)
  • semantic-release should not push beta or alpha to default channel (#13863) (250a315)

6.12.4

1 year ago
6.12.4 (2021-12-28) Bug Fixes
  • mssql/async-queue: fix unable to start mysql due to circular ref (#13823) (49e8614)

7.0.0-alpha.3

1 year ago
7.0.0-alpha.3 (2021-12-27) Bug Fixes Continuous Integration
  • releases: prepare v7 alpha releases (6e597c6)
BREAKING CHANGES
  • releases: This commit prepares the new v7 alpha development branch.

6.12.3

1 year ago
6.12.3 (2021-12-27) Bug Fixes

7.0.0-alpha.2

1 year ago
7.0.0-alpha.2 (2021-12-23) Reverts
  • Revert "ci(release): temporary disable major-release-fail" (cd5a605)

7.0.0-alpha.1

1 year ago
7.0.0-alpha.1 (2021-12-23) Continuous Integration
  • releases: prepare v7 alpha releases (98ad525)
BREAKING CHANGES
  • releases: This commit prepares the new v7 alpha development branch.

6.12.2

1 year ago
6.12.2 (2021-12-22) Bug Fixes
  • abstract: patch jsonb operator for pg if value is json (#13780) (a2375c5)
  • operators: fix ts support for operators.ts (#13805) (b532ab1)
  • postgres: allows usage of schema for ARRAY(ENUM) type name (#13807) (da5b0ce)
  • query-interface: bring back quoteIdentifier(s) to queryInterface (#13810) (001dc60)

5.22.5

v5
1 year ago
5.22.5 (2021-12-21) Bug Fixes
  • dependencies: update validator dependency to latest version (#13802) (9f47e94)

6.12.1

1 year ago
6.12.1 (2021-12-21) Bug Fixes

6.12.0

1 year ago
6.12.0 (2021-12-17) Bug Fixes
  • data-types: unnecessary warning when getting data with DATE dataTypes (#13712) (121884b)
  • docs: add aws-lamda route (#13693) (3059bce)
  • example: fix coordinates format as per GeoJson (#13718) (f9dec20)
  • increment: fix key value broken query (#12985) (fc0b19e)
  • model.d: fix findAndCountAll.count type (#13736) (b7b472e)
  • snowflake: fix to prevent disconnect attempt on already disconnected connection (#13775) (2a9a551)
  • types: add Col to where Ops (#13717) (2d7b865)
  • types: add instance member declaration (#13684) (ae3cde5)
  • types: add missing schema field to sequelize options (c7a0839), closes #12606
  • types: allow override json function with custom return type (#13694) (2c3b384)
  • upsert: fall back to DO NOTHING if no update key values provided (#13594) (4071378)
  • upsert: fall back to DO NOTHING if no update key values provided (#13711) (f9dfaa7), closes #13594
  • wrong interface used within mixin (#13685) (bd3ddf5)
Features

6.12.0-beta.3

1 year ago
6.12.0-beta.3 (2021-12-12) Features
  • model: complete getAttributes feature (b6510df)
  • upsert: add conflictFields option (#13723) (496bede)

6.12.0-beta.2

1 year ago
6.12.0-beta.2 (2021-12-10) Features

6.12.0-beta.1

1 year ago
6.12.0-beta.1 (2021-12-04) Bug Fixes
  • data-types: unnecessary warning when getting data with DATE dataTypes (#13712) (121884b)
  • docs: add aws-lamda route (#13693) (3059bce)
  • example: fix coordinates format as per GeoJson (#13718) (f9dec20)
  • increment: fix key value broken query (#12985) (fc0b19e)
  • types: add Col to where Ops (#13717) (2d7b865)
  • types: add instance member declaration (#13684) (ae3cde5)
  • types: add missing schema field to sequelize options (c7a0839), closes #12606
  • types: allow override json function with custom return type (#13694) (2c3b384)
  • upsert: fall back to DO NOTHING if no update key values provided (#13594) (4071378)
  • upsert: fall back to DO NOTHING if no update key values provided (#13711) (f9dfaa7), closes #13594
  • wrong interface used within mixin (#13685) (bd3ddf5)
Features
  • dialect: snowflake dialect support (#13406) (ad68a5e)
  • typescript: create alpha release with ts (911125e)

6.12.0-alpha.1

1 year ago
6.12.0-alpha.1 (2021-11-19) Features
  • typescript: create alpha release with ts (8b2854a)

6.11.0

1 year ago
6.11.0 (2021-11-18) Features

6.10.0

1 year ago
6.10.0 (2021-11-18) Bug Fixes
  • typing on creation within an association (#13678) (0312f8e)
  • logger: change logging depth from 3 to 1 (#12879) (ddddc24)
  • mariadb: fix MariaDB 10.5 JSON (#13633) (cdd61dd)
  • model: clone options object instead of modifying (#13589) (3be43de)
  • mssql: fix sub query issue occurring with renamed primary key fields (#12801) (73d99ab)
  • mssql: sqlserver 2008 fix for using offsets and include criteria (47c4494)
  • query: make stacktraces include original calling code (#13347) (f581543)
  • types: Add missing type definitions in models (#13553) (73ecf6c)
  • types: add specifc tojson type in model.d.ts (#13661) (5924be5)
  • types: DataType.TEXT overloading definition (#13654) (1690801)
  • types: include 'paranoid' in IncludeThroughOptions definition (#13625) (b1fb1f3)
  • types: ne op documentation (#13666) (98485df)
  • types: rename types and update CONTRIBUTING docs (#13348) (1f23924)
  • expect result is null but got zero (#13637) (da3ac09)
Features
  • definitions: Adds AbstractQuery and before/afterQuery hook definitions (#13635) (37a5858)
  • postgresql: easier SSL config and options param support (#13673) (9591573)

6.9.0

1 year ago
6.9.0 (2021-11-01) Bug Fixes
  • docs: using incorrect esdocs syntax (#13615) (c3c690b)
  • sqlite: quote table names in sqlite getForeignKeysQuery (#13587) (eeb6a8f)
  • upsert: do not overwrite an explcit created_at during upsert (#13593) (594cee8)
Features

6.8.0

1 year ago
6.8.0 (2021-10-24) Bug Fixes
  • types: allow any values in isIn validator (#12962) (d511d91)
  • allows insert primary key with zero (#13458) (e4aff2f)
  • model: Convert number values only if they aren't null to avoid NaN (199b632)
  • model.d: accept [Op.is] in where (broken in TypeScript 4.4) (#13499) (d685a9a)
  • postgres: fix findCreateFind to work with postgres transactions (#13482) (84421d7)
  • select: do not force set subQuery to false (#13490) (0943339)
  • sqlite: fix wrongly overwriting storage if empty string (#13376) (c3e608b), closes #13375
  • types: add missing upsert hooks (#13394) (5e9c209)
  • types: extend BulkCreateOptions by SearchPathable (#13469) (47c2d05), closes #13454
  • types: typo in model.d.ts (#13574) (31d0fbc)
Features

6.7.0

1 year ago
6.7.0 (2021-10-09) Bug Fixes
  • deps: upgrade to secure versions of dev deps (#13549) (cf53734)
  • docs: fix typo in documentation for polymorphic associations (#13405) (bbf3d76)
  • types: allow rangable to take a string tuple (#13486) (ca2a11a)
Features
  • test: add test for nested column in where query (#13478) (26b62c7), closes #13288
  • types: make config type deeply writeable for before connect hook (#13424) (f078f77)

6.6.5

2 years ago
6.6.5 (2021-07-06) Bug Fixes

6.6.4

2 years ago
6.6.4 (2021-06-26) Bug Fixes
  • typings: make Transactionable compatible with TransactionOptions (#13334) (cd2de40)
  • utils: clone attributes before mutating them (#13226) (1a16b91)
  • data-types: use proper field name for ARRAY(ENUM) (#13210) (1cfbd33)
  • typings: fix ignoreDuplicates option (#13220) (b33d78e)
  • typings: allow schema for queryInterface methods (#13223) (6b0b532)
  • typings: restrict update typings (#13216) (63ceb73)
  • typings: returning can specify column names (#13215) (143cc84)
  • typings: model init returns model class, not instance (#13214) (8f2a0d5)
  • plurals: bump inflection dependency (#13260) (deeb5c6)
  • bulk-create: ON CONFLICT with unique index (#13345) (6dcb565)

6.6.2

2 years ago
6.6.2 (2021-03-23) Bug Fixes

6.6.1

2 years ago
6.6.1 (2021-03-22) Bug Fixes
  • query-generator: use AND in sql for not/between (#13043) (a663c54)
  • sqlite: retrieve primary key on upsert (#12991) (023e1d9)
  • types: allow (keyof TAttributes)[] in UpdateOptions.returning (#13130) (97ba242)
  • types: models with attributes couldn't be used in some cases (#13010) (de5f21d)
  • types: remove string from Order type (#13057) (ac39f8a)

6.6.0

2 years ago
6.6.0 (2021-03-21) Bug Fixes Features

5.22.4

2 years ago
5.22.4 (2021-03-14) Bug Fixes

6.5.1

2 years ago
6.5.1 (2021-03-14) Bug Fixes
  • mysql: release connection on deadlocks (#13102) (6388507)
    • Note: this complements the work done in 6.5.0, fixing another situation not covered by it with MySQL.
  • types: allow transaction to be null (#13093) (ced4dc7)

6.5.0

2 years ago
6.5.0 (2021-01-27)

Second release in 2021! šŸŽ‰

Bug Fixes
  • mysql, mariadb: release connection on deadlocks (#12841) (c77b1f3)
  • types: allow changing values on before hooks (#12970) (e5b8929)
  • types: typo in sequelize.js and sequelize.d.ts (#12975) (2fe980e)
Features
  • postgres: add TSVECTOR datatype and @@ operator (#12955) (e45df29)

6.4.0

2 years ago
6.4.0 (2021-01-18)

First release in 2021! šŸŽ‰

Bug Fixes
  • types: better support for readonly arrays (287607a)
  • types: remove part forgotten in #12175 (2249ded)
Features
  • query-interface: support composite foreign keys (#12456) (9ecebef)

6.3.5

2 years ago
6.3.5 (2020-09-01) Bug Fixes
  • truncate: fix missing await in truncate all models with cascade (#12664) (933b3f6)

6.3.4

3 years ago
6.3.4 (2020-08-01) Bug Fixes

6.3.3

3 years ago
6.3.3 (2020-07-11) Bug Fixes
  • mark database drivers as optional peer dependencies (#12484) (ec2af0d)

6.3.2

3 years ago
6.3.2 (2020-07-11) Bug Fixes

6.3.1

3 years ago
6.3.1 (2020-07-10) Bug Fixes

6.3.0

3 years ago
6.3.0 (2020-07-04) Bug Fixes Features
  • types: Add ModelDefined type as syntactic sugar (#12445) (5cabcbc)

6.2.4

3 years ago
6.2.4 (2020-07-01) Bug Fixes

5.22.3

3 years ago
5.22.3 (2020-06-30) Bug Fixes
  • sqlite: describeTable now returns unique and references (#12440) (3d2df28)

6.2.3

3 years ago
6.2.3 (2020-06-28) Bug Fixes
  • sqlite: describeTable now returns unique constraint and references (#12420) (2de3377)

6.2.2

3 years ago
6.2.2 (2020-06-27) Bug Fixes
  • types: fixed types for model.init and sequelize.define; update docs (#12435) (9c446f9)

6.2.1

3 years ago
6.2.1 (2020-06-27) Bug Fixes
  • mssql: insert/upsert operations do not return all fields (#12433) (aeb318a)

5.22.2

3 years ago
5.22.2 (2020-06-27) Bug Fixes
  • mssql: insert/upsert operations do not return all fields (#12434) (56d07c6)

6.2.0

3 years ago
6.2.0 (2020-06-26) Bug Fixes Features
  • types: added optional stricter typing for Model attributes (#12405) (871157b)

5.22.1

3 years ago
5.22.1 (2020-06-26) Bug Fixes

6.1.1

3 years ago
6.1.1 (2020-06-26) Bug Fixes

6.1.0

3 years ago

Sequelize v6 is the next major release after v5. Below is a list of breaking changes to help you upgrade.

Breaking Changes Support for Node 10 and up

Sequelize v6 will only support Node 10 and up #10821.

CLS

You should now use cls-hooked package for CLS support.

  const cls = require('cls-hooked');
  const namespace = cls.createNamespace('....');
  const Sequelize = require('sequelize');

  Sequelize.useCLS(namespace);
Database Engine Support

We have updated our minimum supported database engine versions. Using older database engine will show SEQUELIZE0006 deprecation warning. Please check ENGINE.md for version table.

Sequelize
  • Bluebird has been removed. Internally all methods are now using async/await. Public API now returns native promises. Thanks to Andy Edwards for this refactor work.
  • Sequelize.Promise is no longer available.
  • sequelize.import method has been removed.
Model options.returning

Option returning: true will no longer return attributes that are not defined in the model. Old behavior can be achieved by using returning: ['*'] instead.

Model.changed()

This method now tests for equality with _.isEqual and is now deep aware for JSON objects. Modifying a nested value for a JSON object won't mark it as changed (since it is still the same object).

  const instance = await MyModel.findOne();

  instance.myJsonField.someProperty = 12345; // Changed from something else to 12345
  console.log(instance.changed()); // false

  await instance.save(); // this will not save anything

  instance.changed('myJsonField', true);
  console.log(instance.changed()); // ['myJsonField']

  await instance.save(); // will save
Model.bulkCreate()

This method now throws Sequelize.AggregateError instead of Bluebird.AggregateError. All errors are now exposed as errors key.

Model.upsert()

Native upsert is now supported for all dialects.

const [instance, created] = await MyModel.upsert({});

Signature for this method has been changed to Promise<Model,boolean | null>. First index contains upserted instance, second index contains a boolean (or null) indicating if record was created or updated. For SQLite/Postgres, created value will always be null.

  • MySQL - Implemented with ON DUPLICATE KEY UPDATE
  • PostgreSQL - Implemented with ON CONFLICT DO UPDATE
  • SQLite - Implemented with ON CONFLICT DO UPDATE
  • MSSQL - Implemented with MERGE statement

Note for Postgres users: If upsert payload contains PK field, then PK will be used as the conflict target. Otherwise first unique constraint will be selected as the conflict key.

QueryInterface addConstraint

This method now only takes 2 parameters, tableName and options. Previously the second parameter could be a list of column names to apply the constraint to, this list must now be passed as options.fields property.

Changelog 6.0.0-beta.7
  • docs(associations): belongs to many create with through table
  • docs(query-interface): fix broken links #12272
  • docs(sequelize): omitNull only works for CREATE/UPDATE queries
  • docs: asyncify #12297
  • docs: responsive #12308
  • docs: update feature request template
  • feat(postgres): native upsert #12301
  • feat(sequelize): allow passing dialectOptions.options from url #12404
  • fix(include): check if attributes specified for included through model #12316
  • fix(model.destroy): return 0 with truncate #12281
  • fix(mssql): empty order array generates invalid FETCH statement #12261
  • fix(postgres): parse enums correctly when describing a table #12409
  • fix(query): ensure correct return signature for QueryTypes.RAW #12305
  • fix(query): preserve cls context for logger #12328
  • fix(query-generator): do not generate GROUP BY clause if options.group is empty #12343
  • fix(reload): include default scope #12399
  • fix(types): add Association into OrderItem type #12332
  • fix(types): add clientMinMessages to Options interface #12375
  • fix(types): transactionType in Options #12377
  • fix(types): add support for optional values in "where" clauses #12337
  • fix(types): add missing fields to 'FindOrCreateType' #12338
  • fix: add missing sql and parameters properties to some query errors #12299
  • fix: remove custom inspect #12262
  • refactor: cleanup query generators #12304
6.0.0-beta.6
  • docs(add-constraint): options.fields support
  • docs(association): document uniqueKey for belongs to many #12166
  • docs(association): options.through.where support
  • docs(association): use and instead of 'a nd' #12191
  • docs(association): use correct scope name #12204
  • docs(manuals): avoid duplicate header ids #12201
  • docs(model): correct syntax error in example code #12137
  • docs(query-interface): removeIndex indexNameOrAttributes #11947
  • docs(resources): add sequelize-guard library #12235
  • docs(typescript): fix confusing comments #12226
  • docs(v6-guide): bluebird removal API changes
  • docs: database version support info #12168
  • docs: remove remaining bluebird references #12167
  • feat(belongs-to-many): allow creation of paranoid join tables #12088
  • feat(belongs-to-many): get/has/count for paranoid join table #12256
  • feat(pool): expose maxUses pool config option #12101
  • feat(postgres): minify include aliases over limit #11940
  • feat(sequelize): handle query string host value #12041
  • fix(associations): ensure correct schema on all generated attributes #12258
  • fix(docs/instances): use correct variable for increment #12087
  • fix(include): separate queries are not sub-queries #12144
  • fix(model): fix unchained promise in association logic in bulkCreate #12163
  • fix(model): updateOnDuplicate handles composite keys #11984
  • fix(model.count): distinct without any column generates invalid SQL #11946
  • fix(model.reload): ignore options.where and always use this.where() #12211
  • fix(mssql) insert record failure because of BOOLEAN column type #12090
  • fix(mssql): cast sql_variant in query generator #11994
  • fix(mssql): dont use OUTPUT INSERTED for update without returning #12260
  • fix(mssql): duplicate order in FETCH/NEXT queries #12257
  • fix(mssql): set correct scale for float #11962
  • fix(mssql): tedious v9 requires connect call #12182
  • fix(mssql): use uppercase for engine table and columns #12212
  • fix(pool): show deprecation when engine is not supported #12218
  • fix(postgres): addColumn support ARRAY(ENUM) #12259
  • fix(query): do not bind $ used within a whole-word #12250
  • fix(query-generator): handle literal for substring based operators #12210
  • fix(query-interface): allow passing null for query interface insert #11931
  • fix(query-interface): allow sequelize.fn and sequelize.literal in fields of IndexesOptions #12224
  • fix(scope): don't modify original scope definition #12207
  • fix(sqlite): multiple primary keys results in syntax error #12237
  • fix(sync): pass options to all query methods #12208
  • fix(typings): add type_helpers to file list #12000
  • fix(typings): correct Model.init return type #12148
  • fix(typings): fn is assignable to where #12040
  • fix(typings): getForeignKeysForTables argument definition #12084
  • fix(typings): make between operator accept date ranges #12162
  • refactor(ci): improve database wait script #12132
  • refactor(tsd-test-setup): add & setup dtslint #11879
  • refactor: move all dialect conditional logic into subclass #12217
  • refactor: remove sequelize.import helper #12175
  • refactor: use native versions #12159
  • refactor: use object spread instead of Object.assign #12213
6.0.0-beta.5
  • fix(find-all): throw on empty attributes #11867
  • fix(types): queryInterface.addIndex #11844
  • fix(types): plain option in sequelize.query #11596
  • fix(types): correct overloaded method order #11727
  • fix(types): comparator arg of Sequelize.where #11843
  • fix(types): fix BelongsToManyGetAssociationsMixinOptions #11818
  • fix(types): adds hooks to CreateOptions #11736
  • fix(increment): broken queries #11852
  • fix(associations): gets on many-to-many with non-primary target key #11778
  • fix: properly select SRID if present #11763
  • feat(sqlite): automatic path provision for options.storage #11853
  • feat(postgres): idle_in_transaction_session_timeout connection option #11775
  • feat(index): improve to support multiple fields with operator #11934
  • docs(transactions): fix addIndex example and grammar #11759
  • docs(raw-queries): remove outdated info #11833
  • docs(optimistic-locking): fix missing manual #11850
  • docs(model): findOne return value for empty result #11762
  • docs(model-querying-basics.md): add some commas #11891
  • docs(manuals): fix missing models-definition page #11838
  • docs(manuals): extensive rewrite #11825
  • docs(dialect-specific): add MSSQL domain auth example #11799
  • docs(associations): fix typos in assocs manual #11888
  • docs(associations): fix typo #11869
6.0.0-beta.4
  • feat(sync): allow to bypass drop statements when sync with alter enabled #11708
  • fix(model): injectDependentVirtualAttrs on included models #11713
  • fix(model): generate ON CONFLICT ... DO UPDATE correctly #11666
  • fix(mssql): optimize formatError RegEx #11725
  • fix(types): add getForeignKeyReferencesForTable type #11738
  • fix(types): add 'restore' hooks to types #11730
  • fix(types): added 'fieldMaps' to QueryOptions typings #11702
  • fix(types): add isSoftDeleted to Model #11628
  • fix(types): fix upsert typing #11674
  • fix(types): specified 'this' for getters and setters in fields #11648
  • fix(types): add paranoid to UpdateOptions interface #11647
  • fix(types): include 'as' in IncludeThroughOptions definition #11624
  • fix(types): add Includeable to IncludeOptions.include type #11622
  • fix(types): transaction lock #11620
  • fix(sequelize.fn): escape dollarsign (#11533) #11606
  • fix(types): add nested to Includeable #11354
  • fix(types): add date to where #11612
  • fix(types): add getDatabaseName (#11431) #11614
  • fix(types): beforeDestroy #11618
  • fix(types): query-interface table schema #11582
  • docs: README.md #11698
  • docs(sequelize): detail options.retry usage #11643
  • docs: clarify logging option in Sequelize constructor #11653
  • docs(migrations): fix syntax error in example #11626
  • docs: describe logging option #11654
  • docs(transaction): fix typo #11659
  • docs(hooks): add info about belongs-to-many #11601
  • docs(associations): fix typo #11592
6.0.0-beta.3
  • feat: support cls-hooked / tests #11584
6.0.0-beta.2
  • feat(postgres): change returning option to only return model attributes #11526
  • fix(associations): allow binary key for belongs-to-many #11578
  • fix(postgres): always replace returning statement for upsertQuery
  • fix(model): make .changed() deep aware #10851
  • change: use node 10 #11580

5.22.0

3 years ago
5.22.0 (2020-06-24) Bug Fixes Features
  • sequelize: allow passing dialectOptions.options from url (#12412) (2391d08)

6.0.0-beta.7

3 years ago

5.21.13

3 years ago
5.21.13 (2020-06-14) Bug Fixes
  • types: specified 'this' for getters and setters in fields (#12370) (7fba668)

5.21.12

3 years ago
5.21.12 (2020-06-05) Bug Fixes

5.21.11

3 years ago
5.21.11 (2020-05-26) Bug Fixes
  • include: check if attributes specified for included through model (#12020) (5c733ef)

5.21.10

3 years ago
5.21.10 (2020-05-19) Bug Fixes

6.0.0-beta.6

3 years ago
6.0.0-beta.6
  • docs(add-constraint): options.fields support
  • docs(association): document uniqueKey for belongs to many #12166
  • docs(association): options.through.where support
  • docs(association): use and instead of 'a nd' #12191
  • docs(association): use correct scope name #12204
  • docs(manuals): avoid duplicate header ids #12201
  • docs(model): correct syntax error in example code #12137
  • docs(query-interface): removeIndex indexNameOrAttributes #11947
  • docs(resources): add sequelize-guard library #12235
  • docs(typescript): fix confusing comments #12226
  • docs(v6-guide): bluebird removal API changes
  • docs: database version support info #12168
  • docs: remove remaining bluebird references #12167
  • feat(belongs-to-many): allow creation of paranoid join tables #12088
  • feat(belongs-to-many): get/has/count for paranoid join table #12256
  • feat(pool): expose maxUses pool config option #12101
  • feat(postgres): minify include aliases over limit #11940
  • feat(sequelize): handle query string host value #12041
  • fix(associations): ensure correct schema on all generated attributes #12258
  • fix(docs/instances): use correct variable for increment #12087
  • fix(include): separate queries are not sub-queries #12144
  • fix(model): fix unchained promise in association logic in bulkCreate #12163
  • fix(model): updateOnDuplicate handles composite keys #11984
  • fix(model.count): distinct without any column generates invalid SQL #11946
  • fix(model.reload): ignore options.where and always use this.where() #12211
  • fix(mssql) insert record failure because of BOOLEAN column type #12090
  • fix(mssql): cast sql_variant in query generator #11994
  • fix(mssql): dont use OUTPUT INSERTED for update without returning #12260
  • fix(mssql): duplicate order in FETCH/NEXT queries #12257
  • fix(mssql): set correct scale for float #11962
  • fix(mssql): tedious v9 requires connect call #12182
  • fix(mssql): use uppercase for engine table and columns #12212
  • fix(pool): show deprecation when engine is not supported #12218
  • fix(postgres): addColumn support ARRAY(ENUM) #12259
  • fix(query): do not bind $ used within a whole-word #12250
  • fix(query-generator): handle literal for substring based operators #12210
  • fix(query-interface): allow passing null for query interface insert #11931
  • fix(query-interface): allow sequelize.fn and sequelize.literal in fields of IndexesOptions #12224
  • fix(scope): don't modify original scope definition #12207
  • fix(sqlite): multiple primary keys results in syntax error #12237
  • fix(sync): pass options to all query methods #12208
  • fix(typings): add type_helpers to file list #12000
  • fix(typings): correct Model.init return type #12148
  • fix(typings): fn is assignable to where #12040
  • fix(typings): getForeignKeysForTables argument definition #12084
  • fix(typings): make between operator accept date ranges #12162
  • refactor(ci): improve database wait script #12132
  • refactor(tsd-test-setup): add & setup dtslint #11879
  • refactor: move all dialect conditional logic into subclass #12217
  • refactor: remove sequelize.import helper #12175
  • refactor: use native versions #12159
  • refactor: use object spread instead of Object.assign #12213

5.21.9

3 years ago
5.21.9 (2020-05-14) Bug Fixes
  • mssql: use uppercase for engine table and columns (#12253) (8a3827d)

600 Versions

TagPublished
6.27.0latest2mos ago
6.26.02mos ago
6.25.83mos ago
6.25.73mos ago
6.25.63mos ago
6.25.53mos ago
6.25.43mos ago
6.25.34mos ago
6.25.24mos ago
6.25.14mos ago
6.25.04mos ago
6.24.04mos ago
6.23.24mos ago
6.23.14mos ago
6.23.05mos ago
6.22.15mos ago
6.22.05mos ago
6.21.65mos ago
6.21.55mos ago
6.21.46mos ago
6.21.37mos ago
6.21.27mos ago
6.21.17mos ago
6.21.08mos ago
6.20.18mos ago
6.20.08mos ago
6.19.29mos ago
6.19.19mos ago
6.19.010mos ago
6.18.010mos ago
6.17.01yr ago
6.16.31yr ago
6.16.21yr ago
7.0.0-alpha.9alpha1yr ago
7.0.0-alpha.81yr ago
7.0.0-alpha.71yr ago
6.16.11yr ago
6.16.01yr ago
7.0.0-alpha.61yr ago
6.15.11yr ago
6.15.01yr ago
6.14.11yr ago
6.14.01yr ago
6.13.01yr ago
7.0.0-alpha.51yr ago
7.0.0-alpha2.21yr ago
6.12.51yr ago
7.0.0-alpha2.11yr ago
7.0.0-alpha.41yr ago
6.12.41yr ago
7.0.0-alpha.31yr ago
6.12.31yr ago
7.0.0-alpha.21yr ago
7.0.0-alpha.11yr ago
6.12.21yr ago
5.22.5v51yr ago
6.12.11yr ago
6.12.01yr ago
6.12.0-beta.31yr ago
6.12.0-beta.21yr ago
6.12.0-beta.11yr ago
6.12.0-alpha.11yr ago
6.11.01yr ago
6.10.01yr ago
6.9.01yr ago
6.8.01yr ago
6.7.01yr ago
6.6.52yrs ago
6.6.42yrs ago
6.6.22yrs ago
6.6.12yrs ago
6.6.02yrs ago
5.22.42yrs ago
6.5.12yrs ago
6.5.02yrs ago
6.4.02yrs ago
6.3.52yrs ago
6.3.43yrs ago
6.3.33yrs ago
6.3.23yrs ago
6.3.13yrs ago
6.3.03yrs ago
6.2.43yrs ago
5.22.33yrs ago
6.2.33yrs ago
6.2.23yrs ago
6.2.13yrs ago
5.22.23yrs ago
6.2.03yrs ago
5.22.13yrs ago
6.1.13yrs ago
6.1.03yrs ago
5.22.03yrs ago
6.0.0-beta.73yrs ago
5.21.133yrs ago
5.21.123yrs ago
5.21.113yrs ago
5.21.103yrs ago
6.0.0-beta.63yrs ago
5.21.93yrs ago