issue_comments

Table actions

3 rows where issue = 1386562662

✎ View and edit SQL

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
1258476455 https://github.com/simonw/sqlite-utils/issues/493#issuecomment-1258476455 https://api.github.com/repos/simonw/sqlite-utils/issues/493 IC_kwDOCGYnMM5LAtOn simonw 9599 2022-09-26T19:01:49Z 2022-09-26T19:01:49Z OWNER I tried the tips in https://stackoverflow.com/questions/15258831/how-to-handle-two-dashes-in-rest (not the settings change though, because I might want smart quotes elsewhere) and they didn't work. Maybe I should disable smart quotes entirely? I feel like there should be an escaping trick that works here though. I tried `insert -\\-convert` but it didn't help. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Tiny typographical error in install/uninstall docs 1386562662  
1264219650 https://github.com/simonw/sqlite-utils/issues/493#issuecomment-1264219650 https://api.github.com/repos/simonw/sqlite-utils/issues/493 IC_kwDOCGYnMM5LWnYC chapmanjacobd 7908073 2022-10-01T03:22:50Z 2022-10-01T03:23:58Z CONTRIBUTOR this is likely what you are looking for: https://stackoverflow.com/a/51076749/697964 but yeah I would say just disable smart quotes {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Tiny typographical error in install/uninstall docs 1386562662  
1291166273 https://github.com/simonw/sqlite-utils/issues/493#issuecomment-1291166273 https://api.github.com/repos/simonw/sqlite-utils/issues/493 IC_kwDOCGYnMM5M9aJB simonw 9599 2022-10-25T21:31:15Z 2022-10-25T21:31:15Z OWNER Based on the docs here I tried the following too: https://docutils.sourceforge.io/docs/user/smartquotes.html#description - `\--` - `\\--` - `\\-\\-` - `\-\-` But none of them had the desired effect in this particular piece of markup: the :ref:`insert \--convert <cli_insert_convert>` I think because this is text inside a `:ref:` block, not regular text. Consider the following: The \--convert and the :ref:`insert \--convert <cli_insert_convert>` and It's rendered like this: <img width="328" alt="image" src="https://user-images.githubusercontent.com/9599/197885893-b859f2bd-619b-4406-9688-3a8e592267f5.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Tiny typographical error in install/uninstall docs 1386562662  

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