TK-10402: undo script for Flux room-scene backfill

156ccf75fc6fa2c85ce1a3fd132b61c95cc1fa2b · 2026-09-04 12:18:10 -0700 · Steve

12 NULL room scene_images regenerated via Replicate-Flux fallback (Gemini
prepay depleted). This reverts scene_image->NULL + deletes the generated PNGs.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01EgcJfyrTaPp4vJYtptSXGG

Files touched

A scripts/tk10402-undo.sh

Diff

commit 156ccf75fc6fa2c85ce1a3fd132b61c95cc1fa2b
Author: Steve <steve@designerwallcoverings.com>
Date:   Fri Sep 4 12:18:10 2026 -0700

    TK-10402: undo script for Flux room-scene backfill
    
    12 NULL room scene_images regenerated via Replicate-Flux fallback (Gemini
    prepay depleted). This reverts scene_image->NULL + deletes the generated PNGs.
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
    Claude-Session: https://claude.ai/code/session_01EgcJfyrTaPp4vJYtptSXGG
---
 scripts/tk10402-undo.sh | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/scripts/tk10402-undo.sh b/scripts/tk10402-undo.sh
new file mode 100755
index 0000000..f9a8851
--- /dev/null
+++ b/scripts/tk10402-undo.sh
@@ -0,0 +1,8 @@
+#!/bin/bash
+# UNDO TK-10402 Flux backfill: null the 12 rooms + delete their generated scenes. Reversible.
+cd "$(dirname "$0")/.."
+while IFS='|' read -r slug img; do
+  [ -z "$slug" ] && continue
+  psql postgresql://localhost:5432/idshowroom -c "UPDATE rooms SET scene_image=NULL, hotspots='[]'::jsonb WHERE slug='$slug';"
+  [ -n "$img" ] && rm -f "public$img" && echo "reverted $slug ($img)"
+done < tmp/tk10402-undo-manifest.tsv

← 9c27c31 deploy: guard prod-only runtime data from rsync --delete · back to Interiordesignershowroom · TK-11260: HOTSPOT_PROVIDER dispatcher + openai fallback, bac 323ecdb →