it seems to me if you join as_dict, the key cannot be always a single field. I have a proposed solution in trunk
On Oct 29, 12:22 pm, "mr.freeze" <nat...@freezable.com> wrote: > as_list seems to be recursing properly now. Same error on as_dict but > I am digging deeper. > > On Oct 29, 12:12 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > I actually think i fixed the recursive dictit but it still could use > > some testing. > > > Massimo > > > On Oct 29, 11:58 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > True. The issue with JOIN is not an easy one to fix. > > > > Can you send me a patch about one or both issues? > > > > Massimo > > > > On Oct 29, 11:43 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > Also, the as_list function only converts the first level of DALStorage > > > > to dict when storage_to_dict is true. Both function (as_list,as_dict) > > > > should probably recurse through all level right? > > > > > On Oct 29, 11:27 am, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > Works for normal queries but throws a KeyError on id for joins. > > > > > > On Oct 29, 10:12 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > ok, in trunk, take a look. > > > > > > > On Oct 29, 9:26 am, Renato-ES-Brazil <caliari.ren...@gmail.com> > > > > > > wrote: > > > > > > > > I agree. > > > > > > > > On 29 out, 12:19, "mr.freeze" <nat...@freezable.com> wrote: > > > > > > > > > I think it is worth adding an as_dict function to Rows > > > > > > > > personally. > > > > > > > > > On Oct 29, 9:01 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > > > > My bad again > > > > > > > > > > item_dict=dict([(r['id'],r) for r in db(db.items.id > > > > > > > > > > 0).select > > > > > > > > > ().as_list()]) > > > > > > > > > > On Oct 29, 8:58 am, Fran <francisb...@googlemail.com> wrote: > > > > > > > > > > > On Oct 29, 1:52 pm, mdipierro <mdipie...@cs.depaul.edu> > > > > > > > > > > wrote: > > > > > > > > > > > > oops.there should be no sterisk. > > > > > > > > > > > item_dict=dict([(r.id,r) for r in db(db.items.id > > > > > > > > > > > > 0).select()]) > > > > > > > > > > > Great, that works ;) > > > > > > > > > > > This one still fails: > > > > > > > > > > item_dict=dict([(r.id,r) for r in db(db.items.id > > > > > > > > > > > 0).select().as_list > > > > > > > > > > ()]) > > > > > > > > > > > 'dict' object has no attribute 'id' > > > > > > > > > > > Of course, this is already a dict: > > > > > > > > > > db(db[table].id > 0).select().as_list() > > > > > > > > > > > F > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
