# -*- 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()