`spot_check.py`

25 lines
#!/usr/bin/env python3
import subprocess, json, sys

SSH = ['ssh', 'root@45.61.58.125']
TOKEN = os.environ.get('SHOPIFY_ADMIN_TOKEN','')
SHOP = 'designer-laboratory-sandbox.myshopify.com'

def check(pid):
    q = '{ product(id: "gid://shopify/Product/%s") { id title productType status tags } }' % pid
    body = json.dumps({'query': q})
    cmd = SSH + [
        f"curl -s -X POST 'https://{SHOP}/admin/api/2024-10/graphql.json' "
        f"-H 'X-Shopify-Access-Token: {TOKEN}' -H 'Content-Type: application/json' "
        f"-d '{body}'"
    ]
    r = subprocess.run(cmd, capture_output=True, text=True, check=True)
    d = json.loads(r.stdout)['data']['product']
    if d is None:
        print(f'{pid}: NOT FOUND'); return
    wc = 'Wallcovering' in d['tags']
    print(f"{pid}: type={d['productType']!r} status={d['status']!r} wc_tag={wc} title={d['title'][:70]!r}")

for pid in sys.argv[1:]:
    check(pid)