import mysql.connector
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()
    user_id = user['id']
    
    print(f"\n🔍 ANALYSE DU PACK PLATINUM 6.99€\n")
    
    # Chercher tous les achats de packs
    cursor.execute(f"""
        SELECT * FROM user_avatar_packs 
        WHERE user_id = {user_id}
        ORDER BY purchased_at DESC
    """)
    avatar_packs = cursor.fetchall()
    if avatar_packs:
        print("📦 Achats d'Avatar Packs:")
        for pack in avatar_packs:
            print(f"  - {pack['pack_id']}: {pack['price_paid']}€ ({pack['purchased_at']})")
    
    cursor.execute(f"""
        SELECT * FROM user_ball_skin_packs 
        WHERE user_id = {user_id}
        ORDER BY purchased_at DESC
    """)
    skin_packs = cursor.fetchall()
    if skin_packs:
        print("\n🎨 Achats de Ball Skin Packs:")
        for pack in skin_packs:
            print(f"  - {pack['pack_id']}: {pack['price_paid']}€ ({pack['purchased_at']})")
    
    # Vérifier les points bonus de l'utilisateur
    cursor.execute(f"""
        SELECT bonus_points, hints_remaining, skips_remaining, solutions_remaining
        FROM user_data 
        WHERE user_id = {user_id}
    """)
    user_data = cursor.fetchone()
    if user_data:
        print(f"\n💰 État actuel de l'utilisateur:")
        print(f"   Points bonus: {user_data['bonus_points']}")
        print(f"   Indices restants: {user_data['hints_remaining']}")
        print(f"   Annulations restantes: {user_data['skips_remaining']}")
        print(f"   Solutions restantes: {user_data['solutions_remaining']}")
    
    # Chercher les transactions récentes
    cursor.execute("SHOW TABLES")
    all_tables = [table[0] for table in cursor.fetchall()]
    
    print(f"\n📊 Tables trouvées contenant 'pack':")
    pack_tables = [t for t in all_tables if 'pack' in t.lower()]
    for table in pack_tables:
        print(f"   - {table}")
    
    # Chercher s'il existe une table audit_log ou transactions
    print(f"\n📊 Tables trouvées contenant 'audit' ou 'log':")
    log_tables = [t for t in all_tables if 'audit' in t.lower() or 'log' in t.lower()]
    for table in log_tables:
        print(f"   - {table}")
    
    # Chercher s'il existe une table charge_pack ou bonus_pack
    print(f"\n📊 Toutes les tables de la DB:")
    for table in sorted(all_tables)[:20]:
        print(f"   - {table}")
    
    cursor.close()
    connection.close()
    
except Exception as e:
    print(f"❌ Erreur: {e}")