Can I use with statement with MySQLdb.Connection o

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.

Answer 1

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