Check form sign-ups, save them to Supabase and ping Telegram

import re
from clickruntime import on_event, credentials, http

MY_CHAT = 123456789
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):
    c = event.json or {}
    email = (c.get("email") or "").strip().lower()
    if not re.fullmatch(r"[^@\s]+@[^@\s]+\.[a-z]{2,}", email) or not c.get("name"):
        tg("sendMessage", chat_id=MY_CHAT, text=f"⚠️ Rejected sign-up: {c.get('name') or '?'} <{email or 'no email'}>")
        return {"status": "invalid"}
    if sb("GET", "customers", params={"select": "id", "email": f"ilike.{email}"}):
        tg("sendMessage", chat_id=MY_CHAT, text=f"🔁 Duplicate sign-up: {c['name']} <{email}>")
        return {"status": "duplicate"}
    row = sb("POST", "customers", json={"name": c["name"], "email": email, "company": c.get("company")})[0]
    tg("sendMessage", chat_id=MY_CHAT, text=f"✅ New customer #{row['id']}: {c['name']} <{email}> {c.get('company') or ''}")
    return {"status": "inserted", "id": row["id"]}