home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 778842982

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/simonw/sqlite-utils/issues/228#issuecomment-778842982 https://api.github.com/repos/simonw/sqlite-utils/issues/228 778842982 MDEyOklzc3VlQ29tbWVudDc3ODg0Mjk4Mg== 9599 2021-02-14T21:15:11Z 2021-02-14T21:15:11Z OWNER

Implementation tip: I have code that reads the first row and uses it as headers here: https://github.com/simonw/sqlite-utils/blob/8f042ae1fd323995d966a94e8e6df85cc843b938/sqlite_utils/cli.py#L689-L691

So If I want to use unknown1,unknown2... I can do that by reading the first row, counting the number of columns, generating headers based on that range and then continuing to build that generator (maybe with itertools.chain() to replay the record we already read).

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