issue_comments
2 rows where issue = 462430920
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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]);