xiaoxia/xiaoxia-saas
1
0
Fork 0
Code Issues 8 Pull Requests 1 Actions Packages Projects Releases 7 Wiki Activity

feat(clips): EditorClipResponse 增加 asset_url 签名URL字段 #1403

Closed
xiaoxia wants to merge 1 commits from feat/clips-asset-url into develop
pull from: feat/clips-asset-url
merge into: xiaoxia:develop
Conversation 1 Commits 1 Files Changed 2
+65 -3
xiaoxia commented 2026-08-17 14:20:00 +08:00
Owner
Copy Link
Copy Source

改动说明

扩展模板编辑器 clips API，返回素材视频签名URL，为前端 CSS 预览播放器提供播放能力。

修改文件

文件 改动
apps/api/app/api/routes/templates_editor/schemas.py EditorClipResponse 新增 asset_url: str | None 字段
apps/api/app/api/routes/templates_editor/clips.py GET /clips 和 GET /clips/{clip_id} 批量查询素材 storage_key 生成签名URL

新增字段

{
  "id": "clip-xxx",
  "plan_id": "plan-xxx",
  "clip_type": "main",
  "order": 0,
  "duration": 5.0,
  "asset_url": "https://oss.xxx.com/...?Expires=...",
  ...
}
  • asset_url: 素材视频签名URL，有效期1小时
  • 如果 asset_id 不存在或生成失败，返回 null
  • 不影响现有字段

技术实现

  • 使用现有 StorageService.get_download_url() 生成 OSS 签名URL
  • 使用 AssetRepository.find_by_id() 查询素材 storage_key
  • 列表接口批量查询，避免 N+1 问题
  • 异常安全：任何失败只记录日志，返回 null

验证

  • CI 全绿后合并
  • 等待前端 PR 合并后联调验证
