Unable to insert into a many-to-many table because of a restriction with the foreign key

Question

Unable to insert into a many-to-many table because of a restriction with the foreign key

I am encountering an issue with my schedule table, which is derived from a many-to-many relationship between a classes and users table.

User typeorm schema

@ManyToMany(type => UClass, c => c.users, {cascade: true, onDelete: "CASCADE"})
    @JoinTable({name: "schedule"})
    classes: UClass[]

Class typeorm schema

 @ManyToMany(type => User, u => u.classes)
    @JoinTable({name: "schedule"})
    users: User[]

When attempting to create a user:

{
    "username":"a",
    ...(rest of data)
    "classes":[{"id":"f602a286-3df1-4912-9165-2375b5e45bdd"}]
}

An error is triggered displaying:

QueryFailedError: insert or update on table \"schedule\" violates foreign key constraint \"FK_d796103491cf0bae197dda59477\

I am uncertain why this foreign key error is occurring since both the provided user and class ids are valid. Any assistance would be greatly appreciated.

typescript postgresql typeorm

Answer 1

Answer №1

After spending almost a full day troubleshooting, it dawned on me that the register function was actually working fine in my production app. I decided to trace back my steps using GitHub to see what changes I had made since updating the production version. It turns out that nesting repositories within another repository caused the database migration to behave differently. The solution was simple: I just needed to modify

userRepository: Repository<User>;
classRepository: Repository<UClass>;
scheduleRepository: Repository<any>;

    constructor() {
        this.userRepository = getManager().getRepository(User);
        this.classRepository = getManager().getRepository(UClass);
    }

to

userRepository: Repository<User>;
scheduleRepository: Repository<any>;

    constructor() {
        this.userRepository = getManager().getRepository(User);
    }

Answer 2

After spending almost a full day troubleshooting, it dawned on me that the register function was actually working fine in my production app. I decided to trace back my steps using GitHub to see what changes I had made since updating the production version. It turns out that nesting repositories within another repository caused the database migration to behave differently. The solution was simple: I just needed to modify

userRepository: Repository<User>;
classRepository: Repository<UClass>;
scheduleRepository: Repository<any>;

    constructor() {
        this.userRepository = getManager().getRepository(User);
        this.classRepository = getManager().getRepository(UClass);
    }

to

userRepository: Repository<User>;
scheduleRepository: Repository<any>;

    constructor() {
        this.userRepository = getManager().getRepository(User);
    }

Unable to insert into a many-to-many table because of a restriction with the foreign key

Answer №1

Similar questions

Contrasting covariant and contravariant positions within Typescript

Adding a click functionality to a dynamically generated anchor tag in angular.js

Is it possible to define a class prior to exporting it in typescript/angular? | TSLint warning: unused expression, assignment or function call expected

Having trouble retrieving the data returned from the service in an angular component

The property name in VS Code features a star symbol (★) as part of its design

Typescript's dynamic React component and its conditional types

Labeling src library files with namespaces

What is the process of 'initializing' an object in TypeScript?

Jest is unable to handle ESM local imports during resolution

"Successful deletion with Express, yet error message of 'Not Found' displayed

The typed union type FormGroup in Angular stands out for its versatility and robustness

How can I transform a string array into an object array using Angular 2?

Receiving error in TypeScript while using the 'required' attribute in the input field: "Cannot assign type 'string | undefined' to parameter expecting type 'string'"

Error: global not declared in the context of web3

Error message "After the upgrade to Angular 15, the property 'selectedIndex' is not recognized in the type 'AppComponent'."

Is it advisable to incorporate 'use server' into every function that retrieves confidential information within server components in Next.js?

Utilizing multiple page objects within a single method in Cypress JS

I'm having trouble resolving this error that keeps popping up on this particular line of code: "registrationForm : FormGroup;" Can anyone help me troubleshoot this

Mapping JSON data from an array with multiple properties

Can you provide details about the launch configuration for pwa-node in VSCode?