Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- In [1]: from github import Github
- In [2]: g = Github('oauthtoken')
- In [3]: salt_repo = g.get_repo('saltstack/salt')
- In [4]: salt_repo_issues = salt_repo.get_issues()
- In [5]: import pymysql.cursors
- In [6]: connection = pymysql.connect(host='localhost', user='root', password='Saltstack22', db='db', charset='utf8mb4', curs
- ...: orclass=pymysql.cursors.DictCursor)
- In [7]: try:
- ...: with connection.cursor() as cursor:
- ...: for issue in salt_repo_issues:
- ...: sql = "INSERT INTO `trial_salt_issues_3`(`title`, `created_at`, `updated_at`, `closed_at`) VALUES (%s, %s, %s, %s)"
- ...: cursor.execute(sql, (issue.title, issue.created_at, issue.updated_at, issue.closed_at))
- ...: connection.commit()
- ...: finally:
- ...: connection.close()
Add Comment
Please, Sign In to add comment