Github issue update

​​
​

Template request | Bug report​
Tags: #canny #product #operations #snippet #github
Author: Martin Donadieu​
Description: This notebook provides an automated way to keep track of Github issues and their updates.
Input
Install package
pip install PyGithub
Import librairies
import requests
import json
from github import Github
Insert your accounts details
# For Github
gihub_personal_token = (
    "YOUR_GITHUB_TOKEN"  # Settings/Developer settings/Personal access tokens
)
github_repo = "optimusprime2021/api-tester"  # Github repository name
​
# For Canny
canny_post_url = "https://canny.io/api/v1/posts/list"  # Canny post url
canny_apikey = "CANNY_API_KEY"  # Canny api key
Model
Get Canny posts Dataframe
response = requests.get(canny_post_url)
data = {"apiKey": canny_apikey, "id": "", "limit": "100"}
response = requests.post(canny_post_url, data)
post_details = response.json()
Check connection status
if response.status_code == 200:
    print("Successfully connected to Canny")
elif response.status_code == 404:
    print("Couldn't connect to Canny, Please check the credentials")
    exit()
Generating dataframe
import pandas as pd
​
pd.set_option("mode.chained_assignment", None)
dd = post_details["posts"]
df = pd.DataFrame(columns=dd[0].keys())
for i in range(len(dd)):
    df = df.append(dd[i], ignore_index=True)
# df
​
board = []
category = []
tags = []
for i in range(len(df)):
    board.append(df["board"][i]["name"])
    if not df["category"][i]:
        category.append("Not assigned")
    else:
        category.append(df["category"][i]["name"])
    if not df["tags"][i]:
        tags.append("Not assigned")
    else:
        tags.append(df["tags"][i][0]["name"])
​
​
df = df[["title", "status", "details", "url"]]
df["board"] = board
df["category"] = category
df["tags"] = tags
df = df[(df["tags"] == "Awesome-notebooks")]  # tag name
df
## add url to dataframe
Existing issue list
issues = []
g = Github(gihub_personal_token)
repo = g.get_repo(github_repo)
open_issues = repo.get_issues(state="open")
for issue in open_issues:
    issues.append(issue.title)
Output
Push all issues
repo = g.get_repo(github_repo)
for i in df.index:
    if df["title"][i] not in issues:
        repo.create_issue(
            title=df["title"][i],
            body=df["details"][i] + "\n canny url: " + df["url"][i],
        )
Close all issues
# repo = g.get_repo(github_repo)
# open_issues = repo.get_issues(state='open')
# for issue in open_issues:
#     issue.edit(state='closed')
Read
Create
Last modified 1mo ago