← back to Kravet Sheet Sync 2026 04 20
__pycache__/delete_collision_pilots.cpython-314.pyc
19 lines
+
UK�j � � � R t ^ RIt^ RIt^ RIt]P P RR4 tRt RRRR/RR RR
/RR RR /RR
RR/RRRR/.t
Rt R-R lt ]
EFv t
] ! ] RR]
R, //4 t]P R/ 4 P R/ 4 P R. 4 t]P R/ 4 P R/ 4 P R4 t]' d ]! R]
R, R] 24 M]! R]
R, R] 24 ]
R, P% R 4 R., t]
R, tR ] R ] R 2R ]
R, R ] R 23 FC t]P, ! R!R"R#]! R$4 P P R%R4 R&] R'2.R(R(R(R)7 KE ]P, ! R!R"R#]! R$4 P P R%R4 R*] R+2.R(R(R(R)7 EKy ]! R,4 R# )/z;Delete the 5 DWKK-collision pilot products + clean PG rows.N�SHOPIFY_ADMIN_TOKEN� zPhttps://designer-laboratory-sandbox.myshopify.com/admin/api/2024-10/graphql.json�dw_skuz DWKK-140010�pidz#gid://shopify/Product/7821709836339z DWKK-140056z#gid://shopify/Product/7821709869107z DWKK-140544z#gid://shopify/Product/7821709901875z DWKK-140783z#gid://shopify/Product/7821709934643z DWKK-142909z#gid://shopify/Product/7821710032947zlmutation($in: ProductDeleteInput!){ productDelete(input:$in){ deletedProductId userErrors{field message} } }c �J � \ P ! R T RT;' g / /4 P 4 p\ P P \ P P
\ VRRRR\ /R7 ^ R7 p\ P ! VP 4 4 # )�query� variables�POSTz Content-Typezapplication/jsonzX-Shopify-Access-Token)�data�method�headers)�timeout) �json�dumps�encode�urllib�request�urlopen�Request�URL�TOKEN�loads�read)�q�v�body�rs && �delete_collision_pilots.py�gqlr s� � �
���W�Q�{�1�7�7��3� 4� ;� ;� =�D� �n�n� � �V�^�^� 3� 3�C�T�� � 0�1I�%�P� 4� R�Z\� � ^�A� �:�:�a�f�f�h� � � �in�idr
�
productDelete�
userErrors�deletedProductIdz z: delete errors: z
: deleted �/z1DELETE FROM shopify_products WHERE shopify_id = 'z' AND dw_sku = '�'z7DELETE FROM kravet_catalog WHERE shopify_product_id = '�sshzroot@45.61.58.125z PGPASSWORD=�os�
PGPASSWORDz1 psql -h 127.0.0.1 -U dw_admin -d dw_unified -c "�"T)�capture_output�text�checkz] psql -h 127.0.0.1 -U dw_admin -d dw_unified -c "DELETE FROM dw_sku_registry WHERE dw_sku = 'z,' AND created_at > NOW() - INTERVAL '1 day'"zdone.)N�����)�__doc__r �urllib.requestr �
subprocessr( �environ�getr r �
COLLISIONS�DELr �c�d�errs�del_id�print�split�pid_num�dwskur �run�
__import__� r r �<module>rA sA �� A� '� '��j�j�n�n�*�2�.��V�� �}�e�%J�K�
�}�e�%J�K�
�}�e�%J�K�
�}�e�%J�K�
�}�e�%J�K� �
� y�� �
�A� �C�$��q��x�(�)�*�A� �5�5��� � � � �"� 5� 9� 9�,�� K�D�
�U�U�6�2�
�
"�
"�?�B�
7�
;�
;�<N�
O�F� �
��1�X�;�-� 0���7�8�
��1�X�;�-�z�&��2�3� ��h�n�n�S�!�"�%�G�
�h�K�E� <�G�9�DT�UZ�T[�[\�]�
A�!�E�(��K[�\a�[b�bc�d� �� ���� 1� �
�4�(�0�0�4�4�\�"�E�F�Fw�xy�wz�z{�
|�~� �D�� 6�� �N�N�E�-�
�j��&�.�.�2�2�<��C�D� E9�9>��?n� p�q� �$�d�4� 4�1
�: �g�r