Remap Mysql tuple to dictionary

Tim Chase python.list at tim.thechases.com
Mon Sep 25 12:44:30 EDT 2006


> def remapmysql(a):
>      return (a[0], (a[1:]))
> 
> def test_map():
>      count = 100000 # count of simulated records
>      l1 = range(0, count)
>      l2 = range(count , 2 * count )
>      l3 = range(2 * count, 3 * count )
>      z1 = zip(l1, l2, l3) # simulate a mysql resultset
> 
>      d1 = dict(map(remapmysql,z1))
> 
>      return d1

I'm not sure the map() is needed, as it could just be

 >>> d1 = dict((row[0], row[1:]) for row in z1)

which worked in my tests.

However either seems to work fairly well.

-tkc









More information about the Python-list mailing list