[GUI Plugin] Koreader reading time estimate

[Criveratech]

Just thought I'd throw it in here in case anyone aside me is interested in what i made.
This Plugin calculates your wpm reading speed of the books you have on Koreader. It then uses that to show you an estimated reading time for your books.

You need the Count Pages plugin for this, since it relies on the word count being in a column.
(You need to run the Count Pages plugin on any new book before running this plugin)

Needs 3 columns:

• An int column for reading the word count of a book from.
• A float column for storing the reading speed for calculating estimates without a connected device.
• A text column to store the DD:HH:MM:SS reading time estimate in.

Relies on the Koreader statistics sqlite db being present, so statistics need to be enabled.
It can handle reading half/half in Koreader/somewhere else, since it calculates based on how long you took to read each page.

Running this will lock up calibre, for however long it takes (on my end about 40 seconds for 450 books).
If somebody knows how to properly shunt each .sdr retrieval into jobs feel free to show me an example or send me a pr.

If you delete the book+sdr from the device, and then later reupload it from Calibre, most likely it will not remember.
Since Calibre embeds metadata in the Epub when sending, the md5 hash that Koreader uses will likely have changed.
(the connection between a book and the statistics db works off of the partial_md5)

If you've ever used this Plugin with Koreader connected, you can use it to update the estimate for new books without Koreader connected.

Shoutout to KOReader Sync, since that's what i originally used as a base to learn how to make this. (There is probably still snippets of 1:1 code in there)