Re: [cx-oracle-users] Results as dict
Brought to you by:
atuining
From: <wa...@li...> - 2006-11-09 09:00:06
|
Chris Dunscombe wrote: > > --- Anthony Tuininga <ant...@gm...> wrote: > >> Ah, I see. You can do the same thing with cx_Oracle (create a >> subclassed cursor that returns rows as dictionaries) quite easily. Its >> simply not "out of the box" as you say. There is an implicit >> performance penalty involved (dictionaries cost a great deal more to >> build than tuples do relatively speaking) so I've tended to avoid such >> techniques. My personal preference for when performance is not an >> issue is to return objects with attributes defined for each of the >> columns. Both of these techniques are possible to use without any help >> from any module author and should be available globally as a recipe or >> some such. Would there be appreciation for including such things as >> part of documentation or sample files? > > I would appreciate these sort things very much. ll-orasql (http://www.livinglogic.de/Python/orasql/) implements that kind of functionality (i.e. column access via row.column and row["column"]). Servus, Walter |