Feature request: output number of ignored/replaced rows for insert command

[simonw]

https://hachyderm.io/@briandorsey/109468185742876820

I'm fiddling with piping json to insert -ignore I'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

[simonw]

Right now the command produces no output at all.

Maybe a --verbose mode that writes these numbers to standard error (or even standard output since it's an option)?

Is there a better name than --verbose for this? --summary perhaps?

[briandorsey]

--verbose or --verbosity=ABC were the flags I looked for. Expected to see them at a global level near --version. But only sharing because that's where I looked first, I don't have a strong opinion on the exact wording/location.

[briandorsey]

Current behavior is different when importing via stdin vs. a file. Imports from a file give a progress bar. For this new request, I'd love to see total imported and total ignored/replaced in both cases.

[briandorsey]

Reference: tqdm (https://tqdm.github.io/) shows a progress bar when total is known, and falls back to counting units of work done for streams. File input vs. stdin seems like a similar situation.