issue_comments
3 rows where author_association = "OWNER", issue_url = "https://api.github.com/repos/simonw/datasette/issues/1061" and "updated_at" is on date 2020-10-29
This data as json, CSV (advanced)
Suggested facets: updated_at (date)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
719033013 | https://github.com/simonw/datasette/pull/1061#issuecomment-719033013 | https://api.github.com/repos/simonw/datasette/issues/1061 | MDEyOklzc3VlQ29tbWVudDcxOTAzMzAxMw== | simonw 9599 | 2020-10-29T21:27:14Z | 2020-10-29T21:27:14Z | OWNER | Next challenge: link to `.blob` downloads from https://latest.datasette.io/fixtures?sql=select+rowid%2C+data+from+binary_data This will be a bit tricky. Here's how that template works at the moment: https://github.com/simonw/datasette/blob/d6f9ff71378c4eab34dad181c23cfc143a4aef2d/datasette/templates/query.html#L69-L77 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | .blob output renderer 732634375 | |
719035336 | https://github.com/simonw/datasette/pull/1061#issuecomment-719035336 | https://api.github.com/repos/simonw/datasette/issues/1061 | MDEyOklzc3VlQ29tbWVudDcxOTAzNTMzNg== | simonw 9599 | 2020-10-29T21:29:29Z | 2020-10-29T21:29:29Z | OWNER | Those display_rows have already been processed by the `render_cell` plugin hook: https://github.com/simonw/datasette/blob/d6f9ff71378c4eab34dad181c23cfc143a4aef2d/datasette/views/database.py#L320-L346 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | .blob output renderer 732634375 | |
719042601 | https://github.com/simonw/datasette/pull/1061#issuecomment-719042601 | https://api.github.com/repos/simonw/datasette/issues/1061 | MDEyOklzc3VlQ29tbWVudDcxOTA0MjYwMQ== | simonw 9599 | 2020-10-29T21:45:35Z | 2020-10-29T21:50:42Z | OWNER | Moving the CSV work to a separate issue. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | .blob output renderer 732634375 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);