update_voices.js 1.36 KB
const path = require('path');
const fs = require('fs');

// Load env
const envPath = '/Users/mingbi/Project/drama-creater/.claude/skills/create-drama/.env';
const envContent = fs.readFileSync(envPath, 'utf8');
envContent.split('\n').forEach(line => {
  const m = line.match(/^([^#=]+)=(.*)$/);
  if (m) process.env[m[1].trim()] = m[2].trim();
});

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

const voices = {
  'President': 'zh_male_dayi_uranus_bigtts',
  'Press Secretary': 'en_female_dacey_uranus_bigtts',
  'Reporter': 'en_male_tim_uranus_bigtts',
  'Doctor': 'zh_male_ruyayichen_uranus_bigtts'
};

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

  for (const [name, voiceId] of Object.entries(voices)) {
    const [, affected] = await sequelize.query(
      'UPDATE drama_characters SET voice_id = ? WHERE drama_id = 99 AND name = ?',
      { replacements: [voiceId, name] }
    );
    console.log(`${name}: ${voiceId}`);
  }

  // Verify
  const [chars] = await sequelize.query(
    'SELECT name, voice_id FROM drama_characters WHERE drama_id = 99 ORDER BY id'
  );
  console.log('\nVerification:');
  chars.forEach(c => console.log(`  ${c.name}: ${c.voice_id}`));

  await sequelize.close();
})();