db.define_table('rolic',
Field('name', 'string')
)
db.define_table('thumbnails',
Field('rolic_id', db.rolic),
Field('image', 'upload')
)
Is there a way to make SQL Query to get results like this?
[{'rolic': {'id':1, 'name':'name1'}, thumbnails: [{'id':1,
image:'...'}, {'id':2, image:'...'}]},
{'rolic': {'id':2, 'name':'name2'}, thumbnails: [{'id':3,
image:'...'}, {'id':4, image:'...'}, {'id':5, image:'...'}]}]
thx
