Lawrence D'Oliveiro wrote: > In message <[EMAIL PROTECTED]>, Pom wrote: > > >>I want to convert a Mysql resulset to a dictionary. > > > Here's a function that does this one row at a time: > > def GetEachRecord(TableName, Fields, Condition, Values, Extra = "") : > """generator which does an SQL query which can return 0 or more > result rows, yielding each record in turn as a mapping from > field name to field value. TableName can be a single table name, > or a comma-separated list of names for a join. Extra allows > specification of order/group clauses.""" > Cursor = sql.conn.cursor() # modify this as appropriate > Cursor.execute \ > ( > ", ".join(Fields) > + > " from " > + > TableName > + > " where " > + > Condition > + > " " > + > Extra, > Values > ) > while True : > NextRow = Cursor.fetchone() > if NextRow == None : > Cursor.close() > raise StopIteration > #end if > yield dict(zip(Fields, NextRow)) > #end while > #end GetEachRecord > > You'd use this something like > > for Link in GetEachRecord(...) : > ... Link[fieldname] ... blah-blah ... > This is a spectacularly bad (non-)solution to the original problem. It also shows a fine disregard for readability requirements. I suppose you are using a generator to avoid data duplication, but for 100,000 records this could be regarded as a premature optimisation on modern computers.
regards Steve -- Steve Holden +44 150 684 7255 +1 800 494 3119 Holden Web LLC/Ltd http://www.holdenweb.com Skype: holdenweb http://holdenweb.blogspot.com Recent Ramblings http://del.icio.us/steve.holden -- http://mail.python.org/mailman/listinfo/python-list
