How define belongsToMany association for users?

[solydvision]

Hi,

I tried to make two models of User(exist in this repo) and Team(new).
I added following in User model.
const Team = require("./Team");
Team.memberAssociation = User.belongsToMany(Team, { through: "member" });

How do I make this relationship in Team model, and how to add a user to Team in UserController.js in a method like register?

[aichbauer]

This is more an Sequelize question: https://sequelize.org/master/class/lib/associations/base.js~Association.html
https://sequelize.org/master/class/lib/associations/belongs-to-many.js~BelongsToMany.html

But I'll give you a quick example...

// a team can have multiple members
Team.belongsToMany(User, {
  as: 'teamMember', // this is how you can add, set or remove associations
  through: 'team_members', // define the table, I would suggest to call it model1_model2 or if you have a different name for it then use the name as here model1_name
  foreignKey: 'memberId',// I would always suggest to set your own if you want to work with the plain database
});
// a member can join multiple teams
User.belongsToMany(Team, {
  as: 'membersTeam',
  through: 'team_members',
  foreignKey: 'teamId',
});

// use

const someUser = User.findByPk(1);

Team.addTeamMember(someUser);
Team.addTeamMember(2);
Team.addTeamMember(3);
// team has 1,2,3
Team.removeTeamMember(3);
// team has now member 1,2
Team.setTeamMember([4,5,6])
// team has now 4,5,6 and deletes other associations