On Jun 18, 2007, at 11:47 AM, David S. wrote:
>
> I know that you can:
> my_query.select_by(my_source.c.code.in_('1', '2'))
>
> Is there a way to use kwargs with in_ as you can with equality
> settings, as in:
> my_query.select_by(code='1')
>
> Since SA is NOT a framework, I imagine I could wrap the filter_by
> method to work out Django style kwargs like code__in=(...), but if
> there is an easier way...
>
django's method of shoving SQL operators into the names of keyword
arguments seems horribly ugly to me. SQLAlchemy's approach is to
use query.filter(sometable.c.col.in_(x, y)). it uses the same
operators as everything else without the need to memorize magic codes
to embed in keyword names. select_by() is deprecated in the
upcoming 0.4 series.
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
