Question aboud #80 - itersize in cursor dic

From: Kryklia Alex <kryklia(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Question aboud #80 - itersize in cursor dic
Date: 2012-05-16 09:22:25
Message-ID: CAGv7O6PE_u_FRYfq6ycXVLJCtPNc0dqN=UJWT_EZHLYMP5nzqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2012-05-16 09:23:48 Re: Question aboud #80 - itersize in cursor dic
Previous Message Egbert Bouwman 2012-05-16 08:17:49 Re: is it possibile get the psql prompt output?