Python `__enter__` `__exit__`(with)

class SQL(object):

    def open(self):
        pass

    def fetch(self,sql):
        pass

    def close(self):
        pass

    def __enter__(self):
        self.open()
        return self

    def __exit__(self):
        self.close()


# obj = SQL()
# obj.open()
# obj.fetch('select ....')
# obj.close()

with SQL() as obj: # 自动调用类中的__enter__方法, obj就是__enter__返回值
    obj.fetch('xxxx')
    # 当执行完毕后，自动调用类 __exit__ 方法