TypeORM中@ManyToOne与@OneToMany关联配置报错求助

问题背景 #

使用TypeScript、TypeORM和PostgreSQL开发项目时，配置实体的@ManyToOne与@OneToMany关联关系后出现编译报错，尝试添加空对象、{cascade: true}等参数无法解决。

原始实体代码 #

Product实体 #

// 产品表实体
import  { Category } from './categories/categories.entity';
import { OrderDetails } from 'src/orders/details/orderDetails.entity';
import {
    Column,
    Entity,
    JoinTable,
    ManyToMany,
    ManyToOne,
    PrimaryGeneratedColumn,
} from 'typeorm';

@Entity({name: 'products'})
export class Product {   
 @PrimaryGeneratedColumn('uuid')
    id: string;

    @Column({ length: 50, nullable: false })
    name: string;

    @Column({ nullable: false })
    description: string;

    @Column('decimal', { precision: 10, scale: 2, nullable: false })
    price: number;

    @Column({ nullable: false })
    stock: number;

    @Column({ nullable: true, default: 'default_image_url' })
    imgUrl: string;

    @ManyToOne(() => Category, (category) => category.products)
    @JoinTable() // 错误：多对一关联不需要@JoinTable
    category: Category;

    @ManyToMany(() => OrderDetails)
    @JoinTable()
    orderDetails: OrderDetails[];
}

Category实体 #

// 分类表实体
import { Product } from '../products.entity';
import { Column, Entity, OneToMany, PrimaryGeneratedColumn } from 'typeorm';

@Entity({ name: 'categories' })
export class Category {
    @PrimaryGeneratedColumn('uuid')
    id: string;

    @Column({ length: 50, nullable: false })
    name: string;

    @OneToMany(() => Products) // 错误1：实体名写错（应为Product）；错误2：缺少反向关联参数
    products: Products[]; // 错误：类型应为Product[]
}

报错信息 #

src/categories/categories.entity.ts:22:4 - error TS2554: Expected 2-3 arguments, but got 1.
22   @OneToMany(() => Products)
~~~~~~~~~
node_modules/typeorm/decorator/relations/OneToMany.d.ts:8:102
8 export declare function OneToMany(typeFunctionOrTarget: string | ((type?: any) => ObjectType), inverseSide: string | ((object: T) => any), options?: RelationOptions): PropertyDecorator;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
An argument for 'inverseSide' was not provided.
src/categories/categories.entity.ts:22:20 - error TS2552: Cannot find name 'Products'. Did you mean 'Product'?
22   @OneToMany(() => Products)
~~~~~~~~
src/categories/categories.entity.ts:24:13 - error TS2552: Cannot find name 'Products'. Did you mean 'Product'?
24   products: Products[];
~~~~~~~~
src/categories/categories.entity.ts:24:13 - error TS4031: Public property 'products' of exported class has or is using private name 'Products'.
24   products: Products[];
~~~~~~~~
[10:37:23] Found 4 errors. Watching for file changes.

错误原因分析 #

• Category实体的@OneToMany参数错误：TypeORM的@OneToMany装饰器必须传入2-3个参数，第二个参数是反向关联的属性（即Product实体中对应的category字段），且实体名不应写为复数Products，需改为Product。
• Product实体的@ManyToOne错误使用@JoinTable：@JoinTable仅用于多对多（ManyToMany）关联，一对多/多对一关联不需要这个装饰器，TypeORM会自动处理外键关联。

修正后的代码 #

修正后的Product实体 #

// 产品表实体
import  { Category } from './categories/categories.entity';
import { OrderDetails } from 'src/orders/details/orderDetails.entity';
import {
    Column,
    Entity,
    JoinTable,
    ManyToMany,
    ManyToOne,
    PrimaryGeneratedColumn,
} from 'typeorm';

@Entity({name: 'products'})
export class Product {   
 @PrimaryGeneratedColumn('uuid')
    id: string;

    @Column({ length: 50, nullable: false })
    name: string;

    @Column({ nullable: false })
    description: string;

    @Column('decimal', { precision: 10, scale: 2, nullable: false })
    price: number;

    @Column({ nullable: false })
    stock: number;

    @Column({ nullable: true, default: 'default_image_url' })
    imgUrl: string;

    // 移除多余的@JoinTable
    @ManyToOne(() => Category, (category) => category.products)
    category: Category;

    @ManyToMany(() => OrderDetails)
    @JoinTable()
    orderDetails: OrderDetails[];
}

修正后的Category实体 #

// 分类表实体
import { Product } from '../products.entity';
import { Column, Entity, OneToMany, PrimaryGeneratedColumn } from 'typeorm';

@Entity({ name: 'categories' })
export class Category {
    @PrimaryGeneratedColumn('uuid')
    id: string;

    @Column({ length: 50, nullable: false })
    name: string;

    // 修正实体名为Product，添加反向关联参数
    @OneToMany(() => Product, (product) => product.category)
    products: Product[]; // 修正类型为Product[]
}

验证方法 #

修正后重新启动项目，TypeScript编译错误会消失，TypeORM能正确识别一对多/多对一的关联关系，自动在products表中生成categoryId外键字段。

内容的提问来源于stack exchange，提问作者Edmundo Kinast