or_() returns the first argument if theres only one argument. youre
looking for or_(*map(...))
Kees van den Broek wrote:
>
> Hi,
>
> I'd like to create a query at run time with any amount of filters
> wrapped in an 'OR'.
> What's the right syntax to do this?
> This was my best attempt so far:
>
> from sqlalchemy import *
> id=[1,2]
> q=Province.query.filter(or_(map(lambda n: Province.id == n, id)))
>
>>>> q=Province.query.filter(or_(map(lambda n: Province.id == n, id)))
> Traceback (most recent call last):
> File "<console>", line 1, in <module>
> File "<string>", line 1, in <lambda>
> File "/home/kvdb/public/6pp/env/sevenpp_tg1.1_r6583/lib/python2.6/
> site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/query.py",
> line 52, in generate
> fn(self, *args[1:], **kw)
> File "/home/kvdb/public/6pp/env/sevenpp_tg1.1_r6583/lib/python2.6/
> site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/query.py",
> line 655, in filter
> raise sa_exc.ArgumentError("filter() argument must be of type
> sqlalchemy.sql.ClauseElement or string")
> ArgumentError: filter() argument must be of type
> sqlalchemy.sql.ClauseElement or string
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
