home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 660536265

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/43#issuecomment-660536265 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/43 660536265 MDEyOklzc3VlQ29tbWVudDY2MDUzNjI2NQ== 9599 2020-07-18T20:15:12Z 2020-07-18T20:15:12Z MEMBER

I want to create a SQL query which shows me all of my repositories that have commits that are NOT in the most recent release.

The releases table doesn't have enough information for this because it doesn't tell you the commit hash associated with each release, just the tag: https://github-to-sqlite.dogsheep.net/github/releases

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