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.
>
> -T
>
>
You can treat meta.c as a dict, e.g. meta.c[key] == value.
-Conor
--
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.
