Hello, I want to implement a change log table something similar to ticket_change table in trac.
ticket_change table structure: Primary key (ticket, time, field) Index (ticket, time) ticket integer (fk to my table "ticket") time inetger author field oldvalue newvalue How can I plugin my sqlalchemy connection / setup so that when it tries to save changes to some table (in this case ticket) it saves the old and new value for that field. Where during the sqlalchemy can I plug it in? A different example: address = Addressbook() address.FirstName = kw['FirstName'] address.LastName = kw['LastName'] DBSession.add(address) DBSession.commit() <---somewhere here for each field would get changed to my address_change table address_id time 234234 author: lucas field: FirstName oldvalue: ' ' newvalue: 'Lucas' address_id time 234234 author: lucas field: LastName oldvalue: ' ' newvalue: 'Mylastname' Ideas on how this can be done? Thanks, Lucas -- Using rsync. How to setup rsyncd. http://lucasmanual.com/mywiki/rsync OpenLdap - From start to finish. http://lucasmanual.com/mywiki/OpenLdap --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---