audio_codebuddy/server/update-all-content-to-hello.js

const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();

async function updateAllSubsections() {
  console.log('\n📝 开始更新所有小节内容为"你好"...\n');
  
  // 查找所有level=3的小节
  const subsections = await prisma.bookChapter.findMany({
    where: {
      level: 3
    },
    select: {
      id: true,
      title: true,
      bookId: true,
    }
  });
  
  console.log(`找到 ${subsections.length} 个小节\n`);
  
  let updatedCount = 0;
  let failedCount = 0;
  
  // 批量更新
  for (const sub of subsections) {
    try {
      await prisma.bookChapter.update({
        where: { id: sub.id },
        data: {
          content: '你好',
          contentStatus: 'completed',
          wordCount: 2,
        }
      });
      updatedCount++;
      
      if (updatedCount % 50 === 0) {
        console.log(`已更新 ${updatedCount}/${subsections.length} 个小节...`);
      }
    } catch (error) {
      failedCount++;
      console.error(`更新失败: 小节ID=${sub.id}, ${error.message}`);
    }
  }
  
  console.log(`\n✅ 更新完成！`);
  console.log(`   成功: ${updatedCount} 个`);
  console.log(`   失败: ${failedCount} 个`);
  console.log(`   总计: ${subsections.length} 个\n`);
  
  await prisma.$disconnect();
}

updateAllSubsections().catch(console.error);