Tejaswi wrote:
> 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.
>
>
How about this:
clauses = [meta.c[key] == value for (key, value) in dict.iteritems()]
select([table], and_(*clauses))
or, generatively:
s = select([table])
for (key, value) in dict.iteritems():
s = s.where(meta.c[key] == value)
-Conor
> 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.
