import logging
from django.core.management.base import BaseCommand
from django.utils import timezone
from datetime import timedelta

logger = logging.getLogger(__name__)


class Command(BaseCommand):
    help = 'Remove SecurityEvent rows older than 90 days.'

    def handle(self, *args, **options):
        from core.models import SecurityEvent
        cutoff = timezone.now() - timedelta(days=90)
        deleted, _ = SecurityEvent.objects.filter(created_at__lt=cutoff).delete()
        self.stdout.write(f"prune_logs: deleted {deleted} security events.")
        logger.info(f"prune_logs: deleted {deleted} rows older than 90 days.")
