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