Python MySQL不刷新

I create the GetData class when starting the program and get_data is called every 10 seconds.

class GetData:
    def __init__(self):
        self.conn = pymysql.connect(host='localhost', user='root', password='', db='mydb', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor)

    def get_data(self, data):
        with self.conn.cursor() as cursor:
            self.sql = "SELECT id_data, somedata FROM mytable WHERE (%s = 'example');"
            cursor.execute(self.sql, (data,))
        return cursor.fetchall()

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

填充数据库的程序:

class FillDb:
    def __init__(self):
        self.conn = pymysql.connect(host='localhost', user='root', password='', db='mydb', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor)
        #added this line but doesen't help!
        self.conn.autocommit(True)

    def add_in_db(self, data):
        with self.conn.cursor() as cursor:
            self.sql = "INSERT INTO mytable (somedata) VALUES (%s);"
            cursor.execute(self.sql, (data,))
            self.conn.commit()

推荐答案

为什么你没有看到更新:

该行为的原因是 InnoDB 的默认隔离级别 可重复阅读.使用 REPEATABLE READ，第一个非锁定 SELECT 会建立一个快照，表示该时间点的数据.所有连续的非锁定 SELECT 都从同一个快照中读取.其他事务对数据库的更新不会反映在该快照中，因此保持透明.