Function TestCreateProgram_setNumberNormalized

backend/controllers/programs_test.go:189–220

(t *testing.T)

	if w.Code != http.StatusOK {
		t.Fatalf("expected 200, got %d: %s", w.Code, w.Body.String())
	}

	// Old exercise should be gone
	var count int
	db.DB.QueryRow(`SELECT COUNT(*) FROM program_exercises WHERE program_id = ? AND exercise_id = ?`, pid, exID).Scan(&count)
	if count != 0 {
		t.Error("old exercise not removed after update")
	}

	// New exercise should exist
	db.DB.QueryRow(`SELECT COUNT(*) FROM program_exercises WHERE program_id = ? AND exercise_id = ?`, pid, exID2).Scan(&count)
	if count != 1 {
		t.Error("new exercise not found after update")
	}
}

func TestCreateProgram_setNumberNormalized(t *testing.T) {
	setupTestDB(t)
	uid := createTestUser(t)
	exID := createTestExercise(t)

	// Send set_number: 0 — backend should normalize to 1
	body := map[string]any{
		"name": "Norm Test",
		"days": []map[string]any{
			{
				"is_rest_day": false,
				"exercises": []map[string]any{
					{
						"exercise_id": exID,
						"sets":        []map[string]any{{"set_number": 0, "target_reps": 10, "target_weight": 50.0}},
					},
				},
			},