import urllib.request
import json

DB_API_URL = 'http://47.97.121.32:8080/VOLERTECH/app/api/oauth/getmysql'
DB_JDBC = 'snowy_cloud_mysql_copy'

# Query all battery cells with park and enterprise info
sql = '''
SELECT DISTINCT
    monitor_name AS 电池名称,
    park_name AS 园区名称,
    enterprise_name AS 企业名称
FROM `单体电池详情`
ORDER BY park_name, enterprise_name, monitor_name
'''

print("SQL:", sql)
req = urllib.request.Request(
    DB_API_URL,
    data=json.dumps({'sql': sql, 'basejdbc': DB_JDBC}).encode('utf-8'),
    headers={'Content-Type': 'application/json'}
)
try:
    resp = urllib.request.urlopen(req, timeout=30)
    result = json.loads(resp.read().decode('utf-8'))
    print(json.dumps(result, ensure_ascii=False, indent=2))
except Exception as e:
    print(f'Error: {e}')