works for me
>>> db= DAL()
>>> from gluon.tools import Auth
>>> auth = Auth(db)
>>> auth.define_tables()
>>> db._common_fields.append(auth.signature)
>>> db.define_table('thing',
Field('name'),
Field('name2',
writable=False,
compute=lambda r: r.name+'xxx'))
>>> auth.enable_record_versioning(db)
>>> print db.thing(2).modified_on
2012-09-08 09:22:28
>>> db.thing(2).update_record(name='test4')
>>> print db.thing(2).modified_on
2012-09-08 12:49:01
Massimo
On Saturday, 8 September 2012 12:48:14 UTC-5, Massimo Di Pierro wrote:
>
> Supposed to work any update_record but let me give it a try.
>
> On Saturday, 8 September 2012 12:39:20 UTC-5, Joel Carrier wrote:
>>
>> At first I thought it was related to running on a windows machine using
>> the development server.
>> Then I deployed to a linux machine using the setup-web2py-ubuntu.sh
>> script
>>
>> Yes, the version is: Version 2.0.8 (2012-09-07 03:47:51) stable
>>
>> db.py:
>>
>> # -*- coding: utf-8 -*-
>> if 0:
>> from gluon.sql import *
>> from gluon.validators import *
>> from gluon import T
>>
>>
>> from gluon import current
>>
>>
>> db = SQLDB('mysql://'+settings.sql_user+':'+settings.sql_password+'@'+
>> settings.db_host+'/'+settings.db_name,migrate=settings.migrate,pool_size=
>> 10)
>>
>>
>> response.generic_patterns = ['*'] #if request.is_local else []
>>
>>
>> current.db = db
>> current.T = T
>>
>>
>> from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
>> auth = Auth(db, hmac_key=settings.hmac_key, salt=True)
>> crud, service, plugins = Crud(db), Service(), PluginManager()
>>
>>
>> current.auth = auth
>>
>>
>> auth.settings.registration_requires_verification = True
>> auth.settings.registration_requires_approval = False
>> auth.settings.reset_password_requires_verification = True
>>
>>
>> db._common_fields.append(auth.signature)
>>
>>
>> db.define_table('auth_user',
>> Field('id','id'),
>> Field('first_name', type='string',
>> label=T('First Name')),
>> Field('last_name', type='string',
>> label=T('Last Name')),
>> Field('email', type='string',
>> label=T('Email')),
>> Field('password', type='password',
>> readable=False,
>> label=T('Password')),
>> Field('date_of_birth', type='date',
>> label=T('Date of Birth')),
>> Field('birth_country','integer'),
>> Field('birth_city'),
>> Field('registration_key',default='',
>> writable=False,readable=False),
>> Field('reset_password_key',default='',
>> writable=False,readable=False),
>> Field('registration_id',default='',
>> writable=False,readable=False),
>> format='[%(id)s] %(first_name)s %(last_name)s',
>> )
>>
>>
>> db.auth_user.first_name.requires = IS_UPPER()
>> db.auth_user.last_name.requires = IS_UPPER()
>> db.auth_user.password.requires = CRYPT(key=auth.settings.hmac_key)
>> db.auth_user.registration_id.requires = IS_NOT_IN_DB(db, db.auth_user.
>> registration_id)
>> db.auth_user.email.requires = (
>> IS_EMAIL(error_message=auth.messages.invalid_email),
>> IS_NOT_IN_DB(db, db.auth_user.email),
>> IS_UPPER()
>> )
>>
>>
>> and in models directory i also have a z.py
>>
>> auth.enable_record_versioning(db)
>>
>> Do I have to update my entities using SQLForms only? Or is it suppose to
>> work with any .update_record()?
>>
>> Thanks for your help!
>>
>>
>> On Saturday, September 8, 2012 10:23:05 AM UTC-4, Massimo Di Pierro wrote:
>>>
>>> I am trying to reproduce the problem but I cannot. Are you running 2.0.8?
>>>
>>> On Saturday, 8 September 2012 07:34:19 UTC-5, Joel Carrier wrote:
>>>>
>>>> I want to maintain an audit history of all my objects.
>>>>
>>>> So near the beginning of my model definition I have
>>>>
>>>> db._common_fields.append(auth.signature)
>>>>
>>>> and at the very end I have
>>>>
>>>> auth.enable_record_versioning(db)
>>>>
>>>> The problem I am having is that when I pull up all the records
>>>> representing the history of an object, the modified_by and modified_on
>>>> fields do not reflect the time and user that performed the change. In
>>>> fact, they appear to be stuck on whoever was logged in when I last restart
>>>> the web2py server and the time at which I restarted it. (Maybe it's the
>>>> first person to perform an edit and the time they do it at since last
>>>> restart.)
>>>>
>>>> Anyway, is there something obvious I am missing here?
>>>>
>>>
--
