fix(ci): 自动同步 docker config 到 BuildKit 容器

- 每次确保 builder 存在后自动同步宿主机 docker config - 防止 builder 重建后 registry 认证丢失 - 解决私有镜像拉取 401 问题
ci: 触发干净构建（确保无并发取消） (#1609 )
2026-09-01 16:21:56 +08:00 · 2026-09-01 16:00:34 +08:00 · 2026-09-01 15:46:12 +08:00 · 2026-09-01 15:31:14 +08:00 · 2026-09-01 15:14:08 +08:00 · 2026-09-01 15:12:34 +08:00
46 changed files with 1725 additions and 245 deletions
@@ -150,6 +150,7 @@ jobs:
      run: bash scripts/ci/step_timer_start.sh
    - name: Cache pip dependencies
      uses: actions/cache@v4
+      continue-on-error: true
      with:
        path: /root/.cache/pip
        key: ${{ runner.os }}-pip-style-${{ hashFiles('requirements*.txt') }}
@@ -252,6 +253,7 @@ jobs:
      run: bash scripts/ci/step_timer_start.sh
    - name: Cache pip dependencies
      uses: actions/cache@v4
+      continue-on-error: true
      with:
        path: /root/.cache/pip
        key: ${{ runner.os }}-pip-security-${{ hashFiles('requirements*.txt') }}
@@ -352,6 +354,7 @@ jobs:
      run: bash scripts/ci/step_timer_start.sh
    - name: Cache pip dependencies
      uses: actions/cache@v4
+      continue-on-error: true
      with:
        path: /root/.cache/pip
        key: ${{ runner.os }}-pip-python-${{ hashFiles('requirements*.txt') }}
@@ -456,6 +459,7 @@ jobs:
      run: bash scripts/ci/step_install_ffmpeg.sh
    - name: Cache pip dependencies
      uses: actions/cache@v4
+      continue-on-error: true
      with:
        path: /root/.cache/pip
        key: ${{ runner.os }}-pip-unittests-${{ hashFiles('requirements*.txt') }}
@@ -664,6 +668,7 @@ jobs:
      run: bash scripts/ci/step_timer_start.sh
    - name: Cache npm dependencies
      uses: actions/cache@v4
+      continue-on-error: true
      with:
        path: /root/.npm
        key: ${{ runner.os }}-npm-vitest-${{ hashFiles('apps/web/package-lock.json') }}
@@ -876,7 +881,7 @@ jobs:
      env:
        GITHUB_TOKEN: ${{ github.token }}
      run: |
-        bash scripts/ci/ci_push_paths.sh
+        curl -sfH "Authorization: token $GITHUB_TOKEN" -o /tmp/_ci_push_paths.sh "${GITHUB_API_URL}/repos/${GITHUB_REPOSITORY}/raw/scripts/ci/ci_push_paths.sh?ref=${GITHUB_SHA}" && bash /tmp/_ci_push_paths.sh
    - name: Report CI trace
      if: always()
      shell: sh
@@ -3,7 +3,7 @@ name: PR Auto Scan
 # 作为短作业模式的兜底，防止事件驱动遗漏
 on:
  schedule:
-    - cron: "*/10 * * * *"  # 每10分钟扫描一次（脚本自带240s墙钟上限，降频减负）
+    - cron: "*/15 * * * *"  # 每10分钟扫描一次（脚本自带240s墙钟上限，降频减负）
  workflow_dispatch:

 permissions:
@@ -0,0 +1,57 @@
+"""migrate template_segments data to template_clip_configs
+
+Revision ID: 060_migrate_segments
+Revises: 059_duplicate_rate
+Create Date: 2026-08-31
+"""
+
+import sqlalchemy as sa
+
+from alembic import op
+
+revision = "060_migrate_segments"
+down_revision = "059_duplicate_rate"
+branch_labels = None
+depends_on = None
+
+
+def upgrade() -> None:
+    dialect = op.get_bind().dialect.name
+
+    if dialect == "postgresql":
+        config_expr = (
+            "CASE WHEN s.material_type IS NOT NULL AND s.material_type != '' "
+            "THEN json_build_object('material_type', s.material_type)::jsonb "
+            "ELSE '{}'::jsonb END"
+        )
+        empty_json = "'{}'::jsonb"
+    else:
+        config_expr = (
+            "CASE WHEN s.material_type IS NOT NULL AND s.material_type != '' "
+            "THEN JSON_OBJECT('material_type', s.material_type) "
+            "ELSE '{}' END"
+        )
+        empty_json = "'{}'"
+
+    sql_str = (
+        "INSERT INTO template_clip_configs "
+        '(id, template_id, clip_type, "order", min_duration, max_duration, '
+        "text_template, material_requirements, transition_effect, config, "
+        "created_at, updated_at) "
+        "SELECT "
+        "s.id, s.template_id, 'main', s.segment_order, "
+        "s.duration_min, s.duration_max, "
+        "'', " + empty_json + ", "
+        "'cut', " + config_expr + ", "
+        "s.created_at, s.updated_at "
+        "FROM template_segments s "
+        "WHERE NOT EXISTS ("
+        "  SELECT 1 FROM template_clip_configs c "
+        "  WHERE c.template_id = s.template_id"
+        ")"
+    )
+    op.execute(sa.text(sql_str))
+
+
+def downgrade() -> None:
+    pass
@@ -579,39 +579,45 @@ def smart_match_assets(
        filtered_assets = asset_repository.find_by_library(request.library_id, status=["ready"], limit=10000)
    total_candidates = len(filtered_assets)

-    # 调用统一智能选素材算法（kind 已在 DB 层过滤，无需重复过滤）
-    results = smart_select_assets(
-        filtered_assets,
-        limit=request.limit,
-        kind=None,
-    )
+    # ── 过滤前置：余量 + 高频使用，过滤在评分/截取 limit 之前完成 ──────────
+    # 旧实现先 smart_select_assets(limit=N) 再对这 N 条做过滤，过滤后不回补，
+    # 当排名靠前的素材恰好都被排除时返回空 items（前端回退全选，smart-match 名存实亡）。
+    # 现在先过滤全量候选，每级过滤后为空/不足则回退上一级，最后才评分截取。

-    # 结果层过滤：usable=false（零重复可切区间耗尽且历史区间均达复用上限）的素材
-    # 不返回给前端；不动 smart_select_assets 评分逻辑本身
-    filtered_results = []
-    for r in results:
+    # 1) 余量过滤：usable=False（零重复可切区间耗尽且历史区间均达复用上限）的素材排除
+    usable_assets = []
+    exhausted_assets = []
+    for a in filtered_assets:
        try:
-            avail = compute_asset_availability(r.asset)
+            avail = compute_asset_availability(a)
        except Exception:
            logger.warning(
                "smart-match 余量计算失败，按可用处理: asset_id=%s",
-                getattr(r.asset, "id", "?"),
+                getattr(a, "id", "?"),
                exc_info=True,
            )
            avail = None
        if avail is not None and not avail["usable"]:
-            logger.info(
-                "smart-match 排除已用尽素材: asset_id=%s name=%s",
-                getattr(r.asset, "id", "?"),
-                getattr(r.asset, "name", ""),
-            )
-            continue
-        filtered_results.append(r)
+            exhausted_assets.append(a)
+        else:
+            usable_assets.append(a)

-    # 高频使用排除：同一素材在最近 5 个视频中出现超过 3 次则排除
+    if exhausted_assets:
+        logger.info(
+            "smart-match 余量过滤: 候选 %d，可切区间耗尽 %d",
+            len(filtered_assets), len(exhausted_assets),
+        )
+
+    # 回退策略：余量过滤后为空（全部耗尽）时，保留全部候选，不返回空结果。
+    # 宁可让用户在已耗尽素材上复用，也比 smart-match 空结果回退全选更可控
+    # （全选同样会选到这些素材，且不经过评分排序）。
+    pool = usable_assets if usable_assets else filtered_assets
+
+    # 2) 高频使用排除：同一素材在最近 5 个视频中出现超过 3 次则排除
    MAX_RECENT_USE_COUNT = 3
-    if filtered_results:
-        asset_ids = [getattr(r.asset, "id", "") for r in filtered_results if getattr(r.asset, "id", "")]
+    high_freq_assets = set()
+    if pool:
+        asset_ids = [getattr(a, "id", "") for a in pool if getattr(a, "id", "")]
        if asset_ids:
            try:
                use_counts = get_asset_recent_use_counts(
@@ -619,27 +625,35 @@ def smart_match_assets(
                    asset_ids=asset_ids,
                    recent_video_count=5,
                )
-                high_use_excluded = set()
-                for r in filtered_results:
-                    aid = getattr(r.asset, "id", "")
+                for a in pool:
+                    aid = getattr(a, "id", "")
                    count = use_counts.get(aid, 0)
                    if count > MAX_RECENT_USE_COUNT:
+                        high_freq_assets.add(aid)
                        logger.info(
                            "smart-match 排除高频使用素材: asset_id=%s use_count=%d limit=%d",
                            aid, count, MAX_RECENT_USE_COUNT,
                        )
-                        high_use_excluded.add(id(r))
+                # 回退策略：排除后剩余素材不足（为空或不够 limit）时，
+                # 不再全部排除，保留全部可用素材
+                if high_freq_assets:
+                    remaining_count = len(pool) - len(high_freq_assets)
+                    enough = request.limit is None or remaining_count >= request.limit
+                    if remaining_count > 0 and enough:
+                        pool = [a for a in pool if getattr(a, "id", "") not in high_freq_assets]
                    else:
-                        pass
-                # 如果排除后不够 limit，放宽到不限制
-                remaining = [r for r in filtered_results if id(r) not in high_use_excluded]
-                if len(remaining) >= request.limit:
-                    filtered_results = remaining
-                else:
-                    logger.info("smart-match 高频排除后素材不足(%d<%d)，保留全部", len(remaining), request.limit)
+                        logger.info(
+                            "smart-match 高频排除后素材不足(%d<%s)，保留全部 %d 条",
+                            remaining_count,
+                            request.limit if request.limit is not None else "不限",
+                            len(pool),
+                        )
            except Exception:
                logger.warning("smart-match 高频使用查询失败，跳过排除", exc_info=True)

+    # 3) 调用统一智能选素材算法（kind 已在 DB 层过滤，无需重复过滤）
+    results = smart_select_assets(pool, limit=request.limit, kind=None)
+
    # 扁平结构：SmartMatchItem 继承 AssetResponse，素材字段直接在条目顶层，
    # 前端无需解析 item.asset 包装层，item.id / item.usable / 余量字段直接可读
    items = [
@@ -648,7 +662,7 @@ def smart_match_assets(
            score=r.score,
            breakdown=r.breakdown,
        )
-        for r in filtered_results
+        for r in results
    ]

    return SmartMatchResponse(items=items, total_candidates=total_candidates)
@@ -37,6 +37,9 @@ from fastapi import APIRouter, BackgroundTasks, Depends, HTTPException, Query, s
 from sqlalchemy.orm import Session

 from packages.adapters.sqlalchemy_impl.asset_repository import SQLAlchemyAssetRepository
+from packages.adapters.sqlalchemy_impl.template_clip_config_repository import (
+    SQLAlchemyTemplateClipConfigRepository,
+)
 from packages.adapters.sqlalchemy_impl.template_repository import (
    SQLAlchemyTemplateRepository,
 )
@@ -411,7 +414,25 @@ def _get_template_segments(
                result.append((cc.order, dur_min, dur_max))
            return sorted(result, key=lambda x: x[0])
    except Exception:
-        logger.warning("新模板系统查询clip_configs失败，回退到旧系统", exc_info=True)
+        logger.warning("新模板系统查询clip_configs失败（主表可能不存在），直接查clip_configs表", exc_info=True)
+
+    # 兜底：直接查 template_clip_configs 表（片段表有 template_id 外键，不依赖模板主表）
+    try:
+        direct_repo = SQLAlchemyTemplateClipConfigRepository(db)
+        direct_configs = direct_repo.list_by_template(template_id)
+        if direct_configs:
+            result = []
+            for cc in direct_configs:
+                dur_min = _safe_segment_duration(cc.min_duration, _DEFAULT_EDITOR_CLIP_DURATION)
+                dur_max = _safe_segment_duration(
+                    cc.max_duration or cc.min_duration,
+                    _DEFAULT_EDITOR_CLIP_DURATION,
+                )
+                dur_min, dur_max = min(dur_min, dur_max), max(dur_min, dur_max)
+                result.append((cc.order, dur_min, dur_max))
+            return sorted(result, key=lambda x: x[0])
+    except Exception:
+        logger.warning("直接查clip_configs表也失败，继续回退旧系统", exc_info=True)

    # 回退到旧模板系统（template_segments表）
    try:
@@ -1848,10 +1848,9 @@
    },
    "node_modules/@testing-library/dom": {
      "version": "10.4.1",
-      "resolved": "https://registry.npmmirror.com/@testing-library/dom/-/dom-10.4.1.tgz",
+      "resolved": "https://registry.npmjs.org/@testing-library/dom/-/dom-10.4.1.tgz",
      "integrity": "sha512-o4PXJQidqJl82ckFaXUeoAW+XysPLauYI43Abki5hABd853iMhitooc6znOnczgbTYmEP6U6/y1ZyKAIsvMKGg==",
      "dev": true,
-      "license": "MIT",
      "peer": true,
      "dependencies": {
        "@babel/code-frame": "^7.10.4",
@@ -1938,10 +1937,9 @@
    },
    "node_modules/@types/aria-query": {
      "version": "5.0.4",
-      "resolved": "https://registry.npmmirror.com/@types/aria-query/-/aria-query-5.0.4.tgz",
+      "resolved": "https://registry.npmjs.org/@types/aria-query/-/aria-query-5.0.4.tgz",
      "integrity": "sha512-rfT93uj5s0PRL7EzccGMs3brplhcrghnDoV26NqKhCAS1hVo+WdNsPvE/yb6ilfr5hi2MEk6d5EWJTKdxg8jVw==",
      "dev": true,
-      "license": "MIT",
      "peer": true
    },
    "node_modules/@types/babel__core": {
@@ -3113,10 +3111,9 @@
    },
    "node_modules/dom-accessibility-api": {
      "version": "0.5.16",
-      "resolved": "https://registry.npmmirror.com/dom-accessibility-api/-/dom-accessibility-api-0.5.16.tgz",
+      "resolved": "https://registry.npmjs.org/dom-accessibility-api/-/dom-accessibility-api-0.5.16.tgz",
      "integrity": "sha512-X7BJ2yElsnOJ30pZF4uIIDfBEVgF4XEBxL9Bxhy6dnrm5hkzqmsWHGTiHqRiITNhMyFLyAiWndIJP7Z1NTteDg==",
      "dev": true,
-      "license": "MIT",
      "peer": true
    },
    "node_modules/dunder-proto": {
@@ -4457,10 +4454,9 @@
    },
    "node_modules/lz-string": {
      "version": "1.5.0",
-      "resolved": "https://registry.npmmirror.com/lz-string/-/lz-string-1.5.0.tgz",
+      "resolved": "https://registry.npmjs.org/lz-string/-/lz-string-1.5.0.tgz",
      "integrity": "sha512-h5bgJWpxJNswbU7qCrV0tIKQCaS3blPDrqKWx+QxzuzL1zGUzij9XCWLrSLsJPu5t+eWA/ycetzYAO5IOMcWAQ==",
      "dev": true,
-      "license": "MIT",
      "peer": true,
      "bin": {
        "lz-string": "bin/bin.js"
@@ -5008,10 +5004,9 @@
    },
    "node_modules/pretty-format": {
      "version": "27.5.1",
-      "resolved": "https://registry.npmmirror.com/pretty-format/-/pretty-format-27.5.1.tgz",
+      "resolved": "https://registry.npmjs.org/pretty-format/-/pretty-format-27.5.1.tgz",
      "integrity": "sha512-Qb1gy5OrP5+zDf2Bvnzdl3jsTf1qXVMazbvCoKhtKqVs4/YK4ozX4gKQJJVyNe+cajNPn0KoC0MC3FUmaHWEmQ==",
      "dev": true,
-      "license": "MIT",
      "peer": true,
      "dependencies": {
        "ansi-regex": "^5.0.1",
@@ -5024,10 +5019,9 @@
    },
    "node_modules/pretty-format/node_modules/ansi-styles": {
      "version": "5.2.0",
-      "resolved": "https://registry.npmmirror.com/ansi-styles/-/ansi-styles-5.2.0.tgz",
+      "resolved": "https://registry.npmjs.org/ansi-styles/-/ansi-styles-5.2.0.tgz",
      "integrity": "sha512-Cxwpt2SfTzTtXcfOlzGEee8O+c+MmUgGrNiBcXnuWxuFJHe6a5Hz7qwhwe5OgaSYI0IJvkLqWX1ASG+cJOkEiA==",
      "dev": true,
-      "license": "MIT",
      "peer": true,
      "engines": {
        "node": ">=10"
@@ -5735,10 +5729,9 @@
    },
    "node_modules/react-is": {
      "version": "17.0.2",
-      "resolved": "https://registry.npmmirror.com/react-is/-/react-is-17.0.2.tgz",
+      "resolved": "https://registry.npmjs.org/react-is/-/react-is-17.0.2.tgz",
      "integrity": "sha512-w2GsyukL62IJnlaff/nRegPQR94C/XXamvMWmSHRJ4y7Ts/4ocGRmTHvOs8PSE6pB3dWOrD/nueuU5sduBsQ4w==",
      "dev": true,
-      "license": "MIT",
      "peer": true
    },
    "node_modules/react-refresh": {
@@ -71,4 +71,5 @@ export interface VideoItem {
  generation_params: Record<string, unknown>
  download_url: string
  generated_at: string
+  duplicate_rate?: number
 }
@@ -29,7 +29,6 @@ export function mapVideoToProductItem(video: VideoItem): ProductItem {
    // 后端字段名为 generated_at，映射为 created_at 供前端统一使用
    created_at: video.generated_at,
    updated_at: video.generated_at,
-    // 后端 /videos 接口暂无 duplicate_rate 字段
-    duplicate_rate: undefined,
+    duplicate_rate: video.duplicate_rate,
  }
 }
@@ -338,12 +338,15 @@ const GeneratePage: React.FC = () => {
                size: titleSettings.size,
                font: titleSettings.font,
                color: titleSettings.color,
-                position: titleSettings.position as "top" | "center" | "bottom",
+                position: titleSettings.position as "top" | "center" | "bottom" | "custom",
                bold: titleSettings.bold,
                italic: titleSettings.italic,
                stroke: titleSettings.stroke,
                shadow: titleSettings.shadow,
+                posX: titleSettings.posX,
+                posY: titleSettings.posY,
              }}
+              onTitlePositionChange={styleUpdaters.updateTitlePosition}
            />
          )}
          {currentStep >= 5 && generated && finalVideo && (
@@ -32,12 +32,15 @@ interface FrontendPreviewPlayerProps {
    size: number
    font: string
    color: string
-    position: "top" | "center" | "bottom"
+    position: "top" | "center" | "bottom" | "custom"
    bold?: boolean
    italic?: boolean
    stroke?: boolean
    shadow?: boolean
+    posX?: number | null
+    posY?: number | null
  }
+  onTitlePositionChange?: (posX: number, posY: number) => void
 }

 function formatTime(seconds: number): string {
@@ -105,6 +108,7 @@ const FrontendPreviewPlayer: React.FC<FrontendPreviewPlayerProps> = ({
  serverClips,
  voiceAudioUrl,
  titleSettings,
+  onTitlePositionChange,
 }) => {
  const segments = useMemo(
    () => buildPlaybackSegments(assets, template, serverClips),
@@ -126,6 +130,69 @@ const FrontendPreviewPlayer: React.FC<FrontendPreviewPlayerProps> = ({
        return { width: 1080, height: 1920 }
    }
  })()
+  const customTitleXPct =
+    titleSettings?.posX != null && playRes.width > 0
+      ? (titleSettings.posX / playRes.width) * 100
+      : null
+  const customTitleYPct =
+    titleSettings?.posY != null && playRes.height > 0
+      ? (titleSettings.posY / playRes.height) * 100
+      : null
+
+  // ── 拖拽状态（用 ref 避免在每帧渲染中触发重渲染）──
+  const draggingTitleRef = useRef(false)
+  const titleDragRef = useRef<HTMLDivElement>(null)
+  const handleTitlePointerDown = useCallback(
+    (e: React.PointerEvent<HTMLDivElement>) => {
+      if (!onTitlePositionChange || !playerContainerRef.current) return
+      e.preventDefault()
+      e.stopPropagation()
+      ;(e.target as Element).setPointerCapture(e.pointerId)
+      draggingTitleRef.current = true
+      ;(e.currentTarget as HTMLDivElement).style.cursor = "grabbing"
+    },
+    [onTitlePositionChange],
+  )
+  const handleTitlePointerMove = useCallback((e: React.PointerEvent<HTMLDivElement>) => {
+    if (!draggingTitleRef.current || !playerContainerRef.current) return
+    e.preventDefault()
+    e.stopPropagation()
+    // 拖拽过程中直接修改 DOM，不触发 React 渲染（避免频繁重渲染导致换行）
+    if (titleDragRef.current) {
+      const rect = playerContainerRef.current.getBoundingClientRect()
+      const relX = Math.max(0, Math.min(rect.width, e.clientX - rect.left))
+      const relY = Math.max(0, Math.min(rect.height, e.clientY - rect.top))
+      const xpct = (relX / rect.width) * 100
+      const ypct = (relY / rect.height) * 100
+      titleDragRef.current.style.left = `${xpct}%`
+      titleDragRef.current.style.top = `${ypct}%`
+    }
+  }, [])
+  const handleTitlePointerUp = useCallback(
+    (e: React.PointerEvent<HTMLDivElement>) => {
+      if (!draggingTitleRef.current) return
+      draggingTitleRef.current = false
+      // 拖拽结束时才调用 onTitlePositionChange 保存最终位置
+      if (onTitlePositionChange && playerContainerRef.current) {
+        const rect = playerContainerRef.current.getBoundingClientRect()
+        const relX = Math.max(0, Math.min(rect.width, e.clientX - rect.left))
+        const relY = Math.max(0, Math.min(rect.height, e.clientY - rect.top))
+        const posX = Math.round((relX / rect.width) * playRes.width)
+        const posY = Math.round((relY / rect.height) * playRes.height)
+        onTitlePositionChange(posX, posY)
+      }
+      ;(e.currentTarget as HTMLDivElement).style.cursor = "grab"
+      try {
+        if ((e.currentTarget as Element).hasPointerCapture(e.pointerId)) {
+          ;(e.currentTarget as Element).releasePointerCapture(e.pointerId)
+        }
+      } catch {
+        /* ignore */
+      }
+    },
+    [onTitlePositionChange, playRes.width, playRes.height],
+  )
+
  const playerContainerRef = useRef<HTMLDivElement>(null)
  const [containerHeight, setContainerHeight] = useState(0)
  useEffect(() => {
@@ -524,15 +591,36 @@ const FrontendPreviewPlayer: React.FC<FrontendPreviewPlayerProps> = ({
          <div
            style={{
              position: "absolute",
-              left: `${titleSidePct}%`,
-              right: `${titleSidePct}%`,
-              textAlign: "center",
-              ...(titleSettings.position === "top"
-                ? { top: `${titleTopPct}%` }
-                : titleSettings.position === "center"
-                  ? { top: "50%", transform: "translateY(-50%)" }
-                  : { bottom: `${titleBottomPct}%` }),
+              ...(customTitleXPct != null && customTitleYPct != null
+                ? {
+                    left: `${customTitleXPct}%`,
+                    top: `${customTitleYPct}%`,
+                    transform: "translate(-50%, -50%)",
+                    textAlign: "center" as const,
+                  }
+                : {
+                    left: `${titleSidePct}%`,
+                    right: `${titleSidePct}%`,
+                    textAlign: "center" as const,
+                    ...(titleSettings.position === "top"
+                      ? { top: `${titleTopPct}%` }
+                      : titleSettings.position === "center"
+                        ? { top: "50%", transform: "translateY(-50%)" }
+                        : { bottom: `${titleBottomPct}%` }),
+                  }),
+              pointerEvents: "auto",
+              cursor: onTitlePositionChange ? "grab" : "default",
+              touchAction: "none",
+              userSelect: "none",
+              WebkitUserSelect: "none",
+              padding: "8px 12px",
+              boxShadow: "inset 0 0 0 16px transparent",
            }}
+            ref={titleDragRef}
+            onPointerDown={handleTitlePointerDown}
+            onPointerMove={handleTitlePointerMove}
+            onPointerUp={handleTitlePointerUp}
+            onPointerCancel={handleTitlePointerUp}
          >
            <span
              style={{
@@ -23,7 +23,7 @@ const MaterialModeTabs: React.FC<MaterialModeTabsProps> = ({ mode, onModeChange
        onClick={() => onModeChange("auto")}
        type="button"
      >
-        选择视频库自动匹配
+        AI智能匹配
      </button>
    </div>
  )
@@ -38,9 +38,8 @@ const TitlePresetsGrid: React.FC<TitlePresetsGridProps> = ({
              className="xx-title-preset-preview-text"
              style={{ ...p.previewStyle, fontFamily: getFontFamily(fontFamily || "思源黑体") }}
            >
-              标题
+              T
            </span>
-            <span className="xx-title-preset-card-label">{p.label}</span>
          </button>
        )
      })}
@@ -42,6 +42,7 @@ export const POSITION_OPTIONS = [
  { value: "top", label: "顶部" },
  { value: "center", label: "居中" },
  { value: "bottom", label: "底部" },
+  { value: "custom", label: "自定义" },
 ]

 /* ── 标题字体选项 ── */
@@ -80,7 +81,7 @@ export const TITLE_PRESETS = [
      fontWeight: 700,
      color: "#ffffff",
      WebkitTextStroke: "1px #000000",
-      fontSize: "20px",
+      fontSize: "32px",
    },
  },
  {
@@ -91,14 +92,14 @@ export const TITLE_PRESETS = [
      fontWeight: 700,
      color: "#d4a843",
      textShadow: "1px 1px 3px rgba(0,0,0,0.8)",
-      fontSize: "20px",
+      fontSize: "32px",
    },
  },
  {
    key: "fresh_minimal",
    label: "清新简约",
    style: { size: 24, color: "#333333", bold: false, italic: false, stroke: false, shadow: false },
-    previewStyle: { fontWeight: 400, color: "#333333", fontSize: "18px" },
+    previewStyle: { fontWeight: 400, color: "#333333", fontSize: "32px" },
  },
  {
    key: "variety_show",
@@ -109,14 +110,14 @@ export const TITLE_PRESETS = [
      color: "#ff4081",
      WebkitTextStroke: "1.5px #ffffff",
      textShadow: "2px 2px 4px rgba(0,0,0,0.5)",
-      fontSize: "22px",
+      fontSize: "32px",
    },
  },
  {
    key: "business",
    label: "商务极简",
    style: { size: 24, color: "#1a1a1a", bold: false, italic: false, stroke: false, shadow: false },
-    previewStyle: { fontWeight: 400, color: "#1a1a1a", fontSize: "17px" },
+    previewStyle: { fontWeight: 400, color: "#1a1a1a", fontSize: "32px" },
  },
  {
    key: "retro_film",
@@ -126,7 +127,7 @@ export const TITLE_PRESETS = [
      fontWeight: 400,
      color: "#e8d5b7",
      textShadow: "2px 2px 6px rgba(0,0,0,0.7)",
-      fontSize: "18px",
+      fontSize: "32px",
    },
  },
  {
@@ -137,7 +138,7 @@ export const TITLE_PRESETS = [
      fontWeight: 700,
      color: "#00e5ff",
      textShadow: "0 0 4px #00e5ff, 0 0 8px #00e5ff, 0 0 16px rgba(0,229,255,0.5)",
-      fontSize: "20px",
+      fontSize: "32px",
    },
  },
  {
@@ -148,7 +149,7 @@ export const TITLE_PRESETS = [
      fontWeight: 400,
      color: "#333333",
      textShadow: "1px 1px 2px rgba(0,0,0,0.3)",
-      fontSize: "20px",
+      fontSize: "32px",
    },
  },
 ]
@@ -1733,50 +1733,41 @@
 /* 标题预设卡片网格 */
 .xx-title-presets-grid {
  display: grid;
-  grid-template-columns: repeat(4, 1fr);
-  gap: 10px;
+  grid-template-columns: repeat(6, 1fr);
+  gap: 8px;
 }

 .xx-title-preset-card {
  display: flex;
-  flex-direction: column;
  align-items: center;
  justify-content: center;
-  padding: 14px 8px;
-  background: var(--bg-secondary);
+  width: 52px;
+  height: 52px;
+  padding: 0;
+  background: #3a3a3a;
  border: 2px solid transparent;
-  border-radius: var(--radius-sm);
+  border-radius: 8px;
  cursor: pointer;
  transition: all 0.15s;
-  text-align: center;
 }

 .xx-title-preset-card:hover {
-  border-color: var(--primary-200);
-  background: var(--bg-primary);
+  border-color: #666;
+  background: #4a4a4a;
 }

 .xx-title-preset-card.active {
-  border-color: var(--primary-color);
-  background: var(--primary-50);
+  border-color: #409eff;
+  background: #4a4a4a;
 }

 .xx-title-preset-preview-text {
-  line-height: 1.4;
-  margin-bottom: 6px;
+  font-size: 32px;
+  font-weight: 700;
+  line-height: 1;
  user-select: none;
 }

-.xx-title-preset-card-label {
-  font-size: 11px;
-  color: var(--text-secondary);
-}
-
-.xx-title-preset-card.active .xx-title-preset-card-label {
-  color: var(--primary-color);
-  font-weight: 500;
-}
-
 /* 样式按钮组 */
 .xx-style-btns {
  display: flex;
@@ -20,13 +20,14 @@ const SECONDS_PER_ASSET = 15
 /**
 * 根据模板 segments 计算所需素材数量上限。
 * 取每个 segment 的 duration_min 之和作为目标视频总时长，
- * 再按 15 秒/素材估算需要多少个素材；结果钳制到 [1, 200] 区间（后端 limit 上限 200）。
+ * 再按 15 秒/素材估算需要多少个素材，且保证不少于片段数（每个片段至少 1 个素材）；
+ * 结果钳制到 [1, 200] 区间（后端 limit 上限 200）。
 */
 function computeLimitFromSegments(segments?: TemplateSegment[]): number {
  if (!segments || segments.length === 0) return DEFAULT_LIMIT
  const totalSeconds = segments.reduce((sum, seg) => sum + (seg.duration_min || 0), 0)
  if (totalSeconds <= 0) return DEFAULT_LIMIT
-  const limit = Math.ceil(totalSeconds / SECONDS_PER_ASSET)
+  const limit = Math.max(segments.length, Math.ceil(totalSeconds / SECONDS_PER_ASSET))
  return Math.max(1, Math.min(limit, 200))
 }

@@ -233,7 +233,7 @@ export function useCanvasPlayer(
    fontSize: number
    fontFamily: string
    color: string
-    position: "top" | "center" | "bottom"
+    position: "top" | "center" | "bottom" | "custom"
    bold?: boolean
    stroke?: boolean
    shadow?: boolean
@@ -27,6 +27,8 @@ const DEFAULT_TITLE_SETTINGS: TitleSettings = {
  stroke: true,
  shadow: false,
  color: "#ffffff",
+  posX: null,
+  posY: null,
 }

 export interface GenerateFormState {
@@ -117,6 +117,14 @@ export function useGenerateVideo(props: UseGenerateVideoProps) {
                  font_size: props.titleSettings.size,
                  font_color: props.titleSettings.color,
                  position: props.titleSettings.position,
+                  ...(props.titleSettings.position === "custom" &&
+                  props.titleSettings.posX != null &&
+                  props.titleSettings.posY != null
+                    ? {
+                        pos_x: Math.round(props.titleSettings.posX),
+                        pos_y: Math.round(props.titleSettings.posY),
+                      }
+                    : {}),
                  bold: props.titleSettings.bold,
                  stroke: props.titleSettings.stroke,
                  shadow: props.titleSettings.shadow,
@@ -46,7 +46,16 @@ export function useTitleStyleUpdaters({

  const updatePosition = useCallback(
    (position: string) => {
-      onTitleSettingsChange({ ...titleSettings, position })
+      // 切回三档预设时清掉自定义坐标
+      onTitleSettingsChange({ ...titleSettings, position, posX: null, posY: null })
+    },
+    [titleSettings, onTitleSettingsChange],
+  )
+
+  /** 拖拽更新自定义位置（由预览播放器调用） */
+  const updateTitlePosition = useCallback(
+    (posX: number, posY: number) => {
+      onTitleSettingsChange({ ...titleSettings, position: "custom", posX, posY })
    },
    [titleSettings, onTitleSettingsChange],
  )
@@ -111,6 +120,7 @@ export function useTitleStyleUpdaters({
    updateTitle,
    toggleAiAutoSelect,
    updatePosition,
+    updateTitlePosition,
    updateFont,
    updateSize,
    updateColor,
@@ -16,6 +16,9 @@ export interface TitleSettings {
  stroke: boolean
  shadow: boolean
  color: string
+  /** 自由位置坐标（PlayRes 像素），仅当 position="custom" 时有效 */
+  posX: number | null
+  posY: number | null
 }

 /* ── 智能匹配结果 ── */
@@ -11,7 +11,7 @@ import {
 } from "@ant-design/icons"
 import type { ProductItem } from "../types"
 import { statusConfig, reviewStatusConfig } from "../constants"
-import { formatTime } from "../utils"
+import { formatTime, formatSize } from "../utils"

 interface ProductCardProps {
  product: ProductItem
@@ -210,11 +210,20 @@ export const ProductCard: React.FC<ProductCardProps> = ({
          <span className={`xx-product-status ${st.className}`}>{st.text}</span>
          <span className="xx-product-date">{product.date}</span>
        </div>
-        {product.duplicateRate > 0 && (
-          <span className={`xx-product-dup-rate ${dupClass}`}>
-            查重率：{product.duplicateRate.toFixed(1)}%
+        <div className="xx-product-meta-grid">
+          <span className="xx-product-meta-item">分辨率：{product.resolution || "-"}</span>
+          <span className="xx-product-meta-item">
+            时长：{product.duration > 0 ? formatTime(product.duration) : "-"}
          </span>
-        )}
+          <span className="xx-product-meta-item">大小：{formatSize(product.fileSize)}</span>
+          <span
+            className={`xx-product-meta-item xx-product-dup-rate${
+              product.duplicateRate > 0 ? ` ${dupClass}` : ""
+            }`}
+          >
+            查重率：{product.duplicateRate > 0 ? `${product.duplicateRate.toFixed(1)}%` : "-"}
+          </span>
+        </div>
      </div>

      {/* 操作按钮 */}
@@ -91,8 +91,6 @@
  height: 18px;
  border: 2px solid var(--border-color);
  border-radius: var(--radius-xs);
-  display: grid;
-  place-items: center;
  transition: var(--transition-all);
  background: var(--bg-primary);
  flex-shrink: 0;
@@ -187,8 +185,6 @@
  height: 22px;
  border: 2px solid rgba(255, 255, 255, 0.8);
  border-radius: var(--radius-xs);
-  display: grid;
-  place-items: center;
  background: rgba(0, 0, 0, 0.3);
  backdrop-filter: blur(4px);
  cursor: pointer;
@@ -262,11 +258,8 @@
 .xx-product-thumb {
  position: relative;
  overflow: hidden;
-  display: grid;
-  place-items: center;
  color: var(--text-inverse);
  background: var(--color-gray-950);
-  max-height: 320px;
 }

 .xx-product-thumb-bg {
@@ -276,11 +269,11 @@
  background-position: center;
 }

-/* 内联视频播放器 */
+/* 内联视频播放器（cover 填满容器，竖屏视频不留左右空白） */
 .xx-product-thumb-video {
  width: 100%;
  height: 100%;
-  object-fit: contain;
+  object-fit: cover;
  display: block;
 }

@@ -296,8 +289,6 @@
  border-radius: var(--radius-full);
  background: rgba(0, 0, 0, 0.45);
  backdrop-filter: blur(4px);
-  display: grid;
-  place-items: center;
  font-size: var(--font-size-md);
  transition: var(--transition-all);
 }
@@ -347,6 +338,21 @@
  gap: var(--space-xs);
 }

+/* 卡片信息网格：分辨率/时长 一行，大小/查重率 一行 */
+.xx-product-meta-grid {
+  display: grid;
+  grid-template-columns: 1fr 1fr;
+  gap: 4px var(--space-sm);
+}
+
+.xx-product-meta-item {
+  font-size: var(--font-size-xs);
+  color: var(--text-secondary);
+  white-space: nowrap;
+  overflow: hidden;
+  text-overflow: ellipsis;
+}
+
 /* 状态标签 */
 .xx-product-status {
  padding: 2px 10px;
@@ -491,8 +497,6 @@
  z-index: 1000;
  background: rgba(0, 0, 0, 0.75);
  backdrop-filter: blur(8px);
-  display: grid;
-  place-items: center;
  animation: player-fade-in 0.25s ease-out;
 }

@@ -531,8 +535,6 @@
  background: var(--color-gray-950);
  aspect-ratio: 9 / 16;
  max-height: 60vh;
-  display: grid;
-  place-items: center;
 }

 .xx-player-video-wrap video {
@@ -554,8 +556,6 @@
  backdrop-filter: blur(4px);
  color: var(--text-inverse);
  font-size: 28px;
-  display: grid;
-  place-items: center;
  cursor: pointer;
  border: none;
  transition: var(--transition-all);
@@ -652,8 +652,6 @@
  backdrop-filter: blur(4px);
  color: var(--text-inverse);
  font-size: var(--font-size-md);
-  display: grid;
-  place-items: center;
  cursor: pointer;
  border: none;
  transition: var(--transition-all);
@@ -314,10 +314,13 @@ class VideoDeduplicator:
        project_id: str,
        current_video_id: str | None,
        session: Session,
+        *,
+        user_id: str = "",
    ) -> float:
-        """计算当前视频与项目内已有视频的最高相似度百分比。
+        """计算当前视频与用户库内已有视频的最高相似度百分比。

-        遍历项目内所有其他有指纹的视频，对每个计算相似度：
+        优先按 user_id 全局比较（跨项目），user_id 为空时回退到项目级比较。
+        遍历最近 200 个其他有指纹的视频，对每个计算相似度：
        - MD5 精确匹配 → 100%
        - pHash 相似度 → (1.0 - avg_distance / 64) * 100
        取最高值作为 duplicate_rate（0~100）。
@@ -325,23 +328,34 @@ class VideoDeduplicator:

        Args:
            fingerprint: 当前视频的指纹
-            project_id: 项目 ID
+            project_id: 项目 ID（user_id 为空时的回退范围）
            current_video_id: 当前视频 ID（排除自身，可为 None）
            session: 数据库会话
+            user_id: 用户 ID（优先按用户全局比较）

        Returns:
            duplicate_rate: 0~100 的浮点数
        """
-        # 限制查询最近 100 个视频，避免大项目内存溢出
+        # 限制查询最近 200 个视频，避免大库内存溢出
        from packages.adapters.sqlalchemy_impl.models import GeneratedVideoModel

-        recent_models = (
-            session.query(GeneratedVideoModel)
-            .filter(GeneratedVideoModel.project_id == project_id)
-            .order_by(GeneratedVideoModel.generated_at.desc())
-            .limit(100)
-            .all()
-        )
+        # 优先按 user_id 全局比较（跨项目），否则回退到项目级
+        if user_id:
+            query = session.query(GeneratedVideoModel).filter(
+                GeneratedVideoModel.user_id == user_id,
+            )
+            logger.debug("compute_duplicate_rate: user-level scope user_id=%s", user_id)
+        else:
+            query = session.query(GeneratedVideoModel).filter(
+                GeneratedVideoModel.project_id == project_id,
+            )
+            logger.debug("compute_duplicate_rate: project-level fallback project_id=%s", project_id)
+
+        # 排除当前视频自身（记录可能已写入 DB，必须在查询层排除）
+        if current_video_id:
+            query = query.filter(GeneratedVideoModel.id != current_video_id)
+
+        recent_models = query.order_by(GeneratedVideoModel.generated_at.desc()).limit(200).all()
        video_repo = SQLAlchemyGeneratedVideoRepository(session)
        existing_videos = [video_repo._to_domain(m) for m in recent_models]

@@ -123,7 +123,13 @@ def create_video_record_and_dedup(

        # 计算重复率百分比（与项目内所有已有视频对比取最高相似度）
        try:
-            dup_rate = deduplicator.compute_duplicate_rate(fingerprint, project_id, video_id, session)
+            dup_rate = deduplicator.compute_duplicate_rate(
+                fingerprint,
+                project_id,
+                video_id,
+                session,
+                user_id=user_id,
+            )
            generated_video.duplicate_rate = dup_rate
            logger.info("Duplicate rate for %s: %.2f%%", video_id, dup_rate)
        except Exception as rate_err:
@@ -30,6 +30,14 @@ RUN apt-get update \
    && apt-get install -y --no-install-recommends docker-ce-cli docker-buildx-plugin \
    && rm -rf /var/lib/apt/lists/*

+# Pre-bake ffmpeg: unit-tests run in fresh containers each time; installing ffmpeg
+# on every job cost ~24 min (apt update + hundreds of codec deps). Bake it into the
+# image so step_install_ffmpeg.sh detects it and exits instantly.
+RUN apt-get update \
+    && apt-get install -y --no-install-recommends ffmpeg \
+    && ffmpeg -version | head -1 \
+    && rm -rf /var/lib/apt/lists/*
+
 # Pre-install base deps (layer cache)
 COPY requirements-base.txt ./
 RUN python -m venv "$VIRTUAL_ENV" \
@@ -1,5 +1,6 @@
 # Build stage
 FROM git.xiaoxiajianji.com/xiaoxia/base/node:20 AS builder
+ARG SOURCE_HASH=""
 WORKDIR /app
 ARG VITE_API_URL=https://saas-api.xiaoxiajianji.com
 ENV VITE_API_URL=$VITE_API_URL
@@ -18,8 +19,10 @@ COPY apps/web/ ./

 # 构建：TS增量编译 + Vite构建，tsbuildinfo用cache mount持久化
 # node_modules直接使用镜像中已安装的（layer缓存保证完整性）
+# SOURCE_HASH 变化时强制重新执行（防止 buildkit 幽灵缓存命中）
 RUN --mount=type=cache,target=/app/apps/web/.tscache,sharing=locked \
    mkdir -p .tscache \
+    && echo "SOURCE_HASH=${SOURCE_HASH}" > .cache_bust \
    && ./node_modules/.bin/tsc --incremental --tsBuildInfoFile .tscache/tsconfig.tsbuildinfo \
    && ./node_modules/.bin/vite build

@@ -1,4 +1,9 @@
-"""SQLAlchemy implementation of TemplateRepository."""
+"""SQLAlchemy implementation of TemplateRepository.
+
+模板 segments 数据源已统一为 template_clip_configs 表。
+读取时优先 template_clip_configs，回退 template_segments（兼容历史数据）。
+写入全部走 template_clip_configs。
+"""

 from __future__ import annotations

@@ -10,6 +15,7 @@ from sqlalchemy.orm import Session
 from packages.adapters.sqlalchemy_impl.models import (
    EditPlanModel,
    TemplateCategoryModel,
+    TemplateClipConfigModel,
    TemplateModel,
    TemplateSegmentModel,
 )
@@ -47,27 +53,38 @@ class SQLAlchemyTemplateRepository:
            like_pattern = f"%{keyword}%"
            query = query.filter(TemplateModel.name.like(like_pattern))
        if tag:
-            # JSON 数组包含指定标签（MySQL JSON_CONTAINS / SQLite json_each 兼容写法用 LIKE）
-            query = query.filter(TemplateModel.tags.like(f'%"{tag}"%'))
+            query = query.filter(TemplateModel.tags.like(f'"%{tag}"%'))
        models = query.order_by(TemplateModel.created_at.desc()).offset(skip).limit(limit).all()
        templates = [self._model_to_entity(m) for m in models]
-        # 批量加载所有 segments，避免 N+1 查询
+        # 批量加载 segments —— 优先 template_clip_configs
        if templates:
            template_ids = [t.id for t in templates]
-            seg_models = (
-                self.session.query(TemplateSegmentModel)
-                .filter(TemplateSegmentModel.template_id.in_(template_ids))
-                .order_by(TemplateSegmentModel.segment_order)
+            clip_models = (
+                self.session.query(TemplateClipConfigModel)
+                .filter(TemplateClipConfigModel.template_id.in_(template_ids))
+                .order_by(TemplateClipConfigModel.order)
                .all()
            )
-            # 按 template_id 分组
-            seg_map: dict[str, list] = {}
-            for sm in seg_models:
-                seg_map.setdefault(sm.template_id, []).append(
-                    self._segment_model_to_entity(sm),
+            clip_map: dict[str, list] = {}
+            for cm in clip_models:
+                clip_map.setdefault(cm.template_id, []).append(
+                    self._clip_config_to_segment(cm),
                )
+            # 对没有 clip_configs 的模板，回退读 template_segments
+            missing_ids = [t.id for t in templates if t.id not in clip_map]
+            if missing_ids:
+                old_models = (
+                    self.session.query(TemplateSegmentModel)
+                    .filter(TemplateSegmentModel.template_id.in_(missing_ids))
+                    .order_by(TemplateSegmentModel.segment_order)
+                    .all()
+                )
+                for om in old_models:
+                    clip_map.setdefault(om.template_id, []).append(
+                        self._segment_model_to_entity(om),
+                    )
            for t in templates:
-                t.segments = seg_map.get(t.id, [])
+                t.segments = clip_map.get(t.id, [])
        return templates

    def get(self, template_id: str, user_id: str) -> Optional[Template]:
@@ -100,7 +117,6 @@ class SQLAlchemyTemplateRepository:
            is_active=template.is_active,
        )
        self.session.add(model)
-        # flush 而非 commit，让 create + create_segments 在同一事务中提交
        self.session.flush()
        self.session.refresh(model)
        result = self._model_to_entity(model)
@@ -145,11 +161,8 @@ class SQLAlchemyTemplateRepository:
        if model is None:
            return False
        model.is_active = False
-        # 级联清理关联的 segments，避免孤儿数据
-        self.session.query(TemplateSegmentModel).filter(
-            TemplateSegmentModel.template_id == template_id,
-        ).delete(synchronize_session=False)
-        self.session.commit()
+        # 复用 delete_segments_by_template 清理两张表的关联数据
+        self.delete_segments_by_template(template_id)
        return True

    def count_by_user(
@@ -172,7 +185,7 @@ class SQLAlchemyTemplateRepository:
        if keyword:
            query = query.filter(TemplateModel.name.like(f"%{keyword}%"))
        if tag:
-            query = query.filter(TemplateModel.tags.like(f'%"{tag}"%'))
+            query = query.filter(TemplateModel.tags.like(f'"%{tag}"%'))
        return query.count()

    def copy_template(self, template_id: str, user_id: str, new_name: str) -> Template:
@@ -181,9 +194,8 @@ class SQLAlchemyTemplateRepository:
        if source is None:
            raise ValueError(f"Template {template_id} not found")

-        new_id = str(uuid.uuid4())
        new_template = Template(
-            id=new_id,
+            id=str(uuid.uuid4()),
            user_id=user_id,
            name=new_name,
            mode=source.mode,
@@ -197,28 +209,22 @@ class SQLAlchemyTemplateRepository:
        )
        created = self.create(new_template)

-        # 复制 segments
+        # 复用 create_segments 写入 template_clip_configs
        new_segments: List[TemplateSegment] = []
        for seg in source.segments:
-            new_seg = TemplateSegment(
-                id=str(uuid.uuid4()),
-                template_id=new_id,
-                segment_order=seg.segment_order,
-                duration_min=seg.duration_min,
-                duration_max=seg.duration_max,
-                material_type=seg.material_type,
+            new_segments.append(
+                TemplateSegment(
+                    id=str(uuid.uuid4()),
+                    template_id=created.id,
+                    segment_order=seg.segment_order,
+                    duration_min=seg.duration_min,
+                    duration_max=seg.duration_max,
+                    material_type=seg.material_type,
+                )
            )
-            new_segments.append(new_seg)
-            model = TemplateSegmentModel(
-                id=new_seg.id,
-                template_id=new_seg.template_id,
-                segment_order=new_seg.segment_order,
-                duration_min=new_seg.duration_min,
-                duration_max=new_seg.duration_max,
-                material_type=new_seg.material_type,
-            )
-            self.session.add(model)
        if new_segments:
+            self.create_segments(new_segments)
+        else:
            self.session.commit()

        created.segments = new_segments
@@ -227,34 +233,58 @@ class SQLAlchemyTemplateRepository:
    # ── Segments ──

    def list_segments(self, template_id: str) -> List[TemplateSegment]:
-        models = (
+        """优先从 template_clip_configs 读取，回退读 template_segments。"""
+        clips = (
+            self.session.query(TemplateClipConfigModel)
+            .filter(TemplateClipConfigModel.template_id == template_id)
+            .order_by(TemplateClipConfigModel.order)
+            .all()
+        )
+        if clips:
+            return [self._clip_config_to_segment(m) for m in clips]
+        # 回退：旧表
+        old = (
            self.session.query(TemplateSegmentModel)
            .filter(TemplateSegmentModel.template_id == template_id)
            .order_by(TemplateSegmentModel.segment_order)
            .all()
        )
-        return [self._segment_model_to_entity(m) for m in models]
+        return [self._segment_model_to_entity(m) for m in old]

    def create_segments(self, segments: List[TemplateSegment]) -> List[TemplateSegment]:
+        """写入 template_clip_configs 表。material_type 存入 config JSON。"""
        for seg in segments:
-            model = TemplateSegmentModel(
+            config = {"material_type": seg.material_type} if seg.material_type else {}
+            model = TemplateClipConfigModel(
                id=seg.id,
                template_id=seg.template_id,
-                segment_order=seg.segment_order,
-                duration_min=seg.duration_min,
-                duration_max=seg.duration_max,
-                material_type=seg.material_type,
+                clip_type="main",
+                order=seg.segment_order,
+                min_duration=seg.duration_min,
+                max_duration=seg.duration_max,
+                text_template="",
+                material_requirements={},
+                transition_effect="cut",
+                config=config,
            )
            self.session.add(model)
        self.session.commit()
        return segments

    def delete_segments_by_template(self, template_id: str) -> int:
-        count = (
-            self.session.query(TemplateSegmentModel).filter(TemplateSegmentModel.template_id == template_id).delete()
+        """删除两张表中的 segments 数据，返回删除总数。"""
+        c1 = (
+            self.session.query(TemplateClipConfigModel)
+            .filter(TemplateClipConfigModel.template_id == template_id)
+            .delete(synchronize_session=False)
+        )
+        c2 = (
+            self.session.query(TemplateSegmentModel)
+            .filter(TemplateSegmentModel.template_id == template_id)
+            .delete(synchronize_session=False)
        )
        self.session.commit()
-        return count
+        return c1 + c2

    # ── Categories ──

@@ -366,6 +396,23 @@ class SQLAlchemyTemplateRepository:
            updated_at=model.updated_at,
        )

+    @staticmethod
+    def _clip_config_to_segment(model: TemplateClipConfigModel) -> TemplateSegment:
+        """将 TemplateClipConfigModel 转换为 TemplateSegment 域实体。"""
+        material_type = None
+        if model.config and isinstance(model.config, dict):
+            material_type = model.config.get("material_type")
+        return TemplateSegment(
+            id=model.id,
+            template_id=model.template_id,
+            segment_order=model.order,
+            duration_min=model.min_duration,
+            duration_max=model.max_duration,
+            material_type=material_type,
+            created_at=model.created_at,
+            updated_at=model.updated_at,
+        )
+
    @staticmethod
    def _category_model_to_entity(model: TemplateCategoryModel) -> TemplateCategory:
        return TemplateCategory(
@@ -256,6 +256,42 @@ def _wrap_title_text(
    return "\\N".join(wrapped_segments)


+def _parse_title_position(
+    title_config: dict[str, Any],
+    video_width: int,
+    video_height: int,
+) -> tuple[int, int] | None:
+    """解析标题自由拖拽坐标 pos_x/pos_y（PlayRes 像素坐标系）。
+
+    要求两个字段同时存在、可转 int，且落在 [0, video_width] × [0, video_height]
+    闭区间内。任一条件不满足返回 None，调用方回退 position 三档逻辑。
+
+    Args:
+        title_config: 标题配置 dict
+        video_width: PlayResX（视频宽度像素）
+        video_height: PlayResY（视频高度像素）
+
+    Returns:
+        (x, y) 整数坐标，或 None 表示不使用自由位置
+    """
+    if "pos_x" not in title_config or "pos_y" not in title_config:
+        return None
+    raw_x = title_config["pos_x"]
+    raw_y = title_config["pos_y"]
+    # 坐标必须是 PlayRes 像素整数：bool 是 int 子类（isinstance(True,int)=True）
+    # 但 True/False 作坐标无意义；float 静默截断会造成拖拽位置偏差，一律按非法回退
+    if isinstance(raw_x, bool) or isinstance(raw_y, bool):
+        return None
+    if not isinstance(raw_x, int) or not isinstance(raw_y, int):
+        return None
+    x, y = raw_x, raw_y
+    if video_width <= 0 or video_height <= 0:
+        return None
+    if not (0 <= x <= video_width and 0 <= y <= video_height):
+        return None
+    return (x, y)
+
+
 def build_ass_content(
    *,
    video_width: int,
@@ -343,7 +379,16 @@ def build_ass_content(
            title_shadow.get("offset_y", 2) if title_shadow.get("enabled", False) else 0,
        )

-        title_alignment = position_to_ass_alignment(title_config.get("position", "top"))
+        # ── 自由位置拖拽（工单 #1405 方案 B）────────────────────────────
+        # pos_x/pos_y 为 PlayRes 坐标系像素整数（PlayResX/Y = video_width/height）。
+        # 合法时：TitleStyle Alignment 固定 5（\an5 中对齐，使 \pos 锚点为文本块中心），
+        # Dialogue 文本前注入 {\pos(x,y)}。字段缺失/非法/越界时一律回退
+        # position → alignment 三档逻辑，现有输出保持一字节不变。
+        title_pos = _parse_title_position(title_config, video_width, video_height)
+
+        title_alignment = 5 if title_pos is not None else position_to_ass_alignment(
+            title_config.get("position", "top")
+        )

        styles.append(
            build_ass_style(
@@ -370,6 +415,10 @@ def build_ass_content(
        safe_title_text_raw = escape_ass_text(title_text)
        safe_title_text = _wrap_title_text(safe_title_text_raw, video_width, title_font_size)

+        # 自由位置：在文本前注入 \pos override tag（锚点为文本块中心，配合 \an5）
+        if title_pos is not None:
+            safe_title_text = f"{{\\pos({title_pos[0]},{title_pos[1]})}}{safe_title_text}"
+
        events.append(
            "Dialogue: 0,0:00:00.00," f"{format_ass_time(video_duration)}," "TitleStyle,,0,0,0,," f"{safe_title_text}"
        )
@@ -28,15 +28,12 @@ if [ "$SKIP_BACKEND" = "true" ]; then
  CONTEXTS=("CI/CD Pipeline / Frontend Lint (pull_request)")
 else
  CONTEXTS=(
-    "CI/CD Pipeline / Validate - Code Quality (pull_request)"
-    "CI/CD Pipeline / Validate - Type Check (mypy) (pull_request)"
-    "CI/CD Pipeline / Validate - Migration (alembic) (pull_request)"
+    # CI 优化后 job 名称（2026-08）：Code Quality 拆分为 Style+Security，Type Check+Migration 合并为 Python
+    # 与 pr_auto_scan.py 的 REQUIRED_CONTEXTS_APPROVE 保持一致
+    "CI/CD Pipeline / Validate - Style (pull_request)"
+    "CI/CD Pipeline / Validate - Security (pull_request)"
+    "CI/CD Pipeline / Validate - Python (mypy + alembic) (pull_request)"
    "CI/CD Pipeline / Frontend Lint (pull_request)"
-    "CI/CD Pipeline / Unit Tests (pull_request)"
-    "CI/CD Pipeline / Frontend Unit Tests (pull_request)"
-    "CI/CD Pipeline / PR Build API Image (pull_request)"
-    "CI/CD Pipeline / PR Build Web Image (pull_request)"
-    "CI/CD Pipeline / PR Build Worker Image (pull_request)"
  )
 fi

@@ -153,4 +150,4 @@ done

 echo
 echo "⏰ 快速检查超时（2分钟），CI尚未完成，退出等待下次触发（workflow_run事件或5分钟定时扫描）"
-exit 0
+exit 0
@@ -19,6 +19,18 @@ for arg in "$@"; do
  BUILD_ARGS="$BUILD_ARGS --build-arg $arg"
 done

+# Web 镜像 cache bust：计算 apps/web/ 的 git tree hash
+# 当源码变化时 hash 变化，buildx 的 ARG 缓存键失效 → vite build 必定重新执行
+if [ "${DOCKERFILE##*/}" = "web.Dockerfile" ]; then
+  SOURCE_HASH=$(git rev-parse HEAD:apps/web 2>/dev/null || echo "")
+  if [ -n "$SOURCE_HASH" ]; then
+    echo "Web cache bust: SOURCE_HASH=${SOURCE_HASH}"
+    BUILD_ARGS="$BUILD_ARGS --build-arg SOURCE_HASH=${SOURCE_HASH}"
+  else
+    echo "⚠️  无法计算 apps/web tree hash，跳过 cache bust"
+  fi
+fi
+
 BUILDER_NAME="ci-builder-persist"
 if ! docker buildx inspect "$BUILDER_NAME" > /dev/null 2>&1; then
  echo "持久 builder 不存在，创建中..."
@@ -31,6 +31,18 @@ for arg in "$@"; do
  BUILD_ARGS="$BUILD_ARGS --build-arg $arg"
 done

+# Web 镜像 cache bust：计算 apps/web/ 的 git tree hash
+# 当源码变化时 hash 变化，buildx 的 ARG 缓存键失效 → vite build 必定重新执行
+if [ "${DOCKERFILE##*/}" = "web.Dockerfile" ]; then
+  SOURCE_HASH=$(git rev-parse HEAD:apps/web 2>/dev/null || echo "")
+  if [ -n "$SOURCE_HASH" ]; then
+    echo "Web cache bust: SOURCE_HASH=${SOURCE_HASH}"
+    BUILD_ARGS="$BUILD_ARGS --build-arg SOURCE_HASH=${SOURCE_HASH}"
+  else
+    echo "⚠️  无法计算 apps/web tree hash，跳过 cache bust"
+  fi
+fi
+
 # 确保持久 builder 存在并使用（幂等）
 if ! docker buildx inspect "$BUILDER_NAME" > /dev/null 2>&1; then
  echo "持久 builder 不存在，创建中..."
@@ -4,6 +4,7 @@
 # - docker-container driver, host 网络
 # - 层缓存保存在 buildkit 容器及其 _state 命名卷中，job 结束不清理
 # - 宿主机 ci-docker-cleanup.sh 已豁免该 builder
+# - 每次执行自动同步宿主机 docker config 到 BuildKit 容器（确保 registry 认证）
 # 用法: bash scripts/ci/ensure_persistent_builder.sh
 set -eu

@@ -34,3 +35,26 @@ docker buildx use "$BUILDER"
 docker buildx inspect "$BUILDER" --bootstrap
 echo "✅ builder ready"
 docker buildx ls | head -5
+
+# === 同步宿主机 docker config 到 BuildKit 容器（确保 registry 认证） ===
+# BuildKit 容器名遵循 docker buildx 命名规则: buildx_buildkit_<builder-name>_0
+BUILDKIT_CONTAINER="buildx_buildkit_${BUILDER}_0"
+
+if docker inspect "$BUILDKIT_CONTAINER" >/dev/null 2>&1; then
+  # 宿主机 docker config 路径
+  HOST_DOCKER_CONFIG="/root/.docker/config.json"
+  
+  if [ -f "$HOST_DOCKER_CONFIG" ]; then
+    echo "=== 同步 docker config 到 BuildKit 容器 ==="
+    # 确保容器内 .docker 目录存在
+    docker exec "$BUILDKIT_CONTAINER" mkdir -p /root/.docker
+    # 拷贝 config.json
+    docker cp "$HOST_DOCKER_CONFIG" "$BUILDKIT_CONTAINER:/root/.docker/config.json"
+    echo "✅ docker config 已同步到 BuildKit 容器"
+  else
+    echo "⚠️ 宿主机 docker config 不存在: $HOST_DOCKER_CONFIG（跳过同步）"
+  fi
+else
+  echo "⚠️ BuildKit 容器不存在: $BUILDKIT_CONTAINER（跳过 config 同步）"
+fi
+
@@ -303,9 +303,10 @@ def main():
        "CI/CD Pipeline / CI Gate (pull_request)",
    ]
    REQUIRED_CONTEXTS_APPROVE = [
-        "CI/CD Pipeline / Validate - Code Quality (pull_request)",
-        "CI/CD Pipeline / Validate - Type Check (mypy) (pull_request)",
-        "CI/CD Pipeline / Validate - Migration (alembic) (pull_request)",
+        # CI 优化后 job 名称（2026-08）：Code Quality 拆分为 Style+Security，Type Check+Migration 合并为 Python
+        "CI/CD Pipeline / Validate - Style (pull_request)",
+        "CI/CD Pipeline / Validate - Security (pull_request)",
+        "CI/CD Pipeline / Validate - Python (mypy + alembic) (pull_request)",
        "CI/CD Pipeline / Frontend Lint (pull_request)",
    ]
    FRONTEND_ONLY_CONTEXT = [
@@ -197,8 +197,8 @@ if [ "$USE_SHARED_PG" = "true" ]; then
  # 创建主数据库（xdist 模式下各 worker 会创建自己的数据库，主库作为 fallback）
  echo "创建主测试数据库: $CI_DB_NAME"
  PGPASSWORD="$SHARED_PG_PASSWORD" python3 -c "
-import psycopg2
-conn = psycopg2.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
+import psycopg
+conn = psycopg.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
 conn.autocommit = True
 cur = conn.cursor()
 cur.execute(f'DROP DATABASE IF EXISTS \"$CI_DB_NAME\" WITH (FORCE)')
@@ -304,8 +304,8 @@ if [ "$USE_SHARED_PG" = "true" ]; then

  # 清理所有以 CI_DB_NAME 开头的数据库（主库 + worker 库）
  PGPASSWORD="${SHARED_PG_PASSWORD}" python3 -c "
-import psycopg2
-conn = psycopg2.connect(host='${SHARED_PG_HOST}', port=${SHARED_PG_PORT}, user='${SHARED_PG_USER}', password='${SHARED_PG_PASSWORD}', dbname='postgres')
+import psycopg
+conn = psycopg.connect(host='${SHARED_PG_HOST}', port=${SHARED_PG_PORT}, user='${SHARED_PG_USER}', password='${SHARED_PG_PASSWORD}', dbname='postgres')
 conn.autocommit = True
 cur = conn.cursor()

@@ -344,4 +344,4 @@ python3 scripts/ci_coverage_summary.py
 set -e

 echo ""
-echo "=== CI Integration Tests 全部通过 ✅ ==="
+echo "=== CI Integration Tests 全部通过 ✅ ==="
@@ -409,8 +409,8 @@ except:

    echo "创建测试数据库: $CI_DB_NAME"
    PGPASSWORD="$SHARED_PG_PASSWORD" python3 -c "
-import psycopg2
-conn = psycopg2.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
+import psycopg
+conn = psycopg.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
 conn.autocommit = True
 cur = conn.cursor()
 cur.execute(f'DROP DATABASE IF EXISTS \"$CI_DB_NAME\" WITH (FORCE)')
@@ -431,8 +431,8 @@ conn.close()
      # 清理数据库
      echo "清理测试数据库: $CI_DB_NAME"
      PGPASSWORD="$SHARED_PG_PASSWORD" python3 -c "
-import psycopg2
-conn = psycopg2.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
+import psycopg
+conn = psycopg.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
 conn.autocommit = True
 cur = conn.cursor()
 cur.execute(f'DROP DATABASE IF EXISTS \"$CI_DB_NAME\" WITH (FORCE)')
@@ -169,8 +169,8 @@ if [ "$USE_SHARED_PG" = "true" ]; then

  echo "创建测试数据库: $CI_DB_NAME"
  PGPASSWORD="$SHARED_PG_PASSWORD" python3 -c "
-import psycopg2
-conn = psycopg2.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
+import psycopg
+conn = psycopg.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
 conn.autocommit = True
 cur = conn.cursor()
 cur.execute(f'DROP DATABASE IF EXISTS \"$CI_DB_NAME\" WITH (FORCE)')
@@ -185,8 +185,8 @@ conn.close()
    echo ""
    echo "清理测试数据库: $CI_DB_NAME"
    PGPASSWORD="$SHARED_PG_PASSWORD" python3 -c "
-import psycopg2
-conn = psycopg2.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
+import psycopg
+conn = psycopg.connect(host='$SHARED_PG_HOST', port=$SHARED_PG_PORT, user='$SHARED_PG_USER', password='$SHARED_PG_PASSWORD', dbname='postgres')
 conn.autocommit = True
 cur = conn.cursor()
 cur.execute(f'DROP DATABASE IF EXISTS \"$CI_DB_NAME\" WITH (FORCE)')
@@ -8,7 +8,13 @@ echo "=== CI Validate: 安全扫描 ==="
 # --- 密钥检测 ---
 echo ""
 echo "=== [1/4] Secret detection (detect-secrets) ==="
-python3 -m pip install -q detect-secrets
+python3 -m pip install -q --no-cache-dir detect-secrets || {
+  echo "⚠️  detect-secrets install failed, retrying without cache..."
+  python3 -m pip install -q --no-cache-dir --no-binary :all: detect-secrets || {
+    echo "❌ detect-secrets install failed after retry"
+    exit 1
+  }
+}
 detect-secrets --version

 detect-secrets scan \
@@ -72,17 +78,27 @@ fi
 # --- Pip-audit 依赖漏洞扫描（仅告警）---
 echo ""
 echo "=== [3/4] Python dependency vulnerability scan (pip-audit, advisory only) ==="
-python3 -m pip install -q pip-audit
-pip-audit --version
-EXIT_CODE=0
-for req_file in requirements.txt requirements-base.txt requirements-dev.txt; do
-  if [ -f "$req_file" ]; then
-    echo "--- Scanning $req_file ---"
-    pip-audit -r "$req_file" --desc on 2>&1 | head -40 || EXIT_CODE=$?
-    echo ""
-  fi
-done
-echo "pip-audit scan completed (advisory mode - warnings only, not blocking CI)"
+python3 -m pip install -q --no-cache-dir pip-audit || {
+  echo "⚠️  pip-audit install failed (cache issue?), retrying..."
+  python3 -m pip install -q --no-cache-dir pip-audit || {
+    echo "⚠️  pip-audit unavailable, skipping dependency vulnerability scan (advisory)"
+    pip-audit --version 2>/dev/null || true
+  }
+}
+if command -v pip-audit >/dev/null 2>&1 || python3 -m pip show pip-audit >/dev/null 2>&1; then
+  pip-audit --version
+  EXIT_CODE=0
+  for req_file in requirements.txt requirements-base.txt requirements-dev.txt; do
+    if [ -f "$req_file" ]; then
+      echo "--- Scanning $req_file ---"
+      pip-audit -r "$req_file" --desc on 2>&1 | head -40 || EXIT_CODE=$?
+      echo ""
+    fi
+  done
+  echo "pip-audit scan completed (advisory mode - warnings only, not blocking CI)"
+else
+  echo "⚠️  pip-audit not available, skipping dependency vulnerability scan (advisory)"
+fi

 # --- CI脚本语法校验 ---
 echo ""
@@ -24,7 +24,7 @@ echo "✅ Code formatting checks passed"
 echo ""
 echo "=== [3/3] Dead code detection (vulture, advisory only) ==="
 set +e
-python3 -m pip install -q vulture
+python3 -m pip install -q --no-cache-dir vulture || echo "⚠️  vulture install failed, skipping dead code detection"
 vulture --version
 echo "告警模式，不阻断CI。置信度>=90%建议尽快确认。"
 echo ""
@@ -602,3 +602,148 @@ class TestFontsizeCompensation:
        result = build_ass_style("S", font_size=0)
        parts = result.split(",")
        assert int(parts[2]) >= 1
+
+
+# ── 标题自由位置拖拽（工单 #1405 方案 B）──────────────────────────────────────
+
+
+def _title_style_line(content: str) -> str:
+    return [line for line in content.splitlines() if line.startswith("Style: TitleStyle")][0]
+
+
+def _title_dialogue_line(content: str) -> str:
+    return [line for line in content.splitlines() if line.startswith("Dialogue:") and "TitleStyle" in line][0]
+
+
+class TestTitleFreePosition:
+    """pos_x/pos_y 合法时注入 \\pos 且 Alignment=5；非法/缺失时回退原逻辑。"""
+
+    def _base_kwargs(self):
+        return dict(
+            video_width=1080,
+            video_height=1920,
+            video_duration=8.0,
+            title_text="测试标题",
+        )
+
+    def test_valid_position_injects_pos_tag_and_alignment_5(self):
+        content = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "top", "size": 36, "pos_x": 540, "pos_y": 300},
+        )
+        # Dialogue 文本前注入 {\pos(540,300)}
+        dialogue = _title_dialogue_line(content)
+        assert "{\\pos(540,300)}" in dialogue
+        # TitleStyle Alignment 固定 5（\an5 中对齐，\pos 锚点为文本块中心）
+        fields = [f.strip() for f in _title_style_line(content).split(",")]
+        assert fields[18] == "5"
+
+    def test_boundary_coordinates_zero_and_max_accepted(self):
+        """边界值 0 和 video_width/video_height 合法（闭区间）。"""
+        content = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"pos_x": 0, "pos_y": 1920},
+        )
+        assert "{\\pos(0,1920)}" in _title_dialogue_line(content)
+
+        content2 = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"pos_x": 1080, "pos_y": 0},
+        )
+        assert "{\\pos(1080,0)}" in _title_dialogue_line(content2)
+
+    def test_no_coords_output_identical_to_before(self):
+        """不传坐标 → 输出与现有断言完全一致（回归保护）。"""
+        content = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "top", "size": 36},
+        )
+        # 无 \pos 注入
+        assert "\\pos(" not in content
+        # Alignment 走 position 映射（top → 8）
+        fields = [f.strip() for f in _title_style_line(content).split(",")]
+        assert fields[18] == "8"
+
+    def test_out_of_bounds_falls_back(self):
+        """越界坐标 → 回退 position 三档逻辑，输出与无坐标一致。"""
+        base = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "top", "size": 36},
+        )
+        for pos_x, pos_y in [(-1, 300), (540, -1), (1081, 300), (540, 1921), (99999, 99999)]:
+            content = build_ass_content(
+                **self._base_kwargs(),
+                title_config={"position": "top", "size": 36, "pos_x": pos_x, "pos_y": pos_y},
+            )
+            assert "\\pos(" not in content, f"({pos_x},{pos_y}) should be rejected"
+            assert content == base, f"({pos_x},{pos_y}) output differs from fallback"
+
+    def test_invalid_coords_falls_back(self):
+        """非法类型坐标 → 回退原逻辑。"""
+        base = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "top", "size": 36},
+        )
+        for pos_x, pos_y in [("abc", 300), (540, None), (None, None), (True, 300), (540, False), (540.5, 300.9)]:
+            content = build_ass_content(
+                **self._base_kwargs(),
+                title_config={"position": "top", "size": 36, "pos_x": pos_x, "pos_y": pos_y},
+            )
+            assert "\\pos(" not in content, f"({pos_x!r},{pos_y!r}) should be rejected"
+            assert content == base, f"({pos_x!r},{pos_y!r}) output differs from fallback"
+
+    def test_only_one_coord_falls_back(self):
+        """只传 pos_x 或 pos_y → 回退原逻辑。"""
+        base = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "center", "size": 36},
+        )
+        content_x = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "center", "size": 36, "pos_x": 540},
+        )
+        content_y = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"position": "center", "size": 36, "pos_y": 300},
+        )
+        assert content_x == base
+        assert content_y == base
+        assert "\\pos(" not in content_x
+        assert "\\pos(" not in content_y
+
+    def test_position_three_levels_unchanged_without_coords(self):
+        """无坐标时 top/center/bottom 三档 Alignment 输出不变。"""
+        for position, expected_align in [("top", "8"), ("center", "5"), ("bottom", "2")]:
+            content = build_ass_content(
+                **self._base_kwargs(),
+                title_config={"position": position, "size": 36},
+            )
+            fields = [f.strip() for f in _title_style_line(content).split(",")]
+            assert fields[18] == expected_align
+
+    def test_pos_overrides_position_alignment(self):
+        """有合法坐标时，无论 position 是什么，Alignment 都固定为 5。"""
+        for position in ["top", "center", "bottom"]:
+            content = build_ass_content(
+                **self._base_kwargs(),
+                title_config={"position": position, "size": 36, "pos_x": 100, "pos_y": 200},
+            )
+            fields = [f.strip() for f in _title_style_line(content).split(",")]
+            assert fields[18] == "5"
+            assert "{\\pos(100,200)}" in _title_dialogue_line(content)
+
+    def test_subtitle_not_affected_by_pos(self):
+        """pos_x/pos_y 只影响 Title，Subtitle 输出不变。"""
+        content = build_ass_content(
+            **self._base_kwargs(),
+            title_config={"pos_x": 540, "pos_y": 300},
+            subtitle_text="配音字幕",
+            subtitle_config={"position": "bottom", "size": 24},
+        )
+        sub_style = [line for line in content.splitlines() if line.startswith("Style: SubtitleStyle")][0]
+        sub_fields = [f.strip() for f in sub_style.split(",")]
+        assert sub_fields[18] == "2"  # bottom
+        sub_dialogue = [
+            line for line in content.splitlines() if line.startswith("Dialogue:") and "SubtitleStyle" in line
+        ][0]
+        assert "\\pos(" not in sub_dialogue
@@ -395,11 +395,13 @@ class TestSmartMatchFiltersExhausted:
        # 返回的素材全部 usable=True
        assert all(item.usable for item in resp.items)

-    def test_all_exhausted_returns_empty(self):
-        """全部素材已用尽时返回空列表（不报错，前端显示空结果）。"""
+    def test_all_exhausted_falls_back_to_all(self):
+        """全部素材已用尽时回退保留全部（不返回空——空结果会让前端回退全选，
+        反而绕过评分排序；耗尽素材仍可走复用区间）。"""
        assets = [_exhausted_asset("a-ex-1"), _exhausted_asset("a-ex-2")]
        resp = self._call(assets)
-        assert resp.items == []
+        returned_ids = {item.id for item in resp.items}
+        assert returned_ids == {"a-ex-1", "a-ex-2"}
        assert resp.total_candidates == 2

    def test_fresh_assets_all_returned(self):
@@ -0,0 +1,152 @@
+"""测试 create_video_record_and_dedup 传递 user_id 到查重逻辑.
+
+验证 P0 修复：查重范围从项目级扩大到用户级。
+dedup_helpers 必须把 user_id 传给 compute_duplicate_rate。
+"""
+
+from __future__ import annotations
+
+import sys
+from pathlib import Path
+from unittest.mock import MagicMock, patch
+
+import pytest
+
+# Mock cv2/numpy before imports
+sys.modules.setdefault("cv2", MagicMock())
+sys.modules.setdefault("numpy", MagicMock())
+
+ROOT = Path(__file__).resolve().parents[2]
+sys.path.insert(0, str(ROOT / "apps" / "api"))
+sys.path.insert(0, str(ROOT / "packages"))
+sys.path.insert(0, str(ROOT / "apps" / "worker"))
+
+import os
+
+os.environ.setdefault("JWT_SECRET_KEY", "unit-test-secret")
+os.environ.setdefault("DATABASE_URL", "sqlite:///test.db")
+
+
+class TestDedupHelpersUserIdPassthrough:
+    """验证 dedup_helpers 把 user_id 传递给 compute_duplicate_rate."""
+
+    def test_user_id_passed_to_compute_duplicate_rate(self):
+        """create_video_record_and_dedup 必须传 user_id 给 compute_duplicate_rate."""
+        from video_processing.dedup_helpers import create_video_record_and_dedup
+
+        session = MagicMock()
+        mock_video_repo = MagicMock()
+
+        mock_fingerprint = MagicMock()
+        mock_fingerprint.to_dict.return_value = {"md5": "test", "keyframe_phashes": ["aa"]}
+
+        mock_deduplicator = MagicMock()
+        mock_deduplicator.compute_fingerprint.return_value = mock_fingerprint
+        mock_deduplicator.check_duplicate.return_value = None
+        mock_deduplicator.compute_duplicate_rate.return_value = 42.5
+
+        with (
+            patch(
+                "packages.adapters.sqlalchemy_impl.generated_video_repository.SQLAlchemyGeneratedVideoRepository",
+                return_value=mock_video_repo,
+            ),
+            patch("video_processing.dedup.VideoDeduplicator", return_value=mock_deduplicator),
+        ):
+            result = create_video_record_and_dedup(
+                generation_task_id="task-001",
+                project_id="proj-001",
+                user_id="user-abc",
+                batch_id="",
+                file_url="https://example.com/video.mp4",
+                file_size=1024,
+                duration=15.0,
+                video_path="/tmp/fake_video.mp4",
+                mode="smart",
+                session=session,
+            )
+
+        # 验证 compute_duplicate_rate 被调用且 user_id 正确传递
+        mock_deduplicator.compute_duplicate_rate.assert_called_once()
+        call_kwargs = mock_deduplicator.compute_duplicate_rate.call_args
+        assert (
+            call_kwargs.kwargs.get("user_id") == "user-abc"
+        ), f"user_id 应传递给 compute_duplicate_rate，实际: {call_kwargs}"
+
+    def test_empty_user_id_still_works(self):
+        """user_id 为空时仍然正常执行（回退到 project 级比较）."""
+        from video_processing.dedup_helpers import create_video_record_and_dedup
+
+        session = MagicMock()
+        mock_video_repo = MagicMock()
+
+        mock_fingerprint = MagicMock()
+        mock_fingerprint.to_dict.return_value = {"md5": "test"}
+
+        mock_deduplicator = MagicMock()
+        mock_deduplicator.compute_fingerprint.return_value = mock_fingerprint
+        mock_deduplicator.check_duplicate.return_value = None
+        mock_deduplicator.compute_duplicate_rate.return_value = 0.0
+
+        with (
+            patch(
+                "packages.adapters.sqlalchemy_impl.generated_video_repository.SQLAlchemyGeneratedVideoRepository",
+                return_value=mock_video_repo,
+            ),
+            patch("video_processing.dedup.VideoDeduplicator", return_value=mock_deduplicator),
+        ):
+            result = create_video_record_and_dedup(
+                generation_task_id="task-002",
+                project_id="proj-002",
+                user_id="",
+                batch_id="",
+                file_url="https://example.com/video.mp4",
+                file_size=1024,
+                duration=10.0,
+                video_path="/tmp/fake.mp4",
+                mode="smart",
+                session=session,
+            )
+
+        mock_deduplicator.compute_duplicate_rate.assert_called_once()
+        call_kwargs = mock_deduplicator.compute_duplicate_rate.call_args
+        assert call_kwargs.kwargs.get("user_id") == ""
+
+    def test_duplicate_rate_saved_to_video_record(self):
+        """compute_duplicate_rate 的返回值应写入 generated_video.duplicate_rate."""
+        from video_processing.dedup_helpers import create_video_record_and_dedup
+
+        session = MagicMock()
+        mock_video_repo = MagicMock()
+
+        mock_fingerprint = MagicMock()
+        mock_fingerprint.to_dict.return_value = {"md5": "test"}
+
+        mock_deduplicator = MagicMock()
+        mock_deduplicator.compute_fingerprint.return_value = mock_fingerprint
+        mock_deduplicator.check_duplicate.return_value = None
+        mock_deduplicator.compute_duplicate_rate.return_value = 78.5
+
+        with (
+            patch(
+                "packages.adapters.sqlalchemy_impl.generated_video_repository.SQLAlchemyGeneratedVideoRepository",
+                return_value=mock_video_repo,
+            ),
+            patch("video_processing.dedup.VideoDeduplicator", return_value=mock_deduplicator),
+        ):
+            result = create_video_record_and_dedup(
+                generation_task_id="task-003",
+                project_id="proj-003",
+                user_id="user-xyz",
+                batch_id="",
+                file_url="https://example.com/v.mp4",
+                file_size=2048,
+                duration=20.0,
+                video_path="/tmp/fake2.mp4",
+                mode="smart",
+                session=session,
+            )
+
+        # 验证 update 被调用（包含 duplicate_rate 的记录）
+        mock_video_repo.update.assert_called_once()
+        updated_video = mock_video_repo.update.call_args[0][0]
+        assert updated_video.duplicate_rate == 78.5
@@ -56,9 +56,10 @@ class TestComputeDuplicateRate:

        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
            mock_repo = MockRepo.return_value
-            session.query.return_value.filter.return_value.order_by.return_value.limit.return_value.all.return_value = (
-                []
-            )
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock
+            query_mock.order_by.return_value.limit.return_value.all.return_value = []
+            session.query.return_value = query_mock
            rate = deduplicator.compute_duplicate_rate(fingerprint, "proj1", "vid1", session)

        assert rate == 0.0
@@ -73,7 +74,6 @@ class TestComputeDuplicateRate:
        session = MagicMock()

        existing = self._make_existing_video("existing1", {"md5": "exact_match_md5", "keyframe_phashes": ["aa"]})
-        # Create a mock model with the domain attributes
        mock_model = MagicMock(spec=GeneratedVideoModel)
        mock_model.id = existing.id
        mock_model.project_id = existing.project_id
@@ -83,10 +83,12 @@ class TestComputeDuplicateRate:
        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
            mock_repo = MockRepo.return_value
            mock_repo._to_domain.return_value = existing
-            # Mock the session.query chain
-            session.query.return_value.filter.return_value.order_by.return_value.limit.return_value.all.return_value = [
-                mock_model
-            ]
+            # 链式 filter: 第一次 scope filter，第二次 self-exclusion filter
+            # 让 filter() 返回的对象仍然支持 order_by() 链
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock  # filter → filter chainable
+            query_mock.order_by.return_value.limit.return_value.all.return_value = [mock_model]
+            session.query.return_value = query_mock
            rate = deduplicator.compute_duplicate_rate(fingerprint, "proj1", "vid1", session)

        assert rate == 100.0
@@ -113,9 +115,10 @@ class TestComputeDuplicateRate:
        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
            mock_repo = MockRepo.return_value
            mock_repo._to_domain.return_value = existing
-            session.query.return_value.filter.return_value.order_by.return_value.limit.return_value.all.return_value = [
-                mock_model
-            ]
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock
+            query_mock.order_by.return_value.limit.return_value.all.return_value = [mock_model]
+            session.query.return_value = query_mock
            rate = deduplicator.compute_duplicate_rate(fingerprint, "proj1", "vid1", session)

        # hamming distance = 2, similarity = (1 - 2/64) * 100 = 96.875
@@ -140,9 +143,10 @@ class TestComputeDuplicateRate:
        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
            mock_repo = MockRepo.return_value
            mock_repo._to_domain.return_value = self_video
-            session.query.return_value.filter.return_value.order_by.return_value.limit.return_value.all.return_value = [
-                mock_model
-            ]
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock
+            query_mock.order_by.return_value.limit.return_value.all.return_value = [mock_model]
+            session.query.return_value = query_mock
            rate = deduplicator.compute_duplicate_rate(fingerprint, "proj1", "vid1", session)

        assert rate == 0.0
@@ -172,15 +176,89 @@ class TestComputeDuplicateRate:
        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
            mock_repo = MockRepo.return_value
            mock_repo._to_domain.side_effect = [existing1, existing2]
-            session.query.return_value.filter.return_value.order_by.return_value.limit.return_value.all.return_value = [
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock
+            query_mock.order_by.return_value.limit.return_value.all.return_value = [
                mock_model1,
                mock_model2,
            ]
+            session.query.return_value = query_mock
            rate = deduplicator.compute_duplicate_rate(fingerprint, "proj1", "vid1", session)

        # max similarity: e2 distance=1, (1-1/64)*100 = 98.4375
        assert rate == pytest.approx(98.44, abs=0.1)

+    def test_user_id_scope_cross_project(self):
+        """传 user_id 时应跨项目查询，而非仅当前项目."""
+        from video_processing.dedup import VideoDeduplicator
+
+        from packages.adapters.sqlalchemy_impl.models import GeneratedVideoModel
+
+        deduplicator = VideoDeduplicator()
+        fingerprint = self._make_fingerprint(md5="cross_proj_md5")
+        session = MagicMock()
+
+        # 模拟一个不同项目但同一用户的视频
+        existing = self._make_existing_video(
+            "existing_other_proj", {"md5": "cross_proj_md5", "keyframe_phashes": ["aa"]}
+        )
+        existing.project_id = "proj2"  # 不同项目
+        existing.user_id = "user1"
+
+        mock_model = MagicMock(spec=GeneratedVideoModel)
+        mock_model.id = existing.id
+        mock_model.project_id = existing.project_id
+        mock_model.user_id = existing.user_id
+        mock_model.video_fingerprint = existing.video_fingerprint
+        mock_model.generated_at = "2026-01-01"
+
+        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
+            mock_repo = MockRepo.return_value
+            mock_repo._to_domain.return_value = existing
+
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock
+            query_mock.order_by.return_value.limit.return_value.all.return_value = [mock_model]
+            session.query.return_value = query_mock
+
+            rate = deduplicator.compute_duplicate_rate(
+                fingerprint,
+                "proj1",
+                "vid1",
+                session,
+                user_id="user1",
+            )
+
+        # 应通过 user_id 过滤，且匹配到跨项目视频
+        assert rate == 100.0
+
+    def test_user_id_empty_falls_back_to_project(self):
+        """user_id 为空时应回退到 project_id 过滤."""
+        from video_processing.dedup import VideoDeduplicator
+
+        deduplicator = VideoDeduplicator()
+        fingerprint = self._make_fingerprint()
+        session = MagicMock()
+
+        with patch("video_processing.dedup.SQLAlchemyGeneratedVideoRepository") as MockRepo:
+            mock_repo = MockRepo.return_value
+            query_mock = MagicMock()
+            query_mock.filter.return_value = query_mock
+            query_mock.order_by.return_value.limit.return_value.all.return_value = []
+            session.query.return_value = query_mock
+
+            rate = deduplicator.compute_duplicate_rate(
+                fingerprint,
+                "proj1",
+                "vid1",
+                session,
+                user_id="",
+            )
+
+        assert rate == 0.0
+        # 验证使用的是 project_id 过滤（回退路径）
+        # 通过检查 filter 被调用时的参数来间接验证
+

 class TestDuplicateRateAPI:
    """Test that duplicate_rate is returned in API responses."""
@@ -0,0 +1,243 @@
+"""_get_template_segments 回退路径测试.
+
+验证三级回退链：
+1. 新模板系统（tpl_svc.list_clip_configs）正常 → 直接返回
+2. 新模板系统主表不存在（ValueError）→ 直接查 template_clip_configs 表兜底
+3. 直接查表也失败 → 回退旧模板系统（template_segments）
+4. 全部失败 → 返回空列表
+
+覆盖 P0 修复：自建模板在 edit_templates 主表不存在但在 template_clip_configs 有记录时，
+from-assets 流程不再 400。
+"""
+
+from __future__ import annotations
+
+import os
+import sys
+from pathlib import Path
+from unittest.mock import MagicMock, PropertyMock
+
+os.environ.setdefault("JWT_SECRET_KEY", "unit-test-secret-key-for-testing")
+os.environ.setdefault("DATABASE_URL", "sqlite:///test.db")
+
+sys.path.insert(0, str(Path(__file__).resolve().parents[2] / "apps" / "api"))
+
+from app.api.routes.templates_editor.clips import _get_template_segments
+
+TEST_TEMPLATE_ID = "tmpl-orphan-001"
+DEFAULT_DUR = 5.0  # _DEFAULT_EDITOR_CLIP_DURATION
+
+
+def _make_clip_config(order: int, min_dur: float = 3.0, max_dur: float = 8.0):
+    """构造 mock TemplateClipConfig 领域实体."""
+    cc = MagicMock()
+    cc.order = order
+    cc.min_duration = min_dur
+    cc.max_duration = max_dur
+    return cc
+
+
+def _make_old_segment(segment_order: int, dur_min: float = 4.0, dur_max: float = 7.0):
+    """构造 mock 旧 TemplateSegment."""
+    s = MagicMock()
+    s.segment_order = segment_order
+    s.duration_min = dur_min
+    s.duration_max = dur_max
+    return s
+
+
+# ---------------------------------------------------------------------------
+# 测试
+# ---------------------------------------------------------------------------
+
+
+class TestGetTemplateSegmentsFallback:
+    """_get_template_segments 三级回退链."""
+
+    def test_new_system_works(self):
+        """路径1：新模板系统正常返回 → 直接使用."""
+        configs = [_make_clip_config(0, 2.0, 6.0), _make_clip_config(1, 3.0, 9.0)]
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.return_value = configs
+        db = MagicMock()
+
+        result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        assert len(result) == 2
+        assert result[0] == (0, 2.0, 6.0)
+        assert result[1] == (1, 3.0, 9.0)
+        tpl_svc.list_clip_configs.assert_called_once_with(TEST_TEMPLATE_ID)
+
+    def test_main_table_missing_direct_query_succeeds(self):
+        """路径2（P0修复）：主表不存在 ValueError → 直接查表成功.
+
+        模拟自建模板在 edit_templates 主表已删除/不存在，
+        但 template_clip_configs 表有记录。
+        """
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.side_effect = ValueError(f"模板不存在: {TEST_TEMPLATE_ID}")
+        db = MagicMock()
+
+        # Mock SQLAlchemyTemplateClipConfigRepository
+        direct_configs = [
+            _make_clip_config(0, 2.0, 5.0),
+            _make_clip_config(1, 3.0, 7.0),
+            _make_clip_config(2, 4.0, 8.0),
+        ]
+        with (
+            __import__("unittest.mock", fromlist=["patch"]).patch(
+                "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+            ) as mock_repo_cls,
+        ):
+            mock_repo = MagicMock()
+            mock_repo.list_by_template.return_value = direct_configs
+            mock_repo_cls.return_value = mock_repo
+
+            result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        assert len(result) == 3
+        assert result[0] == (0, 2.0, 5.0)
+        assert result[1] == (1, 3.0, 7.0)
+        assert result[2] == (2, 4.0, 8.0)
+        mock_repo.list_by_template.assert_called_once_with(TEST_TEMPLATE_ID)
+
+    def test_main_table_missing_direct_query_empty_falls_to_old(self):
+        """路径2→3：主表不存在 + 直接查表为空 → 回退旧系统."""
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.side_effect = ValueError("模板不存在")
+        db = MagicMock()
+
+        old_segments = [_make_old_segment(0, 3.0, 6.0)]
+
+        with __import__("unittest.mock", fromlist=["patch"]).patch(
+            "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+        ) as mock_repo_cls:
+            mock_repo = MagicMock()
+            mock_repo.list_by_template.return_value = []  # 新表也没记录
+            mock_repo_cls.return_value = mock_repo
+
+            with __import__("unittest.mock", fromlist=["patch"]).patch(
+                "app.api.routes.templates_editor.clips.SQLAlchemyTemplateRepository"
+            ) as mock_old_cls:
+                mock_old = MagicMock()
+                mock_old.list_segments.return_value = old_segments
+                mock_old_cls.return_value = mock_old
+
+                result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        assert len(result) == 1
+        assert result[0] == (0, 3.0, 6.0)
+
+    def test_all_fail_returns_empty(self):
+        """路径4：三级全部失败 → 返回空列表."""
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.side_effect = ValueError("模板不存在")
+        db = MagicMock()
+
+        with __import__("unittest.mock", fromlist=["patch"]).patch(
+            "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+        ) as mock_repo_cls:
+            mock_repo = MagicMock()
+            mock_repo.list_by_template.side_effect = Exception("DB error")
+            mock_repo_cls.return_value = mock_repo
+
+            with __import__("unittest.mock", fromlist=["patch"]).patch(
+                "app.api.routes.templates_editor.clips.SQLAlchemyTemplateRepository"
+            ) as mock_old_cls:
+                mock_old = MagicMock()
+                mock_old.list_segments.return_value = []  # 旧表也空
+                mock_old_cls.return_value = mock_old
+
+                result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        assert result == []
+
+    def test_direct_query_sorts_by_order(self):
+        """直接查表返回的结果按 order 排序."""
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.side_effect = ValueError("模板不存在")
+        db = MagicMock()
+
+        # 故意乱序
+        configs = [
+            _make_clip_config(2, 5.0, 10.0),
+            _make_clip_config(0, 2.0, 4.0),
+            _make_clip_config(1, 3.0, 6.0),
+        ]
+
+        with __import__("unittest.mock", fromlist=["patch"]).patch(
+            "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+        ) as mock_repo_cls:
+            mock_repo = MagicMock()
+            mock_repo.list_by_template.return_value = configs
+            mock_repo_cls.return_value = mock_repo
+
+            result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        assert [r[0] for r in result] == [0, 1, 2]
+        assert result[0] == (0, 2.0, 4.0)
+        assert result[1] == (1, 3.0, 6.0)
+        assert result[2] == (2, 5.0, 10.0)
+
+    def test_direct_query_handles_none_durations(self):
+        """直接查表时 min/max_duration 为 None → 使用默认值."""
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.side_effect = ValueError("模板不存在")
+        db = MagicMock()
+
+        cc = MagicMock()
+        cc.order = 0
+        cc.min_duration = None
+        cc.max_duration = None
+
+        with __import__("unittest.mock", fromlist=["patch"]).patch(
+            "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+        ) as mock_repo_cls:
+            mock_repo = MagicMock()
+            mock_repo.list_by_template.return_value = [cc]
+            mock_repo_cls.return_value = mock_repo
+
+            result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        assert len(result) == 1
+        # None → default (5.0), max(None or None) → default (5.0)
+        assert result[0] == (0, DEFAULT_DUR, DEFAULT_DUR)
+
+    def test_new_system_returns_empty_tries_direct(self):
+        """新模板系统返回空列表（非异常）→ 继续尝试直接查表."""
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.return_value = []  # 空列表，非异常
+        db = MagicMock()
+
+        direct_configs = [_make_clip_config(0, 3.0, 6.0)]
+
+        with __import__("unittest.mock", fromlist=["patch"]).patch(
+            "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+        ) as mock_repo_cls:
+            mock_repo = MagicMock()
+            mock_repo.list_by_template.return_value = direct_configs
+            mock_repo_cls.return_value = mock_repo
+
+            result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+
+        # 新系统返回空 → 不走 except → 但也没 return → 继续往下走
+        # 直接查表有数据 → 返回
+        assert len(result) == 1
+        assert result[0] == (0, 3.0, 6.0)
+
+    def test_existing_template_unaffected(self):
+        """正常模板（主表存在）行为不变."""
+        configs = [_make_clip_config(0, 2.0, 5.0)]
+        tpl_svc = MagicMock()
+        tpl_svc.list_clip_configs.return_value = configs
+        db = MagicMock()
+
+        with __import__("unittest.mock", fromlist=["patch"]).patch(
+            "app.api.routes.templates_editor.clips.SQLAlchemyTemplateClipConfigRepository"
+        ) as mock_repo_cls:
+            result = _get_template_segments(TEST_TEMPLATE_ID, tpl_svc, db)
+            # 直接查表不应被调用（新系统已返回）
+            mock_repo_cls.assert_not_called()
+
+        assert len(result) == 1
+        assert result[0] == (0, 2.0, 5.0)
@@ -0,0 +1,258 @@
+"""smart-match 过滤回退策略测试：余量过滤/高频排除导致结果集为空时必须回退。
+
+线上事故：路由旧实现先 smart_select_assets(limit=N) 截取，再对这 N 条做
+usable / 高频过滤，过滤后不回补——排名靠前素材全部被排除时返回空 items，
+前端回退全选。修复后过滤全部前置，且每级过滤后为空/不足时回退保留。
+"""
+
+import json
+import os
+import sys
+from pathlib import Path
+from unittest.mock import MagicMock
+
+os.environ.setdefault("JWT_SECRET_KEY", "unit-test-secret-key-for-testing")
+os.environ.setdefault("DATABASE_URL", "sqlite:///test.db")
+
+import pytest
+from fastapi import FastAPI
+from fastapi.testclient import TestClient
+
+ROOT = Path(__file__).resolve().parents[2]
+sys.path.insert(0, str(ROOT / "apps" / "api"))
+sys.path.insert(0, str(ROOT / "packages"))
+
+from app.api.routes.assets import router
+from app.auth import AuthenticatedUser, get_current_user
+from app.core.storage import get_storage_service
+from app.dependencies import (
+    get_asset_library_repository,
+    get_asset_repository,
+    get_project_repository,
+)
+
+from packages.domain import (
+    Asset,
+    AssetLibrary,
+    AssetLibraryKind,
+    AssetStatus,
+    Project,
+    User,
+)
+
+
+class _StubProjectRepo:
+    def __init__(self, projects):
+        self._projects = projects
+
+    def find_by_id(self, pid):
+        return self._projects.get(pid)
+
+
+class _StubAssetLibraryRepo:
+    def __init__(self, libraries):
+        self._libraries = libraries
+
+    def get(self, lid):
+        return self._libraries.get(lid)
+
+
+class _StubAssetRepo:
+    """模拟仓储；session 属性供 get_asset_recent_use_counts 使用（测试中会被 patch）。"""
+
+    def __init__(self, assets):
+        self._assets = assets
+        self.session = MagicMock(name="stub-session")
+
+    def find_by_library(self, lid, skip=0, limit=100, status=None):
+        result = [a for a in self._assets if a.library_id == lid]
+        if status:
+            result = [a for a in result if (a.status.value if hasattr(a.status, "value") else a.status) in status]
+        return result[skip : skip + limit]
+
+    def find_by_library_and_file_type(self, lid, file_type, skip=0, limit=100, status=None):
+        result = [a for a in self._assets if a.library_id == lid and a.file_type == file_type]
+        if status:
+            result = [a for a in result if (a.status.value if hasattr(a.status, "value") else a.status) in status]
+        return result[skip : skip + limit]
+
+
+def _make_app(asset_repo, lib_repo, proj_repo):
+    app = FastAPI()
+    app.include_router(router, prefix="/assets")
+    fake_user = MagicMock()
+    fake_user.user = User(id="user-1", email="test@test.com", display_name="Test")
+    app.dependency_overrides[get_current_user] = lambda: AuthenticatedUser(user=fake_user.user)
+    app.dependency_overrides[get_asset_repository] = lambda: asset_repo
+    app.dependency_overrides[get_asset_library_repository] = lambda: lib_repo
+    app.dependency_overrides[get_project_repository] = lambda: proj_repo
+    app.dependency_overrides[get_storage_service] = lambda: MagicMock()
+    return app
+
+
+def _library():
+    return AssetLibrary(id="lib-1", project_id="proj-1", name="Videos", kind=AssetLibraryKind.VIDEO)
+
+
+def _exhausted_ranges(duration=15.0):
+    """构造 used_time_ranges：整片覆盖 + 每区间 use_count 达上限 3 → usable=False。"""
+    return [
+        {"start": 0.0, "end": duration, "use_count": 3, "plan_id": "p1"},
+    ]
+
+
+def _video_asset(name, duration=15.0, quality=90, used_ranges=None):
+    meta = {"used_time_ranges": used_ranges} if used_ranges is not None else {}
+    return Asset.create(
+        project_id="proj-1",
+        library_id="lib-1",
+        name=name,
+        storage_key=f"key-{name}",
+        mime_type="video/mp4",
+        metadata=meta,
+        quality_score=quality,
+        duration=duration,
+        status=AssetStatus.READY,
+    )
+
+
+class TestSmartMatchAvailabilityFallback:
+    """余量过滤回退：全部素材 usable=False 时不返回空。"""
+
+    def test_all_exhausted_returns_assets_instead_of_empty(self):
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [
+            _video_asset("v1.mp4", used_ranges=_exhausted_ranges(15)),
+            _video_asset("v2.mp4", used_ranges=_exhausted_ranges(25)),
+        ]
+        repo = _StubAssetRepo(assets)
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1"})
+        assert resp.status_code == 200, resp.text
+        data = resp.json()
+        # 回退：保留全部候选，不返回空
+        assert len(data["items"]) == 2
+        assert data["total_candidates"] == 2
+
+    def test_mixed_exhausted_and_fresh_excludes_exhausted(self):
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [
+            _video_asset("exhausted.mp4", quality=99, used_ranges=_exhausted_ranges(15)),
+            _video_asset("fresh.mp4", quality=50, used_ranges=None),
+        ]
+        repo = _StubAssetRepo(assets)
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1"})
+        assert resp.status_code == 200, resp.text
+        names = [item["name"] for item in resp.json()["items"]]
+        assert "fresh.mp4" in names
+        assert "exhausted.mp4" not in names
+
+    def test_limit_backfills_from_lower_ranked_when_top_exhausted(self):
+        """limit=1 且排名第一的素材耗尽时，必须回补排名靠后的可用素材，不返回空。"""
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [
+            _video_asset("top-exhausted.mp4", quality=100, used_ranges=_exhausted_ranges(15)),
+            _video_asset("second-fresh.mp4", quality=40, used_ranges=None),
+            _video_asset("third-fresh.mp4", quality=30, used_ranges=None),
+        ]
+        repo = _StubAssetRepo(assets)
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1", "limit": 1})
+        assert resp.status_code == 200, resp.text
+        data = resp.json()
+        assert len(data["items"]) == 1
+        # 不能是空，也不能是耗尽的高分素材
+        assert data["items"][0]["name"] == "second-fresh.mp4"
+
+
+class TestSmartMatchHighFreqFallback:
+    """高频排除回退：排除后为空/不足 limit 时保留全部可用素材。"""
+
+    def test_all_high_freq_keeps_all(self, monkeypatch):
+        import app.api.routes.assets as routes_mod
+
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [_video_asset("v1.mp4", quality=90), _video_asset("v2.mp4", quality=80)]
+        repo = _StubAssetRepo(assets)
+
+        # 全部素材在最近 5 个视频中使用 5 次（> 3）
+        fake_counts = {assets[0].id: 5, assets[1].id: 5}
+        monkeypatch.setattr(
+            routes_mod, "get_asset_recent_use_counts", lambda db, asset_ids, recent_video_count=5: fake_counts
+        )
+
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1"})
+        assert resp.status_code == 200, resp.text
+        data = resp.json()
+        # 全部高频 → 回退保留全部
+        assert len(data["items"]) == 2
+
+    def test_high_freq_partial_exclusion_with_enough_remaining(self, monkeypatch):
+        import app.api.routes.assets as routes_mod
+
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [
+            _video_asset("hot.mp4", quality=99),
+            _video_asset("cool1.mp4", quality=80),
+            _video_asset("cool2.mp4", quality=70),
+        ]
+        repo = _StubAssetRepo(assets)
+        fake_counts = {assets[0].id: 9, assets[1].id: 1, assets[2].id: 0}
+        monkeypatch.setattr(
+            routes_mod, "get_asset_recent_use_counts", lambda db, asset_ids, recent_video_count=5: fake_counts
+        )
+
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1"})
+        assert resp.status_code == 200, resp.text
+        names = [item["name"] for item in resp.json()["items"]]
+        assert "hot.mp4" not in names
+        assert set(names) == {"cool1.mp4", "cool2.mp4"}
+
+    def test_high_freq_insufficient_for_limit_keeps_all(self, monkeypatch):
+        """3 个素材、limit=5、2 个高频 → 剩余 1 < limit → 保留全部。"""
+        import app.api.routes.assets as routes_mod
+
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [
+            _video_asset("hot1.mp4", quality=99),
+            _video_asset("hot2.mp4", quality=98),
+            _video_asset("cool.mp4", quality=50),
+        ]
+        repo = _StubAssetRepo(assets)
+        fake_counts = {assets[0].id: 8, assets[1].id: 7, assets[2].id: 0}
+        monkeypatch.setattr(
+            routes_mod, "get_asset_recent_use_counts", lambda db, asset_ids, recent_video_count=5: fake_counts
+        )
+
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1", "limit": 5})
+        assert resp.status_code == 200, resp.text
+        names = [item["name"] for item in resp.json()["items"]]
+        # 剩余 1 < limit=5 → 回退保留全部 3 条
+        assert set(names) == {"hot1.mp4", "hot2.mp4", "cool.mp4"}
+
+    def test_high_freq_query_failure_skips_exclusion(self, monkeypatch):
+        import app.api.routes.assets as routes_mod
+
+        def _boom(db, asset_ids, recent_video_count=5):
+            raise RuntimeError("DB down")
+
+        project = Project(id="proj-1", name="Test", owner_user_id="user-1")
+        assets = [_video_asset("v1.mp4", quality=90), _video_asset("v2.mp4", quality=80)]
+        repo = _StubAssetRepo(assets)
+        monkeypatch.setattr(routes_mod, "get_asset_recent_use_counts", _boom)
+
+        app = _make_app(repo, _StubAssetLibraryRepo({"lib-1": _library()}), _StubProjectRepo({"proj-1": project}))
+        with TestClient(app) as client:
+            resp = client.post("/assets/smart-match", json={"library_id": "lib-1"})
+        assert resp.status_code == 200, resp.text
+        assert len(resp.json()["items"]) == 2
@@ -0,0 +1,209 @@
+"""统一模板 segments 数据源单元测试。
+
+验证 template_repository 从 template_clip_configs 读取 segments，
+写入走 template_clip_configs，回退兼容 template_segments。
+"""
+
+from __future__ import annotations
+
+import sys
+import uuid
+from pathlib import Path
+
+sys.path.insert(0, str(Path(__file__).resolve().parents[2] / "apps" / "api"))
+
+import pytest
+from sqlalchemy import create_engine
+from sqlalchemy.orm import sessionmaker
+
+from packages.adapters.sqlalchemy_impl.models import (
+    Base,
+    TemplateClipConfigModel,
+    TemplateModel,
+    TemplateSegmentModel,
+)
+from packages.adapters.sqlalchemy_impl.template_repository import (
+    SQLAlchemyTemplateRepository,
+)
+from packages.domain.template import Template, TemplateSegment
+
+
+@pytest.fixture()
+def session():
+    engine = create_engine("sqlite:///:memory:")
+    Base.metadata.create_all(engine)
+    Session = sessionmaker(bind=engine)
+    s = Session()
+    try:
+        yield s
+    finally:
+        s.close()
+
+
+@pytest.fixture()
+def repo(session):
+    return SQLAlchemyTemplateRepository(session)
+
+
+def _make_template(template_id=None, user_id="u1", name="测试模板", mode="one_take"):
+    tid = template_id or str(uuid.uuid4())
+    return Template(
+        id=tid,
+        user_id=user_id,
+        name=name,
+        mode=mode,
+        category="",
+        tags=[],
+        estimated_duration=30.0,
+        is_active=True,
+        segments=[],
+    )
+
+
+def _make_segment(template_id, order=1, material_type=None):
+    return TemplateSegment(
+        id=str(uuid.uuid4()),
+        template_id=template_id,
+        segment_order=order,
+        duration_min=5.0,
+        duration_max=10.0,
+        material_type=material_type,
+    )
+
+
+class TestCreateSegments:
+    def test_writes_to_clip_configs(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1)
+        repo.create_segments([seg])
+        clips = session.query(TemplateClipConfigModel).filter(TemplateClipConfigModel.template_id == tpl.id).all()
+        assert len(clips) == 1
+        assert clips[0].clip_type == "main"
+        assert clips[0].order == 1
+        assert clips[0].min_duration == 5.0
+
+    def test_material_type_stored_in_config(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1, material_type="voiceover")
+        repo.create_segments([seg])
+        clip = session.query(TemplateClipConfigModel).filter(TemplateClipConfigModel.template_id == tpl.id).first()
+        assert clip.config["material_type"] == "voiceover"
+
+
+class TestListSegments:
+    def test_reads_from_clip_configs(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1, material_type="voiceover")
+        repo.create_segments([seg])
+        result = repo.list_segments(tpl.id)
+        assert len(result) == 1
+        assert result[0].material_type == "voiceover"
+
+    def test_fallback_to_old_table(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        old = TemplateSegmentModel(
+            id=str(uuid.uuid4()),
+            template_id=tpl.id,
+            segment_order=1,
+            duration_min=3.0,
+            duration_max=8.0,
+            material_type="场景",
+        )
+        session.add(old)
+        session.commit()
+        result = repo.list_segments(tpl.id)
+        assert len(result) == 1
+        assert result[0].material_type == "场景"
+
+    def test_clip_configs_takes_priority(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1)
+        repo.create_segments([seg])
+        old = TemplateSegmentModel(
+            id=str(uuid.uuid4()), template_id=tpl.id, segment_order=1, duration_min=1.0, duration_max=2.0
+        )
+        session.add(old)
+        session.commit()
+        result = repo.list_segments(tpl.id)
+        assert len(result) == 1
+        assert result[0].duration_min == 5.0
+
+
+class TestListByUser:
+    def test_batch_loads_from_clip_configs(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1, material_type="人物")
+        repo.create_segments([seg])
+        result = repo.list_by_user("u1")
+        assert len(result) == 1
+        assert len(result[0].segments) == 1
+        assert result[0].segments[0].material_type == "人物"
+
+    def test_fallback_for_old_data(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        old = TemplateSegmentModel(
+            id=str(uuid.uuid4()), template_id=tpl.id, segment_order=1, duration_min=2.0, duration_max=6.0
+        )
+        session.add(old)
+        session.commit()
+        result = repo.list_by_user("u1")
+        assert len(result) == 1
+        assert len(result[0].segments) == 1
+        assert result[0].segments[0].duration_min == 2.0
+
+
+class TestCopyTemplate:
+    def test_copy_writes_to_clip_configs(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1, material_type="voiceover")
+        repo.create_segments([seg])
+        copied = repo.copy_template(tpl.id, "u1", "副本模板")
+        assert copied.id != tpl.id
+        clips = session.query(TemplateClipConfigModel).filter(TemplateClipConfigModel.template_id == copied.id).all()
+        assert len(clips) == 1
+        assert clips[0].config["material_type"] == "voiceover"
+
+    def test_copy_empty_segments(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        copied = repo.copy_template(tpl.id, "u1", "空副本")
+        assert len(copied.segments) == 0
+
+
+class TestDelete:
+    def test_delete_cleans_both_tables(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1)
+        repo.create_segments([seg])
+        old = TemplateSegmentModel(
+            id=str(uuid.uuid4()), template_id=tpl.id, segment_order=1, duration_min=1.0, duration_max=2.0
+        )
+        session.add(old)
+        session.commit()
+        repo.delete(tpl.id, "u1")
+        c1 = session.query(TemplateClipConfigModel).filter(TemplateClipConfigModel.template_id == tpl.id).count()
+        c2 = session.query(TemplateSegmentModel).filter(TemplateSegmentModel.template_id == tpl.id).count()
+        assert c1 == 0
+        assert c2 == 0
+
+    def test_delete_segments_by_template(self, repo, session):
+        tpl = _make_template()
+        repo.create(tpl)
+        seg = _make_segment(tpl.id, order=1)
+        repo.create_segments([seg])
+        old = TemplateSegmentModel(
+            id=str(uuid.uuid4()), template_id=tpl.id, segment_order=2, duration_min=1.0, duration_max=2.0
+        )
+        session.add(old)
+        session.commit()
+        count = repo.delete_segments_by_template(tpl.id)
+        assert count == 2