#!/usr/bin/env python3
from app import app
from models import db, SummarizationJob
from datetime import datetime, timedelta

with app.app_context():
    recent_jobs = SummarizationJob.query.filter(
        SummarizationJob.created_at > datetime.utcnow() - timedelta(minutes=15)
    ).order_by(SummarizationJob.created_at.desc()).limit(10).all()
    
    print(f"Found {len(recent_jobs)} recent summarization jobs:")
    print("-" * 80)
    
    for j in recent_jobs:
        print(f"Job UUID: {j.job_uuid[:8]}...")
        print(f"  Status: {j.status}")
        print(f"  File: {j.original_filename}")
        print(f"  Created: {j.created_at}")
        print(f"  Error: {j.error_message if j.error_message else 'None'}")
        print(f"  Type: {j.summary_type}, Length: {j.summary_length}")
        if j.file_path:
            import os
            if os.path.exists(j.file_path):
                file_size = os.path.getsize(j.file_path) / (1024 * 1024)
                print(f"  File Size: {file_size:.2f} MB")
        print("-" * 80)