| 123456789 |
- # -*- 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()
- cur.execute("SELECT visible, COUNT(*) FROM tenant_sys_menu WHERE parent_id=32372 GROUP BY visible")
- print('system_children_by_visible', cur.fetchall())
- cur.execute("SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id IN (35001,35002,35003,35004,35005,35006,35007) AND menu_type <> 'F' AND visible='0' GROUP BY parent_id, path HAVING COUNT(*)>1")
- print('qw_dup', cur.fetchall())
- cur.close(); conn.close()
|
