issue_comments

Table actions

4 rows where issue = 467218270

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, author_association, 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
511052285 https://github.com/simonw/datasette/issues/558#issuecomment-511052285 https://api.github.com/repos/simonw/datasette/issues/558 MDEyOklzc3VlQ29tbWVudDUxMTA1MjI4NQ== simonw 9599 2019-07-12T22:26:35Z 2019-07-14T01:44:32Z OWNER Thanks, this is really useful feedback. I'll take a look at this and see if I can figure out how the new ASGI/Uvicorn stuff differs from Sanic here. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support unicode in url 467218270  
511052658 https://github.com/simonw/datasette/issues/558#issuecomment-511052658 https://api.github.com/repos/simonw/datasette/issues/558 MDEyOklzc3VlQ29tbWVudDUxMTA1MjY1OA== simonw 9599 2019-07-12T22:28:53Z 2019-07-12T22:28:53Z OWNER Are you definitely running the most recent release of uvicorn? The `raw_path` ASGI variable is only available in 0.8.1 or later. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support unicode in url 467218270  
511168964 https://github.com/simonw/datasette/issues/558#issuecomment-511168964 https://api.github.com/repos/simonw/datasette/issues/558 MDEyOklzc3VlQ29tbWVudDUxMTE2ODk2NA== simonw 9599 2019-07-14T02:57:53Z 2019-07-14T02:57:53Z OWNER I think I've fixed it. Here's a demo: https://latest.datasette.io/fixtures/%F0%9D%90%9C%F0%9D%90%A2%F0%9D%90%AD%F0%9D%90%A2%F0%9D%90%9E%F0%9D%90%AC {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support unicode in url 467218270  
511252718 https://github.com/simonw/datasette/issues/558#issuecomment-511252718 https://api.github.com/repos/simonw/datasette/issues/558 MDEyOklzc3VlQ29tbWVudDUxMTI1MjcxOA== 0x1997 380586 2019-07-15T01:29:29Z 2019-07-15T01:29:29Z NONE Thanks, the latest version works. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support unicode in url 467218270  

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]);