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

print('=== ROOT MENUS (parent_id=0, menu_type=M) ===')
cur.execute(
    "SELECT menu_id, menu_name, order_num, path, visible, status "
    "FROM tenant_sys_menu WHERE parent_id=0 AND menu_type='M' "
    "ORDER BY order_num, menu_id"
)
for r in cur.fetchall():
    print(r)

print('\n=== visible roots (visible=0) ===')
cur.execute(
    "SELECT menu_id, menu_name, order_num, path "
    "FROM tenant_sys_menu WHERE parent_id=0 AND menu_type='M' AND visible='0' "
    "ORDER BY order_num"
)
for r in cur.fetchall():
    print(r)

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

cur.execute(
    "SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=0 AND visible='0' "
    "AND path IN ('admin','saas','proxy','tenant','monitor','tool','company')"
)
print('bad platform visible roots', cur.fetchone()[0])

cur.execute(
    "SELECT COUNT(*) FROM tenant_sys_menu WHERE component LIKE 'admin/%' AND visible='0'"
)
print('visible admin components', cur.fetchone()[0])

# system subtree
print('\n=== system (32372) children ===')
cur.execute(
    "SELECT menu_id, menu_name, parent_id, order_num, path, visible "
    "FROM tenant_sys_menu WHERE parent_id=32372 OR menu_id=32372 "
    "ORDER BY parent_id, order_num LIMIT 30"
)
for r in cur.fetchall():
    print(r)

cur.close()
c.close()