Get a weekly table of post engagement

import time
from clickruntime import on_trigger, credentials, http, state, notify

G = "https://graph.facebook.com/v21.0"
PAGE_ID = "104857600000000"

def page_token():
    user = credentials.connection("facebook", "work")
    return http.get(f"{G}/{PAGE_ID}", params={"fields": "access_token", "access_token": user}).json()["access_token"]

@on_trigger
def run(event):
    posts = http.get(f"{G}/{PAGE_ID}/posts", params={
        "since": int(time.time()) - 7 * 86400, "access_token": page_token(),
        "fields": "message,permalink_url,reactions.summary(true),comments.summary(true),shares"}).json()["data"]
    rows = []
    for p in posts:
        r, c = p["reactions"]["summary"]["total_count"], p["comments"]["summary"]["total_count"]
        s = (p.get("shares") or {}).get("count", 0)
        rows.append((r + c + s, f"{r:>5} {c:>5} {s:>5}  {(p.get('message') or '')[:50]}\n                   {p['permalink_url']}"))
    rows.sort(reverse=True)
    notify.email_me("Facebook posts this week", "react  comm share\n" + "\n".join(line for _, line in rows))
    history = state.get("weekly_totals") or []
    state.set("weekly_totals", (history + [sum(t for t, _ in rows)])[-52:])
    return {"posts": len(rows)}