Question aboud #80 - itersize in cursor dic - Mailing list psycopg

From Kryklia Alex
Subject Question aboud #80 - itersize in cursor dic
Date
Msg-id CAGv7O6PE_u_FRYfq6ycXVLJCtPNc0dqN=UJWT_EZHLYMP5nzqQ@mail.gmail.com
Whole thread Raw
In response to Question aboud #80 - itersize in cursor dic  (Kryklia Alex <kryklia@gmail.com>)
Responses Re: Question aboud #80 - itersize in cursor dic
List psycopg
Hi!
Thank for great library.
Dear group users, please help me with understanding of situation.

in psycopg2 extras.py

in 2.4.4 was:
 89     def __iter__(self):
 90         if self._prefetch:
 91             res = _cursor.fetchmany(self, self.itersize)
 92             if not res:
 93                 return
 94         if self._query_executed:
 95             self._build_index()
 96         if not self._prefetch:
 97             res = _cursor.fetchmany(self, self.itersize)
 98
 99         for r in res:
 100             yield r
 101
 102         # the above was the first itersize record. the following are
 103         # in a repeated loop.
 104         while 1:
 105             res = _cursor.fetchmany(self, self.itersize)
 106             if not res:
 107                 return
 108             for r in res:
 109                 yield r
 110


in 2.4.5 became:
   def __iter__(self):
       if self._prefetch:
           res = _cursor.__iter__(self)
           first = res.next()
       if self._query_executed:
           self._build_index()
       if not self._prefetch:
           res = _cursor.__iter__(self)
           first = res.next()

       yield first
       while 1:
           yield res.next()


----------------------------------------------------------------------------
and now iterating over named cursor return 1 row, not many

Please help, should i use cursor.fetchmany instead?
Or how use itersize? (Why itersize not working)

Thank You

Alex

psycopg by date:

Previous
From: Egbert Bouwman
Date:
Subject: Re: is it possibile get the psql prompt output?
Next
From: Federico Di Gregorio
Date:
Subject: Re: Question aboud #80 - itersize in cursor dic