`db/enrich-wiki.mjs`

38 lines
// Comprehensiveness pass: fill characters.description_original with original
// profiles grounded in factual series knowledge. (Season overviews are static
// editorial content in the /show page — no DB column needed.)
// Run: node db/enrich-wiki.mjs   (idempotent)
import pg from "pg";
const DATABASE_URL =
  process.env.DATABASE_URL ?? "postgresql://localhost/nineoh_guide?host=/tmp";
const pool = new pg.Pool({ connectionString: DATABASE_URL });
const show = (await pool.query(`select id from shows where canonical_title='90210'`)).rows[0];

const CHARACTERS = {
  "Annie Wilson": "The Kansas transplant at the show's center — earnest and stage-struck, repeatedly tested by Beverly Hills.",
  "Erin Silver": "Sharp, creative and guarded — a budding filmmaker who weathers family loss and mental-health struggles.",
  "Naomi Clark": "The wealthy, impulsive queen bee whose schemes and heartbreaks drive much of the series.",
  "Adrianna Tate-Duncan": "A former child star and aspiring singer navigating addiction, motherhood and fame.",
  "Dixon Wilson": "Annie's adopted brother — an athlete turned aspiring music producer with a searching streak.",
  "William 'Liam' Court": "The brooding, motorcycle-riding bad boy with a soft center and a knack for trouble.",
  "Navid Shirazi": "An earnest aspiring journalist and filmmaker — the group's steady conscience.",
  "Debbie Wilson": "The Wilson matriarch, a photographer balancing her career with her kids' chaos.",
  "Ivy Sullivan": "A free-spirited surfer and artist who joins the group as the ensemble widens.",
  "Teddy Montgomery": "A tennis prodigy and heir whose journey of self-discovery is one of the show's landmark arcs.",
  "Ryan Matthews": "The young West Bev teacher pulled into the students' orbit in the early seasons.",
  "Harrison 'Harry' Wilson": "The Wilson patriarch and West Bev principal, steering the family through its move west.",
  "Ethan Ward": "A first-season jock and Annie's early love interest, torn between image and conscience.",
  "Tabitha Wilson": "Annie and Dixon's glamorous, acid-tongued grandmother — a former actress who never lost the spotlight.",
};

let c = 0;
for (const [name, desc] of Object.entries(CHARACTERS)) {
  const r = await pool.query(
    `update characters set description_original=$1 where name=$2 and show_id=$3`,
    [desc, name, show.id]
  );
  c += r.rowCount;
}
console.log(`character profiles: ${c}/${Object.keys(CHARACTERS).length}`);
await pool.end();