Postgres to TypeORM

Question

有人能为以下查询提供一个TypeORM解决方案吗，

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

输出为

active  preference
TRUE    update
TRUE    insert

我的TypeORM回购名称是preferenceRepo，userPreferenceRepo

谢谢。

Answer 1

您只需要执行以下操作：

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();