issues: 449848803

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
449848803 MDU6SXNzdWU0NDk4NDg4MDM= 25 Allow .insert(..., foreign_keys=()) to auto-detect table and primary key 9599 closed 0     4 2019-05-29T14:39:22Z 2019-06-13T05:32:32Z 2019-06-13T05:32:32Z OWNER  

The foreign_keys= argument currently takes a list of triples: python db["usages"].insert_all( usages_to_insert, foreign_keys=( ("line_id", "lines", "id"), ("definition_id", "definitions", "id"), ), ) As of #16 we have a mechanism for detecting the primary key column (the third item in this triple) - we should use that here too, so foreign keys can be optionally defined as a list of pairs.

 140912432 issue     
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/25/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed

Links from other tables