Post a monthly summary of your Supabase figures to Slack

from datetime import date, timedelta
from statistics import mean
from clickruntime import on_trigger, credentials, http, notify, ai
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)

@on_trigger
def run(event):
    end = date.today().replace(day=1)
    start = (end - timedelta(days=1)).replace(day=1)
    prev = (start - timedelta(days=1)).replace(day=1)
    rows = sb("GET", f"market_data?date=gte.{prev}&date=lt.{end}&select=area,date,avg_rent")
    def avg(area, a, b):
        vals = [r["avg_rent"] for r in rows if r["area"] == area and str(a) <= r["date"] < str(b)]
        return mean(vals) if vals else None
    lines = []
    for area in sorted({r["area"] for r in rows}):
        now, before = avg(area, start, end), avg(area, prev, start)
        if now and before:
            lines.append(f"{area}: {now:,.0f} ({(now / before - 1):+.1%})")
    figures = "\n".join(lines)
    summary = ai.generate(f"Write a 3-sentence plain summary of these monthly average rent changes by area:\n{figures}", max_output_tokens=150).text
    notify.slack(f"*{start:%B %Y} market summary*\n{figures}\n\n{summary}", channel="#updates")
    return {"areas": len(lines)}