issue_comments
7 rows where "updated_at" is on date 2019-07-14 sorted by issue_url
This data as json, CSV (advanced)
Suggested facets: issue_url, issue
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 | |
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 | |
511170166 | https://github.com/simonw/datasette/issues/560#issuecomment-511170166 | https://api.github.com/repos/simonw/datasette/issues/560 | MDEyOklzc3VlQ29tbWVudDUxMTE3MDE2Ng== | simonw 9599 | 2019-07-14T03:31:42Z | 2019-07-14T03:31:42Z | OWNER | ``` TypeError: textarea is null[Learn More] codemirror-5.31.0.js:9508:3 fromTextArea http://127.0.0.1:8001/-/static/codemirror-5.31.0.js:9508 <anonymous> http://127.0.0.1:8001/fixtures:286 ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | CodeMirror fails to load on database page 467790646 | |
511170264 | https://github.com/simonw/datasette/issues/560#issuecomment-511170264 | https://api.github.com/repos/simonw/datasette/issues/560 | MDEyOklzc3VlQ29tbWVudDUxMTE3MDI2NA== | simonw 9599 | 2019-07-14T03:34:24Z | 2019-07-14T03:34:24Z | OWNER | Here's why: https://github.com/simonw/datasette/blob/6abe6faff6b035e9334dd05f8c741ae9b7a47440/datasette/templates/_codemirror_foot.html#L2 This works on the `query.html` template: https://github.com/simonw/datasette/blob/6abe6faff6b035e9334dd05f8c741ae9b7a47440/datasette/templates/query.html#L38 But fails on the `database.html` template: https://github.com/simonw/datasette/blob/6abe6faff6b035e9334dd05f8c741ae9b7a47440/datasette/templates/database.html#L28 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | CodeMirror fails to load on database page 467790646 | |
511216484 | https://github.com/simonw/sqlite-utils/issues/35#issuecomment-511216484 | https://api.github.com/repos/simonw/sqlite-utils/issues/35 | MDEyOklzc3VlQ29tbWVudDUxMTIxNjQ4NA== | simonw 9599 | 2019-07-14T16:26:49Z | 2019-07-14T16:26:49Z | OWNER | The last touched primary key should go in `last_pk`. https://github.com/simonw/sqlite-utils/blob/ba6bd47f15c154e348c3c85c05858053a4ab7bab/docs/python-api.rst#L126 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | table.update(...) method 462430920 | |
511216664 | https://github.com/simonw/sqlite-utils/issues/35#issuecomment-511216664 | https://api.github.com/repos/simonw/sqlite-utils/issues/35 | MDEyOklzc3VlQ29tbWVudDUxMTIxNjY2NA== | simonw 9599 | 2019-07-14T16:29:22Z | 2019-07-14T16:29:22Z | OWNER | Should this support both dictionaries AND keyword arguments? ```python db["events_venues"].update((3, 2), custom_label="Label") ``` Pros: this is quite nice to look at. Cons: would have to continue supporting dictionaries as well, since otherwise you won't be able to update columns with names that are not valid Python identifiers. So now there are two ways. I'm going to stick with dictionaries only for the moment. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | table.update(...) method 462430920 | |
511219187 | https://github.com/simonw/sqlite-utils/pull/38#issuecomment-511219187 | https://api.github.com/repos/simonw/sqlite-utils/issues/38 | MDEyOklzc3VlQ29tbWVudDUxMTIxOTE4Nw== | simonw 9599 | 2019-07-14T17:05:26Z | 2019-07-14T17:05:26Z | OWNER | I think I need to solve #36 (compound primary key support) first. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | table.update() method 467862459 |
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]);
updated_at (date) 1 ✖