issue_comments
3 rows where issue_url = "https://api.github.com/repos/simonw/datasette/issues/1131" and reactions = "{"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}"
This data as json, CSV (advanced)
Suggested facets: created_at (date)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
739083472 | https://github.com/simonw/datasette/issues/1131#issuecomment-739083472 | https://api.github.com/repos/simonw/datasette/issues/1131 | MDEyOklzc3VlQ29tbWVudDczOTA4MzQ3Mg== | simonw 9599 | 2020-12-05T00:01:12Z | 2020-12-05T00:01:12Z | OWNER | Here's why: https://github.com/simonw/datasette/blob/37f87b5e52e7f8ddd1c4ffcf368bd7a62a406a6d/datasette/database.py#L158-L163 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | "datasette inspect" outputs invalid JSON if an error is logged 757481949 | |
739083673 | https://github.com/simonw/datasette/issues/1131#issuecomment-739083673 | https://api.github.com/repos/simonw/datasette/issues/1131 | MDEyOklzc3VlQ29tbWVudDczOTA4MzY3Mw== | simonw 9599 | 2020-12-05T00:02:10Z | 2020-12-05T00:02:10Z | OWNER | https://clig.dev/#the-basics > **Send messaging to stderr**. Log messages, errors, and so on should all be sent to stderr. This means that when commands are piped together, these messages are displayed to the user and not fed into the next command. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | "datasette inspect" outputs invalid JSON if an error is logged 757481949 | |
739414118 | https://github.com/simonw/datasette/issues/1131#issuecomment-739414118 | https://api.github.com/repos/simonw/datasette/issues/1131 | MDEyOklzc3VlQ29tbWVudDczOTQxNDExOA== | simonw 9599 | 2020-12-05T20:48:33Z | 2020-12-05T20:48:33Z | OWNER | Oddly enough, I tried fixing this with `sys.stderr.write("{}\n".format(e))` - but my Click `CLIRunner` tests failed because `result.stderr` was an empty string. Adding `sys.stderr.flush()` to the code that output errors fixed that issue. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | "datasette inspect" outputs invalid JSON if an error is logged 757481949 |
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]);