ylrz_saas_his_scrm/sql/check_archive.py

# -*- coding: utf-8 -*-
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 MAX(menu_id) FROM tenant_sys_menu')
print('max_id', cur.fetchone()[0])
cur.execute('SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=32333')
print('direct under 32333', cur.fetchone()[0])
cur.execute(
    "SELECT menu_id, menu_name, parent_id, visible, menu_type "
    "FROM tenant_sys_menu WHERE menu_id=32333"
)
print('32333', cur.fetchone())
cur.execute(
    "SELECT COUNT(*) FROM tenant_sys_menu WHERE visible='1' AND menu_type='M' AND parent_id=0"
)
print('hidden root M', cur.fetchone()[0])
cur.execute('SELECT menu_id FROM tenant_sys_menu WHERE menu_id=35300')
print('35300 exists', cur.fetchone())
cur.close()
c.close()