Quote:
Originally Posted by kido.resuri
What trigger could be used? How to (easily) check if the book is added?
|
Off the top of my head I don't know. What I do know is that when a book is added by the firmware there are multiple inserts into the content, volume_content, Event, AnalyticsEvents and Activity tables. A downloaded book can also get rows in content_keys, volume_tabs, Reviews, Bookmark and ShelfContent (the last two will mean the book has been on a Kobo device or app before).
Potentially, there would need to be a trigger for each of these tables. They would probably be "BEFORE INSERT" and fiddle with the various columns in the table which include the file path. The exact trigger wouldn't be hard to work out.