[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+)

[gurcha]

Subject: Request: Add support for icon overrides / theming

Hi,

Could you please add support for Calibre's built‑in icon theming in a future update?

Currently your plugin uses a custom get_icon() function, which prevents users from overriding the toolbar icon with their own custom images or Calibre icon themes.

The fix is simple: replace the custom function with Calibre's native get_icons(). For example:

python
# Instead of a custom get_icon() function...
# Use Calibre's built-in function:
from calibre.customize.zipplugin import get_icons

icon = get_icons('icon.png', 'Your Plugin Name')
self.qaction.setIcon(icon)
This would allow users to place a custom icon.png in:
calibre/resources/images/Your Plugin Name/icon.png

And it would also make the plugin respect the user's active Calibre icon theme.

There are actually four icons (audit.png, undo.png, empty.png, wrench-hammer.png) that would all benefit from theming support. So you would need to apply get_icons() to each menu action, not just the main toolbar button, but the main toolbar icon is the most important.

Thank you for considering this. I really appreciate your work on this plugin.

Thanks

[PeterT]

Originally Posted by gurcha

Subject: Request: Add support for icon overrides / theming



Hi,



Could you please add support for Calibre's built‑in icon theming in a future update?



Currently your plugin uses a custom get_icon() function, which prevents users from overriding the toolbar icon with their own custom images or Calibre icon themes.



The fix is simple: replace the custom function with Calibre's native get_icons(). For example:



python

# Instead of a custom get_icon() function...

# Use Calibre's built-in function:

from calibre.customize.zipplugin import get_icons



icon = get_icons('icon.png', 'Your Plugin Name')

self.qaction.setIcon(icon)

This would allow users to place a custom icon.png in:

calibre/resources/images/Your Plugin Name/icon.png



And it would also make the plugin respect the user's active Calibre icon theme.



There are actually four icons (audit.png, undo.png, empty.png, wrench-hammer.png) that would all benefit from theming support. So you would need to apply get_icons() to each menu action, not just the main toolbar button, but the main toolbar icon is the most important.



Thank you for considering this. I really appreciate your work on this plugin.



Thanks

Unfortunately the original author is long gone and noone appears to have stepped up with enhancements

[BetterRed]

See ==>> https://www.mobileread.com/forums/sh...0&postcount=60