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

ids = [32431,32440,32704,32806,32591,32385,35106]
for mid in ids:
    cur.execute('SELECT menu_id, parent_id, visible FROM tenant_sys_menu WHERE menu_id=%s', (mid,))
    cur_row = cur.fetchone()
    cur.execute('SELECT menu_id, parent_id, visible FROM tenant_sys_menu_bak WHERE menu_id=%s', (mid,))
    bak_row = cur.fetchone()
    print(mid, 'current=', cur_row, 'backup=', bak_row)

cur.execute('SELECT COUNT(*) FROM tenant_sys_menu_bak WHERE parent_id=35106 AND menu_type<>"F"')
print('bak_35106_children', cur.fetchone()[0])
cur.execute('SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=35106 AND menu_type<>"F"')
print('cur_35106_children', cur.fetchone()[0])

cur.execute('SELECT menu_id FROM tenant_sys_menu_bak WHERE menu_id BETWEEN 32427 AND 32485 LIMIT 5')
print('bak_company_sample', cur.fetchall())
cur.execute('SELECT menu_id FROM tenant_sys_menu WHERE menu_id BETWEEN 32427 AND 32485 LIMIT 5')
print('cur_company_sample', cur.fetchall())

cur.close()
conn.close()