import mysql.connector

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

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

# 카테고리별, 난이도별 게임 수 확인
cursor.execute("""
    SELECT
        c.name as category,
        d.name as difficulty,
        COUNT(g.id) as game_count
    FROM balancepick_categories c
    CROSS JOIN balancepick_difficulties d
    LEFT JOIN balancepick_games g ON g.category_id = c.id AND g.difficulty_id = d.id
    WHERE c.is_active = TRUE AND d.is_active = TRUE
    GROUP BY c.id, d.id
    ORDER BY c.order_index, d.order_index
""")

print("카테고리 | 난이도 | 게임 수")
print("-" * 40)
for row in cursor.fetchall():
    print(f"{row[0]} | {row[1]} | {row[2]}")

# 전체 게임 수
cursor.execute("SELECT COUNT(*) FROM balancepick_games")
total = cursor.fetchone()[0]
print(f"\n총 게임 수: {total}")

# 전체 질문 수
cursor.execute("SELECT COUNT(*) FROM balancepick_questions")
total_q = cursor.fetchone()[0]
print(f"총 질문 수: {total_q}")

cursor.close()
conn.close()