#!/usr/bin/env python3
import pymysql

DB_CONFIG = {
    'host': 'officialsite.kr',
    'port': 23306,
    'user': 'admin',
    'password': 'dlgks~123',
    'database': 'app_master',
    'charset': 'utf8mb4'
}

conn = pymysql.connect(**DB_CONFIG)
cursor = conn.cursor()

print("=== Categories ===")
cursor.execute("SELECT id, name FROM balancepick_categories WHERE is_active = TRUE ORDER BY order_index")
for row in cursor.fetchall():
    print(f"  {row[0]} | {row[1]}")

print("\n=== Difficulties ===")
cursor.execute("SELECT id, name FROM balancepick_difficulties WHERE is_active = TRUE ORDER BY order_index")
for row in cursor.fetchall():
    print(f"  {row[0]} | {row[1]}")

print("\n=== Games count by category/difficulty ===")
cursor.execute("""
    SELECT category_id, difficulty_id, COUNT(*) as cnt
    FROM balancepick_games
    WHERE is_public = TRUE
    GROUP BY category_id, difficulty_id
    ORDER BY category_id, difficulty_id
""")
for row in cursor.fetchall():
    print(f"  {row[0]} | {row[1]} | {row[2]}")

cursor.close()
conn.close()