"""
Liste tous les skin IDs utilisés
"""
import mysql.connector
import json
from python.db_config import DB_CONFIG

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

print("="*70)
print("TOUS LES SKIN IDs UTILISÉS EN BASE")
print("="*70)
print()

cursor.execute('SELECT pack_id, skin_ids FROM ball_skin_packs')
packs = cursor.fetchall()

all_skins = []
for pack in packs:
    skin_ids = json.loads(pack['skin_ids'])
    print(f"{pack['pack_id']}:")
    for sid in skin_ids:
        all_skins.append(sid)
        print(f"  - {sid}")
    print()

print("="*70)
print(f"TOTAL: {len(all_skins)} skins utilisés")
print("="*70)

# Analyser les préfixes
prefixes = {}
for sid in all_skins:
    parts = sid.split('_')
    if len(parts) >= 2:
        prefix = '_'.join(parts[:-1])
        prefixes[prefix] = prefixes.get(prefix, 0) + 1

print("\nPréfixes utilisés:")
for prefix, count in sorted(prefixes.items()):
    print(f"  {prefix}: {count} skins")

cursor.close()
conn.close()