pymysql 오랜시간 사용시 연결이 끊긴다면

 

connection = pymysql.connect(host='host', port=3306,
                             db='db', user='user',
                             passwd='pw', charset='utf8')
cursor = connection.cursor()

connection.ping(reconnect=True) # try reconnect


sql = f"REPLACE INTO item (name,price) VALUES (%s,%s)"
cursor.execute(sql, ("name","100"))
connection.commit()

connection.ping(reconnect=True)를 추가한다