[sqlalchemy] where clause construction using variable names and values

2010-03-31 Thread Tejaswi
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

[sqlalchemy] Re: where clause construction using variable names and values

2010-03-31 Thread Tejaswi
. 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

[sqlalchemy] Re: where clause construction using variable names and values

2010-03-31 Thread Tejaswi
tried really hard on Google, this forum specifically, stackoverflow, etc. The API documentation is sufficient, I am sure; but is not tutorial like. Thanks again. This is greatly appreciated. -T On Mar 31, 4:10 pm, Conor conor.edward.da...@gmail.com wrote: Tejaswi wrote: I am not using sa.orm. I

[sqlalchemy] Re: where clause construction using variable names and values

2010-03-31 Thread Tejaswi
helping. Thanks agian, -T On Mar 31, 4:36 pm, Tejaswi nadaha...@gmail.com wrote: @Conor: This might be what I am looking for. I cannot try it right now, but will reply to this thread in 3-4 hours. Can you please point me to the documentation that discusses the different ways of constructing

[sqlalchemy] Re: where clause construction using variable names and values

2010-03-31 Thread Tejaswi
=html_frontpage)] My table doesn't have column names that are unicode strings. Am I missing something here? -T On Mar 31, 4:43 pm, Tejaswi nadaha...@gmail.com wrote: On second thought, it's nothing to do with SA, and just a python feature that I am not familiar with. The idiom of clause