A better way to query relations from ids of the other?

[frederikhors]

May I ask you what would you do in this case?

I have this situation:

type Profile struct {
	ID     int64 `bun:",pk"`
	Lang   string
	UserID int64
	User *User `rel:"belongs-to"`
}

type User struct {
	ID      int64 `bun:",pk"`
	Name    string
	Profile *Profile `bun:"rel:has-one"`
}

I'm using GraphQL and in a resolver I need to retrieve all Users from Profiles IDs.

Right now I'm doing this:

func (r repo) UsersByProfileIDs(ctx context.Context, ids []uint64) ([]User, error) {
	res := make([]User, 0, len(ids))

	err := r.db.NewSelect().Model(&res).Relation("Profile").Where("profile.user_id in (?)", bun.In(ids)).Scan(ctx)
	if err != nil {
		// handle err
	}

	return res, nil
}

This works but I was wondering if it's a choice you appreciate or if I can do better.

[vmihailenco]

Looks pretty good 👍