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

try:
    connection = mysql.connector.connect(**DB_CONFIG, ssl_disabled=True)
    
    cursor = connection.cursor(dictionary=True)
    
    # Récupérer l'user ID
    cursor.execute("SELECT id, email FROM users WHERE email = 'bruno@taaazzz-prog.fr' LIMIT 1")
    user = cursor.fetchone()
    
    if user:
        print(f"\n✅ Utilisateur trouvé: {user['email']} (ID: {user['id']})")
        
        # Vérifier les achats d'avatar packs
        cursor.execute(f"""
            SELECT pack_id, price_paid, purchased_at 
            FROM user_avatar_packs 
            WHERE user_id = {user['id']}
            ORDER BY purchased_at DESC 
            LIMIT 10
        """)
        
        avatar_packs = cursor.fetchall()
        if avatar_packs:
            print(f"\n📦 Achats d'Avatar Packs:")
            for pack in avatar_packs:
                print(f"  - Pack {pack['pack_id']}: {pack['price_paid']}€ ({pack['purchased_at']})")
        else:
            print(f"\n❌ Aucun achat d'avatar pack trouvé")
        
        # Vérifier les achats de ball skin packs
        cursor.execute(f"""
            SELECT pack_id, price_paid, purchased_at 
            FROM user_ball_skin_packs 
            WHERE user_id = {user['id']}
            ORDER BY purchased_at DESC 
            LIMIT 10
        """)
        
        skin_packs = cursor.fetchall()
        if skin_packs:
            print(f"\n🎨 Achats de Ball Skin Packs:")
            for pack in skin_packs:
                print(f"  - Pack {pack['pack_id']}: {pack['price_paid']}€ ({pack['purchased_at']})")
        else:
            print(f"\n❌ Aucun achat de ball skin pack trouvé")
        
        # Vérifier les avatars de l'utilisateur
        cursor.execute(f"""
            SELECT COUNT(DISTINCT avatar_id) as total_avatars
            FROM user_avatars 
            WHERE user_id = {user['id']}
        """)
        result = cursor.fetchone()
        print(f"\n👤 Total des avatars débloqués: {result['total_avatars']}")
        
        # Vérifier le dernier achat Stripe
        cursor.execute(f"""
            SELECT * FROM stripe_sessions
            WHERE user_id = {user['id']}
            ORDER BY created_at DESC 
            LIMIT 5
        """)
        
        sessions = cursor.fetchall()
        if sessions:
            print(f"\n💳 Sessions Stripe récentes:")
            for session in sessions:
                print(f"  - Session {session.get('session_id')}: Status={session.get('status')} ({session.get('created_at')})")
        
    else:
        print("❌ Utilisateur non trouvé")
    
    cursor.close()
    connection.close()
    
except Exception as e:
    print(f"❌ Erreur: {e}")