ResultProxy has an iterator interface

1 files changed, 8 insertions, 0 deletions

diff --git a/lib/sqlalchemy/engine.py b/lib/sqlalchemy/engine.py
index 5c14e7a3c..dcb14af86 100644
--- a/lib/sqlalchemy/engine.py
+++ b/lib/sqlalchemy/engine.py
@@ -807,6 +807,14 @@ class ResultProxy:
         else:
             rec = self.props[key]
         return rec[0].convert_result_value(row[rec[1]], self.engine)
+    
+    def __iter__(self):
+        while True:
+            row = self.fetchone()
+            if row is None:
+                raise StopIteration
+            else:
+                yield row
         
     def fetchall(self):
         """fetches all rows, just like DBAPI cursor.fetchall()."""