simon
b6df028839
变更摘要: - [fix] 清理根目录 index.html 遗留代码（questionnaire-error + retryLoad 移除） - [fix] 副标题同步更新为自估591分 + 候选志愿546条数据校准 - [fix] 页脚注入版本号 v1.0.0 - [fix] 部署版 index.html: 取消家长标签，统一 filler-tianheng - [fix] Dashboard 文案修正（4份→2份线上问卷） - [fix] 清理冗余部署脚本（v1-v4归档至 archived_scripts/） - [fix] 等效位次工具纳入 deploy 目录 - [chore] .gitignore 初始化 - [init] Git 仓库初始化
48 lines
1.4 KiB
Python
48 lines
1.4 KiB
Python
"""
|
|
直接运行 seed 并检查结果
|
|
"""
|
|
import paramiko, time, base64
|
|
|
|
NAS_HOST = "100.85.152.112"
|
|
NAS_PORT = 22
|
|
NAS_USER = "simon"
|
|
NAS_PASS = "Nas82829330"
|
|
NAS_DEPLOY_PATH = "/volume1/docker/gaokao-portal"
|
|
DOCKER = f"echo '{NAS_PASS}' | sudo -S /usr/local/bin/docker"
|
|
|
|
c = paramiko.SSHClient()
|
|
c.set_missing_host_key_policy(paramiko.AutoAddPolicy())
|
|
c.connect(NAS_HOST, NAS_PORT, NAS_USER, NAS_PASS, timeout=20)
|
|
|
|
def run(cmd, desc="", timeout=30):
|
|
if desc:
|
|
print(f"[{desc}]")
|
|
stdin, stdout, stderr = c.exec_command(cmd, timeout=timeout)
|
|
time.sleep(1)
|
|
ch = stdout.channel
|
|
out = b""
|
|
while not ch.exit_status_ready():
|
|
if ch.recv_ready():
|
|
out += ch.recv(4096)
|
|
time.sleep(0.2)
|
|
while ch.recv_ready():
|
|
out += ch.recv(4096)
|
|
return out.decode().strip()
|
|
|
|
# 1. 先删除数据库
|
|
db_path = f"{NAS_DEPLOY_PATH}/backend/data/gaokao.db"
|
|
run(f"rm -f {db_path}", "删除旧数据库")
|
|
|
|
# 2. 直接调用 seed_data.py（手动触发）
|
|
result = run(f"cd {NAS_DEPLOY_PATH}/backend && python3 seed_data.py", "运行 seed", timeout=30)
|
|
print(f"\nseed 输出:\n{result}")
|
|
|
|
# 3. 检查数据库
|
|
result = run(f"sqlite3 {db_path} 'SELECT id, title, length(questions) as qlen FROM questionnaires;'", "问卷列表")
|
|
print(f"\n数据库内容:\n{result}")
|
|
|
|
# 4. 检查 API
|
|
result = run("curl -s http://localhost:8080/api/questionnaires", "问卷API", timeout=15)
|
|
print(f"\nAPI 返回:\n{result[:500]}")
|
|
|
|
c.close() |