Method List

backend/stores/program.go:27–67

(uid int64, f ProgramFilter)

	return row.Scan(&p.ID, &p.UserID, &p.Name, &p.Notes, &p.CreatedAt)
}

func (s *ProgramStore) List(uid int64, f ProgramFilter) ([]models.Program, error) {
	var rows *sql.Rows
	var err error
	if f.Query != "" {
		rows, err = s.db.Query(
			`SELECT `+programCols+` FROM programs WHERE user_id = ? AND LOWER(name) LIKE ? ORDER BY created_at DESC LIMIT ? OFFSET ?`,
			uid, "%"+strings.ToLower(f.Query)+"%", f.Limit, f.Offset,
		)
	} else {
		rows, err = s.db.Query(
			`SELECT `+programCols+` FROM programs WHERE user_id = ? ORDER BY created_at DESC LIMIT ? OFFSET ?`,
			uid, f.Limit, f.Offset,
		)
	}
	if err != nil {
		return nil, err
	}
	programs := []models.Program{}
	for rows.Next() {
		var p models.Program
		if err := scanProgram(rows, &p); err != nil {
			rows.Close()
			return nil, err
		}
		programs = append(programs, p)
	}
	if err := rows.Err(); err != nil {
		rows.Close()
		return nil, err
	}
	rows.Close() // close the parent cursor BEFORE loading children (#36)

	// loadDays (exercises/sets) stays a per-program call — pre-existing N+1, out of
	// scope here. currentDayIndex is batched below instead of called per-program:
	// unlike loadDays it added 2 brand-new sequential round trips per program on top
	// of that, and SetMaxOpenConns(1) serializes every one of them on the process's
	// single connection.
	for i := range programs {
		days, err := s.loadDays(programs[i].ID)
		if err != nil {
			return nil, err
		}
		programs[i].Days = days