import sys
from pathlib import Path
import json

# Add project root to the Python path
project_root = Path(__file__).parent.resolve()
sys.path.insert(0, str(project_root))

from core.database import SchedulerDatabase

def main():
    """
    Connects to the scheduler database and prints recent job executions and backup operations.
    """
    db = SchedulerDatabase()

    print("--- Recent Job Executions ---")
    recent_executions = db.get_recent_executions(limit=20)
    if not recent_executions:
        print("No job executions found.")
    else:
        for execution in recent_executions:
            print(f"  Execution ID: {execution['id']}")
            print(f"    Job Name: {execution['job_name']}")
            print(f"    Status: {execution['status']}")
            print(f"    Start Time: {execution['start_time']}")
            print(f"    End Time: {execution['end_time']}")
            print(f"    Duration: {execution['duration_seconds']}s")
            print("-" * 20)

    print("\n--- Recent Backup Operations ---")
    recent_backups = db.get_recent_backup_operations(limit=20)
    if not recent_backups:
        print("No backup operations found.")
    else:
        for backup in recent_backups:
            print(f"  Operation ID: {backup['id']}")
            print(f"    Profile ID: {backup['profile_id']}")
            print(f"    Type: {backup['operation_type']}")
            print(f"    Status: {backup['status']}")
            print(f"    Start Time: {backup['start_time']}")
            print(f"    End Time: {backup['end_time']}")
            print(f"    Error: {backup['error_message']}")
            print("-" * 20)

if __name__ == "__main__":
    main()