I was calling auth.define_tables() after defining auth_user manually.
My mistake.
On Saturday, September 8, 2012 1:56:37 PM UTC-4, Joel Carrier wrote:
>
> Hmmm... i never call auth.define_tables I guess because I wanted to
> customize the auth_user table.
> And yet the following tables all get created:
>
> | auth_cas |
> | auth_cas_archive |
> | auth_event |
> | auth_event_archive |
> | auth_group |
> | auth_group_archive |
> | auth_membership |
> | auth_membership_archive |
> | auth_permission |
> | auth_permission_archive |
> | auth_user |
> | auth_user_archive
>
> Could that be why?
>
> On Saturday, September 8, 2012 1:51:24 PM UTC-4, Massimo Di Pierro wrote:
>>
>> 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?
>>>>>>
>>>>>
--
