issue_comments
9 rows where author_association = "OWNER", "created_at" is on date 2017-12-09 and "updated_at" is on date 2017-12-09
This data as json, CSV (advanced)
Suggested facets: issue, created_at (date)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
350413422 | https://github.com/simonw/datasette/pull/168#issuecomment-350413422 | https://api.github.com/repos/simonw/datasette/issues/168 | MDEyOklzc3VlQ29tbWVudDM1MDQxMzQyMg== | simonw 9599 | 2017-12-09T01:33:40Z | 2017-12-09T01:33:40Z | OWNER | https://github.com/channelcat/sanic/releases/tag/0.7.0 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Upgrade to Sanic 0.7.0 280662866 | |
350421661 | https://github.com/simonw/datasette/issues/167#issuecomment-350421661 | https://api.github.com/repos/simonw/datasette/issues/167 | MDEyOklzc3VlQ29tbWVudDM1MDQyMTY2MQ== | simonw 9599 | 2017-12-09T03:52:46Z | 2017-12-09T03:52:46Z | OWNER | Input: results from the database, foreign key definitions, primary key definitions, type of page Output: display_columns and display_rows | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Nasty bug: last column not being correctly displayed 280315352 | |
350424595 | https://github.com/simonw/datasette/issues/167#issuecomment-350424595 | https://api.github.com/repos/simonw/datasette/issues/167 | MDEyOklzc3VlQ29tbWVudDM1MDQyNDU5NQ== | simonw 9599 | 2017-12-09T05:08:27Z | 2017-12-09T05:08:27Z | OWNER | Perhaps the row.html and table.html templates should be passed the same data but should themselves decide if they will display the Link column | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Nasty bug: last column not being correctly displayed 280315352 | |
350496258 | https://github.com/simonw/datasette/issues/160#issuecomment-350496258 | https://api.github.com/repos/simonw/datasette/issues/160 | MDEyOklzc3VlQ29tbWVudDM1MDQ5NjI1OA== | simonw 9599 | 2017-12-09T18:29:28Z | 2017-12-09T18:29:28Z | OWNER | Example usage: datasette package --static css:extra-css/ --static js:extra-js/ \ sf-trees.db --template-dir templates/ --tag sf-trees --branch master This creates a local Docker image that includes copies of the templates/, extra-css/ and extra-js/ directories. You can then run it like this: docker run -p 8001:8001 sf-trees For publishing to Zeit now: datasette publish now --static css:extra-css/ --static js:extra-js/ \ sf-trees.db --template-dir templates/ --name sf-trees --branch master Example: https://sf-trees-wbihszoazc.now.sh/sf-trees-02c8ef1/Street_Tree_List For publishing to Heroku: datasette publish heroku --static css:extra-css/ --static js:extra-js/ \ sf-trees.db --template-dir templates/ --branch master | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to bundle and serve additional static files 278208011 | |
350496277 | https://github.com/simonw/datasette/issues/157#issuecomment-350496277 | https://api.github.com/repos/simonw/datasette/issues/157 | MDEyOklzc3VlQ29tbWVudDM1MDQ5NjI3Nw== | simonw 9599 | 2017-12-09T18:29:41Z | 2017-12-09T18:29:41Z | OWNER | Example usage: datasette package --static css:extra-css/ --static js:extra-js/ \ sf-trees.db --template-dir templates/ --tag sf-trees --branch master This creates a local Docker image that includes copies of the templates/, extra-css/ and extra-js/ directories. You can then run it like this: docker run -p 8001:8001 sf-trees For publishing to Zeit now: datasette publish now --static css:extra-css/ --static js:extra-js/ \ sf-trees.db --template-dir templates/ --name sf-trees --branch master Example: https://sf-trees-wbihszoazc.now.sh/sf-trees-02c8ef1/Street_Tree_List For publishing to Heroku: datasette publish heroku --static css:extra-css/ --static js:extra-js/ \ sf-trees.db --template-dir templates/ --branch master | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Teach "datasette publish" about custom template directories 278190321 | |
350506593 | https://github.com/simonw/datasette/issues/170#issuecomment-350506593 | https://api.github.com/repos/simonw/datasette/issues/170 | MDEyOklzc3VlQ29tbWVudDM1MDUwNjU5Mw== | simonw 9599 | 2017-12-09T21:25:50Z | 2017-12-09T21:25:50Z | OWNER | Turns out this is already supported: https://github.com/simonw/datasette/blob/6bdfcf60760c27e29ff34692d06e62b36aeecc56/datasette/app.py#L307 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Custom template for named canned query 280745470 | |
350506751 | https://github.com/simonw/datasette/issues/170#issuecomment-350506751 | https://api.github.com/repos/simonw/datasette/issues/170 | MDEyOklzc3VlQ29tbWVudDM1MDUwNjc1MQ== | simonw 9599 | 2017-12-09T21:28:32Z | 2017-12-09T21:28:32Z | OWNER | My mistake, that's using the database name - there isn't a way of customizing for a specific named query yet. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Custom template for named canned query 280745470 | |
350507155 | https://github.com/simonw/datasette/issues/170#issuecomment-350507155 | https://api.github.com/repos/simonw/datasette/issues/170 | MDEyOklzc3VlQ29tbWVudDM1MDUwNzE1NQ== | simonw 9599 | 2017-12-09T21:35:30Z | 2017-12-09T21:35:30Z | OWNER | Canned query page (/mydatabase/canned-query): query-mydatabase-canned-query.html query-mydatabase.html query.html | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Custom template for named canned query 280745470 | |
350508049 | https://github.com/simonw/datasette/issues/171#issuecomment-350508049 | https://api.github.com/repos/simonw/datasette/issues/171 | MDEyOklzc3VlQ29tbWVudDM1MDUwODA0OQ== | simonw 9599 | 2017-12-09T21:50:50Z | 2017-12-09T21:50:50Z | OWNER | Quoting the new documentation: You can find out which templates were considered for a specific page by viewing source on that page and looking for an HTML comment at the bottom. The comment will look something like this: <!-- Templates considered: *query-mydb-tz.html, query-mydb.html, query.html --> This example is from the canned query page for a query called "tz" in the database called "mydb". The asterisk shows which template was selected - so in this case, Datasette found a template file called `query-mydb-tz.html` and used that - but if that template had not been found, it would have tried for `query-mydb.html` or the default `query.html`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | HTML comments specifying custom templates for page 280745746 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);