promote-candidates: enumerate columns instead of SELECT * (satisfies pre-deploy PII-guard lint)

1072d8b8cfb0ff9198b03165a46d02a086ce959c · 2026-09-09 23:51:11 -0700 · Steve Abrams

Files touched

M scrapers/promote-candidates.js

Diff

commit 1072d8b8cfb0ff9198b03165a46d02a086ce959c
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Sep 9 23:51:11 2026 -0700

    promote-candidates: enumerate columns instead of SELECT * (satisfies pre-deploy PII-guard lint)
---
 scrapers/promote-candidates.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/scrapers/promote-candidates.js b/scrapers/promote-candidates.js
index 22c6d26..73ddc7e 100644
--- a/scrapers/promote-candidates.js
+++ b/scrapers/promote-candidates.js
@@ -63,7 +63,7 @@ async function main() {
     where = `status='new' AND signal_score >= $1`;
   }
   const r = await pool.query(
-    `SELECT * FROM sod_email_candidates WHERE ${where} ORDER BY signal_score DESC NULLS LAST`,
+    `SELECT id, email, display_name, domain FROM sod_email_candidates WHERE ${where} ORDER BY signal_score DESC NULLS LAST`,
     params
   );
   console.log(`[promote] ${r.rows.length} candidate(s) to promote (min=${MIN_SCORE})`);

← 88cd92f Mac2 sync-and-push job for the /videos All News Daily sectio · back to Stars of Design · Revert "Mac2 sync-and-push job for the /videos All News Dail 2dd03c4 →