Task: Get Generated ID After SQLite Insert
Task: Get Generated ID After SQLite Insert: a task in Terminal-Lego-15k (Harbor dataset). When inserting a row into a SQLite database, you often need to retrieve the auto-generated primary key (ID) of the newly inserted row. A naive approach would be to query the database again to find the…
The task
When inserting a row into a SQLite database, you often need to retrieve the auto-generated primary key (ID) of the newly inserted row. A naive approach would be to query the database again to find the inserted row, but this is inefficient and error-prone in concurrent scenarios.
Part of PrimeIntellect/Terminal-Lego-15k.