Can I use MySQLdb.Connection with an instruction with an object?

Question

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

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

Will the conn object close automatically after a block like the file object?

Thanks.

Answer 1

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