refine: escape SQL regex backslashes to kill $ invalid-escape SyntaxWarning (behavior-preserving; SQL still receives \.0\$)

6f2994aa3d93c1c9cbaecc2a854ae6d64f4d70f9 · 2026-07-30 12:09:36 -0700 · Steve Abrams

Files touched

M bulk_push_v1.py

Diff

commit 6f2994aa3d93c1c9cbaecc2a854ae6d64f4d70f9
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Jul 30 12:09:36 2026 -0700

    refine: escape SQL regex backslashes to kill $ invalid-escape SyntaxWarning (behavior-preserving; SQL still receives \.0\$)
---
 bulk_push_v1.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/bulk_push_v1.py b/bulk_push_v1.py
index c2980e0..417811c 100644
--- a/bulk_push_v1.py
+++ b/bulk_push_v1.py
@@ -124,7 +124,7 @@ def fetch_batch(limit, skip_existing=True):
              row_number() OVER (PARTITION BY n.brand ORDER BY n.map DESC) AS rn_brand
         FROM kravet_diff_new_2026_04_20 n
         JOIN v_kravet_sku_primary_image p
-          ON p.mfr_sku_norm = regexp_replace(regexp_replace(upper(btrim(n.mfr_sku)),'-','.','g'),'\\.0\$','')
+          ON p.mfr_sku_norm = regexp_replace(regexp_replace(upper(btrim(n.mfr_sku)),'-','.','g'),'\\.0\\$','')
          AND p.kind='colorway'
    LEFT JOIN v_kravet_sku_primary_image pr
           ON pr.mfr_sku_norm = p.mfr_sku_norm AND pr.kind='full_repeat'

← 2779d0d auto-save: 2026-07-30T07:45:45 (1 files) — __pycache__/bulk_ · back to Kravet Sheet Sync 2026 04 20 · auto-save: 2026-07-30T12:17:59 (1 files) — __pycache__/bulk_ 0fa547c →