mysql - 如何创建如何在typeorm中创建多对多关系，[NestJS]

Question

如何在多对多关系中保存数据？
(用户，书籍(MTM))
这是用户和书籍之间的多对多关系。
我的服务不正确。
另外，我的代码不起作用。
数据存储在 book 表中。
我需要你的帮助，一切
先感谢您。
我的堆栈 => NestJs、TypeORM、MySQL
有我的实体。
enter image description here
用户实体

@Entity('User')
export class User {
    @PrimaryGeneratedColumn()
    id!: number;

    @Column()
    real_name!: string;

    @Column()
    nick_name!: string;

    @Column()
    @IsEmail()
    email!: string;

    @Column()
    password!: string;

    @Column()
    phone_number!: string;

    @Column()
    image_url: string;

    @BeforeInsert()
    async hashPassword() {
        this.password = await argon2.hash(this.password, {type: argon2.argon2id, hashLength: 40});
    }
}

书本实体

@Entity('Book')
export class Book {
    @PrimaryGeneratedColumn()
    id!: number;

    @Column()
    title: string;

    @Column()
    image_url: string;

    @Column()
    contents: string;

    @Column({ type: 'datetime'})
    datetime: string;

    @ManyToMany(() => User)
    @JoinTable()
    users: User[];
}

book.controller.ts

@UseGuards(JwtAuthGuard)
    @Post('bpc')
    savebpc(@Req() req: any, @Query('title') bookTitle: string){
        return this.BookService.addBpc(req, bookTitle);
    }

书.service.ts

async addBpc(req: any, bookTitle: string): Promise<any>{
        const userId = req.user.id;
        const bookId = await getRepository('Book')
        .createQueryBuilder('book')
        .where({title:bookTitle})
        .getRawOne()

        if (!bookId){
            throw new NotFoundException('Not_found_book');
        }

        const user = await getRepository('User')
        .createQueryBuilder('user')
        .where({id: userId})
        .getRawOne()


        //bookId.user.push(user);
        //await this.bookRepository.save(bookId);

        let userdata = new User();
        userdata.id = user.user_id;
        userdata.real_name = user.user_real_name;
        userdata.nick_name = user.user_nick_name;
        userdata.email = user.user_email;
        userdata.password = user.user_password;
        userdata.image_url = user.user_image_url;
        console.log(userdata);
        

        let bookBpc = new Book();
        bookBpc.title = bookId.book_title;
        bookBpc.image_url = bookId.book_image_url;
        bookBpc.contents = bookId.book_contents;
        bookBpc.datetime = bookId.book_datetime;
        bookBpc.users = [user];
        console.log(bookBpc);

        await this.bookRepository.create([bookBpc]);
        return 'suceess';
    }

Answer 1

您需要在 user 和 book 中添加 manytomany 关系，这是一个使用 express 和 typeorm 的示例，但它与 nestjs 相同
用户实体:

@Entity()
export class User {
  @PrimaryGeneratedColumn()
  id: number;
  @Column({ type: 'varchar', nullable: false, unique: true })
  username: string;
  // we need to add a default password and get it form the .env file
  @Column({ type: 'varchar', nullable: true, default: '' })
  password: string;
  @Column({ type: 'varchar', nullable: true })
  firstname: string;
  @Column({ type: 'varchar', nullable: true })
  lastname: string;
  @Column({ type: 'varchar', nullable: false })
  email: string;
  @Column({ type: 'boolean', nullable: true, default: false })
  connected: boolean;
  @CreateDateColumn({ name: 'created_at' })
  createdAt: Date;

  @UpdateDateColumn({ name: 'updated_at' })
  updatedAt: Date;

  // new properties
  @Column({ name: 'login_attempts', type: 'int', default: 0, nullable: true })
  loginAttempts: number;
  @Column({ name: 'lock_until', type: 'bigint', default: 0, nullable: true })
  lockUntil: number;

  //Many-to-many relation with role
  @ManyToMany((type) => Role, {
    cascade: true,
  })
  @JoinTable({
    name: "users_roles",
    joinColumn: { name: "userId", referencedColumnName: "id" },
    inverseJoinColumn: { name: "roleId" }
  })
  roles: Role[];
}

角色实体:

@Entity()
export class Role {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ type: 'varchar', nullable: false, unique: true })
  profile: string;

  @Column({ type: 'varchar', nullable: false })
  description: string;

  //Many-to-many relation with user
  @ManyToMany((type) => User, (user) => user.roles)
  users: User[];
  @CreateDateColumn({ name: 'created_at' })
  createdAt: Date;

  @UpdateDateColumn({ name: 'updated_at' })
  updatedAt: Date;
}

这是在 user_role 中保存数据的方法:

let entity = await this.userRepository.create(data); //here you create new dataobject that contain user columns 

  let entity2 = { ...entity, roles: data.selectedRoles } // you have to add the association roles here 

  const user = await this.userRepository.save(entity2);