issue_comments
18 rows where "updated_at" is on date 2020-05-04 sorted by issue_url
This data as json, CSV (advanced)
Suggested facets: issue_url, created_at (date)
id | html_url | issue_url ▼ | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
623232984 | https://github.com/dogsheep/dogsheep-photos/issues/1#issuecomment-623232984 | https://api.github.com/repos/dogsheep/dogsheep-photos/issues/1 | MDEyOklzc3VlQ29tbWVudDYyMzIzMjk4NA== | simonw 9599 | 2020-05-04T02:41:32Z | 2020-05-04T02:41:32Z | MEMBER | Needs documentation. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Import photo metadata from Apple Photos into SQLite 602533300 | |
623723026 | https://github.com/dogsheep/dogsheep-photos/issues/15#issuecomment-623723026 | https://api.github.com/repos/dogsheep/dogsheep-photos/issues/15 | MDEyOklzc3VlQ29tbWVudDYyMzcyMzAyNg== | simonw 9599 | 2020-05-04T21:41:30Z | 2020-05-04T21:41:30Z | MEMBER | I'm going to put these in a table called `apple_photos_scores` - I'll also pull in the following columns from the `ZGENERICASSET` table: * `ZOVERALLAESTHETICSCORE` * `ZCURATIONSCORE` * `ZHIGHLIGHTVISIBILITYSCORE` * `ZPROMOTIONSCORE` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Expose scores from ZCOMPUTEDASSETATTRIBUTES 612151767 | |
623723687 | https://github.com/dogsheep/dogsheep-photos/issues/15#issuecomment-623723687 | https://api.github.com/repos/dogsheep/dogsheep-photos/issues/15 | MDEyOklzc3VlQ29tbWVudDYyMzcyMzY4Nw== | simonw 9599 | 2020-05-04T21:43:06Z | 2020-05-04T21:43:06Z | MEMBER | It looks like I can map the photos I'm importing to these tables using the `ZUUID` column on `ZGENERICASSET` to get a `Z_PK` which then maps to the rows in `ZGENERICASSET`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Expose scores from ZCOMPUTEDASSETATTRIBUTES 612151767 | |
623730934 | https://github.com/dogsheep/dogsheep-photos/issues/15#issuecomment-623730934 | https://api.github.com/repos/dogsheep/dogsheep-photos/issues/15 | MDEyOklzc3VlQ29tbWVudDYyMzczMDkzNA== | simonw 9599 | 2020-05-04T22:00:38Z | 2020-05-04T22:00:48Z | MEMBER | Here's the query to create the new table: ```sql create table apple_photos_scores as select ZGENERICASSET.ZUUID, ZGENERICASSET.ZOVERALLAESTHETICSCORE, ZGENERICASSET.ZCURATIONSCORE, ZGENERICASSET.ZPROMOTIONSCORE, ZGENERICASSET.ZHIGHLIGHTVISIBILITYSCORE, ZCOMPUTEDASSETATTRIBUTES.ZBEHAVIORALSCORE, ZCOMPUTEDASSETATTRIBUTES.ZFAILURESCORE, ZCOMPUTEDASSETATTRIBUTES.ZHARMONIOUSCOLORSCORE, ZCOMPUTEDASSETATTRIBUTES.ZIMMERSIVENESSSCORE, ZCOMPUTEDASSETATTRIBUTES.ZINTERACTIONSCORE, ZCOMPUTEDASSETATTRIBUTES.ZINTERESTINGSUBJECTSCORE, ZCOMPUTEDASSETATTRIBUTES.ZINTRUSIVEOBJECTPRESENCESCORE, ZCOMPUTEDASSETATTRIBUTES.ZLIVELYCOLORSCORE, ZCOMPUTEDASSETATTRIBUTES.ZLOWLIGHT, ZCOMPUTEDASSETATTRIBUTES.ZNOISESCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTCAMERATILTSCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTCOMPOSITIONSCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTLIGHTINGSCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTPATTERNSCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTPERSPECTIVESCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTPOSTPROCESSINGSCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTREFLECTIONSSCORE, ZCOMPUTEDASSETATTRIBUTES.ZPLEASANTSYMMETRYSCORE, ZCOMPUTEDASSETATTRIBUTES.ZSHARPLYFOCUSEDSUBJECTSCORE, ZCOMPUTEDASSETATTRIBUTES.ZTASTEFULLYBLURREDSCORE, ZCOMPUTEDASSETATTRIBUTES.ZWELLCHOSENSUBJECTSCORE, ZCOMPUTEDASSETATTRIBUTES.ZWELLFRAMEDSUBJECTSCORE, ZCOMPUTEDASSETATTRIBUTES.ZWELLTIMEDSHOTSCORE from attached.ZGENERICASSET join attached.ZCOMPUTEDASSETATTRIBUTES on attached.ZGENERICASSET.Z_PK = attached.ZCOMPUTEDASSETATTRIBUTES.Z_PK; ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Expose scores from ZCOMPUTEDASSETATTRIBUTES 612151767 | |
623739934 | https://github.com/dogsheep/dogsheep-photos/issues/15#issuecomment-623739934 | https://api.github.com/repos/dogsheep/dogsheep-photos/issues/15 | MDEyOklzc3VlQ29tbWVudDYyMzczOTkzNA== | simonw 9599 | 2020-05-04T22:24:26Z | 2020-05-04T22:24:26Z | MEMBER | Twitter thread with some examples of photos that are coming up from queries against these scores: https://twitter.com/simonw/status/1257434670750408705 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Expose scores from ZCOMPUTEDASSETATTRIBUTES 612151767 | |
623591293 | https://github.com/simonw/datasette/pull/719#issuecomment-623591293 | https://api.github.com/repos/simonw/datasette/issues/719 | MDEyOklzc3VlQ29tbWVudDYyMzU5MTI5Mw== | simonw 9599 | 2020-05-04T17:14:23Z | 2020-05-04T17:14:23Z | OWNER | Thanks, this is a smart fix. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | asgi: check raw_path is not None 594553553 | |
623560732 | https://github.com/simonw/datasette/pull/725#issuecomment-623560732 | https://api.github.com/repos/simonw/datasette/issues/725 | MDEyOklzc3VlQ29tbWVudDYyMzU2MDczMg== | simonw 9599 | 2020-05-04T16:16:21Z | 2020-05-04T16:16:21Z | OWNER | This may fix #754 warnings. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Update aiofiles requirement from ~=0.4.0 to >=0.4,<0.6 598891570 | |
623623696 | https://github.com/simonw/datasette/pull/725#issuecomment-623623696 | https://api.github.com/repos/simonw/datasette/issues/725 | MDEyOklzc3VlQ29tbWVudDYyMzYyMzY5Ng== | stonebig 4312421 | 2020-05-04T18:16:54Z | 2020-05-04T18:16:54Z | NONE | thanks a lot, Simon | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Update aiofiles requirement from ~=0.4.0 to >=0.4,<0.6 598891570 | |
623463200 | https://github.com/simonw/datasette/pull/730#issuecomment-623463200 | https://api.github.com/repos/simonw/datasette/issues/730 | MDEyOklzc3VlQ29tbWVudDYyMzQ2MzIwMA== | dependabot-preview[bot] 27856297 | 2020-05-04T13:27:22Z | 2020-05-04T13:27:22Z | CONTRIBUTOR | Superseded by #753. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Update pytest-asyncio requirement from ~=0.10.0 to >=0.10,<0.12 604001627 | |
623207541 | https://github.com/simonw/datasette/issues/751#issuecomment-623207541 | https://api.github.com/repos/simonw/datasette/issues/751 | MDEyOklzc3VlQ29tbWVudDYyMzIwNzU0MQ== | simonw 9599 | 2020-05-04T00:13:09Z | 2020-05-04T00:13:09Z | OWNER | Relevant code: https://github.com/simonw/datasette/blob/07e208cc6d9e901b87552c1be2854c220b3f9b6d/datasette/views/table.py#L519-L520 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to set custom default _size on a per-table basis 611540797 | |
623207636 | https://github.com/simonw/datasette/issues/751#issuecomment-623207636 | https://api.github.com/repos/simonw/datasette/issues/751 | MDEyOklzc3VlQ29tbWVudDYyMzIwNzYzNg== | simonw 9599 | 2020-05-04T00:13:46Z | 2020-05-04T00:13:46Z | OWNER | Syntax suggestion: ```json { "databases": { "mydatabase": { "tables": { "example_table": { "sort": "created", "size": 10 } } } } } ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to set custom default _size on a per-table basis 611540797 | |
623207741 | https://github.com/simonw/datasette/issues/751#issuecomment-623207741 | https://api.github.com/repos/simonw/datasette/issues/751 | MDEyOklzc3VlQ29tbWVudDYyMzIwNzc0MQ== | simonw 9599 | 2020-05-04T00:14:35Z | 2020-05-04T00:14:35Z | OWNER | I'm calling it `"size"` for consistency with the querystring parameter `_size=`, even though `"page_size"` might be a more accurate name. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to set custom default _size on a per-table basis 611540797 | |
623598224 | https://github.com/simonw/datasette/issues/752#issuecomment-623598224 | https://api.github.com/repos/simonw/datasette/issues/752 | MDEyOklzc3VlQ29tbWVudDYyMzU5ODIyNA== | simonw 9599 | 2020-05-04T17:28:11Z | 2020-05-04T17:28:20Z | OWNER | Good catch: it looks like we're not specifying the charset for those pages: ``` $ curl -i 'https://latest.datasette.io/404' HTTP/1.1 404 Not Found access-control-allow-origin: * content-type: text/html Date: Mon, 04 May 2020 16:23:25 GMT Server: Google Frontend Content-Length: 605 <!DOCTYPE html> <html> <head> <title>Error 404</title> ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Non-utf8 encoding in exceptionhandlers and custom-pages 611835285 | |
623560217 | https://github.com/simonw/datasette/issues/754#issuecomment-623560217 | https://api.github.com/repos/simonw/datasette/issues/754 | MDEyOklzc3VlQ29tbWVudDYyMzU2MDIxNw== | simonw 9599 | 2020-05-04T16:15:28Z | 2020-05-04T16:15:28Z | OWNER | I think those will be fixed by an upgrade to aiofiles 0.5.0: https://github.com/Tinche/aiofiles/compare/v0.4.0...v0.5.0 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Clean up aiofiles warnings on 3.8 611997130 | |
623561480 | https://github.com/simonw/datasette/issues/754#issuecomment-623561480 | https://api.github.com/repos/simonw/datasette/issues/754 | MDEyOklzc3VlQ29tbWVudDYyMzU2MTQ4MA== | simonw 9599 | 2020-05-04T16:17:42Z | 2020-05-04T16:17:42Z | OWNER | Sure enough this run https://travis-ci.org/github/simonw/datasette/jobs/674415040 from that PR no longer shows the warnings. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Clean up aiofiles warnings on 3.8 611997130 | |
623635525 | https://github.com/simonw/datasette/issues/755#issuecomment-623635525 | https://api.github.com/repos/simonw/datasette/issues/755 | MDEyOklzc3VlQ29tbWVudDYyMzYzNTUyNQ== | simonw 9599 | 2020-05-04T18:40:15Z | 2020-05-04T18:40:15Z | OWNER | ``` $ pytest tests/test_database.py -v ================================================================================ test session starts ================================================================================= platform darwin -- Python 3.7.7, pytest-5.2.4, py-1.8.1, pluggy-0.13.1 -- /Users/simon/.local/share/virtualenvs/datasette-AWNrQs95/bin/python cachedir: .pytest_cache rootdir: /Users/simon/Dropbox/Development/datasette, inifile: pytest.ini plugins: asyncio-0.10.0 collected 9 items tests/test_database.py::test_table_exists[tables0-True] PASSED [ 11%] tests/test_database.py::test_table_exists[tables1-False] PASSED [ 22%] tests/test_database.py::test_get_all_foreign_keys PASSED [ 33%] tests/test_database.py::test_table_names PASSED [ 44%] tests/test_database.py::test_execute_write_block_true PASSED [ 55%] tests/test_database.py::test_execute_write_block_false PASSED [ 66%] tests/test_database.py::test_execute_write_fn_block_false no such column: id PASSED [ 77%] tests/test_database.py::test_execute_write_fn_block_true PASSED … | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Fix "no such column: id" output in tests 612082842 | |
623650324 | https://github.com/simonw/datasette/issues/756#issuecomment-623650324 | https://api.github.com/repos/simonw/datasette/issues/756 | MDEyOklzc3VlQ29tbWVudDYyMzY1MDMyNA== | simonw 9599 | 2020-05-04T19:10:23Z | 2020-05-04T19:10:23Z | OWNER | https://github.com/pipxproject/pipx/issues/79 showed me how to upgrade plugins within the pipx virtual environment. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add pipx to installation documentation 612089949 | |
623654436 | https://github.com/simonw/datasette/issues/756#issuecomment-623654436 | https://api.github.com/repos/simonw/datasette/issues/756 | MDEyOklzc3VlQ29tbWVudDYyMzY1NDQzNg== | simonw 9599 | 2020-05-04T19:19:06Z | 2020-05-04T19:19:06Z | OWNER | New documentation is here: https://datasette.readthedocs.io/en/latest/installation.html#install-using-pipx | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add pipx to installation documentation 612089949 |
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]);
author_association 4 ✖