#!/usr/bin/env python3
"""
检查应用状态
"""
import pymysql
from urllib.parse import urlparse
import os
from dotenv import load_dotenv

load_dotenv()

def check_app():
    """检查应用状态"""
    database_url = os.getenv('DATABASE_URL', '')
    parsed = urlparse(database_url)
    config = {
        'host': parsed.hostname or 'localhost',
        'port': parsed.port or 3306,
        'user': parsed.username or 'root',
        'password': parsed.password or '',
        'database': parsed.path[1:] if parsed.path else 'sso_db',
        'charset': 'utf8mb4'
    }

    try:
        conn = pymysql.connect(**config)
        cursor = conn.cursor()
        
        cursor.execute("""
            SELECT name, app_key, is_trusted, is_active, redirect_uris, scope 
            FROM apps 
            WHERE app_key = %s
        """, ('eqhoIdAyAWbA8MsYHsNqQqNLJbCayTjY',))
        
        result = cursor.fetchone()
        if result:
            print(f'应用名称: {result[0]}')
            print(f'App Key: {result[1]}')
            print(f'受信任: {result[2]}')
            print(f'激活状态: {result[3]}')
            print(f'回调URL: {result[4]}')
            print(f'权限范围: {result[5]}')
        else:
            print('❌ 未找到应用')
            
        cursor.close()
        conn.close()
        
    except Exception as e:
        print(f'❌ 检查失败: {e}')

if __name__ == "__main__":
    check_app()