[CAY-414] Support for (batch) query interception and audit

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.2 branch
• Fix Version/s: Undefined future
• Component/s: Core Library
• Assignee: Mike Kienenberger
• Reporter: Andrus Adamchik
• Created: 31/Dec/05 10:02
• Updated: 24/Sep/13 20:24
• Resolved: 24/Sep/13 20:24

Description

There is a common need to audit what Cayenne saves to the database. Currently people implement custom solutions, usually based on inspecting ObjectStore or overriding validateFor* on DataObjects. Due to a mismatch between object model and DB schema (after all ORM is intended to hide many DB details, think flattened relationships and such), clean audit is not always possible to be done that way.

Ideally the solution should be intercepting BatchQueries, as this is what is being sent to the database in its raw form. Audit log should be commitable to the DB (two scenarios were mentioned: log committed in the same or in a separate transaction from the main change).

The discussion of the possible design started in this thread:

http://objectstyle.org/cayenne/lists/cayenne-devel/2005/12/0087.html

Not sure if we should implement a standard "cayenne audit" feature, or simply provide needed extension points and post an audit solution as an example. I am more in favor of a second option (simple extension point) as the actual audit requirements may vary from app to app.