import mysql.connector

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 FROM users WHERE email = 'bruno@taaazzz-prog.fr' LIMIT 1")
    user = cursor.fetchone()
    user_id = user['id']
    
    print("\n=== ANALYSE DES ACHATS DE BRUNO ===\n")
    
    # Vérifier les packs d'avatars achetés
    cursor.execute(f"""
        SELECT pack_id, price_paid, purchased_at 
        FROM user_avatar_packs 
        WHERE user_id = {user_id}
        ORDER BY purchased_at DESC
    """)
    
    avatar_packs = cursor.fetchall()
    for pack in avatar_packs:
        pack_id = pack['pack_id']
        print(f"📦 Pack Avatar '{pack_id}' - {pack['price_paid']}€ - Acheté: {pack['purchased_at']}")
        
        # Voir quels avatars sont dans ce pack
        cursor.execute(f"""
            SELECT id, name FROM avatar_packs WHERE id = '{pack_id}'
        """)
        pack_info = cursor.fetchone()
        if pack_info:
            print(f"   Contient: {pack_info['name']}")
            
            # Voir les avatars du pack
            cursor.execute(f"""
                SELECT avatar_id FROM avatar_pack_avatars WHERE pack_id = '{pack_id}'
            """)
            avatars = cursor.fetchall()
            print(f"   Avatars dans le pack: {len(avatars)}")
            for avatar in avatars:
                print(f"     - Avatar ID: {avatar['avatar_id']}")
                
                # Vérifier si l'utilisateur a cet avatar
                cursor.execute(f"""
                    SELECT * FROM user_avatars 
                    WHERE user_id = {user_id} AND avatar_id = {avatar['avatar_id']}
                """)
                user_has = cursor.fetchone()
                if user_has:
                    print(f"       ✅ L'utilisateur a cet avatar")
                else:
                    print(f"       ❌ L'utilisateur N'A PAS cet avatar")
    
    # Vérifier 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
    """)
    
    skin_packs = cursor.fetchall()
    for pack in skin_packs:
        pack_id = pack['pack_id']
        print(f"\n🎨 Pack Ball Skin '{pack_id}' - {pack['price_paid']}€ - Acheté: {pack['purchased_at']}")
        
        # Voir quels skins sont dans ce pack
        cursor.execute(f"""
            SELECT id, name FROM ball_skin_packs WHERE id = '{pack_id}'
        """)
        pack_info = cursor.fetchone()
        if pack_info:
            print(f"   Contient: {pack_info['name']}")
            
            # Voir les skins du pack
            cursor.execute(f"""
                SELECT skin_id FROM ball_skin_pack_skins WHERE pack_id = '{pack_id}'
            """)
            skins = cursor.fetchall()
            print(f"   Skins dans le pack: {len(skins)}")
            for skin in skins:
                print(f"     - Skin ID: {skin['skin_id']}")
                
                # Vérifier si l'utilisateur a ce skin
                cursor.execute(f"""
                    SELECT * FROM user_ball_skins 
                    WHERE user_id = {user_id} AND skin_id = {skin['skin_id']}
                """)
                user_has = cursor.fetchone()
                if user_has:
                    print(f"       ✅ L'utilisateur a ce skin")
                else:
                    print(f"       ❌ L'utilisateur N'A PAS ce skin")
    
    cursor.close()
    connection.close()
    
except Exception as e:
    print(f"❌ Erreur: {e}")
    import traceback
from python.db_config import DB_CONFIG
    traceback.print_exc()