Get a weekly report on your community

from collections import Counter
from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, http, credentials

GUILD = "GUILD_ID"
MODS_CHANNEL = "MODS_CHANNEL_ID"

def discord(method, path, **kw):
    r = http.request(method, f"https://discord.com/api/v10{path}",
                     headers={"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"}, **kw)
    r.raise_for_status()
    return r.json() if r.content else None

@on_trigger
def run(event):
    since = datetime.now(timezone.utc) - timedelta(days=7)
    members = discord("GET", f"/guilds/{GUILD}/members", params={"limit": 1000})
    joined = sum(1 for m in members if datetime.fromisoformat(m["joined_at"]) >= since)
    counts = Counter()
    for ch in discord("GET", f"/guilds/{GUILD}/channels"):
        if ch["type"] == 0:
            msgs = discord("GET", f"/channels/{ch['id']}/messages", params={"limit": 100})
            counts[ch["name"]] = sum(1 for m in msgs if datetime.fromisoformat(m["timestamp"]) >= since)
    top = "\n".join(f"#{name}: {n}" for name, n in counts.most_common(5))
    discord("POST", f"/channels/{MODS_CHANNEL}/messages",
            json={"content": f"**Last week**\nNew members: {joined}\nBusiest channels:\n{top}"})
    return {"joined": joined}