Where Are The Wise Men?

Okay, so I’m behind the Eight Ball. But I’m using Jython 2.2b1 and finally had a reason to use generators. Of course, we are back in 2.2-land, so our first line is this:

from <strong>future</strong> import generators

Then here is my function. Generators are very nice for processes the result of a SQL query!

</p>

<p>def getResults():
conn = getConnection()
cur = conn.cursor()
cur.execute("select * from table")
ret = cur.fetchone()
while ret!=None:
yield ret
ret = cur.fetchone()
cur.close()

This entry was posted on Wednesday, April 4th, 2007 at 1:38 pm and is filed under Python. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.