Including only pivot table

[n-sviridenko]

Hi, we have a many-to-many relation b/w Foo and Bar models:

  const Foo = sequelize.define('foo', {
}, {
    tableName: 'foo',
  });
  Foo.associate = (db) => {
    Foo.Bars = Foo.belongsToMany(db.bar, { 
      as: 'bars',
      through: db.fooBar,
      foreignKey: 'fooId'
    });
  };
  const Bar = sequelize.define('bar', {
}, {
    tableName: 'bar',
  });
const FooBar = sequelize.define('fooBar', {}, {
    tableName: 'foo_bar',
  });

In order to save on performance, we want to include only a pivot table (FooBar) when executing Foo.findAll() and filter by Bar.id. Something like:

    include: [
      { model: FooBar, as: 'fooBars' },
    ],

instead of

    include: [
      { association: Bar, as: 'bars' },
    ],

But we're having: 'SequelizeEagerLoadingError: fooBar is not associated to foo!\

We need the data which is available there and we don't need any data from the associated table. Is this possible to do so?

[papb]

In a way, yes, you have to do a 'trick' that I plan on documenting soon. Stay tuned!

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