Answer WhatsApp questions from your Supabase knowledge base

from clickruntime import on_event, credentials, http, ai, notify

SUPABASE_URL = "https://your-project.supabase.co"
sb = lambda: {"apikey": credentials.secret("SUPABASE_SECRET_KEY"), "Authorization": f"Bearer {credentials.secret('SUPABASE_SECRET_KEY')}"}
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa(to, text):
    http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"},
              json={"messaging_product": "whatsapp", "to": to, "type": "text", "text": {"body": text}}).raise_for_status()
def incoming(event):
    changes = [c for e in (event.json or {}).get("entry", []) for c in e.get("changes", [])]
    return [(m["from"], m["text"]["body"]) for c in changes for m in c["value"].get("messages", []) if m.get("type") == "text"]

@on_event
def handle(event):
    for phone, text in incoming(event):
        docs = http.post(f"{SUPABASE_URL}/rest/v1/rpc/match_documents", headers=sb(), json={"query_text": text, "match_count": 4}).json()
        context = "\n\n".join(d["content"][:1500] for d in docs)
        answer = ai.generate(f"Question: {text}\n\nDocuments:\n{context}", max_output_tokens=250,
                             system="Answer briefly using only the documents. If they don't contain the answer, reply exactly UNKNOWN.").text.strip()
        if answer == "UNKNOWN":
            wa(phone, "Good question. I've passed it to the team and someone will reply shortly.")
            notify.email_me("Unanswered WhatsApp question", f"From +{phone}:\n{text}")
        else:
            wa(phone, answer)
    return {"ok": True}