#!/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("=== Game status distribution ===")
cursor.execute("""
    SELECT status, COUNT(*) as cnt
    FROM balancepick_games
    GROUP BY status
""")
for row in cursor.fetchall():
    print(f"  {row[0]}: {row[1]}")

print("\n=== Updating all system games to approved ===")
cursor.execute("""
    UPDATE balancepick_games
    SET status = 'approved'
    WHERE user_id = 'system' AND (status IS NULL OR status != 'approved')
""")
affected = cursor.rowcount
conn.commit()
print(f"  Updated {affected} games")

print("\n=== After update ===")
cursor.execute("""
    SELECT status, COUNT(*) as cnt
    FROM balancepick_games
    GROUP BY status
""")
for row in cursor.fetchall():
    print(f"  {row[0]}: {row[1]}")

cursor.close()
conn.close()