33 Commits

Author	SHA1	Message	Date
xiaoxia	153b38a62f	feat: 封面模板 CRUD API (#1323) ... Co-authored-by: xiaoxia <dev@xiaoxiajianji.com> Co-committed-by: xiaoxia <dev@xiaoxiajianji.com>	2026-08-09 18:26:00 +08:00
CI Bot	e9d2831850	feat(ci): mypy upgrade to hard gate + fix type errors	2026-07-16 07:59:07 +08:00
CI Bot	9c6c477f55	fix(backend): Phase 1 后端代码清理与修复 ... P0 关键修复: - P0-1: 注册接口添加 RateLimitMiddleware 限流保护 - P0-3: /metrics 端点添加 JWT 认证（移除匿名访问） - P0-4: 修复 Celery 任务名冲突（generation_task vs generate_video） - P1-5: JWT logout token 黑名单机制 P1 修复: - P1-1: forgot_password 硬编码 localhost → 使用 settings.APP_BASE_URL - P1-2: generation.py 直接创建 DB 连接 → 使用依赖注入 - P1-6: Image.open() 未关闭 → 统一使用 with 语句 - P1-7: 订阅续费事务修复 P2 代码质量: - P2-1: 修复 EditingMode 枚举重复定义 → 统一引用 shared 包 - P2-2: 修复 SMTP_FRON_NAME → SMTP_FROM_NAME 拼写 - P2-3: UserModel subscription_quota 类型统一为 float - P2-4: .env.production DATABASE_MAX_OVERFLOW 30 → 10 - 清理 15 处 except:pass（保留 2 处有注释说明的） - 禁用 SVG 上传（XSS 风险） - 删除 decode_token_unsafe() 不安全函数 - 简化 /ready 端点 - 删除 8 处死代码、10 个空文件/模块 - 合并 3 对 100% 重复函数 - 对齐 6 个废弃环境变量 v2 修复（代码审查后）: - 修复密码重置路由路径: /password/forgot → /forgot-password, /password/reset → /reset-password（与前端 API 对齐） - 合并 _check_project_access: asset_libraries.py 和 edit_plans.py 中的重复函数统一到 _helpers.py（含空字符串守卫 + 中文错误信息） - 顺手修复: HTTPException 统一从 fastapi 导入（替换 starlette 导入） - OSS_ENDPOINT 拼写修复拆分为单独 PR，本 PR 不包含	2026-07-13 13:50:52 +08:00
xiaoxia	841a168d30	feat: 所有API返回的音频URL加OSS预签名（24小时有效期） ... 合并PR #216：给所有API返回的音频URL加OSS预签名 修复私有bucket下TTS合成音频、音色克隆参考音频、配音库音频等返回403的问题。	2026-07-11 11:07:51 +08:00
xiaoxia	3db13fc1da	fix: CosyVoice全量重写 - 适配DashScope百炼API (#212)	2026-07-10 22:52:21 +08:00
灵应	b0f2e4712a	feat: P3 配音模块标签体系 — 标签 CRUD + 素材打标 + tag_ids 筛选 ... - 新增 Tag 领域实体 + TagModel/AssetTagModel ORM 模型 - Alembic 迁移 030：tags 表 + asset_tags 关联表 - TagRepository 端口 + SQLAlchemy/InMemory 实现 - Asset.tag_ids 多对多关联替代原 JSON tags - GET /tags / POST /tags / DELETE /tags/{tag_id} 标签 CRUD - POST /assets/{asset_id}/tags 打标 / DELETE 取消标签 - GET /assets 新增 tag_ids 筛选参数（逗号分隔，取交集） - 19 个单元测试全部通过	2026-07-07 11:58:27 +08:00
灵应	5ca3bbab31	fix: 修复flake8代码质量检查错误	2026-07-03 19:24:17 +08:00
灵应	24ac12167c	feat(task-308): 音色克隆完整流程实现 ... - CosyVoiceService: 新增 submit_clone_task() 和 check_task_status() 非阻塞方法 - VoiceCloneWorkflowService: 编排层，处理 start_clone/process_result/process_failure/retry - Celery 任务 process_voice_clone: 异步轮询 CosyVoice 克隆结果 - API 路由: 创建后触发 Celery 异步任务，支持重试 - 57 个单元测试全部通过（workflow 14 + task 6 + cosyvoice 37）	2026-07-02 12:46:44 +08:00
CI Test	43366f290c	feat: 实现任务2.10 JobService — 异步任务管理 ... - 新增 Job 领域模型（状态机、JobType/JobStatus 枚举） - 新增 JobRepository 端口 + SQLAlchemy 实现 - 新增 10 个 Use Cases（CreateJob/Submit/Progress/Complete/Fail/Retry/Cancel/Get/List/Statistics） - 新增 JobService 服务层，集成 VideoComposeService - 新增 Pydantic schemas + RESTful API 路由 - 新增 Celery compose_video 任务（含进度追踪） - 新增数据库迁移 018（jobs 表） - 新增 44 个单元测试，全部通过 - 修复状态转换：允许 pending→success（快速完成场景）	2026-07-01 22:54:21 +08:00
xiaoxia	560856cf22	fix: resolve all flake8 errors and apply Prettier formatting (#131)	2026-06-30 18:26:53 +08:00
xiaoxia	1217d8cef0	style: apply isort formatting to pass CI validation (#129)	2026-06-30 18:17:44 +08:00
xiaoxia	52ff2f80ad	style: apply black formatting to pass CI validation (#126)	2026-06-30 17:23:08 +08:00
API文档维护Agent	312dad7497	feat: Phase 2 查重后端 API 实现 ... 六边形架构分层实现： Domain 层: - DuplicationRecord / DuplicateSegment 实体 - 状态机生命周期 (pending→processing→completed/failed) Ports 层: - DuplicationRecordRepository Protocol Adapters 层: - SQLAlchemyDuplicationRecordRepository 完整实现 - DuplicationRecordModel / DuplicationSegmentModel ORM 模型 Application 层: - UploadForDuplicationUseCase (上传查重) - ListDuplicationRecordsUseCase (记录列表) - GetDuplicationDetailUseCase (详情查询) - DeleteDuplicationRecordUseCase (删除) - RetryDuplicationUseCase (重新查重) API 层: - POST /api/v1/duplication/upload (上传视频查重) - GET /api/v1/duplication/records (记录列表) - GET /api/v1/duplication/records/{id} (详情含片段) - DELETE /api/v1/duplication/records/{id} (删除) - POST /api/v1/duplication/records/{id}/retry (重新查重) Alembic 迁移: - 011_add_duplication_tables.py (duplication_records + duplication_segments) API 契约与前端 feat/phase2-duplication-ui (PR#75) 完全对齐。 Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>	2026-06-28 16:12:46 +08:00
API文档维护Agent	a43ddb4b63	feat: Phase 1 - 核心重构（去Project层/标题库API/配音库API/清理废弃代码） ... ## 主要变更 ### 1. 清理废弃代码（18个文件删除） - 删除 TaskModel/MilestoneModel/TaskIssueModel 及相关文件 - 删除 ProjectTitleModel/EditPlanModel/EditPlanClipModel 及相关文件 - 清理 domain/ports/adapters/application/api 各层引用 - 从 GenerationTaskModel 移除 edit_plan_id 字段 ### 2. 新建标题库 API（/api/v1/titles） - Domain: TitleLibraryItem 数据类 - Ports: TitleLibraryRepository 接口 - Adapters: SQLAlchemy 实现（软删除） - Application: CRUD Use Cases + 配额检查（max_titles: free=50, basic=500, premium=500） - API: GET/POST/PUT/DELETE 端点 - Schema: Pydantic 请求/响应模型 ### 3. 新建配音库 API（/api/v1/voices） - Domain: VoiceLibraryItem 数据类 - Ports: VoiceLibraryRepository 接口 - Adapters: SQLAlchemy 实现（软删除） - Application: CRUD Use Cases + 配额检查（max_voiceovers: free=10, basic=100, premium=100） - API: GET/POST/PUT/DELETE 端点 - Schema: Pydantic 请求/响应模型 ### 4. 去掉 Project 层依赖 - 修复 authenticated_user.id → authenticated_user.user.id bug - asset_libraries.py: project_id 改为可选查询参数 - generated_videos.py: project_id 改为可选查询参数 - 无 project_id 时通过 find_accessible_projects 获取用户可访问的所有项目 ### 5. 数据库迁移 - 创建 011_phase1_core_refactor.py - 删除 6 个废弃表：tasks, milestones, task_issues, project_titles, edit_plans, edit_plan_clips - 从 generation_tasks 表删除 edit_plan_id 列 ### 6. 其他改进 - 迁移 EditingMode 到独立模块 packages/domain/editing_mode.py - 注册 titles_router 和 voices_router - 添加 get_title_library_repository 和 get_voice_library_repository 依赖 - 更新 domain/ports __init__.py 导出新实体和仓储接口 ## 技术细节 - 遵循六边形架构模式 - 配额检查通过 QuotaRegistry 实现 - 软删除：标题库用 is_active=False，配音库用 status='deleted' - 配音库支持可选的 project_id 关联 ## 破坏性变更 - 删除 6 个废弃表（需先备份数据） - 删除 /api/v1/edit-plans, /api/v1/project-titles, /api/v1/project-management 端点 - generation_tasks API 不再包含 edit_plan_id 字段	2026-06-28 15:02:10 +08:00
API文档维护Agent	e3fb518ab2	refactor: remove all workspace_id references from codebase ... - Remove workspace_id from Pydantic models in project_management routes - Remove workspace_id from SQLAlchemy and SQLite project management repos - Remove workspace_id from worker tasks (storage keys, entity creation) - Remove workspace_id from video dedup and title usage modules - Remove workspace_id from generation and ingest worker tasks - Clean workspace_id from all test files and scripts - Remove workspace-specific test files (list_workspaces, workspace repos) Task: #14 workspace_id 残留清理	2026-06-27 22:52:09 +08:00
xiaoxia	d1833d0bd4	fix: 修复 ENABLE_REDIS_SESSION 变量名不匹配导致登录500 (#58) ... Co-authored-by: xiaoxia-dev <dev@xiaoxiajianji.com> Co-committed-by: xiaoxia-dev <dev@xiaoxiajianji.com>	2026-06-27 19:52:35 +08:00
xiaoxia	388aafbab0	fix: correct ENABLE_REDIS_SESSIONS typo to ENABLE_REDIS_SESSION	2026-06-27 14:45:50 +08:00
xiaoxia	394637d1eb	fix: P2-4 add complete type annotations to dependencies	2026-06-26 17:58:25 +08:00
Xiaoxia AI	6b66601d67	feat(titles): add project title library	2026-06-24 00:30:58 +08:00
Xiaoxia AI	3594cc1216	refactor(auth): configure external service adapters	2026-06-21 11:04:07 +08:00
Xiaoxia AI	27ea04264f	feat(workspace): restore member management routes	2026-06-21 09:36:08 +08:00
Xiaoxia AI	383151efcb	feat(workspace): restore core routes on sqlalchemy adapters	2026-06-21 09:22:09 +08:00
Xiaoxia AI	93271f7dda	refactor(auth): route simple auth through use cases	2026-06-21 08:22:49 +08:00
Xiaoxia AI	bfbaddbd9a	style: normalize python formatting gates	2026-06-21 06:52:19 +08:00
Xiaoxia AI	758c2c7e13	feat(phase7): align asset flow and scaffold generation pipeline	2026-06-18 19:59:37 +08:00
Xiaoxia AI	8d78798a7d	fix(phase7): align api runtime wiring for integration	2026-06-17 18:48:08 +08:00
Xiaoxia AI	db1ebc4e9d	feat(phase7): add asset classification workflow	2026-06-17 18:29:48 +08:00
Xiaoxia AI	ab954991b9	feat(repository): add PostgreSQL WorkspaceInvitation repository ... - Implement PostgresWorkspaceInvitationRepository with full CRUD - Support find_by_token, find_by_email, find_pending_by_email - Auto-select implementation based on USE_IN_MEMORY_DB config - Update DependencyContainer to support both InMemory and PostgreSQL - Complete all PostgreSQL repository implementations Phase 4 Task 38/68 completed	2026-06-17 08:32:24 +08:00
Xiaoxia AI	015fe3d507	feat(config): add database switch between InMemory and PostgreSQL ... - Add USE_IN_MEMORY_DB config flag - Auto-select repository implementation based on config - InMemory: for development and testing (no setup needed) - PostgreSQL: for production (persistent data) - Update DependencyContainer to support both - Add documentation for switching databases - Update .env.example with new config Phase 4 Task 36/68 completed	2026-06-17 08:25:20 +08:00
Xiaoxia AI	0abfc98be0	feat(api): add dependency injection container and auth middleware ... - Implement DependencyContainer for all repositories and use cases - Create singleton pattern for repository instances - Factory methods for all use cases (auth + workspace) - Auth middleware: get_current_user with JWT verification - Permission middleware: require_workspace_access/admin/owner - Support optional authentication (get_current_user_optional) - Integrate with PermissionChecker and QuotaChecker Phase 4 Task 25/68 completed	2026-06-17 07:30:09 +08:00
Xiaoxia AI	9fe0614d43	feat: add deployment configs, systemd service, and tracker init scripts	2026-06-16 22:01:24 +08:00
Xiaoxia AI	f0ee5c6184	feat: persist ingest flow in postgres	2026-06-15 19:34:47 +08:00
Xiaoxia AI	b5a62ee9a3	feat: initial SaaS scaffold ... - domain: User, Workspace, Project, AssetLibrary, Asset, IngestJob - ports: repository interfaces - application: use cases - adapters: in-memory - API: FastAPI 5 routes - worker: Celery ingest_asset - tests: 4 passing	2026-06-15 15:17:40 +08:00