_fix_voices.js 4.74 KB
const fs = require('fs');
const path = require('path');

// Load env
const envPath = path.join(__dirname, '.env');
fs.readFileSync(envPath, 'utf8').split('\n').forEach(l => {
  const m = l.match(/^([^#=]+)=(.*)$/);
  if (m) process.env[m[1].trim()] = m[2].trim();
});

const { Sequelize } = require('sequelize');

const updates = [
  { id: 553, voice_id: 'zh_male_dayi_uranus_bigtts' },       // President - 成熟沉稳
  { id: 554, voice_id: 'en_female_dacey_uranus_bigtts' },     // Press Secretary - 职业女性
  { id: 555, voice_id: 'en_male_tim_uranus_bigtts' },         // Reporter - 年轻男记者
  { id: 556, voice_id: 'zh_male_ruyayichen_uranus_bigtts' },  // Doctor - 儒雅紧张
  { id: 557, voice_id: 'zh_male_dayi_uranus_bigtts' },        // _default - same as President
];

(async () => {
  const s = new Sequelize(process.env.DB_NAME, process.env.DB_USER, process.env.DB_PASSWORD, {
    host: process.env.DB_HOST, port: +process.env.DB_PORT, dialect: 'mysql', logging: false
  });

  for (const u of updates) {
    await s.query('UPDATE drama_characters SET voice_id = ? WHERE id = ?', { replacements: [u.voice_id, u.id] });
  }

  // Verify
  const [rows] = await s.query('SELECT id, character_name, voice_id FROM drama_characters WHERE drama_id = 99 ORDER BY id');
  rows.forEach(r => console.log(`${r.character_name}: ${r.voice_id}`));

  // Now regenerate bundle - read insert-drama.js logic for bundle generation
  // Get drama info
  const [dramas] = await s.query('SELECT * FROM dramas WHERE id = 99');
  const drama = dramas[0];
  const dramaKey = drama.drama_key;

  // Get characters
  const [chars] = await s.query('SELECT * FROM drama_characters WHERE drama_id = 99 ORDER BY id');
  // Get scripts
  const [scripts] = await s.query('SELECT * FROM drama_scripts WHERE drama_id = 99 ORDER BY seq_order');
  // Get emotions
  const [emotions] = await s.query('SELECT * FROM drama_emotions WHERE drama_id = 99');

  const baseLang = drama.language || 'zh';
  const extractTranslations = (v) => v ? { [baseLang]: v } : {};

  const bundle = {
    meta: {
      id: dramaKey,
      title: extractTranslations(drama.title),
      subtitle: extractTranslations(drama.subtitle),
      description: extractTranslations(drama.description),
      system_prompt: drama.system_prompt,
      cover_url: drama.cover_url,
      background_url: drama.background_url,
      bgm_url: drama.bgm_url || null,
      type: drama.type || 'classic',
      language: baseLang,
    },
    characters: {},
    script: [],
  };

  for (const char of chars) {
    const charKey = char.character_name === '_default' ? '_default' : char.character_name;
    const faces = {};
    const charEmotions = emotions.filter(e => 
      (char.character_name === '_default' ? e.character_name === null : e.character_name === char.character_name) ||
      (!e.character_name)
    );
    for (const e of charEmotions) {
      if (e.avatar_key) {
        faces[e.avatar_key] = { url: e.face_url, emotion: e.emotion_name, scale: e.emotion_scale };
      }
    }
    // Use shared emotions for non-default chars
    if (char.character_name !== '_default' && Object.keys(faces).length === 0) {
      const shared = emotions.filter(e => !e.character_name);
      for (const e of shared) {
        if (e.avatar_key) {
          faces[e.avatar_key] = { url: e.face_url, emotion: e.emotion_name, scale: e.emotion_scale };
        }
      }
    }

    const voiceIdMap = {};
    if (char.voice_id) voiceIdMap['zh'] = char.voice_id;
    if (char.voice_id_en) voiceIdMap['en'] = char.voice_id_en;

    bundle.characters[charKey] = {
      id: char.id,
      name: char.character_name === '_default' ? null : extractTranslations(char.character_name),
      voice_id: Object.keys(voiceIdMap).length > 0 ? voiceIdMap : null,
      body_url: char.body_url,
      face_offset: { top: char.face_offset_top, left: char.face_offset_left, width: char.face_offset_width },
      faces,
    };
  }

  for (const sc of scripts) {
    bundle.script.push({
      character: sc.character_name,
      dialogue: extractTranslations(sc.dialogue),
      avatar: sc.avatar_key || 'normal.png',
      action: sc.action || 'none',
      position: sc.position || 'left',
      instruction: sc.instruction || null,
    });
  }

  // Upload to OSS
  const OSS = require('ali-oss');
  const client = new OSS({
    region: process.env.OSS_REGION,
    accessKeyId: process.env.OSS_ACCESS_KEY_ID,
    accessKeySecret: process.env.OSS_ACCESS_KEY_SECRET,
    bucket: process.env.OSS_BUCKET,
  });

  const bundleJson = JSON.stringify(bundle, null, 2);
  const ossPath = `dramas/${dramaKey}/bundle.json`;
  await client.put(ossPath, Buffer.from(bundleJson));
  console.log(`\nBundle 已重新上传: https://${process.env.OSS_BUCKET}.${process.env.OSS_REGION}.aliyuncs.com/${ossPath}`);

  await s.close();
})();