write 6 original spoiler-safe S1 recaps (our wording, grounded in factual events; AI-drafted, review before publish)

c260ce841b7d88fdd6fc28c44871a8528cd37bcb · 2026-07-25 10:29:54 -0700 · Steve

Files touched

A db/seed-recaps-s1.mjs

Diff

commit c260ce841b7d88fdd6fc28c44871a8528cd37bcb
Author: Steve <steve@designerwallcoverings.com>
Date:   Sat Jul 25 10:29:54 2026 -0700

    write 6 original spoiler-safe S1 recaps (our wording, grounded in factual events; AI-drafted, review before publish)
---
 db/seed-recaps-s1.mjs | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)

diff --git a/db/seed-recaps-s1.mjs b/db/seed-recaps-s1.mjs
new file mode 100644
index 0000000..c667c6d
--- /dev/null
+++ b/db/seed-recaps-s1.mjs
@@ -0,0 +1,35 @@
+// ORIGINAL, spoiler-safe Season 1 recaps — written in our own editorial voice,
+// grounded in FACTUAL episode events (not copied or closely paraphrased from any
+// synopsis). These are AI-drafted editorial starters for human review, not
+// authoritative. Copyright protects expression, not plot facts.
+// Run: node db/seed-recaps-s1.mjs
+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 RECAPS = {
+  1: "The series opens as the Wilson family trades small-town Kansas for the 90210 ZIP code after Harry takes the principal's chair at West Beverly Hills High. Siblings Annie and Dixon get a same-day crash course in Beverly Hills social politics while the family settles in near a sharp-tongued grandmother.",
+  2: "Dixon works to win over territorial new teammates while a long-distance breakup leaves Annie unexpectedly open to a first spark in her adopted city — the back half of a two-part premiere that sets the ensemble in motion.",
+  3: "A well-meaning family bowling night goes sideways once the kids' new friends turn up uninvited, and Annie finds herself pulled between two very different love interests as the group's dynamics start to harden.",
+  4: "West Beverly's musical loses its director at the worst possible moment, and talking a familiar alum into stepping in reopens old rivalries over the school's drama scene.",
+  5: "With opening night of the school production closing in, Annie's whirlwind romance with an older guy has her friends worried it's all moving far too fast.",
+  6: "A magazine fashion shoot doubles as a stage for family drama: Annie spins it into a school project while a well-intentioned scheme to patch up a marriage quietly backfires.",
+};
+
+const show = (await pool.query(`select id from shows where canonical_title='90210'`)).rows[0];
+if (!show) { console.error("Run db/seed.mjs first."); process.exit(1); }
+
+let updated = 0;
+for (const [num, text] of Object.entries(RECAPS)) {
+  const res = await pool.query(
+    `update episodes set summary_short_original = $1, spoiler_rating = 0
+       where show_id = $2 and season_number = 1 and episode_number = $3`,
+    [text, show.id, Number(num)]
+  );
+  updated += res.rowCount;
+}
+console.log(`original S1 recaps written: ${updated}`);
+console.log("These are ORIGINAL editorial drafts grounded in factual events — review before publish.");
+await pool.end();

← fc01815 ingest factual cast + character names (TVmaze, names-only, n · back to Nineoh Guide · recaps: complete Season 1 (24 original spoiler-safe drafts) c7d73bc →