[egenix-users] Converting ZQL method return value to dictionary

[Jerry Westrick]

Hello Wade...

Thank you, got it...

My problem was realizing that the "result set" has a
.dictionaries() and not the resulting records defined 
within the result set...

Don't ask me why, but hey...

SO the dictionaries() works outside of the for loop!

Thanks for your help!
Jerry



On Sun, 2003-08-10 at 13:27, Wade Leftwich wrote:
> Jerry Westrick wrote:
> > Hello:
> > 
> > I'm not sure if this is the right list, if not sorry.
> > 
> > I'm trying to convert the result of a Zql method into a dictionary.
> > the code I'm using is: 
> > 
> > # Get User Info
> > for row in context.Get_UserInfo(user=request.AUTHENTICATED_USER):
> >     values['user'] = row
> > 
> > The Get_UserInfo is a Z SQL Method, returning a single row
> > from a mxODBC conneciton.
> > 
> > when I executed the following lines: 
> > 
> > print values['user'] 
> > return printed
> > 
> > 
> > I get 
> > 
> > <r instance at 8d8f130>
> > 
> > I would to convert this r instance to a dictionary, so I can add/modify
> >  values in it like the following:
> > 
> > values['user']['justforfun'] = 'Additional info not from select!'
> > 
> > which at the moment gives me:
> > 
> > Error Type: TypeError
> > Error Value: object does not support item or slice assignment
> > 
> > 
> > 
> > Now to my questions:
> > 1) the class "r", is it a Zope thingy or a mxODBC thingy?
> > 2) is there a mothod to do what I need?
> > 
> > 
> > Than you for your time...
> > Jerry
> > 
> > P.S.  There are other dictionary functions not support by this "R"
> > instance that I would like to use also...
> > 
> > 
> 
> In the past I have frequently written a function to convert each tuple
> in a zsql result to a dictionary. But looking at the current docs
> 
> http://zope.org/Documentation/Books/ZopeBook/current/RelationalDatabases.stx
> 
> toward the bottom of the page, I see that zsql results have a 
> dictionaries() method that returns a list of dicts. I wonder if that's a 
> recent addition, or if I just never noticed it before?
> 
> If that does not work for you, try this:
> 
> def row2dict(row, names):
>      D = {}
>      for i in range(len(names)):
>          D[names[i]] = row[i]
>      return D
> 
> result = context.somezsqlmethod()
> for row in result:
>      print row2dict(row, result.names())
> 
> 
> -- Wade Leftwich
> Ithaca, NY
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> http://lists.egenix.com/mailman/listinfo/egenix-users
>