ylrz_saas_his_scrm/sql/list_broken_paths.py

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

M = dict(
    host='cq-cdb-8fjmemkb.sql.tencentcdb.com',
    port=27220,
    user='root',
    password='Ylrz_1q2w3e4r5t6y',
    database='ylrz_saas',
    charset='utf8mb4',
)

c = pymysql.connect(**M)
cur = c.cursor()
cur.execute(
    "SELECT menu_id, menu_name, parent_id, path, component "
    "FROM tenant_sys_menu WHERE menu_type='M' AND path LIKE 'm%' "
    "ORDER BY parent_id, menu_id"
)
rows = cur.fetchall()
print('M menus with m-prefix path:', len(rows))
for r in rows:
    print(r)

cur.execute(
    "SELECT menu_id, menu_name, parent_id, path FROM tenant_sys_menu "
    "WHERE menu_id IN (35010,35011,35012,35013,35020,35021,35023,35050,35051,35052,35053,35060,35061,35062,35063,35070,35071,35072,35073,35074,35075,35080,35111,35112,35113,35114)"
)
print('\nsecondary module groups:')
for r in cur.fetchall():
    print(r)

cur.close()
c.close()