View Single Post
Old 07-27-2013, 05:36 AM   #21
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 22,005
Karma: 30277294
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by chaley View Post
Just tried that. It tosses an exception trying to delete a UUID that isn't there. I have submitted a fix to Kovid.

That said, this method is very slow. It tries to delete each of the "books" in the range, failing for most of them. It would be better to get a list of IDs in the DB and delete those. However ...

I discovered that it wasn't possible to get calibredb to give you a list of only ids. I submitted a fix for that as well. Assuming Kovid accepts it, you will be able to say --fields="" to show only the ids. You would then take that output and feed it into calibredb remove, perhaps something like this on a *nix box
calibredb remove `calibredb list --fields=""`
Thanks chaley - would it not be better to have a remove * and let calibredb get the list of IDs and do whatever

I gave you the wrong steer before, that error I mentioned was something else that I already solved - it was my error

I've not used the calibredb command before.

The copy of the test database I'm using is at "C:\_Sandpit\metadata.db" Where do I put the database path in the "calibredb remove ids" command. I tried putting the db path before 'remove' and after 'ids'

Could you spell it out in a code box so that I can cut and paste please - assume I want to remove books 1-10

BR

ps: I am not too bothered by how long it runs, it will be in a shutdown script.

Last edited by BetterRed; 07-27-2013 at 05:40 AM.
BetterRed is offline   Reply With Quote