| 123456789101112131415 |
- # -*- coding: utf-8 -*-
- import sys
- import pymysql
- sys.stdout.reconfigure(encoding='utf-8')
- c = pymysql.connect(host='123.60.180.165', port=3306,
- user='aidopremote', password='1234567890aiDOP#',
- database='information_schema', charset='utf8mb4')
- cur = c.cursor()
- for db in ['aidopdev', 'dopdemo']:
- cur.execute("SELECT TABLE_NAME FROM tables WHERE TABLE_SCHEMA=%s AND TABLE_NAME IN ('sys_menu','SysMenu','sys_Menu','sys_tenant','sys_role','sys_user')", (db,))
- print(f"[{db}]", cur.fetchall())
- cur.execute("SELECT TABLE_NAME FROM tables WHERE TABLE_SCHEMA=%s AND TABLE_NAME LIKE '%menu%'", (db,))
- print(f"[{db}] menu-like:", cur.fetchall())
- cur.close(); c.close()
|
