On Jan 16, 2017, at 11:34 PM, Peter Otten <__pete...@web.de> wrote:
> 
> Gregory Ewing wrote:
> 
>> Israel Brewster wrote:
>>> The problem is that, from time to time, I can't get a connection, the
>>> result being that cursor is None,
>> 
>> That's your problem right there -- you want a better-behaved
>> version of psql_cursor().
>> 
>> def get_psql_cursor():
>>    c = psql_cursor()
>>    if c is None:
>>       raise CantGetAConnectionError()
>>    return c
>> 
>> with get_psql_cursor() as c:
>>    ...
> 
> You still need to catch the error -- which leads to option (3) in my zoo, 
> the only one that is actually usable. If one contextmanager cannot achieve 
> what you want, use two:
> 
> $ cat conditional_context_raise.py
> import sys
> from contextlib import contextmanager
> 
> class NoConnection(Exception):
>    pass
> 
> class Cursor:
>    def execute(self, sql):
>        print("EXECUTING", sql)
> 
> @contextmanager
> def cursor():
>    if "--fail" in sys.argv:
>        raise NoConnection
>    yield Cursor()
> 
> @contextmanager
> def no_connection():
>    try:
>        yield
>    except NoConnection:
>        print("no connection")
> 
> with no_connection(), cursor() as cs:
>    cs.execute("insert into...")
> $ python3 conditional_context_raise.py
> EXECUTING insert into...
> $ python3 conditional_context_raise.py --fail
> no connection
> 
> If you want to ignore the no-connection case use 
> contextlib.suppress(NoConnection) instead of the custom no_connection() 
> manager.

Fun :-) I'll have to play around with that. Thanks! :-)

-----------------------------------------------
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-----------------------------------------------
> 
> -- 
> https://mail.python.org/mailman/listinfo/python-list

-- 
https://mail.python.org/mailman/listinfo/python-list

Reply via email to