ylrz_saas_his_scrm/sql/verify_menu_organize.py

# -*- coding: utf-8 -*-
import pymysql

conn = pymysql.connect(
    host='cq-cdb-8fjmemkb.sql.tencentcdb.com', port=27220,
    user='root', password='Ylrz_1q2w3e4r5t6y',
    database='ylrz_saas', charset='utf8mb4',
)
cur = conn.cursor()

queries = [
    ('groups', 'SELECT menu_id, menu_name, parent_id, visible FROM tenant_sys_menu WHERE menu_id IN (35100,35101,35102,35105,35106,32372) ORDER BY menu_id'),
    ('child_counts', 'SELECT parent_id, COUNT(*) c FROM tenant_sys_menu WHERE parent_id IN (35100,35101,35102,35105,35106,32372,35001,35002,35040,35041,35042) GROUP BY parent_id ORDER BY parent_id'),
    ('system_visible_children', "SELECT menu_id, menu_name, parent_id, path, visible FROM tenant_sys_menu WHERE parent_id=32372 AND visible='0' LIMIT 20"),
    ('qw_msg_children', "SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=35001 AND visible='0'"),
    ('store_order_children', "SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=35040 AND visible='0'"),
    ('hidden_hisstore', "SELECT COUNT(*) FROM tenant_sys_menu WHERE menu_id BETWEEN 32591 AND 32643 AND visible='1'"),
]

for name, sql in queries:
    cur.execute(sql)
    rows = cur.fetchall()
    print(name + ':', rows)

cur.close()
conn.close()