MobileRead Forums - View Single Post - Calibre "save to disk", "last_modified" field format

bodiccea · 08-26-2018, 05:19 PM

This is exactly what I did in the script above, but with calibre book insertion date instead of last_modified that I lost as you know.

Still not acceptable, but better than nothing. As I said, I will try to find where is stored this "last_modified" information, to try to correct it from an older backup. Using a "MAX()" will be a plus if it is true that book insertion date in calibre could change too in some situations (not sure of that, but I did read something about it, I forgot where).

But if you know where it is, I will take it :-) Surely not in the metadata.opf, I just made a test. So it should be in the epub file itself

Just found something: In main DB (metadata.db, a SQLite 3.0 database, which is at the root of your library). The table "Books" seems to contain this "last_modified" field. Too late today, but I will confirm with a few books after making some metatadata changes. If confirmed, it will be easy to extract this date from the DB.

bod.

08-26-2018, 05:19 PM	#17
bodiccea Member Posts: 11 Karma: 10 Join Date: Aug 2018 Device: samsung tablet 8", kitkai	This is exactly what I did in the script above, but with calibre book insertion date instead of last_modified that I lost as you know. Still not acceptable, but better than nothing. As I said, I will try to find where is stored this "last_modified" information, to try to correct it from an older backup. Using a "MAX()" will be a plus if it is true that book insertion date in calibre could change too in some situations (not sure of that, but I did read something about it, I forgot where). But if you know where it is, I will take it :-) Surely not in the metadata.opf, I just made a test. So it should be in the epub file itself Just found something: In main DB (metadata.db, a SQLite 3.0 database, which is at the root of your library). The table "Books" seems to contain this "last_modified" field. Too late today, but I will confirm with a few books after making some metatadata changes. If confirmed, it will be easy to extract this date from the DB. bod. Last edited by bodiccea; 08-26-2018 at 05:42 PM.