SQLITE - 若要查看刚刚对应用程序进行的更新，必须注销并重新登录

Question

我通常可以更新SQLITE数据库中的记录，问题是当我查看更新的记录时，它带来了旧信息，要带来更新的信息需要退出应用程序并返回。

我需要做什么才能使应用程序自动识别所做的更改而无需离开？

数据更新代码 ：

conn = sqlite3.connect("datum.db") 
cursor = conn.cursor()
highestscore =  cursor.execute("""select highest_score from datum where id_score = 1""")
highestscore = cursor.fetchone()
highestscore = highestscore[0]
if self.score > highestscore:
highestscore = self.score
atualizar = cursor.execute("""UPDATE datum SET highest_score = ?, last_score = ?;""", (highestscore,self.score,))
conn.commit()
cursor.close() 

数据显示代码：

try:
conn = sqlite3.connect("datum.db") 
cursor = conn.cursor()
hscore = cursor.execute("""select highest_score from datum where id_score = 1""")
hscore = cursor.fetchone()
hscore = hscore[0]
cursor.close()
except:
conn = sqlite3.connect('datum.db')
cursor = conn.cursor()
try:
cursor.execute("""CREATE TABLE datum(id_score INTEGER NOT NULL, highest_score INTEGER, last_score INTEGER);""")
except:
pass
cursor.execute("""INSERT INTO datum(id_score, highest_score, last_score) VALUES(1, 0, 0);""")
conn.commit()
hscore = cursor.execute("""select highest_score from datum where id_score = 1""")
hscore = cursor.fetchone()
hscore = hscore[0]
cursor.close()

Answer 1

处理数据库应用程序的一个好方法是在该类中创建一类 Database(数据库的单独模块(，您可以在该类中插入、更新、删除、显示方法(或您想要的任何其他方法(。这样，您可以访问更新的数据。