Can I use with statement with MySQLdb.Connection object?

Question

I wonder if I can use the context manager with with the Connection object, and write code like this:

with MySQLdb.connect(...) as conn:
    do_something()

Will the conn object be closed automatically after the block like with a file object ?

Thanks.

score 7 · Accepted Answer · edited May 23 '17 at 12:24

7

MySQLdb does not support the context manager protocol. Roll your own, or use oursql instead.

edited May 23 '17 at 12:24

Community

answered Aug 01 '12 at 02:39

Did you ask the asker to pay a bounty two write his code for him in the other question, or did I misinterpret it? – TankorSmash Aug 01 '12 at 02:43
@TankorSmash: Not a bounty specifically; I also accept PayPal transfers and Amazon Canada gift certificates. – Ignacio Vazquez-Abrams Aug 01 '12 at 02:45
Well, I guess everybody needs to make a living somehow. – TankorSmash Aug 01 '12 at 02:53
6

This answer is obsolete; MySQLdb has had this feature for some time. See [my related answer](http://stackoverflow.com/a/22618781/2359271). – Air Oct 06 '15 at 17:47

1 Answers1