[DB-SIG] Use of context managers with DB API 2

[M.-A. Lemburg]

On 03.12.2012 11:29, Daniele Varrazzo wrote:
> On Mon, Dec 3, 2012 at 9:01 AM, M.-A. Lemburg <mal at egenix.com> wrote:
>> On 03.12.2012 02:42, Daniele Varrazzo wrote:
>>> On Mon, Nov 5, 2012 at 9:28 AM, M.-A. Lemburg <mal at egenix.com> wrote:
>>>> On 04.11.2012 23:24, Christoph Zwerschke wrote:
>>>>> To wrap everything up, as a result of our discussion, I will do the following in the next version of
>>>>> PyGreSQL:
>>>>>
>>>>> * make connections context managers for transactions
>>>>>   (may not be the optimal solution, but it's already established)
>>>>> * make cursors self-closing context managers (evident)
>>>>> * not implement shortcut functions (see above)
>>>>>
>>>>> Is everybody happy with that?
>>>>
>>>> Sounds good :-)
>>>
>>> Is there a final wording for the context managers in the dbapi?
>>
>> No, not yet. I wanted to add some text, but got distracted by other
>> things. I'll try to get around to it this week, unless someone beats
>> me to it :-)
> 
> I'd just like to be sure that the version I've implemented (as
> described here:
> <https://github.com/dvarrazzo/psycopg/commit/c2f284cd3b7d3b33f4de348aaac62590feda8c78#L2R554>)
> is conform to the specs or if it requires any tweak.

It sounds exactly like what we've discussed. I also plan to add
a Python example to illustrate the context manager logic.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Dec 03 2012)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2012-11-28: Released eGenix mx Base 3.2.5 ...     http://egenix.com/go36
2013-01-22: Python Meeting Duesseldorf ...                 50 days to go

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/