home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 612707828

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/98#issuecomment-612707828 https://api.github.com/repos/simonw/sqlite-utils/issues/98 612707828 MDEyOklzc3VlQ29tbWVudDYxMjcwNzgyOA== 9599 2020-04-13T01:24:05Z 2020-04-13T01:24:16Z OWNER

Why do I even care about lastrowid here?

I'm trying to ensure that after you insert or upsert a row you can use table.last_pk to start doing things like building additional foreign key relationships.

So maybe it doesn't make sense to make .last_pk available at all for cases where you called .upsert_all() or .insert_all() - it should just be populated for .upsert() and .insert().

The documentation doesn't say it should work for .upsert_all() - it's only documented for the single actions.

https://github.com/simonw/sqlite-utils/blob/6161ebf4de44411b3f33feeacaf4501e803d1116/sqlite_utils/db.py#L1113-L1124

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
597671518  
Powered by Datasette · Queries took 0.995ms · About: github-to-sqlite