================================================================================
CRUNCHYROLL DOWNLOADER - CHALLENGE 2 SOLUTION
Chapter 5: Complete Workflow
Challenge: Episode Export
================================================================================

PROBLEM:
Export episode data to CSV with columns: show, episode, date watched.

SOLUTION:
================================================================================

File: download.py (CSV export)

import csv
from pathlib import Path

def export_to_csv(episodes: list, filename: str = "episodes.csv"):
    """Export episodes to CSV file."""

    if not episodes:
        print("⚠️  No episodes to export")
        return False

    print(f"💾 Exporting to {filename}...")

    try:
        with open(filename, 'w', newline='', encoding='utf-8') as f:
            writer = csv.DictWriter(f, fieldnames=[
                'show_name',
                'episode_number',
                'episode_name',
                'date_watched',
                'duration_minutes'
            ])

            writer.writeheader()
            writer.writerows(episodes)

        print(f"✅ Exported {len(episodes)} episodes to {filename}")
        return True

    except Exception as e:
        print(f"❌ Error exporting: {e}")
        return False


USAGE
================================================================================

from crunchyroll_utils import parse_episodes
from download import export_to_csv

# Get and parse episodes
episodes = client.get_episodes()
parsed = parse_episodes(episodes)

# Export
export_to_csv(parsed, "my_anime_list.csv")


OUTPUT (CSV file)
================================================================================

show_name,episode_number,episode_name,date_watched,duration_minutes
Attack on Titan,1,Colossus,2026-06-15T12:30:00,23
Attack on Titan,2,That Day,2026-06-16T20:15:00,24
Demon Slayer,1,Demon Slayer,2026-06-20T19:00:00,24
...

================================================================================