使用TypeORM更新表的多对多自定义属性

// User.ts
import { Entity, PrimaryGeneratedColumn, Column, ManyToMany, JoinTable } from 'typeorm';
import { Role } from './Role';

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

  @Column()
  name: string;

  @ManyToMany(() => Role)
  @JoinTable()
  roles: Role[];
}

// Role.ts
import { Entity, PrimaryGeneratedColumn, Column, ManyToMany } from 'typeorm';
import { User } from './User';

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

  @Column()
  name: string;

  @ManyToMany(() => User, user => user.roles)
  users: User[];
}

// User.ts
import { Entity, PrimaryGeneratedColumn, Column, ManyToMany, JoinTable } from 'typeorm';
import { Role } from './Role';

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

  @Column()
  name: string;

  @ManyToMany(() => Role)
  @JoinTable({
    name: 'user_role',
    joinColumn: {
      name: 'user_id',
      referencedColumnName: 'id',
    },
    inverseJoinColumn: {
      name: 'role_id',
      referencedColumnName: 'id',
    },
  })
  roles: Role[];
}

// Role.ts
import { Entity, PrimaryGeneratedColumn, Column, ManyToMany } from 'typeorm';
import { User } from './User';

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

  @Column()
  name: string;

  @Column()
  customProperty: string;

  @ManyToMany(() => User, user => user.roles)
  users: User[];
}

import { getRepository } from 'typeorm';
import { User } from './User';
import { Role } from './Role';

async function updateUserRoles(userId: number, roleId: number, customProperty: string) {
  const userRepository = getRepository(User);
  const roleRepository = getRepository(Role);

  const user = await userRepository.findOne(userId);
  const role = await roleRepository.findOne(roleId);

  if (user && role) {
    user.roles.push(role);
    role.customProperty = customProperty;

    await userRepository.save(user);
    await roleRepository.save(role);
  }
}