home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 622213950

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/dogsheep/github-to-sqlite/issues/35#issuecomment-622213950 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/35 622213950 MDEyOklzc3VlQ29tbWVudDYyMjIxMzk1MA== 9599 2020-05-01T02:09:04Z 2020-05-01T02:09:04Z MEMBER

It sped up this query a lot - 2.5s down to 300ms: sql select repos.full_name, json_object( 'href', 'https://github.com/' || repos.full_name || '/issues/' || issues.number, 'label', '#' || issues.number ) as issue, issues.title, users.login, users.id, issues.state, issues.locked, issues.assignee, issues.milestone, issues.comments, issues.created_at, issues.updated_at, issues.closed_at, issues.author_association, issues.pull_request, issues.repo, issues.type from issues join repos on repos.id = issues.repo join users on issues.user = users.id where issues.state = 'open' and issues.user not in (9599, 27856297) and not exists ( select id from issue_comments where issue_comments.user = 9599 and issues.id = issue_comments.issue ) order by issues.updated_at desc;

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
610511450  
Powered by Datasette · Queries took 0.92ms · About: github-to-sqlite