[GUI Plugin] Audit Log

[BetterRed]

@Mountain343 - seeing as I sent you here, a brief explanation

The erroneous Tag value "Lost Angles" is not contained within every book record, it is held in a Tags table where each entry has a unique row number and a value. These row numbers are used to relate the Tag values to books records. If you change the value to "Los Angeles" the only thing that changes is that value in the relevant row in the Tags table, the unique number does not change. Hence the relationship between the book record and the Tags table remains valid.

IMO spending a few minutes familiarising oneself with calibre's data base schema via a tool such as DB Browser for SQLite is worth the effort. If you're not familiar with the concepts of relational databases, start with the default library. Of necessity the handling of custom columns is a more complex than the built-in columns.

Stay Safe

BR

[droopy]

Originally Posted by Dopedangel

This plugin seem really useful specially for mass metadata downloads. But I think the name doesn't describe what it does as well as it should. You should name it something like undo metadata or Log for metadata undo.

Sounds like a good suggestion.

[DaltonST]

This plugin seem really useful specially for mass metadata downloads. But I think the name doesn't describe what it does as well as it should. You should name it something like undo metadata or Log for metadata undo.

AL does not "undo" all of the metadata that it logs. Example: Authors. Calibre itself must be used to change Authors back to what they used to be.

99% of AL's value comes from creating an audit-trail (log) of all metadata that has changed, its previous values, and when it was changed. The "undo" function is just a lagniappe that I threw in for good measure in Version 1.0.3.

Without this audit-trail, changing any metadata back to what it was would be impossible, even manually.

With the audit-trail, it is reasonably easy to change it back manually even if the "undo" feature does not exist (such as for Authors). By simply copying and pasting from the Log into the appropriate Calibre Edit Metadata columns, manual changes could easily be made.

I won't narrow or minimize its characterization by renaming it "undo metadata" or "Log for metadata undo".

https://duckduckgo.com/?t=ffab&q=def...tion&iax=about




DaltonST

[droopy]

Hi Dalton.
Thank you for clarifying.

[DaltonST]

Version 1.0.15 - 2020-08-01 Qt tweaks for small displays.


DaltonST

[DaltonST]

Version 1.0.16 - 2020-12-19 Miscellany.


DaltonST

[ownedbycats]

I got this error when trying to "undo logged change". It happened for both the standard series column and a custom taglike column.

calibre, version 5.13.0
ERROR: AL: Undo : Sorry, AL cannot Reverse/Undo the selected line. <br><br><b>Unsupported table_action:    insert

Thank you.

EDIT: Also, just out of curiosity, is the log itself stored the _audit_log table in metatdata.db, or is that used for something else?

[ownedbycats]

I did a bit more testing. The issue seems to happen specifically when reverting an "insert" on a text-based column.

[DaltonST]

Minimum Calibre Version is 5.99.3.



DaltonST

[DaltonST]

New version using only Qt6 & Python 3 has been attached here:

https://www.mobileread.com/forums/sh...6&postcount=24


DaltonST

[DaltonST]

Version 1.0.18 - 2022-04-13 Qt6 Compatibility; Minimum Calibre Version now 6.0.0 (5.99.9+)