typescript - 如何计算 OneToMany 关系?
问题描述
我有如下关系:
项目实体
@OneToMany(() => UserProjectRelations, userProject => userProject.projectId, {
onUpdate: 'CASCADE',
onDelete: 'CASCADE'
})
members: UserProjectRelations[];
UserProjectRelations.entity
@ManyToOne(() => Project, {
nullable: false,
onUpdate: 'CASCADE',
onDelete: 'CASCADE',
primary: true,
})
@JoinColumn({
name: 'projectId',
})
projectId: Project;
我有如下查询:
const projects = await this.conn.getRepository(UserProjectRelations).createQueryBuilder('userProject')
.innerJoin("userProject.userId", "user", "user.id = :userId", { userId: user.id })
.leftJoinAndSelect("userProject.projectId", "projectId")
如何使用上面的查询获取members
来自的计数?Project.entity
我需要使用此查询,因为我需要与他一起获取另一个重要数据,但另外我需要获取UserProjectRelations
inmembers
数组的计数,
谢谢你的帮助