AIDA / scripts /reset_alerts_for_testing.py
destinyebuka's picture
fyp
f9598ce
#!/usr/bin/env python3
"""
Script to reset alert notification status for testing
This clears the last_notified_at timestamp so alerts will trigger again
"""
import asyncio
import sys
from pathlib import Path
# Add parent directory to path
sys.path.insert(0, str(Path(__file__).parent.parent))
from app.database import connect_db, disconnect_db, get_db
import logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
async def reset_alert_notifications():
"""Reset all alerts' last_notified_at to allow re-triggering"""
try:
# Connect to database
await connect_db()
db = await get_db()
# Reset all active alerts
result = await db.search_alerts.update_many(
{"is_active": True},
{"$set": {"last_notified_at": None}}
)
logger.info(f"✅ Reset {result.modified_count} alert(s)")
# Show active alerts
alerts = await db.search_alerts.find({"is_active": True}).to_list(length=None)
if alerts:
logger.info(f"\n{'='*60}")
logger.info(f"Active Alerts (Ready to Trigger Again):")
logger.info(f"{'='*60}")
for alert in alerts:
logger.info(f" Alert ID: {alert.get('_id')}")
logger.info(f" User: {alert.get('user_id')}")
logger.info(f" Query: {alert.get('user_query')}")
logger.info(f" Location: {alert.get('search_params', {}).get('location', 'Any')}")
logger.info(f" Last Notified: {alert.get('last_notified_at', 'Never')}")
logger.info(f" {'-'*60}")
logger.info(f"{'='*60}\n")
except Exception as e:
logger.error(f"Failed to reset alerts: {e}")
raise
finally:
await disconnect_db()
if __name__ == "__main__":
logger.info("Resetting alert notifications for testing...")
asyncio.run(reset_alert_notifications())