#!/bin/bash

OUTPUT_CSV="shrewsbury_all_programs.csv"
echo "Program,Section,Dates,Schedule,Location,StartDate" > "$OUTPUT_CSV"

for FILE in raw_programs/*.json; do
  # Extract program name and sections in one jq pass
  jq -r '.data | .programName as $pname | .sections[] | [
    $pname,
    .name,
    (.sessionsSummary.dateRange // ""),
    (.sessionsSummary.recurrenceSummary // ""),
    (.sessionsSummary.locationSummary // ""),
    (.startDate // "")
  ] | @csv' "$FILE" >> "$OUTPUT_CSV"
done

echo "Done. Saved to $OUTPUT_CSV"
wc -l "$OUTPUT_CSV"