Hi there,
I have small issue and don't know how to solve ..
I need to have this kind of query:
q = dbsession().query(User).
options(eagerload_all('lang_pairs.lang_a'),
eagerload_all('lang_pairs.lang_a')).
join(['lang_pairs']).
filter(
or_(
and_(LangPair.a_lg_id == 'L1', LangPair.a_lg_id == 'L2'),
and_(LangPair.a_lg_id == 'L3', LangPair.a_lg_id == 'L4'),
and_(LangPair.a_lg_id == 'L5', LangPair.a_lg_id == 'L6'),
....
)
)
Obviously the part with many 'and_' clauses needs to be dynamicly
created based on particular user search.
How to achieve (generate dynamicaly) that?
When I tried to do a list of 'and_' and put it into
'...filter(or_(list_of_generated_ands))' SQLA told me:
ArgumentError: filter() argument must be of type
sqlalchemy.sql.ClauseElement or string
Tomasz
--
_i______'simplicity_is_the_key'__________tomasz_nazar
_ii____'i_am_concern_oriented'________________JKM-UPR
_iii__'patsystem.sf.net'___________________linux_user
_'aspectized.com'___________________________prevayler
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
