Re: Audit Trail

2008-08-20 Thread erikcw
Hi Sergio, I updated my code with your changes, and it still doesn't seem to be working. I don't have the history Manager in my model. Is it working for you? Are you using the latest trunk? Thanks! Erik On Aug 19, 12:15 pm, Sérgio Durand <[EMAIL PROTECTED]> wrote: > Hi people, > > Finally i'

Re: Audit Trail

2008-08-21 Thread Sérgio Durand
Hi Erick, It was working on r8339. I've updated django this morning to r8460 to and still working !! What is "history Manager" that you said ? look how i'm using audit trail: 1) i have my 'ordinary' model (without audit trail feature) 2) i get the audit trail code and drop it into site-packages

Re: Audit Trail

2008-08-24 Thread Larrik Jaerico
Sérgio, Sorry about the **kwargs thing, my fault. I'm the one who patched AuditTrail to reflect the newest version of Django, but since I have some custom code in there I had to go line-by-line and figure out what to bring back to the website. I missed the **kwargs thing, though, it seems. -Larr

Re: audit trail support

2007-04-20 Thread drourke
I would (and do) implement audit trails right in the database itself using the trigger and procedure language that your database provides. In this manner, any front-end application writing to the database will have the audit-trail by default, without need for front-end application support. In ot

Re: audit trail support

2007-04-20 Thread [EMAIL PROTECTED]
Thank you for the advice, David -- you make a good point. How would you track which Django user made which change? Perhaps I could subclass models.Model so save() always fills an (uneditable) field 'updated_by' with the current user. Likewise, we could have an (editable) field "reason_for_chang

Re: audit trail support

2007-04-20 Thread Malcolm Tredinnick
Hi Jason, On Fri, 2007-04-20 at 13:30 -0400, Jason McVetta wrote: > I need to add real audit trail and change-notification support to an > existing Django app and to one that is under development. The best > way to do this, it seems to me, is to add audit support to the Django > framework itself

Re: audit trail support

2007-04-21 Thread Tim Chase
> I will be working on this project as part of my Real Job(tm), > so devoting time to it should not be a problem. However, > before I begin coding, I want the community's input on a few > issues. > > What is the right way, at DB level, to implement the audit > trail? I had two ideas: Todd Schr

Re: audit trail support

2007-04-23 Thread David Larlet
2007/4/20, Jason McVetta <[EMAIL PROTECTED]>: > I need to add real audit trail and change-notification support to an > existing Django app and to one that is under development. The best way to > do this, it seems to me, is to add audit support to the Django framework > itself. My requirements ar

Re: audit trail support

2007-04-23 Thread Jason McVetta
On 4/20/07, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > > In your descriptions below, you remove the ability for a developer to > use manual primary keys, by the sound of it, since one of your special > fields wants to be a single-column primary key. That's not invisible. Does Django currentl

Re: audit trail support

2007-04-23 Thread Jason McVetta
On 4/21/07, Tim Chase <[EMAIL PROTECTED]> wrote: > > Todd Schraml authored a good article in Dr. Dobb's Journal > (http://www.ddj.com/dept/database/184406340) titled _Table > Patterns & Changing Data_ where he discusses five patterns for > keeping historical data, and the requirements that would le

Re: audit trail support

2007-04-23 Thread Jason McVetta
On 4/23/07, David Larlet <[EMAIL PROTECTED]> wrote: > > It's a bit ugly to declare instance hidden variables (pre) but we need to > be > sure that the save/delete is effective (post) before logging it. > It's not beautiful, perhaps, but I may end up doing something very similar. However, one requi

Re: audit trail support

2007-04-23 Thread robin_percy
What about doing both? Write a pre_save record indicating the operation about to be attempted. And a post_save indicating the success of the operation, using a unique identifier to identify the pair. Then if the post_save gets out of sync, you have a record of transactions that may be at fault.

Re: audit trail support

2007-04-24 Thread Jason McVetta
On 4/24/07, robin_percy <[EMAIL PROTECTED]> wrote: > > What about doing both? Write a pre_save record indicating the > operation about to be attempted. And a post_save indicating the > success of the operation, using a unique identifier to identify the > pair. Then if the post_save gets out of s

Re: audit trail support

2007-04-26 Thread Jason McVetta
Here is my current thinking: - No changes to main model tables - Designate a model to be audited by including inner class "Audit" - One shadow table per audited model - Generate shadow tables for all audited models on post_syncdb - Only write to one DB, until multi-db support is com

Re: audit trail functionality in database model

2017-01-21 Thread Mike Dewhirst
You could have a look at Marty Alchin's Pro Django (not really for beginners but ...) on page 263 where he shows how to do almost exactly what you describe. If you got that book it would accelerate your progress in Django anyway. The only downside is it was published in 2008 and Django has move

Re: audit trail functionality in database model

2017-01-21 Thread Fred Stluka
Enrico, I've done this in the past.  I didn't use Django directly for the audit tables.  Instead I defined DB triggers on each primary table that inserted a row of audit values into the audit table.  I can send you sample trigger code that works in Oracle and My

Re: audit trail functionality in database model

2017-01-22 Thread enrico baranski
Hi Mike, thanks for that reference, I will take a look. Enrico -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To

Re: audit trail functionality in database model

2017-01-22 Thread enrico baranski
Hi Fed, the DB trigger approach sounds very exciting to me because I really need to be sure that there is no way to manipulate records without audit trail. I also would be very interested in the trigger code for MySQL you mentioned. You also mentioned that you did something similar in the past

Re: audit trail functionality in database model

2017-01-22 Thread enrico baranski
Thinking about this topic more detailed made me realize that I also need to track the user who performed the insert/change (delete is globally not permitted) actions. However, that are user names managed via Django ... so when i use DB triggers I only can track the MySQL user who is used by the

Re: audit trail functionality in database model

2017-01-22 Thread Fred Stluka
Enrico, the DB trigger approach sounds very exciting to me because I really need to be sure that there is no way to manipulate records without audit trail. I also would be very interested in the trigger code for MySQL you mentioned. OK.  I'll append s

Re: audit trail functionality in database model

2017-01-22 Thread Fred Stluka
Enrico, In the sample MySQL trigger code of my previous message, you'll see that I always store, in the primary table, the string username of the most recent user to update the table.  Therefore, that value is available to the DB trigger as NEW.update_user.

Re: audit trail functionality in database model

2017-01-23 Thread Melvyn Sopacua
On Saturday 21 January 2017 04:15:34 enrico baranski wrote: > I'm quite new to Django and currently experimenting with the database > model. Defining fields appears to be quite intuitive and is well > described in the documentation. However, I am looking into audit > trail functionalities. Don'

Re: audit trail functionality in database model

2017-01-23 Thread Ryan Castner
Django Field History is a great project to audit trail a model field On Saturday, January 21, 2017 at 7:19:57 AM UTC-5, enrico baranski wrote: > > Hi all Django users, > > I'm quite new to Django and currently experimenting with the database > model. Defining fields appears to be quite intuitive

Re: audit trail functionality in database model

2017-01-26 Thread enrico baranski
@Fred: Thanks a lot, that really helped me! enrico -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this g

Re: Audit trail code - avoid multiple foreign key issues?

2009-12-04 Thread Stodge
No progress so far. I know I can do this: attrs[field.name] = copy.copy(field) if attrs[field.name].rel: attrs[field.name].rel.related_name = "audit_%s_%s" % (cls.__name__, field.name) But this doesn't seem to make a difference. I still get: Error: One or