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 
    bt.name AS 电池名称, 
    p.name AS 园区名称, 
    e.name AS 企业名称 
FROM battery_table bt 
LEFT JOIN park p ON bt.park_id = p.id 
LEFT JOIN enterprise e ON bt.enterprise_id = e.id 
ORDER BY p.name, e.name, bt.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}')