## 改动说明 扩展模板编辑器 clips API，返回素材视频签名URL，为前端 CSS 预览播放器提供播放能力。 ## 修改文件 | 文件 | 改动 | |------|------| | `apps/api/app/api/routes/templates_editor/schemas.py` | `EditorClipResponse` 新增 `asset_url: str \| None` 字段 | | `apps/api/app/api/routes/templates_editor/clips.py` | `GET /clips` 和 `GET /clips/{clip_id}` 批量查询素材 storage_key 生成签名URL | ## 新增字段 ```json { "id": "clip-xxx", "plan_id": "plan-xxx", "clip_type": "main", "order": 0, "duration": 5.0, "asset_url": "https://oss.xxx.com/...?Expires=...", ... } ``` - `asset_url`: 素材视频签名URL，有效期1小时 - 如果 asset_id 不存在或生成失败，返回 `null` - 不影响现有字段 ## 技术实现 - 使用现有 `StorageService.get_download_url()` 生成 OSS 签名URL - 使用 `AssetRepository.find_by_id()` 查询素材 storage_key - 列表接口批量查询，避免 N+1 问题 - 异常安全：任何失败只记录日志，返回 null ## 验证 - CI 全绿后合并 - 等待前端 PR 合并后联调验证
xiaoxia added 1 commit 2026-08-17 14:20:01 +08:00
feat(clips): EditorClipResponse 增加 asset_url 签名URL字段
CI/CD Pipeline / Check if frontend-only change (pull_request) Failing after 0s
Details
CI/CD Pipeline / Validate - Code Quality (pull_request) Failing after 0s
Details
CI/CD Pipeline / Validate - Type Check (mypy) (pull_request) Failing after 0s
Details
CI/CD Pipeline / Validate - Migration (alembic) (pull_request) Failing after 0s
Details
CI/CD Pipeline / Build Staging API Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Staging Web Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Staging Worker Image (pull_request) Has been skipped
Details
AI Code Review / AI Code Review (pull_request) Failing after 0s
Details
PR Automation / Auto Merge on CI Green + Approved (pull_request) Failing after 0s
Details
Preview Deploy / Deploy Preview Environment (pull_request) Failing after 0s
Details
CI/CD Pipeline / Unit Tests (pull_request) Failing after 0s
Details
CI/CD Pipeline / Frontend Lint (pull_request) Has been skipped
Details
CI/CD Pipeline / Frontend Unit Tests (pull_request) Failing after 0s
Details
CI/CD Pipeline / PR Build API Image (pull_request) Has been skipped
Details
CI/CD Pipeline / PR Build Web Image (pull_request) Has been skipped
Details
CI/CD Pipeline / PR Build Worker Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Integration Tests (pull_request) Failing after 0s
Details
CI/CD Pipeline / Deploy Staging (Watchtower auto-deploy) (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Production API Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Production Web Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Production Worker Image (pull_request) Has been skipped
Details
CI/CD Pipeline / CI Gate (pull_request) Failing after 0s
Details
CI/CD Pipeline / Staging E2E Tests (pull_request) Has been skipped
Details
CI/CD Pipeline / Staging API Integration Tests (pull_request) Has been skipped
Details
CI/CD Pipeline / ACR Image Cleanup (pull_request) Has been skipped
Details
CI/CD Pipeline / Deploy Production (pull_request) Has been skipped
Details
CI/CD Pipeline / Canary Release to Production (pull_request) Has been skipped
Details
CI/CD Pipeline / Production Browser E2E (pull_request) Has been skipped
Details
PR Automation / Auto Approve on CI Green (pull_request) Successful in 3m18s
Details
ACR Cleanup / ACR Image Cleanup (pull_request_target) Successful in 42s
Details
Preview Cleanup / Cleanup Preview Environment (pull_request) Successful in 57s
Details
36630d3828 
- EditorClipResponse 新增 asset_url: str | None 字段
- GET /clips 列表接口批量查询素材 storage_key 生成签名URL
- GET /clips/{clip_id} 详情接口同样返回 asset_url
- 签名URL有效期1小时，失败时返回null不影响其他字段
- 为前端CSS预览播放器提供素材视频播放能力
xiaoxia closed this pull request 2026-08-17 14:43:25 +08:00
gitea-actions bot commented 2026-08-17 14:44:21 +08:00
Copy Link
Copy Source

🗑️ 预览环境已清理

PR #1403 已关闭或合并，对应的预览环境已被清理。

如有需要，可以重新打开 PR 来重新生成预览环境。

🗑️ **预览环境已清理** PR #1403 已关闭或合并，对应的预览环境已被清理。 > 如有需要，可以重新打开 PR 来重新生成预览环境。
Some required checks failed
CI/CD Pipeline / Check if frontend-only change (pull_request) Failing after 0s
Details
CI/CD Pipeline / Validate - Code Quality (pull_request) Failing after 0s
Details
CI/CD Pipeline / Validate - Type Check (mypy) (pull_request) Failing after 0s
Details
CI/CD Pipeline / Validate - Migration (alembic) (pull_request) Failing after 0s
Details
CI/CD Pipeline / Build Staging API Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Staging Web Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Staging Worker Image (pull_request) Has been skipped
Details
AI Code Review / AI Code Review (pull_request) Failing after 0s
Required
Details
PR Automation / Auto Merge on CI Green + Approved (pull_request) Failing after 0s
Details
Preview Deploy / Deploy Preview Environment (pull_request) Failing after 0s
Details
CI/CD Pipeline / Unit Tests (pull_request) Failing after 0s
Details
CI/CD Pipeline / Frontend Lint (pull_request) Has been skipped
Details
CI/CD Pipeline / Frontend Unit Tests (pull_request) Failing after 0s
Details
CI/CD Pipeline / PR Build API Image (pull_request) Has been skipped
Details
CI/CD Pipeline / PR Build Web Image (pull_request) Has been skipped
Details
CI/CD Pipeline / PR Build Worker Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Integration Tests (pull_request) Failing after 0s
Details
CI/CD Pipeline / Deploy Staging (Watchtower auto-deploy) (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Production API Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Production Web Image (pull_request) Has been skipped
Details
CI/CD Pipeline / Build Production Worker Image (pull_request) Has been skipped
Details
CI/CD Pipeline / CI Gate (pull_request) Failing after 0s
Required
Details
CI/CD Pipeline / Staging E2E Tests (pull_request) Has been skipped
Details
CI/CD Pipeline / Staging API Integration Tests (pull_request) Has been skipped
Details
CI/CD Pipeline / ACR Image Cleanup (pull_request) Has been skipped
Details
CI/CD Pipeline / Deploy Production (pull_request) Has been skipped
Details
CI/CD Pipeline / Canary Release to Production (pull_request) Has been skipped
Details
CI/CD Pipeline / Production Browser E2E (pull_request) Has been skipped
Details
PR Automation / Auto Approve on CI Green (pull_request) Successful in 3m18s
Details
ACR Cleanup / ACR Image Cleanup (pull_request_target) Successful in 42s
Details
Preview Cleanup / Cleanup Preview Environment (pull_request) Successful in 57s
Details

Pull request closed

Please reopen this pull request to perform a merge.
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
Clear labels
P0
阻塞性，必须立即处理
 P1
高优先级
 P2
中优先级
 P3
低优先级/后考虑
 architecture
架构设计
 backend
后端相关
 blocked
阻塞中
 bug
Bug修复
 ci-bug
CI本身的bug
 ci-optimization
CI优化类任务
 ci-pipeline
CI流水线/workflow相关
 cleanup
代码清理
 devops
运维/部署/CI
 documentation
文档相关
 feature
新功能
 frontend
前端相关
 question
需要讨论确认
 ready
PR CI通过，可合并
 refactor
代码重构
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
auto-approve-bot xiaoxia
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: xiaoxia/xiaoxia-saas#1403
Delete Branch "feat/clips-asset-url"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?