In TypeORM and NestJS, when dealing with a many-to-many relationship, you need an intermediate (or junction) table to link the entities. To insert data into the intermediate table, you have to create instances of both entities and associate them through the relationship. Here's how you can achieve this:

Let's assume we have two entities: Product and Category, and they have a many-to-many relationship. A product can belong to multiple categories, and a category can have multiple products.

  1. Define the Entities and the Relationship:
// product.entity.ts import { Entity, PrimaryGeneratedColumn, Column, ManyToMany, JoinTable } from 'typeorm'; import { Category } from './category.entity'; @Entity() export class Product { @PrimaryGeneratedColumn() id: number; @Column() name: string; @ManyToMany(() => Category) @JoinTable() categories: Category[]; } // category.entity.ts import { Entity, PrimaryGeneratedColumn, Column, ManyToMany } from 'typeorm'; import { Product } from './product.entity'; @Entity() export class Category { @PrimaryGeneratedColumn() id: number; @Column() name: string; @ManyToMany(() => Product, product => product.categories) products: Product[]; }
  1. Insert Data into the Intermediate Table:

To insert data into the intermediate table, you need to create instances of both Product and Category entities and associate them together. Use the repository methods to save the entities and persist the relationship.

// product.controller.ts import { Controller, Post, Body } from '@nestjs/common'; import { ProductService } from './product.service'; import { Product } from './product.entity'; @Controller('products') export class ProductController { constructor(private readonly productService: ProductService) {} @Post() async createProduct(@Body() productData: Partial<Product>) { // Create a new product const product = this.productService.create(productData); // Get or create the categories (assuming categoryIds is an array of category ids) const categoryIds = productData.categoryIds || []; const categories = await this.productService.getOrCreateCategories(categoryIds); // Associate the product with categories product.categories = categories; // Save the product with the relationship to the categories return; } }
  1. ProductService:

In the ProductService, you can implement the methods to handle the database operations.

// product.service.ts import { Injectable } from '@nestjs/common'; import { InjectRepository } from '@nestjs/typeorm'; import { Repository } from 'typeorm'; import { Product } from './product.entity'; import { Category } from './category.entity'; @Injectable() export class ProductService { constructor( @InjectRepository(Product) private readonly productRepository: Repository<Product>, @InjectRepository(Category) private readonly categoryRepository: Repository<Category>, ) {} async create(productData: Partial<Product>): Promise<Product> { const product = this.productRepository.create(productData); return; } async getOrCreateCategories(categoryIds: number[]): Promise<Category[]> { const categories = await this.categoryRepository.findByIds(categoryIds); const missingCategoryIds = categoryIds.filter(id => !categories.some(category => === id)); if (missingCategoryIds.length > 0) { const newCategories = => this.categoryRepository.create({ id })); await; return categories.concat(newCategories); } return categories; } async save(product: Product): Promise<Product> { return; } }

The ProductService contains the methods to create a new product, retrieve existing categories, and create new categories if needed. The getOrCreateCategories method ensures that the categories associated with the product exist in the database before creating the relationship.

Remember to register the entities, the service, and the controller in the appropriate modules of your NestJS application.

This example illustrates the basic approach to insert data into the intermediate table when dealing with a many-to-many relationship using TypeORM and NestJS. Adjust the code as per your specific application requirements.

Have questions or queries?
Get in Touch