import pymysql

conn = pymysql.connect(
    host='officialsite.kr',
    port=23306,
    user='admin',
    password='dlgks~123',
    database='app_master',
    charset='utf8mb4'
)

cursor = conn.cursor(pymysql.cursors.DictCursor)

# users 테이블 구조 확인
print("=" * 60)
print("users 테이블 구조")
print("=" * 60)

cursor.execute("DESCRIBE users")
columns = cursor.fetchall()

for col in columns:
    print(f"  {col['Field']:20} | {col['Type']:40} | {col['Null']} | {col['Key']} | {col['Default']}")

# login_type enum 값 확인
print("\n" + "=" * 60)
print("login_type ENUM 값 확인")
print("=" * 60)

cursor.execute("""
    SELECT COLUMN_TYPE
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA = 'app_master'
    AND TABLE_NAME = 'users'
    AND COLUMN_NAME = 'login_type'
""")
result = cursor.fetchone()
if result:
    print(f"  {result['COLUMN_TYPE']}")

# calmoa 앱의 기존 사용자 확인
print("\n" + "=" * 60)
print("기존 사용자 (app_name 별)")
print("=" * 60)

cursor.execute("""
    SELECT app_name, login_type, COUNT(*) as cnt
    FROM users
    GROUP BY app_name, login_type
""")
results = cursor.fetchall()

for r in results:
    print(f"  {r['app_name']:20} | {r['login_type']:10} | {r['cnt']} 명")

cursor.close()
conn.close()