#!/usr/bin/env python3
"""Script pour vérifier les logs d'authentification d'un utilisateur"""

import mysql.connector
import sys
from python.db_config import DB_CONFIG

def check_auth_logs(email):
    try:
        conn = mysql.connector.connect(**DB_CONFIG)
        cursor = conn.cursor(dictionary=True)
        
        # Trouver l'utilisateur
        cursor.execute("SELECT id, email FROM users WHERE email = %s", (email,))
        user = cursor.fetchone()
        
        if not user:
            print(f"❌ Aucun utilisateur trouvé avec l'email: {email}")
            return
        
        user_id = user['id']
        print(f"👤 Utilisateur: {user['email']} - ID: {user_id}")
        print()
        
        # Vérifier les logs d'authentification
        cursor.execute("""
            SELECT * FROM audit_log 
            WHERE user_id = %s AND action = 'auth.login'
            ORDER BY created_at DESC 
            LIMIT 5
        """, (user_id,))
        logs = cursor.fetchall()
        
        print("📋 Logs d'authentification (5 derniers):")
        if logs:
            for log in logs:
                print(f"   - {log['created_at']} | IP: {log.get('ip_address', 'N/A')} | Details: {log.get('details', 'N/A')[:50]}")
        else:
            print("   ⚠️  Aucun log d'authentification trouvé (action='auth.login')")
        
        cursor.close()
        conn.close()
        
    except mysql.connector.Error as err:
        print(f"❌ Erreur de connexion à la base de données: {err}")

if __name__ == "__main__":
    email = sys.argv[1] if len(sys.argv) > 1 else "bruno@taaazzz.be"
    check_auth_logs(email)