The Status Header — Three Numbers That Tell You Everything

def dashboard_stats():
    active = db.execute(
        "SELECT COUNT(*) FROM security_sessions WHERE expires_at > ?",
        (now(),)
    ).fetchone()[0]

    fails_1h = db.execute("""
      SELECT COUNT(*) FROM security_attempts
      WHERE success = 0 AND attempted_at > ?
    """, (now() - 3600,)).fetchone()[0]

    blacklisted = db.execute(
        "SELECT COUNT(*) FROM security_blacklist"
    ).fetchone()[0]

    status = "green"
    if fails_1h >= 5 or blacklisted >= 5:
        status = "red"
    elif fails_1h >= 1 or blacklisted >= 1:
        status = "yellow"

    return {"active": active, "fails_1h": fails_1h,
            "blacklisted": blacklisted, "status": status}