← back to Hollywood Import

verify2.js

11 lines

const { spawnSync } = require('child_process');
const { scrubMomentum, leakCheck } = require('./scrub-momentum');
const PSQL='/opt/homebrew/opt/postgresql@14/bin/psql';
const sql=`SELECT json_agg(t) FROM (SELECT id,pattern_name,color_name,collection,dw_sku,mfr_sku,image_url,all_images,specs
  FROM vendor_catalog WHERE vendor_code='hollywood'
   AND (sync_status='new' OR (on_shopify IS NOT TRUE AND shopify_product_id IS NULL)) AND mfr_sku IS NOT NULL) t`;
const rows=JSON.parse(spawnSync(PSQL,['-U','stevestudio2','-d','dw_unified','-tA','-c',sql],{encoding:'utf8',maxBuffer:1<<30}).stdout||'[]')||[];
let leaks=0,complete=0,multiImg=0,oneImg=0;
for(const r of rows){const p=scrubMomentum(r);if(leakCheck(p).length)leaks++;if(p.complete)complete++;if(p.imageCount>1)multiImg++;else oneImg++;}
console.log('netnew rows:',rows.length,'| leaks:',leaks,'| complete:',complete,'| >1 image:',multiImg,'| exactly 1 image:',oneImg);