There exists a table. I added the modified_by field as shown below. I
also tried the second version which is what I really want.
db.define_table('DOCUMENTATION',
Field('documentation_type','string'),
Field('modified_by', 'reference auth_user',
default=auth.user_id, update=auth.user_id, writable=False))
db.define_table('DOCUMENTATION',
Field('documentation_type','string'),
Field('modified_by', 'string',
default=auth.user, update=auth.user, writable=False))
I then modify (via SQLForm) a row in the table. checking the database with
SQL I can see that the modified_by column is added to the table. But the
row that I modified is null.
Why: I know auth has record versioning, but I have multiple application
that use the database. I use triggers to audit changes to key reference
tables. In these triggers I see "web2py" in the application field (nice
for setting that). I'd like to have the modified_by field update with each
change to make it easier to see who did what.
-- end of question
New to the software. Liking it very much. thanks to all those who
contribute.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
