issue_comments

Table actions

3 rows where issue = 610843136

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

id ▼ html_url issue_url node_id user created_at updated_at author_association body reactions issue performed_via_github_app
622461537 https://github.com/dogsheep/github-to-sqlite/issues/37#issuecomment-622461537 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/37 MDEyOklzc3VlQ29tbWVudDYyMjQ2MTUzNw== simonw 9599 2020-05-01T16:35:40Z 2020-05-01T16:35:40Z MEMBER This will check if the view exists and has the exact same matching definition as the one we want. If it doesn't, we will drop it (if it exists) and recreate it. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Mechanism for creating views if they don't yet exist 610843136  
622461948 https://github.com/dogsheep/github-to-sqlite/issues/37#issuecomment-622461948 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/37 MDEyOklzc3VlQ29tbWVudDYyMjQ2MTk0OA== simonw 9599 2020-05-01T16:36:42Z 2020-05-01T16:36:42Z MEMBER It should only create views if the underlying tables exist. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Mechanism for creating views if they don't yet exist 610843136  
622978173 https://github.com/dogsheep/github-to-sqlite/issues/37#issuecomment-622978173 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/37 MDEyOklzc3VlQ29tbWVudDYyMjk3ODE3Mw== simonw 9599 2020-05-02T16:19:31Z 2020-05-02T16:19:47Z MEMBER I can use the new `.create_view(..., replace=True)` parameter in `sqlite-utils` 2.7.2 for this. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Mechanism for creating views if they don't yet exist 610843136  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
, [performed_via_github_app] TEXT);
CREATE INDEX [idx_issue_comments_issue]
                ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
                ON [issue_comments] ([user]);