Thanks.
I assume also that:
db.define_table('dog',Field('name'),Field('owner','reference dog'))
should be:
db.define_table('dog',Field('name'),Field('owner','reference person'))
?
On Thursday, October 10, 2013 5:37:16 AM UTC-10, Massimo Di Pierro wrote:
>
> Oops. A typo. I fixed it in the previous message.
>
> On Wednesday, 9 October 2013 21:41:46 UTC-5, James Thompson wrote:
>>
>> I'm a little confused by:
>> >db.dog.owner.represent = None
>> >SQLFORM.grid(db.dog.represent==db.person.id)
>>
>> Why would we use db.dog.represent==db.person.id
>> rather than db.dog.owner==db.person.id
>> here?
>>
>> Thanks.
>>
>>
>>
>>
>> On Wednesday, October 9, 2013 3:20:08 PM UTC-10, Massimo Di Pierro wrote:
>>>
>>> It depends. It may.
>>>
>>> For example given:
>>>
>>> db.define_table('person',Field('name'),format='%(name)s')
>>> db.define_table('dog',Field('name'),Field('owner','reference dog'))
>>>
>>> if you do:
>>>
>>> SQLFORM.grid(db.dog.owner==db.person.id)
>>>
>>> it will do a recursive select for each row to find a representation of
>>> db.dog.owner.
>>>
>>> You can disabled this:
>>>
>>> db.dog.owner.represent = None
>>> SQLFORM.grid(db.dog.represent==db.person.id)
>>>
>>> or hide it
>>>
>>> db.dog.owner.readable = False
>>> SQLFORM.grid(db.dog.represent==db.person.id)
>>>
>>> or cache it:
>>>
>>> db.dog.owner.represent = lambda v,r: cache.ram('person-%s'%v, lambda
>>> v=v: v and '%(name)s'%db.person(v), None)
>>> SQLFORM.grid(db.dog.represent==db.person.id)
>>>
>>> You can always add the {{=response.toolbar()}} to see all the database
>>> queries.
>>>
>>>
>>> On Wednesday, 9 October 2013 14:39:07 UTC-5, James Thompson wrote:
>>>>
>>>> When using SQLTABLE (or something like: {{=query_results}}) to display
>>>> rows in a view, foreign key fields display data from their related table.
>>>> Is web2py doing individual queries for each of these fields?
>>>>
>>>>
>>>>
--
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.
