crcp: explicit column list in broker-of-record recorder (satisfy deploy PII-leak lint gate) (TK-10139)

8c17144d0eb1a260268a5a7e4300067da5c44785 · 2026-08-02 23:05:13 -0700 · steve

Files touched

M scripts/broker-of-record-recorder.js

Diff

commit 8c17144d0eb1a260268a5a7e4300067da5c44785
Author: steve <steve@designerwallcoverings.com>
Date:   Sun Aug 2 23:05:13 2026 -0700

    crcp: explicit column list in broker-of-record recorder (satisfy deploy PII-leak lint gate) (TK-10139)
---
 scripts/broker-of-record-recorder.js | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/scripts/broker-of-record-recorder.js b/scripts/broker-of-record-recorder.js
index acf0fc7..3f36670 100644
--- a/scripts/broker-of-record-recorder.js
+++ b/scripts/broker-of-record-recorder.js
@@ -43,10 +43,13 @@ function addressKey(address, city) {
 const _clean = (v) => { const s = v == null ? '' : String(v).trim(); return s === '' ? null : s; };
 const _eq = (a, b) => (_clean(a) || '') === (_clean(b) || '');
 
+// Explicit column list (no SELECT *) — satisfies the deploy PII-leak lint gate.
+const COLS = 'id, address_key, address, city, ain, broker_firm, broker_agent, source_of_truth, source_host, observed_at';
+
 // Newest row for an address_key, or null.
 function latestRow(address_key) {
   return db().prepare(
-    `SELECT * FROM broker_of_record_history WHERE address_key = ? ORDER BY observed_at DESC, id DESC LIMIT 1`
+    `SELECT ${COLS} FROM broker_of_record_history WHERE address_key = ? ORDER BY observed_at DESC, id DESC LIMIT 1`
   ).get(address_key) || null;
 }
 
@@ -93,7 +96,7 @@ function lastBrokerOfRecord(address_key) {
 // All history rows for an address_key, newest first.
 function historyFor(address_key) {
   return db().prepare(
-    `SELECT * FROM broker_of_record_history WHERE address_key = ? ORDER BY observed_at DESC, id DESC`
+    `SELECT ${COLS} FROM broker_of_record_history WHERE address_key = ? ORDER BY observed_at DESC, id DESC`
   ).all(address_key);
 }

← 9ac5408 auto-save: 2026-08-02T18:47:17 (4 files) — data/condos-redfi · back to Commercialrealestate · auto-save: 2026-08-02T23:48:52 (2 files) — data/crcp-drift-s 7d1d29d →