issue_comments

Table actions

1 row where issue = 612082842

✎ View and edit SQL

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
623635525 https://github.com/simonw/datasette/issues/755#issuecomment-623635525 https://api.github.com/repos/simonw/datasette/issues/755 MDEyOklzc3VlQ29tbWVudDYyMzYzNTUyNQ== simonw 9599 2020-05-04T18:40:15Z 2020-05-04T18:40:15Z OWNER ``` $ pytest tests/test_database.py -v ================================================================================ test session starts ================================================================================= platform darwin -- Python 3.7.7, pytest-5.2.4, py-1.8.1, pluggy-0.13.1 -- /Users/simon/.local/share/virtualenvs/datasette-AWNrQs95/bin/python cachedir: .pytest_cache rootdir: /Users/simon/Dropbox/Development/datasette, inifile: pytest.ini plugins: asyncio-0.10.0 collected 9 items tests/test_database.py::test_table_exists[tables0-True] PASSED [ 11%] tests/test_database.py::test_table_exists[tables1-False] PASSED [ 22%] tests/test_database.py::test_get_all_foreign_keys PASSED [ 33%] tests/test_database.py::test_table_names PASSED [ 44%] tests/test_database.py::test_execute_write_block_true PASSED [ 55%] tests/test_database.py::test_execute_write_block_false PASSED [ 66%] tests/test_database.py::test_execute_write_fn_block_false no such column: id PASSED [ 77%] tests/test_database.py::test_execute_write_fn_block_true PASSED … {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Fix "no such column: id" output in tests 612082842  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);