How to get relations of relations using Typeorm?

When working with Typeorm, managing relationships between entities is a common requirement. Typeorm supports various relationship types, including One-to-One (OneToOne), One-to-Many (OneToMany), Many-to-One (ManyToOne), and Many-to-Many (ManyToMany). I will now provide a detailed explanation of how to define and retrieve these relationships.

Defining Entity Relationships

Consider two entities, User and Photo. A user can have multiple photos, representing a typical One-to-Many relationship.

1. Defining the User Entity:

typescript
import { Entity, PrimaryGeneratedColumn, Column, OneToMany } from 'typeorm';
import { Photo } from './Photo';

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

    @Column()
    name: string;

    @OneToMany(() => Photo, photo => photo.user)
    photos: Photo[];
}

1. Defining the Photo Entity:

typescript
import { Entity, PrimaryGeneratedColumn, Column, ManyToOne } from 'typeorm';
import { User } from './User';

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

    @Column()
    url: string;

    @ManyToOne(() => User, user => user.photos)
    user: User;
}

Retrieving Relationship Data

Suppose you want to retrieve a user and all their associated photos. You can use the find or findOne methods and specify the relationships to load via the relations option.

Example Code:

typescript
import { getRepository } from 'typeorm';
import { User } from './entity/User';

async function getUserAndPhotos() {
    const userRepository = getRepository(User);
    const user = await userRepository.findOne({ where: { id: 1 }, relations: ['photos'] });

    if(user) {
        console.log('User:', user);
        console.log('Photos:', user.photos);
    } else {
        console.log('No user found.');
    }
}

This code loads the user with ID 1 and all related photos. The relations option with 'photos' corresponds to the photos property defined in the User entity.

Summary

When using Typeorm to manage entity relationships, the key is to correctly define relationships within entity classes and specify which relationships to load during queries using the relations parameter. This enables Typeorm to automatically handle database-level join operations, simplifying and optimizing data retrieval. Additionally, Typeorm supports advanced query capabilities, such as customizing join queries with QueryBuilder, which offers greater flexibility and robust functionality for handling complex relationships.