issue_comments
5 rows where issue = 677265716
This data as json, CSV (advanced)
Suggested facets: user, author_association, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 672357176 | https://github.com/simonw/datasette/pull/927#issuecomment-672357176 | https://api.github.com/repos/simonw/datasette/issues/927 | MDEyOklzc3VlQ29tbWVudDY3MjM1NzE3Ng== | simonw 9599 | 2020-08-11T23:32:08Z | 2020-08-11T23:33:09Z | OWNER | Needs documentation and tests. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 'datasette --get' option, refs #926 677265716 | |
| 672357902 | https://github.com/simonw/datasette/pull/927#issuecomment-672357902 | https://api.github.com/repos/simonw/datasette/issues/927 | MDEyOklzc3VlQ29tbWVudDY3MjM1NzkwMg== | simonw 9599 | 2020-08-11T23:32:39Z | 2020-08-11T23:32:39Z | OWNER | It works: ``` $ datasette --get '/:memory:.json?sql=select * from sqlite_master' | jq . { "database": ":memory:", "query_name": null, "rows": [], "truncated": false, "columns": [ "type", "name", "tbl_name", "rootpage", "sql" ], "query": { "sql": "select * from sqlite_master", "params": {} }, "private": false, "allow_execute_sql": true, "query_ms": 0.8032321929931641 } ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 'datasette --get' option, refs #926 677265716 | |
| 672375214 | https://github.com/simonw/datasette/pull/927#issuecomment-672375214 | https://api.github.com/repos/simonw/datasette/issues/927 | MDEyOklzc3VlQ29tbWVudDY3MjM3NTIxNA== | codecov[bot] 22429695 | 2020-08-12T00:01:23Z | 2020-08-12T00:23:45Z | NONE | # [Codecov](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=h1) Report > Merging [#927](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=desc) into [main](https://codecov.io/gh/simonw/datasette/commit/83eda049af3f38d4289118d3576f96b2535084b1&el=desc) will **increase** coverage by `0.39%`. > The diff coverage is `100.00%`. [](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=tree) ```diff @@ Coverage Diff @@ ## main #927 +/- ## ========================================== + Coverage 83.62% 84.02% +0.39% ========================================== Files 27 28 +1 Lines 3682 3774 +92 ========================================== + Hits 3079 3171 +92 Misses 603 603 ``` | [Impacted Files](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=tree) | Coverage Δ | | |---|---|---| | [datasette/cli.py](https://codecov.io/gh/simonw/datasette/pull/927/diff?src=pr&el=tree#diff-ZGF0YXNldHRlL2NsaS5weQ==) | `75.13% <100.00%> (+1.00%)` | :arrow_up: | | [datasette/utils/testing.py](https://codecov.io/gh/simonw/datasette/pull/927/diff?src=pr&el=tree#diff-ZGF0YXNldHRlL3V0aWxzL3Rlc3RpbmcucHk=) | `100.00% <100.00%> (ø)` | | ------ [Continue to review full report at Codecov](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=continue). > **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta) > `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data` > Powered by [Codecov](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=footer). Last update [83eda04...2111da0](https://codecov.io/gh/simonw/datasette/pull/927?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments). | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 'datasette --get' option, refs #926 677265716 | |
| 672382108 | https://github.com/simonw/datasette/pull/927#issuecomment-672382108 | https://api.github.com/repos/simonw/datasette/issues/927 | MDEyOklzc3VlQ29tbWVudDY3MjM4MjEwOA== | simonw 9599 | 2020-08-12T00:09:18Z | 2020-08-12T00:09:18Z | OWNER | Documentation can go here: https://datasette.readthedocs.io/en/latest/getting_started.html#datasette-serve-options | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 'datasette --get' option, refs #926 677265716 | |
| 672391299 | https://github.com/simonw/datasette/pull/927#issuecomment-672391299 | https://api.github.com/repos/simonw/datasette/issues/927 | MDEyOklzc3VlQ29tbWVudDY3MjM5MTI5OQ== | simonw 9599 | 2020-08-12T00:19:20Z | 2020-08-12T00:19:20Z | OWNER | Docs: https://github.com/simonw/datasette/blob/2111da01a03cfc62303b6a4b59ea9f96d22c0f78/docs/getting_started.rst#datasette---get | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 'datasette --get' option, refs #926 677265716 |
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]);