← back to Interiordesignershowroom

scripts/tk10402-undo.sh

9 lines

#!/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