I am not using sa.orm. I want to use only the sql expression syntax.
@Conor: I tried the dict approach. The problem is, I don't know how
many key value pairs I will have. I will have to use a map, or map* to
construct the full set of where clauses. This is the syntax I am not
able to figure out.
Thanks for the replies.
-T
On Mar 31, 10:39 am, werner <wbru...@free.fr> wrote:
> On 31/03/2010 08:19, Tejaswi wrote:
>
>
>
> > I have a dict of keys to values which have to go into my where clause
> > with an and_.
>
> > Say dict = {"key1": value1, "key2": value2}
>
> > my select statement should look like select * from blah where key1 =
> > value1 and key2 = value2
>
> > I know this has to do with constructing the right where clause
> > element, but I cannot seem to find documentation on it.
>
> > select([table], meta.c.<columnname> == value) doesn't take a variable
> > key.
>
> > Any help would be greatly appreciated.
>
> Are you using SA.orm?
>
> If yes, then you probably want to look at query.Query.filter and/or
> query.Query.filter_by.
>
> Werner
--
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.
