On Mon, 2007-10-01 at 09:57 -0400, J. Clifford Dyer wrote: > On Mon, Oct 01, 2007 at 06:32:07AM -0700, Besturk.Net Admin wrote regarding > Select as dictionary...: > > > > aia.execute("SELECT id, w from list") > > links=aia.fetchall() > > print links > > > > and result > > [(1, 5), (2,5).......] (2 million result) > > > > I want to see this result directly as a dictionary: > > > > {1: 5, 2: 5 .....} > > > > How do i select in this format ? > > > Try this: > > aia.execute("SELECT id, w from list") > links=aia.fetchall() > linkdict = dict() > for k,v in links: > linkdict[k] = v > print linkdict
Improvement 1: Use the fact that dict can be initialized from a sequence of key/value pairs: aia.execute("SELECT id, w from list") linkdict = dict(aia.fetchall()) Improvement 2: Use an iterator instead of reading all rows into memory: aia.execute("SELECT id, w from list") linkdict = dict(iter(aia.fetchone,None)) -- Carsten Haese http://informixdb.sourceforge.net -- http://mail.python.org/mailman/listinfo/python-list