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

fix(P0): 成片库download_url签名修复 + 删除接口补齐 #531

Merged
auto-approve-bot merged 1 commits from fix/p0-video-sign-url-and-delete into develop 2026-07-18 18:23:01 +08:00
Conversation 3 Commits 1 Files Changed 5
+104 -4
xiaoxia commented 2026-07-18 18:17:21 +08:00
Owner
Copy Link
Copy Source

改动

1. 成片库 download_url 签名修复（#529）

根因：_normalize_storage_key 从 URL 提取 path 后未做 URL 解码，导致路径中含 URL 编码字符（如 %20、%XX 等）时，sign_url 用编码后的 key 计算签名，与 OSS 服务端不一致 → SignatureDoesNotMatch。

修复：packages/shared/storage.py 中 _normalize_storage_key 对 URL path 增加 unquote() 解码，与素材库直接传原始 key 的行为一致。

2. 成片库删除接口补齐

  • DELETE /videos/{id}：单个成片硬删除，同步删除 OSS 文件（失败不阻断）
  • POST /videos/batch-delete：批量删除，返回 success_count + failed_ids
  • Repository 层新增 delete() 和 batch_delete() 方法

影响范围：5 个文件，+104/-4

## 改动 ### 1. 成片库 download_url 签名修复（#529） **根因**：`_normalize_storage_key` 从 URL 提取 path 后未做 URL 解码，导致路径中含 URL 编码字符（如 %20、%XX 等）时，`sign_url` 用编码后的 key 计算签名，与 OSS 服务端不一致 → `SignatureDoesNotMatch`。 **修复**：`packages/shared/storage.py` 中 `_normalize_storage_key` 对 URL path 增加 `unquote()` 解码，与素材库直接传原始 key 的行为一致。 ### 2. 成片库删除接口补齐 - `DELETE /videos/{id}`：单个成片硬删除，同步删除 OSS 文件（失败不阻断） - `POST /videos/batch-delete`：批量删除，返回 success_count + failed_ids - Repository 层新增 `delete()` 和 `batch_delete()` 方法 **影响范围**：5 个文件，+104/-4
xiaoxia added the bugbackendP0 labels 2026-07-18 18:17:21 +08:00
xiaoxia added 1 commit 2026-07-18 18:17:21 +08:00
fix(P0): 成片库download_url签名修复 + 删除接口补齐
CI Build & Deploy Pipeline / Build Staging API Image (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Build Staging Web Image (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Build Staging Worker Image (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Deploy Staging (Watchtower auto-deploy) (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Build Production API Image (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Build Production Web Image (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Build Production Worker Image (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Staging API Integration Tests (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Deploy Production (pull_request) Has been skipped
Details
CI Build & Deploy Pipeline / Production Browser E2E (pull_request) Has been skipped
Details
Preview Deploy / Deploy Preview Environment (pull_request) Failing after 16s
Details
CI/CD Pipeline / Check if frontend-only change (pull_request) Successful in 21s
Details
AI Code Review / AI Code Review (pull_request) Failing after 32s
Details
CI/CD Pipeline / Frontend Lint (pull_request) Successful in 1m5s
Details
CI/CD Pipeline / Validate Code Quality And Tests (pull_request) Successful in 2m4s
Details
CI/CD Pipeline / Integration Tests (pull_request) Successful in 1m30s
Details
CI/CD Pipeline / Unit Tests (pull_request) Successful in 2m54s
Details
Auto Approve CI PRs / Auto Approve on CI Green (pull_request) Successful in 5m37s
Details
Auto Merge CI PRs / Auto Merge on CI Green + Approved (pull_request) Successful in 5m40s
Details
Preview Cleanup / Cleanup Preview Environment (pull_request) Successful in 36s
Details
CI Build & Deploy Pipeline / Staging E2E Tests (pull_request) Failing after 12m15s
Details
287ffad2a8 
- _normalize_storage_key对URL路径做unquote解码，修复URL编码字符导致SignatureDoesNotMatch
- 新增DELETE /videos/{id} 单个成片删除
- 新增POST /videos/batch-delete 批量删除
- 同步删除OSS视频文件，失败不阻断DB删除
auto-approve-bot approved these changes 2026-07-18 18:22:59 +08:00
auto-approve-bot left a comment
Collaborator
Copy Link
Copy Source

CI全绿，自动审批通过。

CI全绿，自动审批通过。
auto-approve-bot approved these changes 2026-07-18 18:22:59 +08:00
auto-approve-bot left a comment
Collaborator
Copy Link
Copy Source

CI全绿，自动审批通过。

CI全绿，自动审批通过。
auto-approve-bot merged commit 40cb1ab8f3 into develop 2026-07-18 18:23:01 +08:00
auto-approve-bot deleted branch fix/p0-video-sign-url-and-delete 2026-07-18 18:23:01 +08:00
gitea-actions bot commented 2026-07-18 18:23:37 +08:00
Copy Link
Copy Source

🗑️ 预览环境已清理

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

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

🗑️ **预览环境已清理** PR #531 已关闭或合并，对应的预览环境已被清理。 > 如有需要，可以重新打开 PR 来重新生成预览环境。
Sign in to join this conversation.
Reviewers
No Reviewers
auto-approve-bot
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 P0 backend bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
auto-approve-bot xiaoxia
No Assignees
3 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: xiaoxia/xiaoxia-saas#531
Delete Branch "fix/p0-video-sign-url-and-delete"

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?