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!")
|
