One more question Anthony,
If I have other tables which reference themselves like :
db.define_table('mytable',Field('myfield','string'))
db.define_table('my_other_table',Field('myTable','reference mytable'))
should I replace the* 'reference mytable' *statement with* 'reference %s' %
I_dont_know_what*' to be "lazy_tables compliant"?
Thank you
Le jeudi 18 avril 2013 13:59:18 UTC+2, Anthony a écrit :
>
> Have the auth tables been defined at that point. In any case, to avoid
> pre-mature table definition, try replacing auth.settings.table_user with:
>
> 'reference %s' % auth.settings.table_user_name
>
> Anthony
>
> On Thursday, April 18, 2013 7:51:19 AM UTC-4, Loïc wrote:
>>
>> Hello All
>>
>> consider the example model file below :
>>
>> db = DAL('sqlite://storage.sqlite')
>>
>> signature = db.Table(db,'auth_signature',
>> Field('created_on','datetime',default=request.now,
>> writable=False,readable=False, label=T('Created on')),
>> Field('created_by',auth.settings.table_user,default=auth.user_id,
>> writable=False,readable=False, label=T('Created by')),
>> Field('modified_on','datetime',update=request.now,default=request
>> .now,
>> writable=False,readable=False, label=T('Modified on')),
>> Field('modified_by',auth.settings.table_user,
>> default=auth.user_id,update=auth.user_id,
>> writable=False,readable=False, label=T('Modified by'))
>> )
>>
>> db._common_fields.append(signature)
>>
>> db.define_table('mytable',Field('myfield','string'))
>> db.mytable.myfield.requires = IS_EMPTY_OR(IS_URL())
>>
>> Then, if I want to activate lazy_tables
>> db = DAL('sqlite://storage.sqlite', lazy_tables=True)
>>
>> I got the following error that I don't really understand.
>> Can anyone explain me?
>> Thank you
>>
>> Error ticket for "test" Ticket ID
>>
>> 127.0.0.1.2013-04-18.13-47-51.4d08ccf5-8d25-4cf1-a8dd-081d76046b7a
>> <type 'exceptions.AttributeError'> 'NoneType' object has no attribute
>> 'startswith' Version web2py™ Version
>> 2.4.5-stable+timestamp.2013.03.18.22.46.22 Python Python 2.7.3:
>> C:\Python27\python.exe (prefix: C:\Python27) Traceback
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>> 12.
>> 13.
>>
>> Traceback (most recent call last):
>> File "C:\Users\MCR\Google Drive\loic\web2py\web2py\gluon\restricted.py",
>> line 212, in restricted
>> exec ccode in environment
>> File "C:/Users/MCR/Google
>> Drive/loic/web2py/web2py/applications/test/models/db.py"
>> <http://127.0.0.1:8000/admin/default/edit/test/models/db.py>, line 101, in
>> <module>
>> db.mytable.myfield.requires = IS_EMPTY_OR(IS_URL())
>> File "C:\Users\MCR\Google Drive\loic\web2py\web2py\gluon\dal.py", line
>> 7790, in __getattr__
>> return self.lazy_define_table(tablename,*fields,**args)
>> File "C:\Users\MCR\Google Drive\loic\web2py\web2py\gluon\dal.py", line
>> 7714, in lazy_define_table
>> polymodel=polymodel)
>> File "C:\Users\MCR\Google Drive\loic\web2py\web2py\gluon\dal.py", line
>> 776, in create_table
>> elif field_type.startswith('reference'):
>> AttributeError: 'NoneType' object has no attribute 'startswith'
>>
>>
>>
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
