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'

# Show all tables
sql = 'SHOW TABLES'

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}')
