video-accessibility/backend/app/migrations/scripts
Vadym Samoilenko 290d5e32e6 fix: 7 caption/AD quality bugs + retranslation error handling
Bug fixes:
- Bug 1a: source_has_ad flag prevents AI generating AD over existing professional AD;
  JobBrief/Job models, gemini service prompt conditional, NewBrief UI checkbox
- Bug 1b: disable native textTracks on video element to prevent double captions
- Bug 2: caption ALL audible speech including off-screen narrators (prompt fix)
- Bug 3: DCMP §6.01 disfluency removal for EN/ES/FR/DE/IT (prompt + post-pass)
- Bug 4: VTT cue settings (line:0%, position:) preserved through parser round-trip
- Bug 5: Whisper word-level timestamp alignment via new caption_aligner service
- Bug 6: assert_cue_alignment used .start/.end; renamed to .start_time/.end_time
- New migration: backfill source_has_ad=False on existing jobs and job_briefs

Also fix retranslation error handling to preserve existing GCS URIs on failure
so video_native captions remain accessible if retranslation fails.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-07 15:38:20 +01:00
..
migration_2025-08-17-120000_initial_schema.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2025-08-17-120001_index_optimization.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2025-08-17-120002_audit_log_schema_update.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2025-10-10-000000_add_auth_provider.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2025-10-10-000001_update_user_schema_validator.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2025-12-22-000000_add_approved_source_status.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2025-12-27-000000_add_rendering_video_status.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2026-01-05-000000_add_failed_statuses.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2026-01-11-000000_add_rendering_qc_status.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2026-04-16-000000_add_linguist_role.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2026-04-27-000000_add_project_manager_role.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2026-04-28-000000_create_memberships_collection.py feat(saas): Phase 0+1 — Organization/Membership entities and dev branch 2026-04-27 16:46:24 +01:00
migration_2026-04-28-000001_backfill_memberships.py chore: push all session changes — backend hardening, tests, apache config, deploy scripts 2026-04-30 15:52:14 +01:00
migration_2026-04-28-000002_create_invitations_collection.py feat(saas): Phase 2 — invitation flow, email templates, MS SSO zero-membership 2026-04-27 16:52:08 +01:00
migration_2026-04-28-000003_backfill_job_organization_id.py feat(saas): Phase 3 — membership-based authz + Mailgun + job.organization_id 2026-04-27 16:56:42 +01:00
migration_2026-04-29-000000_add_processing_failed_status_and_indexes.py fix(migrations): replace relative imports with absolute in PR-7 migrations 2026-04-29 22:05:32 +01:00
migration_2026-04-29-000001_create_job_briefs_collection.py fix(migrations): replace relative imports with absolute in PR-7 migrations 2026-04-29 22:05:32 +01:00
migration_2026-04-30-000000_backfill_membership_team_ids.py fix(security): close MT-17/18/19, restore cross-tenant tests, quick wins 2026-04-30 10:32:23 +01:00
migration_2026-04-30-000001_add_cancelled_status.py fix(tts): fetch job_doc before gcs_path call in _generate_language_tts; add cancelled migration 2026-04-30 20:36:03 +01:00
migration_2026-04-30-000002_fix_status_enum.py fix(migrations): correct listCollections cursor parsing, add processing_failed+cancelled to status enum 2026-04-30 20:47:21 +01:00
migration_2026-05-08-000000_add_source_has_ad.py fix: 7 caption/AD quality bugs + retranslation error handling 2026-05-07 15:38:20 +01:00