import datetime
from django.core.management.base import BaseCommand
from django.utils import timezone
from accounts.models import EmailJob

class Command(BaseCommand):
    help = 'Deletes sent email jobs older than 14 days.'

    def handle(self, *args, **options):
        start_time = timezone.now()
        self.stdout.write(f"[{start_time}] Starting prune_email_jobs...")

        cutoff = start_time - datetime.timedelta(days=14)
        deleted_count, _ = EmailJob.objects.filter(status='sent', created_at__lt=cutoff).delete()

        end_time = timezone.now()
        self.stdout.write(f"[{end_time}] Completed prune_email_jobs. Pruned {deleted_count} rows.")
