Add and list Supabase records from Telegram commands

from clickruntime import on_event, credentials, http

ALLOWED = {123456789}  # your Telegram chat id
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 tg(method, **params):
    return http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/{method}", json=params).json()

@on_event
def handle(event):
    msg = (event.json or {}).get("message") or {}
    chat, text = msg.get("chat", {}).get("id"), (msg.get("text") or "").strip()
    if chat not in ALLOWED or not text.startswith("/"):
        return {"ignored": True}
    cmd, _, arg = text.partition(" ")
    if cmd == "/add" and arg:
        row = sb("POST", "links", json={"text": arg})[0]
        reply = f"Saved #{row['id']}"
    elif cmd == "/list":
        rows = sb("GET", "links?order=id.desc&limit=10")
        reply = "\n".join(f"#{r['id']} {r['text']}" for r in rows) or "Nothing saved yet"
    elif cmd == "/delete" and arg.isdigit():
        reply = f"Deleted #{arg}" if sb("DELETE", f"links?id=eq.{arg}") else f"No row #{arg}"
    else:
        reply = "Commands: /add <text>, /list, /delete <id>"
    tg("sendMessage", chat_id=chat, text=reply)
    return {"command": cmd}