issues: 561460274

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
561460274 MDU6SXNzdWU1NjE0NjAyNzQ= 84 .upsert() with hash_id throws error 9599 closed 0     0 2020-02-07T07:08:19Z 2020-02-07T07:17:11Z 2020-02-07T07:17:11Z OWNER  

python db[table_name].upsert_all(rows, hash_id="pk") This throws an error: PrimaryKeyRequired('upsert() requires a pk')

The problem is, if you try this:

python db[table_name].upsert_all(rows, hash_id="pk", pk="pk") You get this error: AssertionError('Use either pk= or hash_id=')

hash_id= should imply that pk= that column.

 140912432 issue     
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/84/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