issue_comments

Table actions

4 rows where issue = 616271236

✎ 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
627035928 https://github.com/simonw/sqlite-utils/issues/112#issuecomment-627035928 https://api.github.com/repos/simonw/sqlite-utils/issues/112 MDEyOklzc3VlQ29tbWVudDYyNzAzNTkyOA== simonw 9599 2020-05-12T00:24:16Z 2020-05-12T00:24:51Z OWNER I would add `ignore=True/False` as a parameter here: https://github.com/simonw/sqlite-utils/blob/af3f81b540923f2cf04c76cfa81b0d811c0084bf/sqlite_utils/db.py#L731-L761 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} add_foreign_key(...., ignore=True) 616271236  
627036010 https://github.com/simonw/sqlite-utils/issues/112#issuecomment-627036010 https://api.github.com/repos/simonw/sqlite-utils/issues/112 MDEyOklzc3VlQ29tbWVudDYyNzAzNjAxMA== simonw 9599 2020-05-12T00:24:37Z 2020-05-12T00:24:37Z OWNER Here's how it works for `create_view`: https://github.com/simonw/sqlite-utils/blob/af3f81b540923f2cf04c76cfa81b0d811c0084bf/sqlite_utils/db.py#L327-L336 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} add_foreign_key(...., ignore=True) 616271236  
627036475 https://github.com/simonw/sqlite-utils/issues/112#issuecomment-627036475 https://api.github.com/repos/simonw/sqlite-utils/issues/112 MDEyOklzc3VlQ29tbWVudDYyNzAzNjQ3NQ== simonw 9599 2020-05-12T00:26:25Z 2020-05-12T00:26:48Z OWNER Question: if you use `ignore=True` should it still raise an error if one of the columns you referenced does not exist? That's tricky. I'm leaning towards "that's still an error". Are we ignoring an already existing foreign key, or ignoring all errors? {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} add_foreign_key(...., ignore=True) 616271236  
627036749 https://github.com/simonw/sqlite-utils/issues/112#issuecomment-627036749 https://api.github.com/repos/simonw/sqlite-utils/issues/112 MDEyOklzc3VlQ29tbWVudDYyNzAzNjc0OQ== simonw 9599 2020-05-12T00:27:24Z 2020-05-12T00:27:24Z OWNER Here's an example of some code that would be cleaner with this mechanism: https://github.com/dogsheep/swarm-to-sqlite/blob/f4a82633da927cde672c9d9af92930bfca2e3ddf/swarm_to_sqlite/utils.py#L120-L143 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} add_foreign_key(...., ignore=True) 616271236  

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