Hi,
if I have the following:
db.define_table('master',
Field('name')
)
db.define_table('detail',
Field('master', db.master),
Field('a_field')
)
if db(db.master.id>0).count() == 0:
db.master.insert(name='A')
db.master.insert(name='B')
db.master.insert(name='C')
if db(db.detail.id>0).count() == 0:
db.detail.insert(master=1, a_field='AA')
db.detail.insert(master=1, a_field='AB')
db.detail.insert(master=1, a_field='AC')
db.detail.insert(master=2, a_field='BA')
db.detail.insert(master=2, a_field='BB')
db.detail.insert(master=2, a_field='BC')
db.detail.insert(master=2, a_field='CA')
db.detail.insert(master=2, a_field='CB')
in the shell do:
>>> a = db.master[1]
>>> a
<Row {'update_record': <function <lambda> at 0x37f8fc34>, 'name': 'A',
'id': 1, 'delete_record': <function <lambda> at 0x37f8f80c>, 'detail':
<gluon.sql.Set object at 0x380c0cac>}>
>>> b = a.detail
>>> b.select()
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "/usr/home/jose/w2p/gluon/sql.py", line 3056, in select
rows = response(query)
File "/usr/home/jose/w2p/gluon/sql.py", line 3051, in response
db._execute(query)
File "/usr/home/jose/w2p/gluon/sql.py", line 895, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: Cannot operate on a closed database.
How do I get the detail records?
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
