Touch images folder content (problem?!)

[davidfor]

Originally Posted by PeterT

@GeoffR: I think my approach would be to move the images directory, make a new one, and then for each image found in the SQL database move the corresponding image back to the new images directory.

Not a bad way of doing it. The following query will get the image ids:

SELECT DISTINCT ImageId
FROM content
WHERE ContentType = 6

Then doing a "move ImageId*" to images directory would restore all the cover images for the books the device knows about. There are other images should also to be recovered. The images for the badges are in the directory as well.

I started on adding this to the utilities plugin yesterday. I thought of absurdly simple way of working out the extras files. I just need to finish writing the code to do prompting and the actual deletes.

[PeterT]

Originally Posted by davidfor

Not a bad way of doing it. The following query will get the image ids:

SELECT DISTINCT ImageId
FROM content
WHERE ContentType = 6

Then doing a "move ImageId*" to images directory would restore all the cover images for the books the device knows about. There are other images should also to be recovered. The images for the badges are in the directory as well.

I started on adding this to the utilities plugin yesterday. I thought of absurdly simple way of working out the extras files. I just need to finish writing the code to do prompting and the actual deletes.

Geez; it's at least 12 minutes since you posted... Where's the final version! You're slowing down....

[GeoffR]

Originally Posted by davidfor

Then doing a "move ImageId*" to images directory would restore all the cover images for the books the device knows about. There are other images should also to be recovered. The images for the badges are in the directory as well.

Where there is a book with the same author/title as a recommendation, Calibre shows the recommendation as if it were a duplicate book, so I had missed deleting them when I thought I had deleted all the recommendations. But they can be distinguished from real books because they have zero size, and after deleting them the few extra images remaining in my Glo's images directory are probably just the badges.

So now I know what is going on, it seems the existing Kobo driver does all I need after all. I just need to delete all the old recommendations occasionally and there should be no problem.

[davidfor]

Originally Posted by PeterT

Geez; it's at least 12 minutes since you posted... Where's the final version! You're slowing down....

https://www.mobileread.com/forums/sho...38#post2560238. Happy?

[davidfor]

Originally Posted by davidfor

https://www.mobileread.com/forums/sho...38#post2560238. Happy?

I discovered last night that I had forgotten to attach the beta plugin to that post. See https://www.mobileread.com/forums/sho...60#post2565160 for the latest version. With an attachment.