View Single Post
Old 01-16-2019, 06:25 PM   #7
knc1
Going Viral
knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.
 
knc1's Avatar
 
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
Quote:
Originally Posted by mergen3107 View Post
@NiLuJe
thank you for clearing this out!
Okay, so let's leave alone Java booklet.

I am going to approach from different side:
1) I was able to find book length and its current progress in /var/local/cc.db . However, I don't know how to extract these values from shell. I read a few tutorials on sqlite, but they only allow to change values inside the database, not extract them. How can I extract them?
https://www.sqlite.org/lang_select.html
Quote:
2) Chapters structure prorbably I can extract from mobi files themselves. This idea comes from Calibre plug-ins capability. I am thinking on something like preparation files (with chapters info) which are put next to each respective book so that the script can go and find it.
3) The only real problem for now seems to identify which book is currently open. I'll think on it after I solve first two For now I guess I should enter them manually in the script.
Quote:
Originally Posted by j.p.s View Post
Study the SQL command named SELECT
The full application is pre-installed.
See: https://www.sqlite.org/docs.html
And (picture): https://www.sqlite.org/lang.html

There is also both a Lua and a Java interface to the SQLite3 library.
Note: As-built, the pre-installed sqlite3 can not handle the locale setting used by a (very) few of the db tables.

The Lua and the Java interfaces to the SQLite3 library do not have that problem.

Both NiLuJe and myself have stand-alone builds available that can handle any Unicode locale (but they are REALLY BIG files).

Last edited by knc1; 01-16-2019 at 06:32 PM.
knc1 is offline   Reply With Quote