issue_comments

Table actions

7 rows where issue = 1077243232

✎ 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
991306712 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991306712 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47FiPY simonw 9599 2021-12-10T21:28:27Z 2021-12-10T21:28:27Z OWNER Failures started with this commit, which only touches documentation so is completely unrelated: https://github.com/simonw/sqlite-utils/commit/e328db8eba1fbf29a69eda95dfec861954f9e771 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  
991307422 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991307422 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47Fiae simonw 9599 2021-12-10T21:29:34Z 2021-12-10T21:29:34Z OWNER Here's the test in question. The way it works is a bit weird (deleting everything in the `_fts_data` table in order to force errors that can be fixed with `.rebuild_fts()`): https://github.com/simonw/sqlite-utils/blob/8ae77a6961fed94ef2c9cc81fcfc7c81d222d9a2/tests/test_fts.py#L257-L285 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  
991309002 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991309002 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47FizK simonw 9599 2021-12-10T21:32:14Z 2021-12-10T21:32:14Z OWNER Here's what the method does: https://github.com/simonw/sqlite-utils/blob/e328db8eba1fbf29a69eda95dfec861954f9e771/sqlite_utils/db.py#L1941-L1952 Maybe I don't need a test that deliberately corrupts the database here? Not sure how to test that `rebuild` has been called though. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  
991309759 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991309759 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47Fi-_ simonw 9599 2021-12-10T21:33:18Z 2021-12-10T21:33:18Z OWNER https://www.sqlite.org/fts5.html#the_rebuild_command says: > This command first deletes the entire full-text index, then rebuilds it based on the contents of the table or [content table](https://www.sqlite.org/fts5.html#external_content_tables). It is not available with [contentless tables](https://www.sqlite.org/fts5.html#contentless_tables). > > `INSERT INTO ft(ft) VALUES('rebuild');` {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  
991395919 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991395919 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47F4BP simonw 9599 2021-12-11T00:52:31Z 2021-12-11T00:52:31Z OWNER It turns out `rebuild` does indeed work against content tables, so I can put that in the test instead. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  
991398367 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991398367 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47F4nf simonw 9599 2021-12-11T01:03:14Z 2021-12-11T01:03:14Z OWNER The new test: https://github.com/simonw/sqlite-utils/blob/ee13f98c2c7ca3b819bd0fc55da3108cb6a6434a/tests/test_fts.py#L270-L277 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  
991399604 https://github.com/simonw/sqlite-utils/issues/354#issuecomment-991399604 https://api.github.com/repos/simonw/sqlite-utils/issues/354 IC_kwDOCGYnMM47F460 simonw 9599 2021-12-11T01:08:46Z 2021-12-11T01:08:46Z OWNER That passed! {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Test failure in test_rebuild_fts 1077243232  

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