# -*- 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('=== system direct children count by visible ===')
cur.execute(
    "SELECT visible, COUNT(*) FROM tenant_sys_menu WHERE parent_id=32372 "
    "AND menu_type<>'F' GROUP BY visible"
)
print(cur.fetchall())

print('\n=== system visible direct children (should be 35100-35106 only) ===')
cur.execute(
    "SELECT menu_id, menu_name, order_num, path, visible "
    "FROM tenant_sys_menu WHERE parent_id=32372 AND visible='0' "
    "ORDER BY order_num, menu_id"
)
for r in cur.fetchall():
    print(r)

print('\n=== secondary groups under qw (32361) ===')
cur.execute(
    "SELECT menu_id, menu_name, parent_id, order_num, path, visible "
    "FROM tenant_sys_menu WHERE parent_id=32361 OR menu_id=32361 "
    "ORDER BY parent_id, order_num LIMIT 20"
)
for r in cur.fetchall():
    print(r)

print('\n=== path m-prefix count (broken by post_process) ===')
cur.execute("SELECT COUNT(*) FROM tenant_sys_menu WHERE path LIKE 'm%' AND menu_type='M'")
print(cur.fetchone()[0])

cur.close()
c.close()