How to implement typeorm relation with same column name

Viewed 11

I have this loantypeid that is foreign key in loanproduct table and primary key inside loantype table

@Entity()
export class loanproduct {
  @PrimaryColumn({ default: () => 'uuid_generate_v4()' })
  loanid: string;
  
  @ManyToOne(() => loantype, (type: loantype) => type.loantypeid)
  loantypeid: string;
}


@Entity()
export class loantype {
  @PrimaryColumn({ default: () => 'uuid_generate_v4()' })
  @OneToMany(() => loanproduct, (loanproduct) => loanproduct.loantypeid)
  loantypeid: string;

  @Column()
  content: string;
}

My question is when i run my code with leftJoinAndSelect

.createQueryBuilder('loanproduct')
.leftJoinAndSelect('loanproduct.loantypeid', 'loantype')

It generate wrong SELECT QUERY:

SELECT 
  "loanproduct"."loanid" AS "loanproduct_loanid", 
  "loanproduct"."loantypeidLoantypeid" AS "loanproduct_loantypeidLoantypeid", 
  "loantype"."loantypeid" AS "loantype_loantypeid", 
  "loantype"."content" AS "loantype_content" 
FROM "loanproduct" "loanproduct" 
LEFT JOIN "loantype" "loantype" 
ON "loantype"."loantypeid"="loanproduct"."loantypeidLoantypeid

It's adding Loantypeid inside "loantypeid"

0 Answers
Related