issue_comments

Table actions

2 rows where issue = 787098146

✎ 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
766430644 https://github.com/simonw/datasette/issues/1190#issuecomment-766430644 https://api.github.com/repos/simonw/datasette/issues/1190 MDEyOklzc3VlQ29tbWVudDc2NjQzMDY0NA== simonw 9599 2021-01-24T20:57:03Z 2021-01-24T20:57:03Z OWNER I really like this idea. It feels like an opportunity for a plugin that adds two things: an API endpoint to Datasette for accepting uploaded databases, and a `datasette publish upload` subcommand which can upload files to that endpoint (with some kind of authentication mechanism). {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `datasette publish upload` mechanism for uploading databases to an existing Datasette instance 787098146  
766433153 https://github.com/simonw/datasette/issues/1190#issuecomment-766433153 https://api.github.com/repos/simonw/datasette/issues/1190 MDEyOklzc3VlQ29tbWVudDc2NjQzMzE1Mw== simonw 9599 2021-01-24T21:13:25Z 2021-01-24T21:13:25Z OWNER This ties in to a bunch of other ideas that are in flight at the moment. If you're publishing databases by uploading them, how do you attach metadata? Ideally by baking it into the database file itself, using the mechanism from #1169. How could this interact with the `datasette insert` concept from #1163? Could you pass a CSV file to the `upload` command and have that converted and uploaded for you, or would you create the database file locally using `datasette insert` and then upload it as a separate `datasette upload` step? Lots to think about here. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `datasette publish upload` mechanism for uploading databases to an existing Datasette instance 787098146  

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