Function TestGenericsNestedPreloads

tests/generics_test.go:658–707

(t *testing.T)

}

func TestGenericsNestedPreloads(t *testing.T) {
	user := *GetUser("generics_nested_preload", Config{Pets: 2})
	user.Friends = []*User{GetUser("generics_nested_preload", Config{Pets: 5})}

	ctx := context.Background()
	db := gorm.G[User](DB)

	for idx, pet := range user.Pets {
		pet.Toy = Toy{Name: "toy_nested_preload_" + strconv.Itoa(idx+1)}
	}

	if err := db.Create(ctx, &user); err != nil {
		t.Fatalf("errors happened when create: %v", err)
	}

	user2, err := db.Preload("Pets.Toy", nil).Preload("Friends.Pets", func(db gorm.PreloadBuilder) error {
		return nil
	}).Where(user.ID).Take(ctx)
	if err != nil {
		t.Errorf("failed to nested preload user")
	}
	CheckUser(t, user2, user)
	if len(user.Pets) == 0 || len(user.Friends) == 0 || len(user.Friends[0].Pets) == 0 {
		t.Fatalf("failed to nested preload")
	}

	if DB.Dialector.Name() == "mysql" {
		// mysql 5.7 doesn't support row_number()
		if strings.HasPrefix(DB.Dialector.(*mysql.Dialector).ServerVersion, "5.7") {
			return
		}
	}
	if DB.Dialector.Name() == "sqlserver" {
		// sqlserver doesn't support order by in subquery
		return
	}

	user3, err := db.Preload("Pets.Toy", nil).Preload("Friends.Pets", func(db gorm.PreloadBuilder) error {
		db.LimitPerRecord(3)
		return nil
	}).Where(user.ID).Take(ctx)
	if err != nil {
		t.Errorf("failed to nested preload user")
	}
	CheckUser(t, user3, user)

	if len(user3.Friends) != 1 || len(user3.Friends[0].Pets) != 3 {
		t.Errorf("failed to nested preload with limit per record")
	}
}

func TestGenericsDistinct(t *testing.T) {
	ctx := context.Background()