issue_comments
8 rows where "updated_at" is on date 2022-10-18 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: issue_url, issue
created_at (date) 1 ✖
id ▲ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
1282830806 | https://github.com/simonw/sqlite-utils/issues/501#issuecomment-1282830806 | https://api.github.com/repos/simonw/sqlite-utils/issues/501 | IC_kwDOCGYnMM5MdnHW | simonw 9599 | 2022-10-18T18:23:36Z | 2022-10-18T18:23:36Z | OWNER | Tests pass now. Updated docs: - https://sqlite-utils.datasette.io/en/latest/cli.html#table-formatted-output - https://sqlite-utils.datasette.io/en/latest/cli-reference.html#query - and many other places on that page | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Tests failing due to updated tabulate library 1413641049 | |
1282819035 | https://github.com/simonw/sqlite-utils/issues/501#issuecomment-1282819035 | https://api.github.com/repos/simonw/sqlite-utils/issues/501 | IC_kwDOCGYnMM5MdkPb | simonw 9599 | 2022-10-18T18:15:05Z | 2022-10-18T18:15:05Z | OWNER | I'm going to skip the cog test on Python 3.6 to address this. The documentation on the website will show the available list of options for 3.7 and higher. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Tests failing due to updated tabulate library 1413641049 | |
1282817901 | https://github.com/simonw/sqlite-utils/issues/501#issuecomment-1282817901 | https://api.github.com/repos/simonw/sqlite-utils/issues/501 | IC_kwDOCGYnMM5Mdj9t | simonw 9599 | 2022-10-18T18:14:35Z | 2022-10-18T18:14:35Z | OWNER | Now the 3.6 tests fail - because the new release of tabulate dropped support for that Python version (so on Python 3.6 you get an older version): https://github.com/simonw/sqlite-utils/actions/runs/3275842849/jobs/5391181675 https://github.com/astanin/python-tabulate/blame/20c6370d5da2dae89b305bfb6c7f12a0f8b7236c/pyproject.toml#L22 shows minimum is 3.7 now. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Tests failing due to updated tabulate library 1413641049 | |
1282813168 | https://github.com/simonw/sqlite-utils/issues/501#issuecomment-1282813168 | https://api.github.com/repos/simonw/sqlite-utils/issues/501 | IC_kwDOCGYnMM5Mdizw | simonw 9599 | 2022-10-18T18:12:15Z | 2022-10-18T18:12:15Z | OWNER | Here's the new Tabulate release: - https://github.com/astanin/python-tabulate/releases/tag/v0.9.0 - https://github.com/astanin/python-tabulate/compare/v0.8.10...v0.9.0 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Tests failing due to updated tabulate library 1413641049 | |
1282800547 | https://github.com/simonw/sqlite-utils/issues/500#issuecomment-1282800547 | https://api.github.com/repos/simonw/sqlite-utils/issues/500 | IC_kwDOCGYnMM5Mdfuj | simonw 9599 | 2022-10-18T18:02:09Z | 2022-10-18T18:02:09Z | OWNER | Documentation: https://sqlite-utils.datasette.io/en/latest/reference.html#sqlite-utils-utils-flatten | {"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0} | Turn --flatten into a documented utility function 1413610718 | |
1282780770 | https://github.com/simonw/sqlite-utils/issues/500#issuecomment-1282780770 | https://api.github.com/repos/simonw/sqlite-utils/issues/500 | IC_kwDOCGYnMM5Mda5i | simonw 9599 | 2022-10-18T17:45:56Z | 2022-10-18T17:46:05Z | OWNER | I think the public interface is a `flatten(row)` function that does `dict(_flatten(row))`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Turn --flatten into a documented utility function 1413610718 | |
1282779755 | https://github.com/simonw/sqlite-utils/issues/500#issuecomment-1282779755 | https://api.github.com/repos/simonw/sqlite-utils/issues/500 | IC_kwDOCGYnMM5Mdapr | simonw 9599 | 2022-10-18T17:45:10Z | 2022-10-18T17:45:10Z | OWNER | It should go in `sqlite_utils.utils` - documented here: https://sqlite-utils.datasette.io/en/stable/reference.html#sqlite-utils-utils | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Turn --flatten into a documented utility function 1413610718 | |
1282778928 | https://github.com/simonw/sqlite-utils/issues/500#issuecomment-1282778928 | https://api.github.com/repos/simonw/sqlite-utils/issues/500 | IC_kwDOCGYnMM5Mdacw | simonw 9599 | 2022-10-18T17:44:20Z | 2022-10-18T17:44:20Z | OWNER | Here's how it works: https://github.com/simonw/sqlite-utils/blob/d792dad1cf5f16525da81b1e162fb71d469995f3/sqlite_utils/cli.py#L1847-L1848 https://github.com/simonw/sqlite-utils/blob/d792dad1cf5f16525da81b1e162fb71d469995f3/sqlite_utils/cli.py#L1082-L1088 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Turn --flatten into a documented utility function 1413610718 |
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]);
updated_at (date) 1 ✖