issue_comments: 501516797
This data as json
| html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| https://github.com/simonw/sqlite-utils/issues/25#issuecomment-501516797 | https://api.github.com/repos/simonw/sqlite-utils/issues/25 | 501516797 | MDEyOklzc3VlQ29tbWVudDUwMTUxNjc5Nw== | 9599 | 2019-06-13T01:46:36Z | 2019-06-13T01:47:35Z | OWNER | Maybe `foreign_keys` could even optionally just be a list of columns - it could then attempt to detect the related tables based on some rules-of-thumb and raise an error if there's no obvious candidate. Rules: * If the column name ends in `_id`, remove that suffix and look for a matching table. * Try for a table which is the column name without the `_id` suffix with an `s` appended to it * Try for a table that's the exact match for the column name If none of these rules match, raise an error. So the above example could be further simplified to: ```python db["usages"].insert_all( usages_to_insert, foreign_keys=["line_id", "definition_id"] ) ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 449848803 |