Loading nested relationships results in empty structs

[krsmll]

Hello.

I've encountered an issue where I cannot load nested relationships.

Here is the code:

tracklist, err := dbmodels.Tracklists(
    dbmodels.TracklistWhere.UserID.EQ(userID),
    qm.Load(dbmodels.TracklistRels.TracklistTitles,
	    qm.Load(dbmodels.TracklistTitleRels.Status),
	    qm.Load(dbmodels.TracklistTitleRels.Title,
		    qm.Load(dbmodels.TitleRels.Genres, qm.Limit(3)),
		    qm.Load(dbmodels.TitleRels.Format),
		    qm.Load(dbmodels.TitleRels.Type),
	    ),
    ),
).One(ctx, tx)

Returned struct looks like this, notice the relations for the TracklistTitle are nil.

Here is the ERD for these tables:

I also tried using qm.Rels() as shown in the example, however that didn't work for another reason:
Error #01: dbmodels: failed to execute a one query for tracklists: could not find LoadType method for eager loading

Any help would be appreciated!

[stephenafamo]

Can you print out all the generated queries with boil.DebugMode = true?

[krsmll]

Yes, here you go:

SELECT "tracklists".* FROM "tracklists" WHERE ("tracklists"."user_id" = $1) LIMIT 1;
[2]
SELECT * FROM "tracklist_titles" WHERE ("tracklist_titles"."tracklist_id" IN ($1));
[2]