AiDOPWarehouse/doc/_find_sysdb.py

# -*- coding: utf-8 -*-
"""探测 165 服务器上 sys_menu / sys_role_menu 所在的库。"""
from __future__ import annotations

import pymysql

CONN = dict(host="123.60.180.165", port=3306, user="aidopremote", password="1234567890aiDOP#",
            charset="utf8mb4", connect_timeout=15)

conn = pymysql.connect(**CONN)
try:
    cur = conn.cursor()
    cur.execute("SHOW DATABASES")
    dbs = [r[0] for r in cur.fetchall()]
    print("DATABASES", dbs)
    for db in dbs:
        if db in ("information_schema", "mysql", "performance_schema", "sys"):
            continue
        try:
            cur.execute(
                "SELECT TABLE_NAME FROM information_schema.TABLES "
                "WHERE TABLE_SCHEMA=%s AND LOWER(TABLE_NAME) IN ('sysmenu','sysrolemenu','sysuser','systenant','sys_menu','sys_role_menu')",
                (db,),
            )
            hits = [r[0] for r in cur.fetchall()]
            if hits:
                print(db, "->", hits)
        except Exception as e:
            print(db, "ERR", e)
finally:
    conn.close()