![]() |
#1 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
[GUI Plugin] Last Modified
This plugin enables the user to have his own custom last_modified column(s), instead of relying on calibre's last_modified which is reserved for internal use and sometimes changes when the books has not been modified. The plugin can update one or more custom date column(s) whenever one or more of the following events happen:
This gives the user more flexibility in defining when a custom #last_modified column(s) should be updated. There is also option to include/exclude changes from certain columns from updating the custom Last modified column(s) (see screenshots). Note that you must add at least one custom date column to be able to use this plugin. Installation Notes:
Special Notes:
Credits
Paypal Donations: Version History: Spoiler:
Last edited by capink; 09-29-2023 at 07:46 AM. Reason: Version 0.8.5 |
![]() |
![]() |
![]() |
#2 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,328
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
First of all: Thank you very much, I'm going to give it a try. I've installed over calibre 5.25 Windows 64 bit and it doesn't start. If I run calibre in debug mode, I find the following log:
Spoiler:
I don't know which the problem is. |
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
Sorry for the mishap. I uploaded a new version.
|
![]() |
![]() |
![]() |
#4 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6,328
Karma: 12117215
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
No need to be sorry, thank you for your work.
|
![]() |
![]() |
![]() |
#5 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,243
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
This'll be useful!
|
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,243
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Question: Does "book metadata change" check for changes in composite columns?
I have it set to change for all columns except for my reading-status (#read, #percentread, #lastread, and a few others). However, I have a composite #currentlyreading column that pulls from those. Should I add that too, or will LM ignore it? Last edited by ownedbycats; 08-13-2021 at 04:32 PM. |
![]() |
![]() |
![]() |
#7 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
No. It does not respond to changes in composite columns.
|
![]() |
![]() |
![]() |
#8 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,243
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Thank you.
![]() |
![]() |
![]() |
![]() |
#9 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
I posted a new version. This version adds a new event called "Book Created" for newly added book(s). In the previous version, the following events were triggred when adding books:
As a result, there were a lot of events per book, and consequently multiple updates to date fields by the plugin when a book was added. This lead to problem when adding multiple books (ThreadViolationError Exception). So, the in the new plugin, all the above events are dropped for newly created books; so they will not update any date field. The only event that is not dropped is the "book_created" event. This makes it cleaner IMO. Also it reduces the frequency of the ThreadViolationError exception, although I am not sure it goes away completely. So people using the plugin can start in debug mode and monitor whether this error is still happening. |
![]() |
![]() |
![]() |
#10 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
Version 0.4.0
Version 0.4.0
|
![]() |
![]() |
![]() |
#11 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,243
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Question: Is it possible that the threading violation error could result in database changes no longer saving as described in this thread?
I read the other thread in Development but it was not clear whether it was a silent error (which I would not have noticed as I keep the debug log minimized) or not. I did do a bulk-edit (if relevant, changing the value of an enumerated column) with the bugged version of Last Modified activated. I checked the books and the #lastmodified datetime was written to OPF and restored with the rest of the database. Last edited by ownedbycats; 08-29-2021 at 04:54 PM. |
![]() |
![]() |
![]() |
#12 | |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
Quote:
Also when testing, I restarted calibre multiple times to test various edits to the plugin, and the added books were always there. I deleted them in mass at the very end. Still cannot be sure. I guess Kovid is better equipped to answer this. Yes, the error was silent. You had to watch the debug output to notice it. |
|
![]() |
![]() |
![]() |
#13 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,243
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Do you also run from source? I am curious whether there'd be any changes to Calibre that weren't present when you were testing that may affect things. I built from source shortly after 5.26 was released (this change wasn't in stable).
Or there could be other factors as to why it would fall over for me but not you. Last edited by ownedbycats; 08-29-2021 at 05:08 PM. |
![]() |
![]() |
![]() |
#14 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,134
Karma: 1954142
Join Date: Aug 2015
Device: Kindle
|
No. I don't run from source, and I don't think that particular change you linked to would make a difference. But maybe there are other factors I am not aware of.
|
![]() |
![]() |
![]() |
#15 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,916
Karma: 7176769
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
A threading violation or any other error while writing the database could cause a transaction to be rolled back. How big is a transaction? My guess: changes to a column for all affected books.
|
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] KindleUnpack - The Plugin | DiapDealer | Plugins | 494 | 05-18-2024 02:34 AM |
[GUI Plugin] Manga plugin | mastertea | Plugins | 6 | 01-06-2022 02:43 AM |
[GUI Plugin] Save Virtual Libraries To Column (GUI) | chaley | Plugins | 14 | 04-04-2021 05:25 AM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |