issue_comments
13 rows where author_association = "OWNER", "created_at" is on date 2020-10-10 and "updated_at" is on date 2020-10-10
This data as json, CSV (advanced)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
706450418 | https://github.com/simonw/datasette/issues/1010#issuecomment-706450418 | https://api.github.com/repos/simonw/datasette/issues/1010 | MDEyOklzc3VlQ29tbWVudDcwNjQ1MDQxOA== | simonw 9599 | 2020-10-10T00:08:27Z | 2020-10-10T00:09:13Z | OWNER | This commit broke it: https://github.com/simonw/datasette/commit/8f97b9b58e77f82fef1f10e9c9f6754b993544b6#diff-ed4bb3a97b7efa4d45be6a6ea6f4636cL114-R165 <img width="1106" alt="Banners_and_Alerts_and_datasette_client_internal_requests_mechanism_·_simonw_datasette_8f97b9b" src="https://user-images.githubusercontent.com/9599/95640559-25a37f00-0a52-11eb-838e-9f771ab5a413.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | json / CSV links are broken in Datasette 0.50 718484082 | |
706455202 | https://github.com/simonw/datasette/issues/1010#issuecomment-706455202 | https://api.github.com/repos/simonw/datasette/issues/1010 | MDEyOklzc3VlQ29tbWVudDcwNjQ1NTIwMg== | simonw 9599 | 2020-10-10T00:33:46Z | 2020-10-10T00:33:46Z | OWNER | Since this is an urgent fix that needs to go out I've marked the `base_url` tests as `xfail`. I need to solve those separately, see #900 and various other bug reports. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | json / CSV links are broken in Datasette 0.50 718484082 | |
706455505 | https://github.com/simonw/datasette/issues/1010#issuecomment-706455505 | https://api.github.com/repos/simonw/datasette/issues/1010 | MDEyOklzc3VlQ29tbWVudDcwNjQ1NTUwNQ== | simonw 9599 | 2020-10-10T00:35:41Z | 2020-10-10T00:35:41Z | OWNER | I missed the links on the query page: https://latest.datasette.io/fixtures?sql=select+pk1%2C+pk2%2C+pk3%2C+content+from+compound_three_primary_keys+order+by+pk1%2C+pk2%2C+pk3+limit+101 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | json / CSV links are broken in Datasette 0.50 718484082 | |
706473306 | https://github.com/simonw/datasette/issues/1005#issuecomment-706473306 | https://api.github.com/repos/simonw/datasette/issues/1005 | MDEyOklzc3VlQ29tbWVudDcwNjQ3MzMwNg== | simonw 9599 | 2020-10-10T02:45:46Z | 2020-10-10T02:45:46Z | OWNER | https://github.com/simonw/datasette/blob/9f6dd985bc0eff70f8a9ce65c6578bc43d2e172b/tests/test_html.py#L145-L149 https://github.com/simonw/datasette/blob/9f6dd985bc0eff70f8a9ce65c6578bc43d2e172b/tests/test_html.py#L539-L564 https://github.com/simonw/datasette/blob/8f97b9b58e77f82fef1f10e9c9f6754b993544b6/tests/test_api.py#L1190-L1194 https://github.com/simonw/datasette/blob/8f97b9b58e77f82fef1f10e9c9f6754b993544b6/tests/test_api.py#L742-L746 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Remove xfail tests when new httpx is released 718259202 | |
706480763 | https://github.com/simonw/datasette/issues/1011#issuecomment-706480763 | https://api.github.com/repos/simonw/datasette/issues/1011 | MDEyOklzc3VlQ29tbWVudDcwNjQ4MDc2Mw== | simonw 9599 | 2020-10-10T03:42:58Z | 2020-10-10T03:42:58Z | OWNER | Oh no! It's the same bug as #1010. Thanks for the report, I shall push out 0.50.2 as quickly as possible. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | column name links broken in 0.50.1 718521469 | |
706480791 | https://github.com/simonw/datasette/issues/1011#issuecomment-706480791 | https://api.github.com/repos/simonw/datasette/issues/1011 | MDEyOklzc3VlQ29tbWVudDcwNjQ4MDc5MQ== | simonw 9599 | 2020-10-10T03:43:13Z | 2020-10-10T03:43:13Z | OWNER | Demo: click column headers on https://latest.datasette.io/fixtures/compound_three_primary_keys | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | column name links broken in 0.50.1 718521469 | |
706482542 | https://github.com/simonw/datasette/issues/1011#issuecomment-706482542 | https://api.github.com/repos/simonw/datasette/issues/1011 | MDEyOklzc3VlQ29tbWVudDcwNjQ4MjU0Mg== | simonw 9599 | 2020-10-10T03:58:58Z | 2020-10-10T03:58:58Z | OWNER | The fix is live on the demo: https://latest.datasette.io/fixtures/compound_three_primary_keys?_sort_desc=pk2 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | column name links broken in 0.50.1 718521469 | |
706483680 | https://github.com/simonw/datasette/issues/1011#issuecomment-706483680 | https://api.github.com/repos/simonw/datasette/issues/1011 | MDEyOklzc3VlQ29tbWVudDcwNjQ4MzY4MA== | simonw 9599 | 2020-10-10T04:09:32Z | 2020-10-10T04:09:32Z | OWNER | OK, Datasette 0.50.2 is live on PyPI now. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | column name links broken in 0.50.1 718521469 | |
706626796 | https://github.com/simonw/datasette/issues/1014#issuecomment-706626796 | https://api.github.com/repos/simonw/datasette/issues/1014 | MDEyOklzc3VlQ29tbWVudDcwNjYyNjc5Ng== | simonw 9599 | 2020-10-10T23:47:23Z | 2020-10-10T23:48:26Z | OWNER | The GitHub API has these: `link: <https://api.github.com/repositories/107914493/commits?page=2>; rel="next", <https://api.github.com/repositories/107914493/commits?page=46>; rel="last"` WordPress API: https://css-tricks.com/wp-json/wp/v2/posts `link: <https://css-tricks.com/wp-json/wp/v2/posts?page=2>; rel="next"` It also has these: ``` x-wp-total: 5162 x-wp-totalpages: 517 ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add Link: pagination HTTP headers 718723543 | |
706626913 | https://github.com/simonw/datasette/issues/1014#issuecomment-706626913 | https://api.github.com/repos/simonw/datasette/issues/1014 | MDEyOklzc3VlQ29tbWVudDcwNjYyNjkxMw== | simonw 9599 | 2020-10-10T23:49:08Z | 2020-10-10T23:49:08Z | OWNER | This should be documented on https://docs.datasette.io/en/stable/json_api.html | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add Link: pagination HTTP headers 718723543 | |
706626934 | https://github.com/simonw/datasette/issues/1014#issuecomment-706626934 | https://api.github.com/repos/simonw/datasette/issues/1014 | MDEyOklzc3VlQ29tbWVudDcwNjYyNjkzNA== | simonw 9599 | 2020-10-10T23:49:25Z | 2020-10-10T23:49:25Z | OWNER | I'm just going to implement the 'next' one. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add Link: pagination HTTP headers 718723543 | |
706626971 | https://github.com/simonw/datasette/issues/1014#issuecomment-706626971 | https://api.github.com/repos/simonw/datasette/issues/1014 | MDEyOklzc3VlQ29tbWVudDcwNjYyNjk3MQ== | simonw 9599 | 2020-10-10T23:49:57Z | 2020-10-10T23:49:57Z | OWNER | I won't offer a total-number header. That's expensive to calculate - no need to calculate it unless it's explicitly asked for. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add Link: pagination HTTP headers 718723543 | |
706627035 | https://github.com/simonw/datasette/issues/1014#issuecomment-706627035 | https://api.github.com/repos/simonw/datasette/issues/1014 | MDEyOklzc3VlQ29tbWVudDcwNjYyNzAzNQ== | simonw 9599 | 2020-10-10T23:50:40Z | 2020-10-10T23:50:40Z | OWNER | First example page to add this to: `?_shape=array`, e.g. https://latest.datasette.io/fixtures/compound_three_primary_keys.json?_shape=array | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add Link: pagination HTTP headers 718723543 |
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]);