Upgrade to v6

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

Sequelize

• Bluebird has been removed. Public API now returns native promises.
• 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.

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.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