Update stock in Supabase and email a reorder for approval

import secrets
import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http

LINK = "https://hooks.clickruntime.com/t/your-trigger-id"
MANAGER = "ops@northwind.com"
SUPABASE = "https://your-project.supabase.co/rest/v1"

def sb(method, path, **kw):
    key = credentials.secret("SUPABASE_KEY")
    r = http.request(method, f"{SUPABASE}/{path}", **kw, headers={"apikey": key, "Authorization": f"Bearer {key}", "Prefer": "return=representation,resolution=merge-duplicates"})
    return r.raise_for_status() or (r.json() if r.content else None)

def send(to, subject, text):
    msg = EmailMessage()
    msg["To"], msg["Subject"] = to, subject
    msg.set_content(text)
    build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()

@on_event
def handle(event):
    body = event.json or {}
    if "decision" in body:
        sb("PATCH", f"approvals?id=eq.{body['id']}&token=eq.{body['token']}", json={"status": body["decision"]})
        return {"approval": body["id"], "status": body["decision"]}
    item = sb("GET", f"inventory?sku=eq.{body['sku']}")[0]
    qty = item["quantity"] + int(body["change"])
    sb("PATCH", f"inventory?sku=eq.{body['sku']}", json={"quantity": qty})
    if qty < item["reorder_level"] <= item["quantity"]:
        token = secrets.token_urlsafe(16)
        req = sb("POST", "approvals", json={"sku": body["sku"], "quantity": item["reorder_qty"], "token": token, "status": "pending"})[0]
        links = "\n".join(f"{d.title()}: {LINK}?id={req['id']}&token={token}&decision={d}d" for d in ("approve", "reject"))
        send(MANAGER, f"Reorder {item['name']}? ({qty} left)", f"{item['name']} is down to {qty} (reorder level {item['reorder_level']}).\n"
             f"Order {item['reorder_qty']} more?\n\n{links}")
    return {"sku": body["sku"], "quantity": qty}