Feature request: output number of ignored/replaced rows for insert command
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- Python
- Stars
- 2.2k
- Forks
- 172
- Avg merge
- 9m
- Merged PRs (30d)
- 1
Description
https://hachyderm.io/@briandorsey/109468185742876820
I'm fiddling with piping json to
insert -ignoreI'd love to see the count of records inserted & ignored, but didn't see a way to do that in the help/docs.Example:
xh "https://hachyderm.io/api/v1/timelines/tag/rust?max_id=109443380308326328" | sqlite-utils insert aoc.db aoc - --pk=id --ignore
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the sqlite-utils insert command, its --ignore handling, and the related help or documentation. Trace how inserted, ignored, and replaced rows are currently processed, then define output that reports those counts and verify the command's resulting summary.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- cli, database
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100