# -*- 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 menu_id, menu_name, parent_id, order_num, path, visible, menu_type "
    "FROM tenant_sys_menu WHERE menu_id=35300"
)
print('35300', cur.fetchone())
cur.execute('SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=35300')
print('children', cur.fetchone()[0])
cur.execute(
    "SELECT menu_id, menu_name, order_num, path, visible "
    "FROM tenant_sys_menu WHERE parent_id=0 AND visible='0' AND menu_type='M' "
    "ORDER BY order_num"
)
print('visible roots:')
for r in cur.fetchall():
    print(' ', r)
cur.execute('SELECT COUNT(*) FROM tenant_sys_menu WHERE parent_id=32333')
print('still under 32333', cur.fetchone()[0])
cur.close()
c.close()