How to select a collection of users using foreign keys?

Question

How to select a collection of users using foreign keys?

I have a junction table (also known as join table) with foreign keys of a users table. So first I get a collection of the foreign keys I'm interested in, and then a second query for selecting the actual records of the users.

Is there a more convenient way doing it ("at once")?

sql
database
node.js
orm
sequelize.js

Answer 1

User.hasMany(SomethingElse);
SomethingElse.hasMany(User);

somethingElseInstance.getUsers();

If your foreign keys are named something other than userId and somethingElseId, you will have to do a bit of configuration, but it is still very much doable. If you need more help, please show your sequelize model definitions