Re: Connection pooling and with statement

On Tue, Aug 27, 2013 at 8:13 AM, Frank Broniewski <brfr(at)metrico(dot)lu> wrote:
> Am 2013-08-23 12:03, schrieb Frank Broniewski:
>
>> Another question that occured to me is how I use the with statement with
>> the pool class:
>>
>> I can do:
>> with pool.getconn() as conn:
>> with conn.cursor() as cursor:
>> # do stuff
>>
>> Where do I need to call pool.putconn(conn)? How does the with statement
>> affect the connection? Is the with statement suitable for connection
>> pooling at all?
>
>
> Hey everybody,
>
> I want to come back to my question above. Any ideas on this?

The pools are not transaction managers. You you want to use a pool in
a 'with' statement you can write your subclass adding __enter__ and
__exit__ method.

-- Daniele