To keep this conversation fairly modular, I'm responding to different possible solutions in different posts. This one is about Carl's comments on:
> 1. Stick some code into the database connector, as I described in > possibility 1 of my original post. I guess the connector would be > the "connection" class? My commenst inserted below are prefaced with "Ken:" On Thursday, October 16, 2014 12:13:20 PM UTC-4, Carl Meyer wrote: > I don't see any way this is feasible, if you want it to cover raw SQL > executed through ``cursor.execute``. Are you planning to parse the SQL > for every raw statement, *Ken: Yes.* > figure out if its an INSERT or UPDATE, *Ken: Yes.* > and then > figure out which row(s) it might affect? Ken: No; at this point my code inserts an element that assigns the user id to "last_updated_by" into the SET clause of an UPDATE query or the VALUES clause of an INSERT query, then hands the modified query back to the connector, which passes it on to the DB. At this point you're well into re-implementing chunks of PostgreSQL in your app code. Ken: No, just a modest bit of parsing and tweaking of SQL queries. My code doesn't have to execute the queries in any way. Ken: Here's how I did it back in the dark ages, when Zope rather than Django was my framework: https://drive.google.com/file/d/0B-thboqjuKZTNG9DR3lqalJaOWM/view?usp=sharing. The db.py module is the query pathway of the ZPsycopgDA adapter. I have changed this out-of-the-box Zope module only by adding the lines I have enclosed here in "ADDED: << ... >>" delimiters. I have added the whole _insert_when_who_updates() function, three lines invoking it from the query() function, and a few import lines. Ken: So to implement this in Django, one would have to find the Django counterpart of ZPsycopgDA.db.py and insert this code in the same way. Ken: Whaddya think? <https://drive.google.com/file/d/0B-thboqjuKZTNG9DR3lqalJaOWM/view?usp=sharing> -- 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 group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b68fba53-11be-47e1-b02f-7740c1647f9c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
