issue_comments

Table actions

7 rows where issue = 1166731361

✎ 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
1065377926 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065377926 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gGCG simonw 9599 2022-03-11T18:34:05Z 2022-03-11T18:34:05Z OWNER Two options: - Delete and recreate the release on GitHub, triggering it to be fixed on Read The Docs (as the `stable` version) - but cancel the push to PyPI, since that platform doesn't allow package versions to be over-written and in this case since the changelog file isn't included in the PyPI package there should be no change at all - Push a 3.25.2 release. I'm going to try and do that first option. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  
1065378902 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065378902 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gGRW simonw 9599 2022-03-11T18:35:26Z 2022-03-11T18:35:26Z OWNER I deleted both the release and the tag from GitHub using the web interface. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  
1065379528 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065379528 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gGbI simonw 9599 2022-03-11T18:36:17Z 2022-03-11T18:36:17Z OWNER I created a new tag and release: https://github.com/simonw/sqlite-utils/releases/tag/3.25.1 And I cancelled the publish workflow: https://github.com/simonw/sqlite-utils/actions/runs/1970415399 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  
1065380286 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065380286 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gGm- simonw 9599 2022-03-11T18:37:23Z 2022-03-11T18:37:23Z OWNER On ReadTheDocs that triggered a new `stable` build but it didn't seem to trigger a new build of `3.25.1`: https://readthedocs.org/projects/sqlite-utils/builds/ <img width="844" alt="image" src="https://user-images.githubusercontent.com/9599/157931210-80505416-509d-4c28-a894-b3f856ce0661.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  
1065381047 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065381047 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gGy3 simonw 9599 2022-03-11T18:38:27Z 2022-03-11T18:38:27Z OWNER OK that fixed it here: https://sqlite-utils.datasette.io/en/stable/changelog.html I'm going to trigger a rebuild of `3.25.1` too: <img width="881" alt="CleanShot 2022-03-11 at 10 37 33@2x" src="https://user-images.githubusercontent.com/9599/157931383-24682894-90be-4ede-b316-18efadbaf84b.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  
1065382145 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065382145 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gHEB simonw 9599 2022-03-11T18:39:05Z 2022-03-11T18:39:05Z OWNER https://sqlite-utils.datasette.io/en/3.25.1/changelog.html is currently wrong: <img width="971" alt="image" src="https://user-images.githubusercontent.com/9599/157931484-479f04ea-700c-4daf-8b63-10f3d8d40a94.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  
1065384183 https://github.com/simonw/sqlite-utils/issues/414#issuecomment-1065384183 https://api.github.com/repos/simonw/sqlite-utils/issues/414 IC_kwDOCGYnMM4_gHj3 simonw 9599 2022-03-11T18:40:39Z 2022-03-11T18:40:39Z OWNER That fixed it: <img width="971" alt="image" src="https://user-images.githubusercontent.com/9599/157931695-383a0454-127e-4978-8888-eeccae0b40ad.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} I forgot to include the changelog in the 3.25.1 release 1166731361  

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