I see. You are suing the nightly build. Get the latest one (in 5 minutes)
and see if you still have the problem.
On Tuesday, 21 August 2012 17:55:49 UTC-5, Daniel Gonzalez wrote:
>
> Not trunk. I am using:
>
> Version 2.00.0 (2012-06-18 17:07:27) dev
>
> The funny thing is that, accessing other tables in the same controller
> does not raise an exception.
> For example, this works fine:
>
> form = SQLFORM(db['agent'])
>
> 'agent' being my old agent table (I am migrating the agents to the
> auth_user table).
>
> On Wednesday, August 22, 2012 12:49:30 AM UTC+2, Massimo Di Pierro wrote:
>>
>> Are you using trunk. We have been messing up with it a lot in the last 3
>> days. Try it again now.
>>
>> On Tuesday, August 21, 2012 5:41:03 PM UTC-5, Daniel Gonzalez wrote:
>>>
>>> Hi,
>>>
>>> I have defined so my authorization table (db.py):
>>>
>>> # Use the authorization table for agents
>>> agent_table = auth.settings.table_user_name
>>> db.define_table(
>>> agent_table,
>>> Field('email', unique=True),
>>> Field('agent_doc_id', length=128, compute=create_new_agent),
>>> Field('password', 'password', length=512, compute=automatic_password
>>> , readable=False, label='Password'),
>>> format = '%(email)s %(agent_doc_id)s %(password)s')
>>>
>>>
>>> # Add contstraints to the agent table
>>> agent = db[agent_table]
>>> agent.email.requires = [IS_EMAIL(error_message=auth.messages.
>>> invalid_email), IS_NOT_IN_DB(db, '%s.email' % (agent_table))]
>>>
>>> In one of my controllers I want to access the agents, which are in the
>>> auth_user table. I do the following:
>>>
>>> form = SQLFORM(db[agent_table])
>>>
>>> I have verified my database (sqlite), and the table is indeed there. But
>>> I get the following error:
>>>
>>> <type 'exceptions.KeyError'> 'auth_user'
>>>
>>> The errror is happening when accessing db[agent_table] in the
>>> controller. Meanwhile, doing the same access in the model file (db.py),
>>> works fine.
>>> What is going on?
>>>
>>> Thanks,
>>> Daniel
>>>
>>
--
