如何在 TypeORM 中检索关联数据和关系数据？

Question

我有这个实体类。这是两个表之间的关联。

import { Column, Entity, Index, JoinColumn, ManyToOne } from "typeorm";

import { Classroom } from "./Classroom";

import { Teacher } from "./Teacher";

@Index("fk_class_has_teacher_teacher1_idx", ["teacherId"], {})

@Index("fk_class_has_teacher_class1_idx", ["classId"], {})

@Entity("teacherclassroom", { schema: "school" })

export class Teacherclassroom {

  @Column("int", { primary: true, name: "class_id" })

  classId: number;

  @Column("int", { primary: true, name: "teacher_id" })

  teacherId: number;

  @Column("datetime", {

    name: "reg_date",

    nullable: true,

    default: () => "CURRENT_TIMESTAMP"

  })

  regDate: Date | null;

  @ManyToOne(

    () => Classroom,

    classroom => classroom.teacherclassrooms,

    { onDelete: "NO ACTION", onUpdate: "NO ACTION" }

  )

  @JoinColumn([{ name: "class_id", referencedColumnName: "id" }])

  class: Classroom;

  @ManyToOne(

    () => Teacher,

    teacher => teacher.teacherclassrooms,

    { onDelete: "NO ACTION", onUpdate: "NO ACTION" }

  )

  @JoinColumn([{ name: "teacher_id", referencedColumnName: "id" }])

  teacher: Teacher;

}

当我从该关联中检索一行时，我想要做的是获取教师和课堂详细信息。我是这样做的，

import "reflect-metadata";

import { createConnection, getRepository } from "typeorm";

import { Teacherclassroom } from "./entity/Teacherclassroom";

import { Classroom } from "./entity/Classroom";

import { Teacher } from "./entity/Teacher";

createConnection().then(async connection => {

    const myRepository = getRepository(Teacherclassroom);

    const test = myRepository.find({ relations: ["teacher", "classroom"] });

    console.log(test);

}).catch(error => console.log(error));

我收到这个错误，

Relation was not found, please check if it is correct and really exist in your entity.

Answer 1

只需更改class为classroom在课堂关系中@ManyToOne(() => Classroom,classroom => classroom.teacherclassrooms,{ onDelete: "NO ACTION", onUpdate: "NO ACTION" })@JoinColumn([{ name: "class_id", referencedColumnName: "id" }])classroom: Classroom;只需更改class为classroom在课堂关系中@ManyToOne(() => Classroom,classroom => classroom.teacherclassrooms,{ onDelete: "NO ACTION", onUpdate: "NO ACTION" })@JoinColumn([{ name: "class_id", referencedColumnName: "id" }])classroom: Classroom;