# -*- coding: utf-8 -*- import json, urllib.request, urllib.parse, time, sqlite3 BASE = "http://127.0.0.1:8012" DB = r"F:\水利智学系统\可运行版(解压即用,双击start.bat)\backend\data\shuili_exam.db" def get(path): with urllib.request.urlopen(BASE + path, timeout=15) as r: return json.loads(r.read().decode("utf-8")) def unwrap(d): if isinstance(d, dict) and "data" in d and isinstance(d["data"], dict) and "list" in d["data"]: return d["data"] return d print("=== T7 FTS 代位权/一造管理 ===") d = unwrap(get("/api/v1/question/search_fts?keyword=" + urllib.parse.quote("代位权") + "&subject=" + urllib.parse.quote("一造管理") + "&page=1&page_size=10")) print("total=", d.get("total"), "list_ids=", [it.get("id") for it in d.get("list", [])]) print("=== T7 科目隔离 代位权/水利案例 (expect 0) ===") d = unwrap(get("/api/v1/question/search_fts?keyword=" + urllib.parse.quote("代位权") + "&subject=" + urllib.parse.quote("一造水利案例") + "&page=1&page_size=10")) print("total=", d.get("total")) print("=== T7 LIKE兜底 2字 管理 (fts=false) ===") d = unwrap(get("/api/v1/question/search_fts?keyword=" + urllib.parse.quote("管理") + "&page=1&page_size=3")) print("total=", d.get("total")) print("=== T7 触发器同步 ===") conn = sqlite3.connect(DB); cur = conn.cursor() MARK = "ZZQMARKER9X7" cur.execute("INSERT INTO questions (subject, chapter, q_type, title, option_a, answer, analysis, is_deleted, create_time, update_time) " "VALUES (?,?,?,?,?,?,?,0,datetime('now'),datetime('now'))", ("一造管理", "测试章", "single", MARK + " 触发器同步验证题干", "A", "A", MARK)) newid = cur.lastrowid; conn.commit(); time.sleep(0.4) d = unwrap(get("/api/v1/question/search_fts?keyword=" + urllib.parse.quote(MARK) + "&subject=" + urllib.parse.quote("一造管理") + "&page=1&page_size=10")) ids = [it.get("id") for it in d.get("list", [])] print("after insert, newid", newid, "found:", newid in ids) cur.execute("UPDATE questions SET is_deleted=1 WHERE id=?", (newid,)); conn.commit(); time.sleep(0.4) d = unwrap(get("/api/v1/question/search_fts?keyword=" + urllib.parse.quote(MARK) + "&subject=" + urllib.parse.quote("一造管理") + "&page=1&page_size=10")) ids = [it.get("id") for it in d.get("list", [])] print("after soft-delete, newid in results (expect False):", newid in ids) cur.execute("DELETE FROM questions WHERE id=?", (newid,)); conn.commit(); conn.close() print("=== T9 export_editable json ===") raw = get("/api/v1/question/export_editable?subject=" + urllib.parse.quote("一造管理") + "&export_format=json") n = len(raw) if isinstance(raw, list) else len(raw.get("data") or raw.get("list") or []) print("rows=", n) print("DONE")