Thanks!
Michael Bayer mike...@zzzcomputing.com
Sent by: sqlalchemy@googlegroups.com
02/12/2010 10:48 AM
Please respond to
sqlalchemy@googlegroups.com
To
sqlalchemy@googlegroups.com
cc
Subject
Re: [sqlalchemy] Oracle in clause limit
grach wrote:
Hello all,
I'm relatively new to SQLAlchemy - is there any elegant workaround
that SQLAlchemy provides for queries with in clause that contains more
than 1000 items?
I have, say, date, item, value table that I'd like to query for
arbitrary set of dates and items (date and item list is provided by
the user or generated by the program. (I'd like to avoid creating temp
tables with arguments and perfoming a join).
Since you don't want to use a subquery/temp table, there's no other option
except to iteratively execute N number of queries where N is (number of
items / 1000), and piece the results together.
it can be as easy as:
def select_lots_of_stuff(collection):
while collection:
items, collection = collection[:1000], collection[1000:]
for result in conn.execute(select.where(col.in_(items))):
yield result
Many thanks,
--
You received this message because you are subscribed to the Google
Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@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.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@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.
---
This communication may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this communication
in error) please notify the sender immediately and destroy this
communication. Any unauthorized copying, disclosure or distribution of the
material in this communication is strictly forbidden.
Deutsche Bank does not render legal or tax advice, and the information
contained in this communication should not be regarded as such.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@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.