Function main

scripts/regen-illustrations.ts:17–39

()

];

async function main() {
  for (const id of IDS) {
    const { rows } = await pool.query('SELECT title, category, excerpt FROM perspectives WHERE id = $1', [id]);
    if (!rows[0]) { console.log(`SKIP ${id} - not found`); continue; }
    const { title, category, excerpt } = rows[0];
    console.log(`Generating: ${title.slice(0, 60)}...`);
    try {
      const { imageBuffer, promptUsed } = await generateIllustration({ title, category, excerpt });
      const hex = '\\x' + imageBuffer.toString('hex');
      const ins = await pool.query(
        `INSERT INTO perspective_illustrations (perspective_id, image_data, prompt_used, status, approved_at)
         VALUES ($1, $2, $3, 'approved', NOW()) RETURNING id`,
        [id, hex, promptUsed]
      );
      const illId = ins.rows[0].id;
      await pool.query('UPDATE perspectives SET illustration_id = $1 WHERE id = $2', [illId, id]);
      console.log(`  OK: ${illId} (${(imageBuffer.length / 1024).toFixed(0)} KB)`);
    } catch (e: any) {
      console.log(`  FAIL: ${e.message}`);
    }
  }
  await pool.end();
}
main();