query with multiple tables & relations

[mrjawright]

if you have 3 tables:

type AccessGroup struct {
	bun.BaseModel `bun:"table:access_groups,alias:ag"`
	Id            int64      `bun:",pk,autoincrement"`
	Name          string     `bun:",unique"`
	Users         []User     `bun:"m2m:user_to_access_groups,join:AccessGroup=User"`
	EndPoints     []Endpoint `bun:"m2m:access_group_to_endpoints,join:AccessGroup=Endpoint"`
}

type Endpoint struct {
	bun.BaseModel `bun:"table:endpoints,alias:ep"`
	Id            int64         `bun:",pk,autoincrement"`
	Name          string        `bun:",unique"`
	AccessGroups  []AccessGroup `bun:"m2m:access_group_to_endpoints,join:Endpoint=AccessGroup"`
}

type User struct {
	bun.BaseModel `bun:"table:users,alias:u"`
	Email         string        `bun:",notnull"`
	UserId        uuid.UUID     `bun:"type:uuid,pk"`
	AccessGroups  []AccessGroup `bun:"m2m:user_to_access_groups,join:User=AccessGroup"`
	Password      string        `bun:",notnull"`
}

and two relations:

type AccessGroupToEndpoint struct {
	GroupId     int64        `bun:",pk"`
	AccessGroup *AccessGroup `bun:"rel:belongs-to,join:group_id=id"`
	EndpointId  int64        `bun:",pk"`
	Endpoint    *Endpoint    `bun:"rel:belongs-to,join:endpoint_id=id"`
}

type UserToAccessGroup struct {
	UserId      uuid.UUID    `bun:",pk"`
	User        *User        `bun:rel:belongs-to,join:user_id=user_id`
	GroupId     int64        `bun:",pk"`
	AccessGroup *AccessGroup `bun:"rel:belongs-to,join:group_id=id"`
}

How can I write a query that will return all of the Endpoint records for a given User? Is there a way to write a single query that uses the relations to link all the tables?

[GamerGirlandCo]

Did you ever figure this out?

[mrjawright]

I was evaluating a couple of different options at the time, and I don't remember if I solved this issues with this orm, or just abandoned ORMs altogether.