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(); })();