Postgres to TypeORM

Question

Can anyone please give a TypeORM solution for the below query,

select upr.active, pr.preference from user_preferences upr
left join preferences pr
on upr.preferenceid = pr.id
where upr.userid = 1

The output is,

active  preference
TRUE    update
TRUE    insert

My TypeORM repo names are preferenceRepo, userPreferenceRepo

Thanks.

What have you tried yourself?

Evaldas Buinauskas
– Evaldas Buinauskas

2021-01-11 07:29:11 +00:00
Commented Jan 11, 2021 at 7:29 — Evaldas Buinauskas
– Evaldas Buinauskas, Commented Jan 11, 2021 at 7:29

Ayoub Touba · Accepted Answer · 2021-01-11 13:52:28Z

2

you simply need to do:

return  this.userPreferenceRepo.createQueryBuilder('upr') 
    .leftJoin("upr.preferenceid", "pr") // replace preferenceid with the name of the colmun that relate user and Preference entity 
   .select(["upr.active","pr.preference"])
   .where("upr.userid = :id ", { id: id }) 
   .getRawMany();

answered Jan 11, 2021 at 13:52

Ayoub Touba

3,0773 gold badges16 silver badges31 bronze badges

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

1 Comment

Joseph Over a year ago

Nice. Yes its working fine. Thank u so much ! - @Youba

Collectives™ on Stack Overflow

Postgres to TypeORM

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related