#!/usr/bin/env python3
"""Check status of recent summarization jobs"""
from app import app
from models import db, SummarizationJob, Case
from datetime import datetime, timedelta

with app.app_context():
    # Get case 6
    case = Case.query.get(6)
    if case:
        print(f"Case: {case.case_name}\n")

        # Get recent summarization jobs for this case (last 10 minutes)
        recent_jobs = SummarizationJob.query.filter(
            SummarizationJob.case_id == 6,
            SummarizationJob.created_at > datetime.utcnow() - timedelta(minutes=10)
        ).order_by(SummarizationJob.created_at.desc()).all()

        print(f"Found {len(recent_jobs)} recent summarization job(s):\n")

        for job in recent_jobs:
            print(f"Job UUID: {job.job_uuid}")
            print(f"  Filename: {job.original_filename}")
            print(f"  Status: {job.status}")
            print(f"  Created: {job.created_at}")

            if job.status == 'completed':
                print(f"  Has Results: {job.results is not None}")
                if job.results:
                    print(f"  Summary Length: {len(job.results.summary)} chars")
            elif job.status == 'failed':
                print(f"  Error: {job.error_message}")

            print()
    else:
        print("Case 6 not found")