ylrz_saas_his_scrm/sql/verify_menu_ids.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()

sample_ids = [32431,32440,32704,32755,32806,32591,32482,29194,35100]
cur.execute('SELECT menu_id, menu_name, parent_id, visible, component FROM tenant_sys_menu WHERE menu_id IN (%s)' % ','.join(map(str, sample_ids)))
print('samples:')
for r in cur.fetchall():
    print(r)

cur.execute('SELECT COUNT(*) FROM tenant_sys_menu')
print('total', cur.fetchone()[0])

cur.execute('SELECT COUNT(*) FROM tenant_sys_menu_bak')
try:
    print('backup_total', cur.fetchone()[0])
except:
    pass

cur.execute("SELECT parent_id, COUNT(*) FROM tenant_sys_menu WHERE menu_id BETWEEN 32427 AND 32485 GROUP BY parent_id ORDER BY COUNT(*) DESC LIMIT 10")
print('company_menu_parents', cur.fetchall())

cur.execute("SELECT parent_id, COUNT(*) FROM tenant_sys_menu WHERE menu_id BETWEEN 32704 AND 32755 GROUP BY parent_id ORDER BY COUNT(*) DESC LIMIT 10")
print('qw_menu_parents', cur.fetchall())

cur.execute("SELECT menu_id, parent_id FROM tenant_sys_menu WHERE menu_id IN (32431,32440,32439,32704,32806)")
print('target_rows', cur.fetchall())

cur.close()
conn.close()