[QUESTION] How to create a query endpoint for a many-to-many relation with custom properties?

[jhonnydelima]

I'm trying to create a query endpoint for a many-to-many relation which has custom properties.

Setup:

• Nestjs
• TypeORM
• Postgres
• GraphQL

common.dto.ts

@ObjectType()
export class CommonDTO {
  @FilterableField(() => ID)
  id: number;

  @FilterableField()
  createdAt: Date;

  @FilterableField()
  updatedAt: Date;
}

establishment.dto.ts (the same for the entity plus the @OneToMany decorator/relation)

@ObjectType('Establishment')
export class EstablishmentDTO extends CommonDTO {
  @FilterableField()
  code: string;

  @FilterableField()
  companyName: string;

  @FilterableField()
  businessName: string;
}

address.dto.ts (the same for the entity plus the @OneToMany decorator/relation)

@ObjectType('Address')
export class AddressDTO extends CommonDTO {
  @FilterableField()
  street: string;

  @FilterableField()
  number: string;

  @FilterableField({ nullable: true })
  complement?: string;

  @FilterableField({ nullable: true })
  latitude?: number;

  @FilterableField({ nullable: true })
  longitude?: number;

  @FilterableField()
  zipCode: string;
}

establishment-address.entity.ts

@Entity('establishments_addresses')
export class EstablishmentAddress {
  @PrimaryGeneratedColumn()
  id: number;

  @CreateDateColumn({ name: 'created_at' })
  createdAt: Date;

  @ManyToOne(() => Establishment, (establishment) => establishment.establishmentsAddresses)
  @JoinColumn({ name: 'establishment_id' })
  establishment: Establishment;

  @ManyToOne(() => Address, (address) => address.establishmentsAddresses)
  @JoinColumn({ name: 'address_id' })
  address: Address;
}

Below is a query example to get one establishment by the code. However, it gets only the data from the establishment, and what I need is to get the establishment with all its addresses.

@Query(() => EstablishmentConnection)
  async establishment(@Args() query: EstablishmentCodeFilter): Promise<ConnectionType<EstablishmentDTO>> {
    const establishment = EstablishmentConnection.createFromPromise((q) => this.service.query(q), {
      ...query,
    });

    return establishment;
  }

Do I need to add the property addresses: AddressDTO[] in EstablishmentDTO or just add some decorator for connection? Can someone give me a hand with that? This is basically the continuation of #1506, but I splitted them, since the subjects are not the same.

Thanks in advance.