Typeorm postgres: Create relation by unique column (not PK) as constraint

Question

so I'm struglling for a while now. I'm trying to model my custom join table in postgres using typeorm.

I want to set non PK column ('uuid') as relation constraint, but I can't find any solution.

I have two already existing tables, lets name them A and B.

@Entity()
export class A {
  @PrimaryGeneratedColumn('uuid')
  uuid: string;

 ...
}

@Entity()
@Unique(['uuid'])
export class B {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  @Generated('uuid')
  uuid: string;

 ...
}

So now I want my join table to be

@Entity()
@Unique(['a', 'b'])
export class AB {
  @PrimaryGeneratedColumn('uuid')
  uuid: string;

  @ManyToOne(() => A, { nullable: false })
  a: A;

  @ManyToOne(() => B, { nullable: false })
  b: B;
}

and then I would like to save new entity like repository.save({ a: { uuid: uuid }, b: { uuid: uuid }}); It works when I try to save relation B with its PK ('id') but aint working with uuid.

I'd be greateful for any help cheers

chimek0 · Accepted Answer · 2021-04-13 21:17:48Z

1

Ok, so I figure it out, in case anyone has the same problem, here is my solution. I've removed @Unique('uuid') from table B and declared it directly on column, I also had to mark column as type: 'uuid', then on join table I've used @JoinColumn decorator pointing to uuid column.

@Entity()
export class B {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ unique: true, type: 'uuid' })
  @Generated('uuid')
  uuid: string;

 ...
}

@Entity()
@Unique(['a', 'b'])
export class AB {
  @PrimaryGeneratedColumn('uuid')
  uuid: string;

  @ManyToOne(() => A, { nullable: false })
  a: A;

  @ManyToOne(() => B, { nullable: false })
  @JoinColumn({ referencedColumnName: 'uuid' })
  b: B;
}

answered Apr 13, 2021 at 21:17

chimek0

213 bronze badges

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

Collectives™ on Stack Overflow

Typeorm postgres: Create relation by unique column (not PK) as constraint

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related