ylrz_saas_his_scrm/sql/_check_f.py

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 COUNT(*) FROM tenant_sys_menu WHERE menu_type='F'")
print('total F', cur.fetchone()[0])
cur.execute("""
SELECT COUNT(*) FROM tenant_sys_menu f
JOIN tenant_sys_menu p ON f.parent_id=p.menu_id
WHERE f.menu_type='F' AND p.menu_type='C'
""")
print('F under C', cur.fetchone()[0])
cur.execute("""
SELECT p.menu_id, p.menu_name, p.component, COUNT(*) 
FROM tenant_sys_menu f
JOIN tenant_sys_menu p ON f.parent_id=p.menu_id
WHERE f.menu_type='F' AND p.component LIKE 'qw/%'
GROUP BY p.menu_id ORDER BY COUNT(*) DESC LIMIT 5
""")
print('qw pages with most F buttons:')
for r in cur.fetchall(): print(r)
c.close()