Jon Atkinson wrote: > Hello, > > I'd like to add a feature to the web application I'm developing, which > will track the changes to the data in the system. I've created a web > interface for various items of data, and each has a create and an edit > view. > > If possible, I'd like to create a log of who edited or created a piece > of given data, so that when viewing that data I can display a nice > list: "Dave created this on 14/09/2007, Molly edited this on > 17/09/2007" etc.
Jon, What you want is probably this: http://code.djangoproject.com/wiki/AuditTrail This gives you complete auditing of any model you attach it to (except ManyToManyFields currently, I believe), and also by default attaches a timestamp and the type of change (I will be updating it later today to distinguish between inserts and updates, since the necessary ticket landed. It already distinguishes between inserts/updates and deletes). You'll just need to add one extra field, the User field. To add support for saving the user in the audited table, you need to do two things: 1) http://code.djangoproject.com/wiki/CookBookThreadlocalsAndUser This gives you access to the current User. Since the audit table code doesn't have a handle to the request, this is the only other way I know of you can get it. 2) Set up your audit field to use a callback function for that extra trackable field. Something like this: class Person(models.Model): first_name = models.CharField(maxlength=255) last_name = models.CharField(maxlength=255) salary = models.PositiveIntegerField() history = audit.AuditTrail(track_fields=(('change_user', models.IntegerField(), threadlocals.get_current_user),)) This field will then be available in your history and for all of your searching and reporting on the Audit model. I did just write this off the cuff, so let us know if the threadlocals part works out for you. Good luck, George --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
