[QUESTION] Has-many filtering queries

[kubakl]

I need to query for entities that have a has-many relation with another table. Example:

type Recipe struct {
    ID int64
    Name string
    Categories []*RecipeCategory `bun:"rel:has-many,join:id=recipe_id"`
}

type Category struct {
    ID int64
    Name string
}

type RecipeCategory struct {
    ID int64
    CategoryID int64
    RecipeID int64
}

Let's say I want to query for a recipe where category_id is equal to 1 or 2. How I can do that?

[danclive]

var items []Recipe
err := service.GetDB().NewSelect().
	Model(&items).
	Relation("Categories", func(q *bun.SelectQuery) *bun.SelectQuery {
		return q.Where("category_id IN (?)", bun.In([]int64{1, 2}))
	}).
	Scan(context.Background())
if err != nil {
	panic(err)
}
fmt.Printf("%v\n", items)