"""
Vérifie les ball skin packs en BDD
"""
import mysql.connector
from python.db_config import DB_CONFIG

conn = mysql.connector.connect(**DB_CONFIG)
cursor = conn.cursor(dictionary=True)

print("="*70)
print("BALL SKIN PACKS EN BASE DE DONNÉES")
print("="*70)
print()

cursor.execute('SELECT pack_id, name, skin_ids, is_active FROM ball_skin_packs ORDER BY id')
packs = cursor.fetchall()

for pack in packs:
    status = "✅ ACTIF" if pack['is_active'] else "❌ INACTIF"
    print(f"{status} - {pack['pack_id']}: {pack['name']}")
    skin_ids = eval(pack['skin_ids']) if isinstance(pack['skin_ids'], str) else pack['skin_ids']
    print(f"  Skins: {', '.join(skin_ids[:3])}{'...' if len(skin_ids) > 3 else ''} ({len(skin_ids)} total)")
    print()

cursor.close()
conn.close()