← back to Hollywood Import

apply-innov.sql

27 lines

BEGIN;
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034984 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034967 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034969 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034970 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034971 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034972 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034974 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034975 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034976 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034977 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034978 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034979 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034980 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034981 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034983 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035933 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035934 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035935 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035937 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035940 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"33.95"'),'{hw_price}','"49.16"'),'{retail_price}','"49.16"'),'{cost}','"30.56"') WHERE id=2034982 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035938 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035936 AND vendor_code='hollywood';
UPDATE vendor_catalog SET specs=jsonb_set(jsonb_set(jsonb_set(jsonb_set(coalesce(specs,'{}'::jsonb),'{list_price}','"104.95"'),'{hw_price}','"151.97"'),'{retail_price}','"151.97"'),'{cost}','"94.46"') WHERE id=2035939 AND vendor_code='hollywood';
COMMIT;