Method loadExercises

backend/stores/program.go:180–220

loadExercises scans + closes the parent cursor BEFORE loading each exercise's sets (#36), and surfaces scan errors.

(programID int64)

	for i := range ids {
		idSelects[i] = "SELECT ? AS program_id"
		inPlaceholders[i] = "?"
	}
	idsCSV := strings.Join(inPlaceholders, ",")

	query := `
		WITH ids(program_id) AS (` + strings.Join(idSelects, " UNION ALL ") + `),
		anchors AS (
			SELECT w.program_id AS program_id, w.program_day_id AS anchor_day_id,
			       w.id AS anchor_wid, w.started_at AS anchor_started_at
			FROM workouts w
			JOIN program_days pd ON pd.id = w.program_day_id
			WHERE w.user_id = ? AND pd.is_rest_day = 0 AND w.program_id IN (` + idsCSV + `)
			  AND NOT EXISTS (
				SELECT 1 FROM workouts w2
				JOIN program_days pd2 ON pd2.id = w2.program_day_id
				WHERE w2.user_id = w.user_id AND w2.program_id = w.program_id AND pd2.is_rest_day = 0
				  AND (w2.started_at > w.started_at OR (w2.started_at = w.started_at AND w2.id > w.id))
			  )
		)
		SELECT ids.program_id, a.anchor_day_id, a.anchor_wid, a.anchor_started_at,
			(SELECT COUNT(*) FROM workouts w
			 WHERE w.user_id = ? AND w.program_id = ids.program_id
			   AND w.program_day_id IS NULL AND w.program_day_dropped = 0
			   AND (a.anchor_started_at IS NULL
			        OR w.started_at > a.anchor_started_at
			        OR (w.started_at = a.anchor_started_at AND w.id > a.anchor_wid))
			) AS unlinked
		FROM ids
		LEFT JOIN anchors a ON a.program_id = ids.program_id`

	args := make([]any, 0, 2*len(ids)+2)
	for _, id := range ids {
		args = append(args, id)
	}
	args = append(args, uid)
	for _, id := range ids {
		args = append(args, id)
	}
	args = append(args, uid)

	rows, err := s.db.Query(query, args...)
	if err != nil {
		return nil, err
	}