I think:
rows = db(db.thumbnails.rolic_id==db.rolic.id).select()
rows =
[{'rolic':row.rolic.as_dict(),'thumbnail':row.thumbnail.as_dict()} for
row in rows]
this may work too but I am not sure:
rows = db(db.thumbnails.rolic_id==db.rolic.id).select().as_dict()
give it a try.
Massimo
On Jan 21, 6:34 pm, LightOfMooN <[email protected]> wrote:
> 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
