[sqlalchemy] Re: Audit log client side

2008-02-22 Thread sdobrev

check MapperExtensions, u have pre+post ins/upd/del hooks there. 
u may or may not have a mapper for the log-table.

On Friday 22 February 2008 21:21:52 Marco De Felice wrote:
 Hi
 I'm thinking about a simple client side table audit with SA. Given
 the audit log pattern: http://martinfowler.com/ap2/auditLog.html
 wouldn't it be simple to adapt it to a mapped class?
 I was thinking of a log() function inside the mapped class that if
 called saves data into a second table (could it be in a distinct
 log database?) with the same columns + timestamp and current user
 columns. Is there a way to automate this function at the orm level
 without defining additional mappers?

 I'm sorry for the vagueness but I'm really just beginning to
 explore this. Thanks all

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---



[sqlalchemy] Re: Audit log client side

2008-02-22 Thread sdobrev

and, i do have bitemporal pattern implemented at 
http://dbcook.svn.sourceforge.net/viewvc/dbcook/trunk/dbcook/misc/timed2/
it is not at all optimized but is correct.

 check MapperExtensions, u have pre+post ins/upd/del hooks there.
 u may or may not have a mapper for the log-table.

 On Friday 22 February 2008 21:21:52 Marco De Felice wrote:
  Hi
  I'm thinking about a simple client side table audit with SA.
  Given the audit log pattern:
  http://martinfowler.com/ap2/auditLog.html wouldn't it be simple
  to adapt it to a mapped class?
  I was thinking of a log() function inside the mapped class that
  if called saves data into a second table (could it be in a
  distinct log database?) with the same columns + timestamp and
  current user columns. Is there a way to automate this function at
  the orm level without defining additional mappers?
 
  I'm sorry for the vagueness but I'm really just beginning to
  explore this. Thanks all


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---