Thread: Detecting if book being read / home screen in nickel
View Single Post
Old 09-21-2018, 09:52 PM   #9
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by NiLuJe View Post
@davidfor: Yeah, the timing issue is also compounded by the fact that if you're launching something that kills Nickel, that might effectively rollback (well, discard with WAL) the last few events related to the icon you've just clicked anyway .
(I readily admit to never having checked how well nickel copes with SIGTERM in terms of DB handling, so this point may well be moot ).

But that's definitely worth looking into nonetheless!

EDIT: And, yeah, the icon gets marked as Finished (or 99% Read for stuff that kills Nickel) .
No, that's expected. Nickel tends to mark non-kepubs as finished, but leaves the percent read as 99. I think that when it marks an epub as read, it doesn't update the percent read and just leaves it at whatever was last set.
Quote:
EDIT²: And not much luck either with the DB, in terms of figuring out where we are (especially as far as the Home screen is concerned), either via SELECT * FROM Activity ORDER BY Date; or SELECT * FROM Event ORDER BY LastOccurrence; ;/.
The Activity table wouldn't be useful enough. For the Event, you would have to look for what was the last event out of things like page turn (46), open a book (1020), close a book (1021) and probably a couple of others.
Quote:
EDIT³: Some more luck w/ SELECT * FROM AnalyticsEvents ORDER BY Timestamp;, except that it seems to be updated in short bursts, and not instantaneously :?
I haven't paid much attention to the AnalyticsEvents table. But, it gets cleared periodically, so it might not be helpful.
davidfor is offline   Reply With Quote