Michael,
Thanks for the quick reply.
Michael Bayer wrote:
On Jan 11, 2009, at 4:51 PM, Werner F. Bruhin wrote:
I can not find the answer looking through the 0.5 doc for my problem.
query =
session.query(db.SomeClass).filter(something).order_by(anorder)
# get the first row
row = query.first()
# display a dialog to the user
# one of the possible actions is to press a button which should show
the
next row in the query
row = query.???()
How could I use fetchone() on this? Or is there another/correcter
way
to do this type of thing ins SA?
the query itself is an iterator, so you could say result =
iter(query); row = result.next() .
now, if you are looking for the results from the *server* to be non-
buffered, that requires something more (namely yield_per()), but it
has a lot of caveats so I would not use it unless you absolutely know
what you're doing.
Just for the archive, I ended up doing something along these lines:
if self.searchInit:
whatever is needed to setup the searchQuery
self.searchResult = iter(self.searchQuery)
try:
row = self.searchResult.next()
except StopIteration:
... do whatever if nothing is found
else:
try:
row = self.searchResult.next()
except StopIteration:
do whatever when there are no more rows
Michael, thanks again for excellent support.
Werner
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---