Function main

scripts/test-illustration.ts:45–79

()

];

async function main() {
  const dbConfig = getDatabaseConfig();
  if (!dbConfig) throw new Error('No DB config');
  await initializeDatabase(dbConfig);
  const { getPool } = await import('../server/src/db/client.js');
  const pool = getPool();

  for (const p of PERSPECTIVES) {
    // Clear old illustration
    await pool.query('UPDATE perspectives SET illustration_id = NULL WHERE id = $1', [p.id]);
    await pool.query('DELETE FROM perspective_illustrations WHERE perspective_id = $1', [p.id]);

    console.log(`\nGenerating: ${p.title.slice(0, 60)}...`);
    const { imageBuffer, promptUsed } = await generateIllustration({
      title: p.title,
      category: p.category,
      authorDescription: p.authorDescription,
    });
    console.log('Generated', (imageBuffer.length / 1024).toFixed(0), 'KB');

    const illustration = await db.createIllustration({
      perspective_id: p.id,
      image_data: imageBuffer,
      prompt_used: promptUsed,
      author_description: p.authorDescription,
      status: 'generated',
    });

    await db.approveIllustration(illustration.id, p.id);
    console.log('Approved:', illustration.id);
  }

  console.log('\nDone!');
  process.exit(0);
}
main().catch(e => { console.error(e); process.exit(1); });