import sqlite3

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

# Check existing child menu entries for reference
c.execute("SELECT code, name, iconPath, level FROM menu WHERE parentCode='ManualControl' AND code NOT IN ('DeviceConfig','DeviceDebug')")
print("Reference entries:")
for r in c.fetchall():
    print(f"  {r}")

# Fix: set iconPath and level to match existing pattern
c.execute("""UPDATE menu SET iconPath = '.\\xinzeng_1.png', level = '2' 
             WHERE code IN ('DeviceConfig','DeviceDebug')""")
conn.commit()

# Verify
c.execute("SELECT code, name, iconPath, level, type, parentCode FROM menu WHERE code IN ('DeviceConfig','DeviceDebug')")
print("\nFixed entries:")
for r in c.fetchall():
    print(f"  {r}")

conn.close()

# Fix source database
src_db = r'd:\TestPlatform\TapProject\WPFProject\Config\Database\database.db'
conn = sqlite3.connect(src_db)
c = conn.cursor()

c.execute("""UPDATE menu SET level = '2' 
             WHERE code IN ('DeviceConfig','DeviceDebug')""")
conn.commit()

c.execute("SELECT code, name, iconPath, level FROM menu WHERE code IN ('DeviceConfig','DeviceDebug')")
print("\nSource DB fixed:")
for r in c.fetchall():
    print(f"  {r}")

conn.close()
print("\nDone!")