issue_comments

Table actions

4 rows where issue = 658476055

✎ 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
659610687 https://github.com/simonw/datasette/issues/896#issuecomment-659610687 https://api.github.com/repos/simonw/datasette/issues/896 MDEyOklzc3VlQ29tbWVudDY1OTYxMDY4Nw== simonw 9599 2020-07-16T19:05:43Z 2020-07-16T19:05:43Z OWNER I'm going to give this a go - if it turns out to be a bad idea I can revert it back out again. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Use white-space: pre-wrap on ALL table cell contents 658476055  
659615034 https://github.com/simonw/datasette/issues/896#issuecomment-659615034 https://api.github.com/repos/simonw/datasette/issues/896 MDEyOklzc3VlQ29tbWVudDY1OTYxNTAzNA== simonw 9599 2020-07-16T19:14:07Z 2020-07-16T19:14:07Z OWNER Demo: https://srccon-2020.datasette.io/srccon?sql=select+id%2C+day%2C+time%2C+event_name%2C+event_description%2C+facilitators+from+sessions+order+by+event_dtstart+limit+101 I really like this: <img width="1396" alt="srccon__select_id__day__time__event_name__event_description__facilitators_from_sessions_order_by_event_dtstart_limit_101" src="https://user-images.githubusercontent.com/9599/87712630-d228da00-c75d-11ea-8f44-69886e599a07.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Use white-space: pre-wrap on ALL table cell contents 658476055  
659734703 https://github.com/simonw/datasette/issues/896#issuecomment-659734703 https://api.github.com/repos/simonw/datasette/issues/896 MDEyOklzc3VlQ29tbWVudDY1OTczNDcwMw== simonw 9599 2020-07-16T23:34:57Z 2020-07-16T23:34:57Z OWNER I'm worried about how this will interact with some of the plugins: * https://github.com/simonw/datasette-json-html * https://github.com/simonw/datasette-pretty-json {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Use white-space: pre-wrap on ALL table cell contents 658476055  
659773897 https://github.com/simonw/datasette/issues/896#issuecomment-659773897 https://api.github.com/repos/simonw/datasette/issues/896 MDEyOklzc3VlQ29tbWVudDY1OTc3Mzg5Nw== simonw 9599 2020-07-17T01:26:08Z 2020-07-17T01:26:08Z OWNER I manually tested it with those plugins and it seems to interoperate just fine - since both of those use `<pre>` tags for the cases that I care about so they're already expecting white-space to be pre wrapped in some way. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Use white-space: pre-wrap on ALL table cell contents 658476055  

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