On Oct 29, 9:35 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I'm trying to find the fastest way to convert an sql result into a
> dict or list.
>>> from collections import defaultdict
>>> results = defaultdict(defaultdict)
>>> for contact_id, field_id, field_name, value in sql_result:
... results[contact_id][field_id] = value
... results[contact_id][field_name] = value
...
This lets you reference things in a straightforward way:
>>> results[1]['email']
'[EMAIL PROTECTED]'
If you'd prefer to use only the ids for reference:
>>> results = defaultdict(defaultdict)
>>> for contact_id, field_id, field_name, value in sql_result:
... results[contact_id][field_id] = (field_name, value)
...
>>> results[1][1]
('address', 'something street')
Hope this helps.
--
http://mail.python.org/mailman/listinfo/python-list
