issue_comments

Table actions

3 rows where issue = 1077893013

✎ 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
991960179 https://github.com/simonw/datasette/issues/1551#issuecomment-991960179 https://api.github.com/repos/simonw/datasette/issues/1551 IC_kwDOBm6k_c47IBxz simonw 9599 2021-12-12T19:54:45Z 2021-12-12T19:54:45Z OWNER This is technically a backwards-incompatible for any plugins that use `request.args` - but it's unlikely to break anything. At any rate this needs to happen before Datasette 1.0! {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `keep_blank_values=True` when parsing `request.args` 1077893013  
991960416 https://github.com/simonw/datasette/issues/1551#issuecomment-991960416 https://api.github.com/repos/simonw/datasette/issues/1551 IC_kwDOBm6k_c47IB1g simonw 9599 2021-12-12T19:56:12Z 2021-12-12T19:56:12Z OWNER Python documentation for `parse_qs`: https://docs.python.org/3/library/urllib.parse.html#urllib.parse.parse_qs > The optional argument *keep_blank_values* is a flag indicating whether blank values in percent-encoded queries should be treated as blank strings. A true value indicates that blanks should be retained as blank strings. The default false value indicates that blank values are to be ignored and treated as if they were not included. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `keep_blank_values=True` when parsing `request.args` 1077893013  
991960719 https://github.com/simonw/datasette/issues/1551#issuecomment-991960719 https://api.github.com/repos/simonw/datasette/issues/1551 IC_kwDOBm6k_c47IB6P simonw 9599 2021-12-12T19:58:17Z 2021-12-12T19:58:17Z OWNER Here's an example of the difference that causes: ```pycon >>> import urllib.parse >>> urllib.parse.parse_qs("foo=bar") {'foo': ['bar']} >>> urllib.parse.parse_qs("foo=bar&baz=") {'foo': ['bar']} >>> urllib.parse.parse_qs("foo=bar&baz=", keep_blank_values=True) {'foo': ['bar'], 'baz': ['']} ``` {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `keep_blank_values=True` when parsing `request.args` 1077893013  

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