import sqlite3

# Check both databases
for label, db_path in [
    ("Output DB", r'd:\TestPlatform\TapProject\WPFProject\bin\x64\Debug\Config\Database\database.db'),
    ("Source DB", r'd:\TestPlatform\TapProject\WPFProject\Config\Database\database.db')
]:
    print(f"\n=== {label} ===")
    conn = sqlite3.connect(db_path)
    c = conn.cursor()
    
    # Check schema
    c.execute("PRAGMA table_info(menu)")
    cols = [row[1] for row in c.fetchall()]
    print(f"Columns: {cols}")
    
    # Check our entries
    c.execute("SELECT * FROM menu WHERE code IN ('DeviceConfig','DeviceDebug')")
    for r in c.fetchall():
        print(f"  Menu: {r}")
    
    # Check comparison with working entries
    c.execute("SELECT code, name, level, type, parentCode FROM menu WHERE parentCode='ManualControl'")
    print("\n  ManualControl children:")
    for r in c.fetchall():
        print(f"    {r}")
    
    # Check role_menu_rel
    c.execute("SELECT * FROM role_menu_rel WHERE menuCode IN ('DeviceConfig','DeviceDebug')")
    print("\n  role_menu_rel:")
    for r in c.fetchall():
        print(f"    {r}")
    
    conn.close()