typeorm查询多托马尼关系

Question

我正在尝试查询桌子产品以查找某些具有“类别“食物”，“冷”的产品。

我希望有人可以给我一个人，以便查询两个或更多类别 我能够使它充满活力，但我在QueryBuilder上挣扎

@Entity()
export class Product{
    @Property()
    @ManyToMany(() => Category, category=> category.products)
    @JoinTable({
        name: "product_category",
        joinColumn: {
            name: "product",
            referencedColumnName: "Id"
        },
        inverseJoinColumn: {
            name: "category",
            referencedColumnName: "Id"
        }
    })
    categories: Category[];
    }

@Entity()
export class Category {
    @Property()
    @PrimaryGeneratedColumn("uuid")
    Id: string;

    @Column()
    @Property()
    name: string;

    @Property()
    @ManyToMany(() => LibraryItems, libraryItem => libraryItem.categories)
    products: Product[];
}

我尝试使用此信息： query.Where（“ categories.name in（：... name1）和categories.name in（：... name2）”，{name1：“ food”，name2：“ cold”}）

Answer 1

我们讨论。这是查询的一个示例将是：

    ...select(["count(categories.name) as count","o.*"]) 
             // count(categories.name) here to get total of categories
    .where('categories.name in (:...categories)',{categories})
            // filter by user ids we need
    .groupBy('product.id')
    .having("count = :count", {count:categories.length})
           // here we check if the products has the categories we want 
    .getRawMany();

ps：正如您在评论中提到的那样，这个问题将至少用想要的类别

进行全局示例，其中mysql查询 使用W3School数据库

SELECT o.*,count(o.OrderID) as total FROM OrderDetails as o join Products as p  on o.ProductId = p.ProductID where o.ProductID in (11) group by o.OrderID having total = 3;