audio_codebuddy/deploy-package/scripts/check-tts-result.js

const { PrismaClient } = require('@prisma/client');
const p = new PrismaClient();
(async () => {
  for (const bookId of [77, 78]) {
    const b = await p.book.findUnique({ where: { id: bookId }, select: { id: true, title: true, targetLanguage: true, genStage: true } });
    console.log(`book ${b.id} (${b.targetLanguage}) genStage=${b.genStage} title=${b.title}`);
    const chs = await p.bookChapter.findMany({ where: { bookId }, select: { id: true, title: true, audioUrl: true, audioDuration: true, content: true, genStage: true } });
    for (const ch of chs) {
      console.log(`  ch#${ch.id} genStage=${ch.genStage} dur=${ch.audioDuration}s url=${(ch.audioUrl||'').slice(-60)}`);
      if (ch.content) {
        const sample = ch.content.substring(0, 150).replace(/\n/g, ' / ');
        console.log(`    content sample: ${sample}`);
      }
    }
  }
  await p.$disconnect();
})();