File size: 4,361 Bytes
30d7573
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
"""
One-off: replace the old 4 free voices (Rachel/Bill/Alice/Daniel) with the new 4
(Kristen/Hale/Samara X/Connor) in every existing user's saved_voices rows.

This is the saved_voices counterpart to update_prebuilt_voice_defaults.py (which only
fixed the prebuilt_voices catalog table). prebuilt_voices does not drive the actual
"choose a voice" pickers in the product -- Step 3 (BlogUrlForm.tsx) and the
existing-project voice-change picker (ProjectVoiceSettingsCard.tsx) both read
saved_voices directly (GET /api/voices/saved, GET /api/projects/{id}/voices). Every
user who signed up before the prebuilt_voices fix still has 4 saved_voices rows
pointing at the old ids, which is why they kept seeing the old names.

Deliberately an UPDATE-in-place, not delete+reinsert (unlike scripts/sync_prebuilt_
voices.py, which was investigated and NOT used for this because it force-replaces
every user's saved voices on every run by design -- a bigger blast radius than
wanted). This script only touches the 4 old-id rows that already exist, preserves
each row's id/created_at, and does not touch projects.custom_voice_id, scenes, or
any rendered audio/video at all.

Usage:
    python3 scripts/replace_saved_voice_defaults.py --dry-run
    python3 scripts/replace_saved_voice_defaults.py
"""
import os
import sys
from argparse import ArgumentParser

CURRENT_DIR = os.path.dirname(__file__)
PROJECT_ROOT = os.path.abspath(os.path.join(CURRENT_DIR, ".."))
if PROJECT_ROOT not in sys.path:
    sys.path.insert(0, PROJECT_ROOT)

from app.database import SessionLocal
from app.constants import OLD_TO_NEW_VOICE_IDS, FREE_PREMADE_FALLBACK
from app.models.saved_voice import SavedVoice
from app.services.elevenlabs_voice_design import get_voice_metadata

NEW_NAME_BY_ID = {item["voice_id"]: item["name"] for item in FREE_PREMADE_FALLBACK}


def run(dry_run: bool) -> None:
    db = SessionLocal()
    try:
        updated = 0
        deleted_dupes = 0

        rows = (
            db.query(SavedVoice)
            .filter(SavedVoice.voice_id.in_(OLD_TO_NEW_VOICE_IDS.keys()))
            .all()
        )

        meta_cache: dict[str, dict] = {}

        for row in rows:
            new_id = OLD_TO_NEW_VOICE_IDS[row.voice_id]

            # If this user already has the new id saved too (e.g. manually added),
            # updating this row in place would create a visible duplicate -- delete
            # the stale old-id row instead and leave the existing new-id row alone.
            already_has_new = (
                db.query(SavedVoice)
                .filter(
                    SavedVoice.user_id == row.user_id,
                    SavedVoice.source == row.source,
                    SavedVoice.voice_id == new_id,
                )
                .first()
            )
            if already_has_new:
                print(
                    f"[replace-saved] user_id={row.user_id} already has {new_id} saved; "
                    f"deleting stale row id={row.id} (voice_id={row.voice_id})"
                )
                if not dry_run:
                    db.delete(row)
                deleted_dupes += 1
                continue

            if new_id not in meta_cache:
                meta_cache[new_id] = get_voice_metadata(new_id) or {}
            meta = meta_cache[new_id]

            print(
                f"[replace-saved] user_id={row.user_id} row id={row.id}: "
                f"{row.voice_id} ({row.name!r}) -> {new_id} ({NEW_NAME_BY_ID.get(new_id)!r})"
            )
            if not dry_run:
                row.voice_id = new_id
                row.name = NEW_NAME_BY_ID.get(new_id, row.name)
                if meta.get("preview_url"):
                    row.preview_url = meta["preview_url"]
                if meta.get("description"):
                    row.description = meta["description"]
            updated += 1

        if dry_run:
            db.rollback()
        else:
            db.commit()

        print(
            f"[replace-saved] done: updated={updated} deleted_dupes={deleted_dupes} "
            f"dry_run={int(dry_run)}"
        )
    finally:
        db.close()


if __name__ == "__main__":
    parser = ArgumentParser()
    parser.add_argument("--dry-run", action="store_true", help="Print planned changes without writing to DB.")
    args = parser.parse_args()
    run(dry_run=args.dry_run)