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 <[email protected]> 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 [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.
