Translate postgres query to sequelize

Question

I am having trouble connecting relationships in sequelize.

SELECT * from actors 
JOIN "actorStatuses" 
   on "actorStatuses".actor_id = actors.id 
JOIN movies 
   on movies.id = "actorStatuses".actor_id 
WHERE movies.date = '7/8/2017';

Vivek Doshi · Accepted Answer · 2018-04-02 04:35:29Z

1

Here you go :

model.Actor.findAll({ // change model name as per yours
    include : [
        {
            model : model.ActorStatuses // change model name as per yours
            required : true ,
        },{
            model : model.Movies // change model name as per yours
            required : true ,
            where : { date : 'your_date' }
        }
    ]
});

This will create exact same query / result as you required.

answered Apr 2, 2018 at 4:35

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

spaceDog Over a year ago

Thanks for responding, but don't I see to define the relationships first?

Vivek Doshi Over a year ago

Yes that's the obvious thing

spaceDog Over a year ago

Thank you so much.

Collectives™ on Stack Overflow

Translate postgres query to sequelize

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related