Function TestGenericsNestedJoins

tests/generics_test.go:461–535

(t *testing.T)

}

func TestGenericsNestedJoins(t *testing.T) {
	users := []User{
		{
			Name: "generics-nested-joins-1",
			Manager: &User{
				Name: "generics-nested-joins-manager-1",
				Company: Company{
					Name: "generics-nested-joins-manager-company-1",
				},
				NamedPet: &Pet{
					Name: "generics-nested-joins-manager-namepet-1",
					Toy: Toy{
						Name: "generics-nested-joins-manager-namepet-toy-1",
					},
				},
			},
			NamedPet: &Pet{Name: "generics-nested-joins-namepet-1", Toy: Toy{Name: "generics-nested-joins-namepet-toy-1"}},
		},
		{
			Name:     "generics-nested-joins-2",
			Manager:  GetUser("generics-nested-joins-manager-2", Config{Company: true, NamedPet: true}),
			NamedPet: &Pet{Name: "generics-nested-joins-namepet-2", Toy: Toy{Name: "generics-nested-joins-namepet-toy-2"}},
		},
	}

	ctx := context.Background()
	db := gorm.G[User](DB)
	db.CreateInBatches(ctx, &users, 100)

	var userIDs []uint
	for _, user := range users {
		userIDs = append(userIDs, user.ID)
	}

	users2, err := db.Joins(clause.LeftJoin.Association("Manager"), nil).
		Joins(clause.LeftJoin.Association("Manager.Company"), nil).
		Joins(clause.LeftJoin.Association("Manager.NamedPet.Toy"), nil).
		Joins(clause.LeftJoin.Association("NamedPet.Toy"), nil).
		Joins(clause.LeftJoin.Association("NamedPet").As("t"), nil).
		Where(map[string]any{"id": userIDs}).Find(ctx)

	if err != nil {
		t.Fatalf("Failed to load with joins, got error: %v", err)
	} else if len(users2) != len(users) {
		t.Fatalf("Failed to load join users, got: %v, expect: %v", len(users2), len(users))
	}

	sort.Slice(users2, func(i, j int) bool {
		return users2[i].ID > users2[j].ID
	})

	sort.Slice(users, func(i, j int) bool {
		return users[i].ID > users[j].ID
	})

	for idx, user := range users {
		// user
		CheckUser(t, user, users2[idx])