javascript - Automatic Eager Loading in Sequelize when I am using belongsToMany assocation

Question

Okay consider this. I have 2 Entities in my database - Groups and Users. So relations exists between them -

1. A user can be member of many groups, a group can have many members (Many to Many)
2. A admin(user) can be admin of many groups, a group can have many admins (Many to Many)

The code is as follows -

// Groups and Users (Admins) MANY-TO-MANY
User.belongsToMany(Groups, {through: "admins", as: "AdminGroups"});
Groups.belongsToMany(User, {through: 'admins', as: "Admins"});

// Groups and Users (Members) MANY-TO-MANY
User.belongsToMany(Groups, {through: 'members', as: "MemberGroups"});
Groups.belongsToMany(User, {through: 'members', as: "Members"});

question from:https://stackoverflow.com/questions/65835302/automatic-eager-loading-in-sequelize-when-i-am-using-belongstomany-assocation

Answer 1

You can exclude eager loading data by using joinTableAttributes. Setting empty array to not fetch anything from the associated table.

const admins = await group.getAdmins({
  attributes: ['id', 'firstname', 'lastname'],
  joinTableAttributes: []
});