Node.JS Typescript TypeORM ManyToMany relations with empty result set

Question

I have the following typescript TypeORM model:

@Entity()
export class Teacher extends EntityBase {
    @Column({ length: 256 })
    public firstName: string

    @Column({ length: 256 })
    public lastName: string

    @Column({ unique: true, length: 256 })
    public email: string

    @ManyToMany((type) => Student, (student) => student.teachers, { nullable: true })
    @JoinTable()
    public students: Student[]

    constructor(first: string, last: string, email: string) {
        super();
        this.firstName = first;
        this.lastName = last;
        this.email = email;
        //this.students = []; TypeORM initialization failed! InitializedRelationError: Array initializations are not allowed in entity relations
    }
}

The following query:

    public override async GetByEmail (email: string): Promise<Teacher | null> {
        return await this._repository.findOneOrFail({
            where: { email: email },
            relations: ["students"]
        });
    }

failed:

Exception: {"criteria":{"where":{"email":"[email protected]"},"relations":["students"]},"message":"Could not find any entity of type \"Teacher\" matching: {\n    \"where\": {\n        \"email\": \"[email protected]\"\n    },\n    \"relations\": [\n        \"students\"\n    ]\n}"}

khteh · Accepted Answer · 2024-07-07 03:31:29Z

0

findOneOrFail will throw. Need to catch exception and handle it as non-existing entity. I switched to findOne

edited Jul 7, 2024 at 3:31

answered Jul 6, 2024 at 9:07

khteh

4,28011 gold badges62 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node.JS Typescript TypeORM ManyToMany relations with empty result set

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related