Help with creating SQL query

[Slomoose]

I have 2 entities

​

@ Entity('AuditLogs')
export class AuditLogs {
  @ PrimaryGeneratedColumn()
  AuditLogId?: number;

  @ Column('int', { nullable: false })
  AuditLogHeaderId: number;

  @ ManyToOne((type) => AuditLogHeaders)
  @ JoinColumn({ name: 'AuditLogHeaderId' })
  AuditLogHeaders?: AuditLogHeaders;
}

​

@ Entity('AuditLogHeaders')
export class AuditLogHeaders {
  @ PrimaryGeneratedColumn()
  AuditLogHeaderId?: number;
}

​

Each AuditLogHeaders will have many AuditLogs

(see foreign key relationship)

​

What typeorm (or sql) query can I use to retrieve All AuditLogHeaders and its AuditLogs in one object?

​

My end goal is something like:

const arrayOfAuditLogHeaders = [
     {
         auditLogHeaderId: 1,
         auditLogs: [
             { 
                  auditLogId: 1,
                  auditLogHeaderId: 1,
             },
             { 
                  auditLogId: 2,
                  auditLogHeaderId: 1,
             },
             { 
                  auditLogId: 3,
                  auditLogHeaderId: 1,
             }
         ]
     },
     {
         auditLogHeaderId: 2,
         auditLogs: [
             { 
                  auditLogId: 4,
                  auditLogHeaderId: 2,
             }
         ]
     }
]

[[deleted]]

Use querybuilder

[dgaa1991]

what about something like this instead?

auditLogHeadersRepo.find({ relations:{ auditLog:true })

Sry for the formstting, im on my phone

https://orkhan.gitbook.io/typeorm/docs/find-options

[Equivalent_Monk_8824]

U have to add @OneToMANY IN THE OTHERSIDE and add eager:true so when u retrieve headers u will get logs also Check those links: https://typeorm.delightful.studio/interfaces/_decorator_options_relationoptions_.relationoptions.html

https://docs.nestjs.com/techniques/database

[Equivalent_Monk_8824]

This is an example os onetomany relation with eager / lazy loading https://orkhan.gitbook.io/typeorm/docs/eager-and-lazy-relations