Turn approved Notion feature requests into GitHub issues

from clickruntime import on_trigger, credentials, http, notify, report_fetched

def gh(method, path, **kw):
    resp = http.request(method, f"https://api.github.com{path}", headers={
        "Authorization": f"Bearer {credentials.connection('github', 'work')}", "Accept": "application/vnd.github+json"}, **kw)
    return resp.raise_for_status() or (resp.json() if resp.content else None)
def notion(method, path, **kw):
    resp = http.request(method, f"https://api.notion.com/v1{path}", headers={
        "Authorization": f"Bearer {credentials.secret('NOTION_TOKEN')}", "Notion-Version": "2022-06-28"}, **kw)
    return resp.raise_for_status() or resp.json()

REPO, DB = "acme/app", "your-notion-database-id"

@on_trigger
def run(event):
    pages = notion("POST", f"/databases/{DB}/query", json={"filter": {"and": [
        {"property": "Status", "status": {"equals": "Approved"}}, {"property": "GitHub", "url": {"is_empty": True}}]}})["results"]
    report_fetched(len(pages))
    if not pages:
        return {"created": 0}
    created = []
    for p in pages:
        title = "".join(t["plain_text"] for t in p["properties"]["Name"]["title"])
        desc = "".join(t["plain_text"] for t in p["properties"].get("Description", {}).get("rich_text", []))
        issue = gh("POST", f"/repos/{REPO}/issues", json={"title": title, "labels": ["feature-request"], "body": f"{desc}\n\nNotion: {p['url']}"})
        notion("PATCH", f"/pages/{p['id']}", json={"properties": {"GitHub": {"url": issue["html_url"]}}})
        created.append(f"{title}: {issue['html_url']}")
    notify.email_me(f"{len(created)} feature requests sent to GitHub", "\n".join(created))
    return {"created": len(created)}