#!/usr/bin/env python3
"""Script pour vérifier les achats de packs d'avatars en base de données."""

import mysql.connector
from python.db_config import DB_CONFIG

def main():
    config = DB_CONFIG
    
    try:
        conn = mysql.connector.connect(**config)
        cursor = conn.cursor(dictionary=True)
        
        print("=" * 50)
        print("VÉRIFICATION DES ACHATS DE PACKS D'AVATARS")
        print("=" * 50)
        
        # 1. Vérifier les packs disponibles
        print("\n📦 PACKS DISPONIBLES:")
        cursor.execute("SELECT * FROM avatar_packs")
        packs = cursor.fetchall()
        if packs:
            for pack in packs:
                print(f"  - Pack ID: {pack['pack_id']}")
                print(f"    Nom: {pack['name']}")
                print(f"    Prix: {pack['price']}€")
                avatars = pack['avatars'].split(',') if pack['avatars'] else []
                print(f"    Nombre d'avatars: {len(avatars)}")
                print()
        else:
            print("  Aucun pack disponible")
        
        # 2. Vérifier les achats
        print("\n🛒 ACHATS DE PACKS:")
        cursor.execute("""
            SELECT uap.*, p.name as pack_name 
            FROM user_avatar_packs uap
            JOIN avatar_packs p ON uap.pack_id = p.pack_id
        """)
        purchases = cursor.fetchall()
        if purchases:
            for p in purchases:
                print(f"  - User ID: {p['user_id']}")
                print(f"    Pack: {p['pack_name']} ({p['pack_id']})")
                print(f"    Date d'achat: {p['purchased_at']}")
                print()
        else:
            print("  Aucun achat de pack enregistré")
        
        # 3. Vérifier les utilisateurs existants
        print("\n👥 UTILISATEURS RÉCENTS:")
        cursor.execute("SELECT id, pseudo, current_avatar FROM users ORDER BY id DESC LIMIT 5")
        users = cursor.fetchall()
        for user in users:
            print(f"  - ID: {user['id']}, Pseudo: {user['pseudo']}, Avatar actuel: {user['current_avatar']}")
        
        conn.close()
        print("\n✅ Vérification terminée")
        
    except mysql.connector.Error as err:
        print(f"❌ Erreur MySQL: {err}")
    except Exception as e:
        print(f"❌ Erreur: {e}")

if __name__ == "__main__":
    main()