Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

psycopg by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group