CODEWITHSUNDEEP
postgresqlnestjstypeorm
noam steiner
noam steiner

Reputation: 4444

TypeORM: Save entity with ManyToMany relation with custom field does not save properly

I have ManyToMany relationship of users and projects as follow:

// project.entity.ts

@Entity()
export class Project extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @OneToMany(type => ProjectUser, projectUser => projectUser.project)
  projectUsers: ProjectUser[];

  @CreateDateColumn({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP', readonly: true })
  createdAt: Date;

  @UpdateDateColumn({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP' })
  updatedAt: Date;

  @DeleteDateColumn({ type: 'timestamp' })
  deletedAt: Date;

}

// user.entity.ts

@Entity()
export class User extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  email: string;

  @Column()
  password: string;

  @OneToMany(type => ProjectUser, projectUser => projectUser.user)
  projectUsers: ProjectUser;

  @CreateDateColumn({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP', readonly: true })
  createdAt: Date;

  @UpdateDateColumn({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP' })
  updatedAt: Date;

  @DeleteDateColumn({ type: 'timestamp' })
  deletedAt: Date;
}

// project_user.entity.ts

@Entity()
export class ProjectUser extends BaseEntity{
    @PrimaryGeneratedColumn()
    id: number;

    @Column()
    projectId: number;

    @Column()
    userId: number;

    @Column()
    isUserCreator: boolean;

    @ManyToOne(type => Project, project => project.projectUsers)
    @JoinColumn()
    project: Project;

    @ManyToOne(type => User, user => user.projectUsers)
    @JoinColumn()
    user: User;
}

When I try to save a new project the new ProjectUser record does not save.

// project.service.ts


   async create(project: DeepPartial<Project>): Promise<Project> {
        ---> project  { name: 'project1', projectUsers: [{userId: 1, isUserCreator: true}]

        const projectToSave = Project.create(project)
        projectToSave.projectUsers = ProjectUser.create(project.projectUsers)
        return await projectToSave.save();
    }

Any ideas why cant I save the record in the related table?

Upvotes: 5

Views: 5546

Answers (1)

andsilver
andsilver

Reputation: 5972

You only created projectUsers instances but not saving them.

Use below code for saving all of the project and projectUsers:

const projectToSave = Project.create(project);
await projectToSave.save();

const projectUsers = ProjectUser.create(project.projectUsers);
projectUsers.forEach(p => p.project = projectToSave);
await projectUsers.save(projectUsers);
return projectToSave;

Or

const projectUsers = await ProjectUser.save(ProjectUser.create(project.projectUsers));
const projectToSave = Project.create(project);
projectToSave.projectUsers = projectUsers;
return await projectToSave.save();

Another solution You can just set cascade option in your entity to save automatically.

Upvotes: 3

Related Questions