Files
adminandClaude Sonnet 5.5 e72345a958 fix(console): schema DDL 移出 web root,兜底行为抽进 lib 并锁进 CI
- static/migrate.sql ⇒ schema/migrate.sql(编译期内嵌不变,运行期不在 web root)
  ⇒ 大小写 / %2E / 尾斜杠 / 双斜杠等路径变体全部拿不到 DDL
- 404 与 SPA 兜底从二进制 crate 抽进 lib(src/routes/fallback.rs)
  ⇒ /api 与 /api/ 统一回 404 JSON,SPA 深链回 index.html
- 新增 tests/spa_fallback.rs:6 条断言锁住兜底行为
- README 整段重写为现行 18 实体 CRUD + 鉴权面 + 上游 SPA 托管
- build-frontend.sh 可执行;产物目录缺失时回落 npm 构建路径
- registry::validate() 挪到 PGlite::open 之前,注册表写坏即秒退
- mw.rs 注释点明两套 4xx 形状并存是刻意分歧

Co-Authored-By: Claude Sonnet 5.5 <[email protected]>
2026-10-25 05:58:20 +08:00

95 lines
4.3 KiB
Bash
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
#!/usr/bin/env bash
# 从上游 ssw-tdc 的迁移脚本重新生成 schema/migrate.sql。
#
# 做法:按 (major, minor, patch, 文件名) 排序打进一个空 PostgreSQL,再 pg_dump --schema-only。
# ⚠️ boot/db/ 根目录的 6 个(V1.0.4 ~ V1.0.9)容易漏 —— 它们建 tdc_order / tdc_api_consume_log /
# tdc_notify 等表并 ALTER tdc_delivery_task / tdc_resource / tdc_product。
# ⚠️ V2.10.0 版本号重复(两个文件)⇒ 不能靠 Flyway 排序,必须显式按文件名兜底。
#
# 🔴 本脚本**不会** DROP / 重建目标库:目标库 public schema 非空时直接快速失败,
# 由调用方自己准备空库(未授权的破坏性数据库操作不做)。
# 🔴 自检在**落盘之前**做:生成物先写进一次性临时目录,表数校验通过后才覆盖 schema/migrate.sql,
# 避免一次顺序错误的运行把已入库的 schema 写坏。
#
# 用法:
# UPSTREAM_REPO=/path/to/ssw-tdc \
# PGHOST=127.0.0.1 PGPORT=15432 PGUSER=postgres PGDATABASE=tdc_gen \
# ./scripts/gen-migrate.sh
set -euo pipefail
ROOT="$(cd "$(dirname "$0")/.." && pwd)"
UPSTREAM_REPO="${UPSTREAM_REPO:-/tmp/sswtdc-probe}"
OUT="${ROOT}/schema/migrate.sql"
# 🔴 产物落在 schema/(**不在 web root**)—— static/ 会被挂到 HTTP 上。
mkdir -p "${ROOT}/schema" "${ROOT}/target"
# 一次性工作目录:失败时保留,便于排查(不做 rm)
WORK="$(mktemp -d "${ROOT}/target/gen-migrate.XXXXXX")"
if [ ! -d "${UPSTREAM_REPO}/boot/db" ]; then
echo "[gen-migrate] 上游仓库不存在:${UPSTREAM_REPO}" >&2
exit 1
fi
command -v psql >/dev/null 2>&1 || { echo "[gen-migrate] 需要 psql(PostgreSQL 客户端)" >&2; exit 1; }
command -v pg_dump >/dev/null 2>&1 || { echo "[gen-migrate] 需要 pg_dump" >&2; exit 1; }
# ① 预检:目标库 public schema 必须为空(本脚本不替调用方清理数据库)
EXISTING="$(psql -v ON_ERROR_STOP=1 -tAc \
"SELECT count(*) FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = 'public';" \
| tr -d '[:space:]')"
if [ -z "${EXISTING}" ]; then
echo "[gen-migrate] 无法确认目标库状态(psql 无输出),已中止。" >&2
exit 1
fi
if [ "${EXISTING}" != "0" ]; then
echo "[gen-migrate] 目标库 public schema 已有 ${EXISTING} 个对象,已中止。" >&2
echo "[gen-migrate] 请自行准备一个空库(例如新建 tdc_gen)后再跑;本脚本不会 DROP/重建数据库。" >&2
exit 1
fi
# ② 收集迁移并排序(版本三元组 + 文件名兜底)
{
ls -1 "${UPSTREAM_REPO}"/boot/db/tdc/V*.sql 2>/dev/null || true
ls -1 "${UPSTREAM_REPO}"/boot/db/V*.sql 2>/dev/null || true
} | awk -F/ '
{
file = $NF
if (match(file, /^V[0-9]+\.[0-9]+\.[0-9]+__/) == 0) { next }
ver = substr(file, 2, RLENGTH - 3)
split(ver, p, ".")
printf "%010d.%010d.%010d\t%s\t%s\n", p[1], p[2], p[3], file, $0
}' | sort | cut -f3- > "${WORK}/migrations.txt"
COUNT="$(wc -l < "${WORK}/migrations.txt" | tr -d ' ')"
echo "[gen-migrate] 迁移文件数:${COUNT}(上游应为 82)"
# ③ 逐个打进目标库
: > "${WORK}/replay.log"
while IFS= read -r f; do
if ! psql -v ON_ERROR_STOP=1 -q -f "${f}" >>"${WORK}/replay.log" 2>&1; then
echo "[gen-migrate] 迁移失败:${f}" >&2
tail -40 "${WORK}/replay.log" >&2
echo "[gen-migrate] 工作目录保留在:${WORK}" >&2
exit 1
fi
done < "${WORK}/migrations.txt"
# ④ 导出 schema 到临时文件(先不碰 schema/migrate.sql)
pg_dump --schema-only --no-owner --no-privileges > "${WORK}/raw.sql"
# ⑤ 剥掉 pg_dump 前言(restrict/unrestrict/SET/set_config)
grep -vE '^\\restrict|^\\unrestrict|^SET |^SELECT pg_catalog\.set_config' "${WORK}/raw.sql" > "${WORK}/migrate.sql"
# ⑥ 自检:表数不对就中止,绝不覆盖已入库的 schema/migrate.sql
TABLES="$(grep -cE '^CREATE TABLE public\.' "${WORK}/migrate.sql" || true)"
if [ "${TABLES}" != "30" ]; then
echo "[gen-migrate] ⚠️ 表数是 ${TABLES}(应为 30),请复核迁移顺序;已中止,未改动 ${OUT}。" >&2
echo "[gen-migrate] 候选产物保留在:${WORK}/migrate.sql" >&2
exit 1
fi
# ⑦ 校验通过后才落盘
cp "${WORK}/migrate.sql" "${OUT}"
echo "[gen-migrate] 已生成 ${OUT}(${TABLES} 张表,字节数 $(wc -c < "${OUT}" | tr -d ' '))"
echo "[gen-migrate] 工作目录:${WORK}"