fix: replace SELECT * with explicit columns in shopify-push (pre-deploy lint)

292b0789b54eee893c7c6ec2babfc7c98e6b752a · 2026-08-20 10:04:37 -0700 · Steve Abrams

Files touched

M scripts/shopify-push.mjs

Diff

commit 292b0789b54eee893c7c6ec2babfc7c98e6b752a
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Aug 20 10:04:37 2026 -0700

    fix: replace SELECT * with explicit columns in shopify-push (pre-deploy lint)
---
 scripts/shopify-push.mjs | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/scripts/shopify-push.mjs b/scripts/shopify-push.mjs
index 1a7699a..12e1e32 100644
--- a/scripts/shopify-push.mjs
+++ b/scripts/shopify-push.mjs
@@ -73,7 +73,8 @@ async function main() {
   const dwBare = dwSkuArg.replace(/-sample$/i, '');
   // 1. FileMaker source of truth
   const { rows: fmRows } = await pool.query(
-    `SELECT * FROM filemaker_wallpaper WHERE upper(dw_sku)=upper($1) LIMIT 1`, [dwBare]);
+    `SELECT dw_sku, title, name_of_pattern, mfr_number, width, specs, is_discontinued
+       FROM filemaker_wallpaper WHERE upper(dw_sku)=upper($1) LIMIT 1`, [dwBare]);
   const fm = fmRows[0];
   if (!fm) { await pool.end(); return out({ ok: false, dw_sku: dwSkuArg, reason: 'not in FileMaker WALLPAPER file' }); }
   if (fm.is_discontinued) { await pool.end(); return out({ ok: false, dw_sku: dwSkuArg, reason: 'FileMaker marks this DISCONTINUED — refusing to push' }); }

← 7ae6937 nav-agent: sync v1.3 (host left-sidebar collapse on load) · back to All Designerwallcoverings · chore: v1.7.1 (session close) ea049e2 →