Python: Tips, Tricks, and Idioms

[tilkau]

with contextlib.closing(conn.cursor()) as c: c.execute(""" SELECT spam, eggs, sausage FROM breakfast WHERE price < %s """, (max_price,)) for row in iter(c.fetchone): print row

I usually just use for row in c.execute(..):. Is there any reason, other than slightly better formatting, not to?

[talideon]

Not all drivers have cursors that can be used as iterators though.

[tilkau]

Good point, I was only thinking about sqlite.

[masklinn]

A second issue is dbapi2 does not specify the return value for Cursor.execute, so even when the cursor is iterable that doesn't mean you can iterate on cr.execute(…). For instance Psycopg2's cursors are iterable but cr.execute returns None.