issue_comments
8 rows where "created_at" is on date 2019-05-25 and user = 9599
This data as json, CSV (advanced)
Suggested facets: issue_url
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
495818358 | https://github.com/simonw/sqlite-utils/issues/18#issuecomment-495818358 | https://api.github.com/repos/simonw/sqlite-utils/issues/18 | MDEyOklzc3VlQ29tbWVudDQ5NTgxODM1OA== | simonw 9599 | 2019-05-25T00:16:50Z | 2019-05-25T00:16:50Z | OWNER | Oh that's really interesting - yeah I think having an option to insert if missing, skip otherwise would be a good feature. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | .insert/.upsert/.insert_all/.upsert_all should add missing columns 413871266 | |
495818615 | https://github.com/simonw/sqlite-utils/issues/21#issuecomment-495818615 | https://api.github.com/repos/simonw/sqlite-utils/issues/21 | MDEyOklzc3VlQ29tbWVudDQ5NTgxODYxNQ== | simonw 9599 | 2019-05-25T00:19:04Z | 2019-05-25T00:19:04Z | OWNER | I think this can be implemented as an `--ignore` option to `sqlite-utils insert` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Option to ignore inserts if primary key exists already 448391492 | |
495818849 | https://github.com/simonw/sqlite-utils/issues/20#issuecomment-495818849 | https://api.github.com/repos/simonw/sqlite-utils/issues/20 | MDEyOklzc3VlQ29tbWVudDQ5NTgxODg0OQ== | simonw 9599 | 2019-05-25T00:21:04Z | 2019-05-25T00:21:04Z | OWNER | I'm going to implement this using a new `--json-cols` option which works by detecting any string value that starts with [ or { and is valid JSON. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | JSON column values get extraneously quoted 432727685 | |
495823173 | https://github.com/simonw/sqlite-utils/issues/22#issuecomment-495823173 | https://api.github.com/repos/simonw/sqlite-utils/issues/22 | MDEyOklzc3VlQ29tbWVudDQ5NTgyMzE3Mw== | simonw 9599 | 2019-05-25T01:17:55Z | 2019-05-25T01:17:55Z | OWNER | Shipped 1.0 to PyPI! | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Release notes for 1.0 448395665 | |
495823219 | https://github.com/simonw/sqlite-utils/issues/22#issuecomment-495823219 | https://api.github.com/repos/simonw/sqlite-utils/issues/22 | MDEyOklzc3VlQ29tbWVudDQ5NTgyMzIxOQ== | simonw 9599 | 2019-05-25T01:18:27Z | 2019-05-25T01:18:27Z | OWNER | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-0 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Release notes for 1.0 448395665 | |
495929743 | https://github.com/simonw/datasette/pull/365#issuecomment-495929743 | https://api.github.com/repos/simonw/datasette/issues/365 | MDEyOklzc3VlQ29tbWVudDQ5NTkyOTc0Mw== | simonw 9599 | 2019-05-25T16:09:54Z | 2019-05-25T16:09:54Z | OWNER | That last commit referenced the wrong ticket - it was meant to reference #356 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | fix small doc typo 361764460 | |
495931078 | https://github.com/simonw/datasette/issues/356#issuecomment-495931078 | https://api.github.com/repos/simonw/datasette/issues/356 | MDEyOklzc3VlQ29tbWVudDQ5NTkzMTA3OA== | simonw 9599 | 2019-05-25T16:30:09Z | 2019-05-25T16:30:09Z | OWNER | Implemented in https://github.com/simonw/datasette/commit/d923d847545e829bf946bb9170bebfc7c3f9d993 Documentation here: https://datasette.readthedocs.io/en/latest/facets.html#facet-by-many-to-many Demo here: https://latest.datasette.io/fixtures/roadside_attractions | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to display facet counts for many-to-many relationships 346028655 | |
495931140 | https://github.com/simonw/datasette/issues/356#issuecomment-495931140 | https://api.github.com/repos/simonw/datasette/issues/356 | MDEyOklzc3VlQ29tbWVudDQ5NTkzMTE0MA== | simonw 9599 | 2019-05-25T16:30:59Z | 2019-05-25T16:30:59Z | OWNER | I went with a much more simple URL scheme: `?_facet_m2m=destination_table` (it then figures out which the middle table is by looking at the foreign keys). This can be extended to be more complicated in the future if needed. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to display facet counts for many-to-many relationships 346028655 |
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]);