auto-data-snapshot: 2026-08-12T09:25:42 (1 data files) — build.sql

ebc0a69c587eaaaaa2fd5e7d4c0f1d290db18a7c · 2026-08-12 09:25:48 -0700 · auto-commit-fleet

Files touched

M build.sql

Diff

commit ebc0a69c587eaaaaa2fd5e7d4c0f1d290db18a7c
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Wed Aug 12 09:25:48 2026 -0700

    auto-data-snapshot: 2026-08-12T09:25:42 (1 data files) — build.sql
---
 build.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/build.sql b/build.sql
index 53fa453..329777f 100644
--- a/build.sql
+++ b/build.sql
@@ -68,6 +68,15 @@ SELECT l.combo_sku, l.mfr_pattern, l.series, l.jpg_name, l.supplier, CURRENT_DAT
 FROM fm_wallpaper_live l
 WHERE NOT EXISTS (SELECT 1 FROM master_fmpro f WHERE upper(f.sku) = l.combo_sku);
 
+-- ===== queue this run's NEW skus for Steve's approval (canary) — pending; never re-queues a decided sku =====
+INSERT INTO fmpro_wallpaper_review (sku, review_status, batch_date, vendor_name, mfr_sku, sku_prefix, image_filename)
+SELECT DISTINCT ON (sku) sku, 'pending', CURRENT_DATE,
+       nullif(vendor_name,''), nullif(mfr_sku,''), nullif(sku_prefix,''), nullif(image_filename,'')
+FROM master_fmpro
+WHERE added_date::date = CURRENT_DATE AND nullif(sku,'') IS NOT NULL
+ORDER BY sku, (nullif(vendor_name,'') IS NOT NULL) DESC
+ON CONFLICT (sku) DO NOTHING;
+
 SELECT
   (SELECT count(*) FROM fm_wallpaper_live) AS live_distinct_combosku,
   (SELECT count(*) FROM fmpro)             AS fmpro_rows,

← 73f5131 Nightly FileMaker WALLPAPER -> postgres sync (fm_wallpaper_l · back to Fm Wallpaper Sync · Add new-SKU approval gate: fmpro_wallpaper_review (canary ba 620fba6 →