Mixin BelongsToMany

View code

Many-to-many association with a join table.

When the join table has additional attributes, these can be passed in the options object:

UserProject = sequelize.define('user_project', {
  role: Sequelize.STRING
});
User.belongsToMany(Project, { through: UserProject });
Project.belongsToMany(User, { through: UserProject });
// through is required!

user.addProject(project, { role: 'manager', transaction: t });

All methods allow you to pass either a persisted instance, its primary key, or a mixture:

Project.create({ id: 11 }).then(function (project) {
  user.addProjects([project, 12]);
});

In the API reference below, replace Assocation(s) with the actual name of your association, e.g. for User.belongsToMany(Project) the getter will be user.getProjects().


getAssociations([options]) -> Promise.<Array.<Instance>>

View code

Get everything currently associated with this, using an optional where clause.

Params:

Name Type Description
[options] Object
[options.where] Object An optional where clause to limit the associated models
[options.scope] String | Boolean Apply a scope on the related model, or remove its default scope by passing false
[options.schema] String Apply a schema on the related model

setAssociations([newAssociations], [options]) -> Promise

View code

Set the associated models by passing an array of instances or their primary keys. Everything that it not in the passed array will be un-associated.

Params:

Name Type Description
[newAssociations] Array.<Instance | String | Number> An array of persisted instances or primary key of instances to associate with this. Pass null or undefined to remove all associations.
[options] Object Options passed to through.findAll, bulkCreate, update and destroy. Can also hold additional attributes for the join table
[options.validate] Object Run validation for the join model

addAssociations([newAssociations], [options]) -> Promise

View code

Associate several persisted instances with this.

Params:

Name Type Description
[newAssociations] Array.<Instance | String | Number> An array of persisted instances or primary key of instances to associate with this.
[options] Object Options passed to through.findAll, bulkCreate and update. Can also hold additional attributes for the join table.
[options.validate] Object Run validation for the join model.

addAssociation([newAssociation], [options]) -> Promise

View code

Associate a persisted instance with this.

Params:

Name Type Description
[newAssociation] Instance | String | Number A persisted instance or primary key of instance to associate with this.
[options] Object Options passed to through.findAll, bulkCreate and update. Can also hold additional attributes for the join table.
[options.validate] Object Run validation for the join model.

createAssociation([values], [options]) -> Promise

View code

Create a new instance of the associated model and associate it with this.

Params:

Name Type Description
[values] Object
[options] Object Options passed to create and add. Can also hold additional attributes for the join table

removeAssociation([oldAssociated], [options]) -> Promise

View code

Un-associate the instance.

Params:

Name Type Description
[oldAssociated] Instance | String | Number Can be an Instance or its primary key
[options] Object Options passed to through.destroy

removeAssociations([oldAssociated], [options]) -> Promise

View code

Un-associate several instances.

Params:

Name Type Description
[oldAssociated] Array.<Instance | String | Number> Can be an array of instances or their primary keys
[options] Object Options passed to through.destroy

hasAssociation([instance], [options]) -> Promise

View code

Check if an instance is associated with this.

Params:

Name Type Description
[instance] Instance | String | Number Can be an Instance or its primary key
[options] Object Options passed to getAssociations

hasAssociations([instances], [options]) -> Promise

View code

Check if all instances are associated with this.

Params:

Name Type Description
[instances] Array.<Instance | String | Number> Can be an array of instances or their primary keys
[options] Object Options passed to getAssociations

countAssociations([options]) -> Promise.<Int>

View code

Count everything currently associated with this, using an optional where clause.

Params:

Name Type Description
[options] Object
[options.where] Object An optional where clause to limit the associated models
[options.scope] String | Boolean Apply a scope on the related model, or remove its default scope by passing false

This document is automatically generated based on source code comments. Please do not edit it directly, as your changes will be ignored. Please write on IRC, open an issue or a create a pull request if you feel something can be improved. For help on how to write source code documentation see JSDoc and dox