import sqlite3, sys

db = sys.argv[1]
mode = sys.argv[2] if len(sys.argv) > 2 else "show"
con = sqlite3.connect(db)
cur = con.cursor()
cols = [r[1] for r in cur.execute("PRAGMA table_info(proxy_host)")]
print("columns:", cols)
row = cur.execute(
    "SELECT id,domain_names,forward_scheme,forward_host,forward_port,enabled FROM proxy_host WHERE id=6"
).fetchone()
print("before:", row)
if mode == "apply":
    cur.execute(
        "UPDATE proxy_host SET forward_scheme='http', forward_host='projectcat-api', forward_port=8000 WHERE id=6"
    )
    con.commit()
    row2 = cur.execute(
        "SELECT id,domain_names,forward_scheme,forward_host,forward_port,enabled FROM proxy_host WHERE id=6"
    ).fetchone()
    print("after:", row2)
con.close()