pymysql连接校验

class DataSource(object):

    def __init__(self):
        self.conn = self.to_connect()

    def __del__(self):
        self.conn.close()

    # @staticmethod
    def to_connect(self):
        return pymysql.connect(host="localhost", user="root", passwd="123456", database="task_dialogue")

    def is_connected(self):
        """Check if the server is alive"""
        try:
            self.conn.ping(reconnect=True)
            # print"db is connecting"
        except:
            # traceback.print_exc()
            self.conn = self.to_connect()
            print("db reconnect")


# 使用方法
db = DataSourece()
db.is_connected()
connect = db.conn