cactus-vision-score: skip user_removed designs (only score the 701 live survivors)

989c3d097ddd794e15993e1d65b8fb3e0425adc7 · 2026-05-27 08:41:29 -0700 · Steve Abrams

Files touched

M scripts/cactus-vision-score.js

Diff

commit 989c3d097ddd794e15993e1d65b8fb3e0425adc7
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed May 27 08:41:29 2026 -0700

    cactus-vision-score: skip user_removed designs (only score the 701 live survivors)
---
 scripts/cactus-vision-score.js | 1 +
 1 file changed, 1 insertion(+)

diff --git a/scripts/cactus-vision-score.js b/scripts/cactus-vision-score.js
index 7c7b4be..7b4bc99 100644
--- a/scripts/cactus-vision-score.js
+++ b/scripts/cactus-vision-score.js
@@ -52,6 +52,7 @@ const idsRaw = psqlQuery(
   `SELECT d.id, COALESCE(d.local_path,'') FROM all_designs d
    JOIN wallco_cactus_rank r ON r.design_id = d.id
    WHERE d.category ILIKE '%cactus%' AND r.vision_score IS NULL
+     AND NOT COALESCE(d.user_removed,false)
    ORDER BY d.id ${LIMIT ? 'LIMIT ' + LIMIT : ''};`
 ).trim();

← ae1089a edges-review: add Snapshot tab sourcing flagged designs from · back to Wallco Ai · cactus curator: relabel Live->Publish for clarity (action va bd86cb5 →