import sqlite3

db_path = r'd:\TestPlatform\TapProject\WPFProject\bin\x64\Debug\Config\Database\database.db'
conn = sqlite3.connect(db_path)
c = conn.cursor()

# Check if ManualControl parent menu has a role_menu_rel entry
print("=== ManualControl menu entry ===")
c.execute("SELECT * FROM menu WHERE code='ManualControl'")
for r in c.fetchall():
    print(f"  {r}")

print("\n=== role_menu_rel for ManualControl ===")
c.execute("SELECT * FROM role_menu_rel WHERE menuCode='ManualControl'")
for r in c.fetchall():
    print(f"  {r}")

# Check all parent menus and their role relations
print("\n=== All parent menus (type='' or empty dllPath) ===")
c.execute("SELECT m.code, m.name, m.type, m.parentCode, rrel.roleCode FROM menu m LEFT JOIN role_menu_rel rrel ON m.code = rrel.menuCode WHERE m.type = '' OR m.type IS NULL")
for r in c.fetchall():
    print(f"  {r}")

# Simulate the full login query for admin user
print("\n=== Full menu tree for admin (all levels) ===")
c.execute("""
    SELECT DISTINCT m.code, m.name, m.type, m.parentCode, m.level, m.dllPath
    FROM menu AS m 
    INNER JOIN role_menu_rel AS rrel ON m.code = rrel.menuCode
    INNER JOIN role AS r ON rrel.roleCode = r.code
    INNER JOIN user_role_rel AS urel ON r.code = urel.roleCode
    AND urel.username = 'admin'
    ORDER BY m.level, m.id
""")
for r in c.fetchall():
    print(f"  {r}")

conn.close()