Relations (OneToMany, ManyToOne, ManyToMany) in NestJS - Step-by-Step Execution

Concept Flow - Relations (OneToMany, ManyToOne, ManyToMany)

Define Entities

↓

Add Relation Decorators

↓

OneToMany <-> ManyToOne Setup

↓

ManyToMany Setup

↓

Use Repository to Save & Query

↓

Relations Loaded or Joined

↓

Access Related Data

This flow shows how to define entities, set up relations with decorators, save and query data, and access related entities in NestJS.

Execution Sample

NestJS

import { Entity, PrimaryGeneratedColumn, Column, OneToMany, ManyToOne } from 'typeorm';

@Entity()
export class Author {
  @PrimaryGeneratedColumn() id: number;
  @Column() name: string;
  @OneToMany(() => Book, book => book.author) books: Book[];
}

@Entity()
export class Book {
  @PrimaryGeneratedColumn() id: number;
  @Column() title: string;
  @ManyToOne(() => Author, author => author.books) author: Author;
}

Defines Author and Book entities with OneToMany and ManyToOne relations between them.

Execution Table

Step	Action	Entity State	Relation Setup	Result
1	Create Author instance	Author { id: undefined, name: 'Alice', books: [] }	No relations yet	Author object ready
2	Create Book instance	Book { id: undefined, title: 'NestJS Guide', author: undefined }	No relations yet	Book object ready
3	Assign author to book	Book.author = Author instance	ManyToOne relation set	Book linked to Author
4	Add book to author's books array	Author.books = [Book instance]	OneToMany relation set	Author linked to Book
5	Save Author and Book to DB	Entities persisted	Relations saved via foreign keys	Data stored with relations
6	Query Book with author relation	Book loaded with author	Relation joined	Book.author accessible
7	Query Author with books relation	Author loaded with books array	Relation joined	Author.books accessible
8	Exit	-	-	Relations fully established and accessible

💡 All entities saved and relations correctly linked in database

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	Final
Author instance	undefined	{ id: undefined, name: 'Alice', books: [] }	{ id: undefined, name: 'Alice', books: [] }	{ id: undefined, name: 'Alice', books: [] }	{ id: undefined, name: 'Alice', books: [Book instance] }	Persisted with id
Book instance	undefined	undefined	{ id: undefined, title: 'NestJS Guide', author: undefined }	{ id: undefined, title: 'NestJS Guide', author: Author instance }	{ id: undefined, title: 'NestJS Guide', author: Author instance }	Persisted with id

Key Moments - 3 Insights

Why do we assign the author to the book and also add the book to the author's books array?

Because OneToMany and ManyToOne relations are two sides of the same link. Assigning both ensures the relation is complete in memory before saving, as shown in steps 3 and 4 of the execution_table.

What happens if we save only the book without adding it to the author's books array?

The database will store the foreign key from book to author, but the author's books array in memory won't reflect the relation until reloaded, as the OneToMany side is not updated (see step 4).

How does ManyToMany differ from OneToMany/ManyToOne in setup?

ManyToMany uses a join table to link entities on both sides equally, unlike OneToMany/ManyToOne which uses a foreign key on the ManyToOne side. This is a separate step after OneToMany/ManyToOne setup.

Visual Quiz - 3 Questions

Look at the execution_table at step 3, what relation is being set?

A OneToMany from Author to Book

B ManyToOne from Book to Author

C ManyToMany between Author and Book

D No relation set yet

💡 Hint

Check the 'Relation Setup' column at step 3 in execution_table

At which step does the Author's books array get updated?

A Step 2

B Step 3

C Step 4

D Step 5

💡 Hint

Look for 'Author.books = [Book instance]' in the 'Entity State' column

If we skip adding the book to the author's books array, what will happen?

A The relation will be fully saved and accessible both ways

B The book will not save at all

C The database will save the relation but Author.books in memory will be empty

D An error will occur during save

💡 Hint

Refer to key_moments explanation about incomplete relation setup

Concept Snapshot

Relations in NestJS with TypeORM:
- Use @OneToMany on the 'one' side and @ManyToOne on the 'many' side
- Both sides must reference each other for full relation
- ManyToMany uses @ManyToMany with a join table
- Save entities with relations to persist foreign keys
- Query with relations to access linked data easily

Full Transcript

This visual execution trace shows how to set up relations in NestJS using TypeORM decorators. First, entities are defined with @Entity and columns. Then, relations are added using @OneToMany and @ManyToOne decorators referencing each other. Instances of entities are created and linked by assigning the related objects on both sides. Saving these entities persists the relations in the database via foreign keys. Querying with relations loads the linked data for easy access. Key moments clarify why both sides must be assigned and how ManyToMany differs. The quiz tests understanding of relation setup steps and effects of incomplete linking.