-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmask.sql
8 lines (8 loc) · 4.55 KB
/
mask.sql
1
2
3
4
5
6
7
8
INSERT INTO "public"."new_products" ("sku", "type", "size", "name", "description", "main_media_url", "extra_media_urls", "customizable", "customization_options", "metadata", "resale_enabled", "resale_limited", "resale_whitelist", "weight_value", "weight_units", "package_length", "package_width", "package_height", "package_code", "unit_price", "row_created_at", "row_updated_at") VALUES ('CL-MA-2013-L', 'mask', 'L', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CL', NULL, '2021-05-24 04:39:50.22179+00', NULL);
INSERT INTO "public"."new_products" ("sku", "type", "size", "name", "description", "main_media_url", "extra_media_urls", "customizable", "customization_options", "metadata", "resale_enabled", "resale_limited", "resale_whitelist", "weight_value", "weight_units", "package_length", "package_width", "package_height", "package_code", "unit_price", "row_created_at", "row_updated_at") VALUES ('CL-MA-2013-M', 'mask', 'M', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CL', NULL, '2021-05-24 04:39:50.222556+00', NULL);
INSERT INTO "public"."new_products" ("sku", "type", "size", "name", "description", "main_media_url", "extra_media_urls", "customizable", "customization_options", "metadata", "resale_enabled", "resale_limited", "resale_whitelist", "weight_value", "weight_units", "package_length", "package_width", "package_height", "package_code", "unit_price", "row_created_at", "row_updated_at") VALUES ('CL-MA-2013-S', 'mask', 'S', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CL', NULL, '2021-05-24 04:39:50.223369+00', NULL);
INSERT INTO "public"."new_product_templates" ("sku", "width", "height", "dpi", "ghost", "output_bucket", "crop", "touchup", "approval", "images", "image_placements", "texts", "text_placements", "info_bars", "info_blocks") VALUES ('CL-MA-2013-L', 2345, 1365, 210, NULL, 'hoopswagg.approved/masks', NULL, NULL, 't', '[{"ID": 0, "Name": "2013_mask", "Path": "backgrounds/presets", "Type": "static", "Color": "", "FlipH": false, "FlipV": false, "ImageX": 0, "ImageY": 0, "Resize": true, "Source": "resources", "AnchorX": 0, "AnchorY": 0, "IsColor": false, "BoxWidth": 2690, "BoxHeight": 1365, "Extension": "jpg", "ResizeAuto": false, "ResizeWidth": 0, "ResizeHeight": 1365, "ResizeFunction": 0}]', '[{"X": 1172, "Y": 682, "ID": 0, "Rotate": false, "AnchorX": 0.5, "AnchorY": 0.5, "RotateX": 0, "RotateY": 0, "RotateAngle": 0}]', NULL, NULL, NULL, '[{"X": 0, "Y": 1365, "FlipH": true, "FlipV": false, "Width": 1050, "AnchorX": 0, "AnchorY": 0}]');
INSERT INTO "public"."new_product_templates" ("sku", "width", "height", "dpi", "ghost", "output_bucket", "crop", "touchup", "approval", "images", "image_placements", "texts", "text_placements", "info_bars", "info_blocks") VALUES ('CL-MA-2013-M', 2345, 1190, 210, NULL, 'hoopswagg.approved/masks', NULL, NULL, 't', '[{"ID": 0, "Name": "2013_mask", "Path": "backgrounds/presets", "Type": "static", "Color": "", "FlipH": false, "FlipV": false, "ImageX": 0, "ImageY": 0, "Resize": true, "Source": "resources", "AnchorX": 0, "AnchorY": 0, "IsColor": false, "BoxWidth": 2345, "BoxHeight": 1190, "Extension": "jpg", "ResizeAuto": false, "ResizeWidth": 0, "ResizeHeight": 1190, "ResizeFunction": 0}]', '[{"X": 1172, "Y": 595, "ID": 0, "Rotate": false, "AnchorX": 0.5, "AnchorY": 0.5, "RotateX": 0, "RotateY": 0, "RotateAngle": 0}]', NULL, NULL, NULL, '[{"X": 0, "Y": 1190, "FlipH": true, "FlipV": false, "Width": 1050, "AnchorX": 0, "AnchorY": 0}]');
INSERT INTO "public"."new_product_templates" ("sku", "width", "height", "dpi", "ghost", "output_bucket", "crop", "touchup", "approval", "images", "image_placements", "texts", "text_placements", "info_bars", "info_blocks") VALUES ('CL-MA-2013-S', 1890, 840, 210, NULL, 'hoopswagg.approved/masks', NULL, NULL, 't', '[{"ID": 0, "Name": "2013_mask", "Path": "backgrounds/presets", "Type": "static", "Color": "", "FlipH": false, "FlipV": false, "ImageX": 0, "ImageY": 0, "Resize": true, "Source": "resources", "AnchorX": 0, "AnchorY": 0, "IsColor": false, "BoxWidth": 1890, "BoxHeight": 840, "Extension": "jpg", "ResizeAuto": false, "ResizeWidth": 1890, "ResizeHeight": 0, "ResizeFunction": 0}]', '[{"X": 945, "Y": 420, "ID": 0, "Rotate": false, "AnchorX": 0.5, "AnchorY": 0.5, "RotateX": 0, "RotateY": 0, "RotateAngle": 0}]', NULL, NULL, NULL, '[{"X": 0, "Y": 840, "FlipH": true, "FlipV": false, "Width": 1050, "AnchorX": 0, "AnchorY": 0}]');
UPDATE order_items set cropped = true, processed = true where sku ilike '%CL-MA-2013%';
DELETE from order_sync_errors where details ilike '%CL-MA-2013%'