Get a weekly pull request report per repo

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

BB = "https://api.bitbucket.org/2.0"

def bb(path, **params):
    resp = http.get(f"{BB}{path}", headers={"Authorization": f"Bearer {credentials.secret('BITBUCKET_TOKEN')}"}, params=params)
    resp.raise_for_status()
    return resp.json()

@on_trigger
def run(event):
    cutoff = datetime.now(timezone.utc) - timedelta(days=7)
    rows = ["repo | opened | merged | declined | authors"]
    for repo in bb("/repositories/acme", pagelen=100)["values"]:
        counts, authors = Counter(), set()
        page = bb(f"/repositories/acme/{repo['slug']}/pullrequests", q='state="MERGED" OR state="DECLINED" OR state="OPEN"',
                  sort="-updated_on", pagelen=50)
        for p in page["values"]:
            if datetime.fromisoformat(p["updated_on"]) < cutoff:
                break
            counts["opened"] += datetime.fromisoformat(p["created_on"]) >= cutoff
            counts[p["state"].lower()] += 1
            authors.add(p["author"]["display_name"])
        if authors:
            rows.append(f"{repo['slug']} | {counts['opened']} | {counts['merged']} | {counts['declined']} | {', '.join(sorted(authors))}")
    notify.email_me("Bitbucket pull requests last week", "\n".join(rows))
    return {"repos": len(rows) - 1}