SQliteQueueDatabase更新延迟？

Question

为什么Peewee SQliteQueue更新需要“一些”时间才能应用于数据库

这是我的调试日志：

2019-10-15 22:50:16,933 - peewee.sqliteq                   (a68) :  DEBUG (sqliteq:176) - received query UPDATE "table_episodes" SET "subtitles" = ? WHERE ("table_episodes"."path" = ?)
2019-10-15 22:50:16,934 - peewee                           (a68) :  DEBUG (peewee:2993) - ('UPDATE "table_episodes" SET "subtitles" = ? WHERE ("table_episodes"."path" = ?)', [u"[['en', u'/some_path.en.srt']]", u'/some_path'])
2019-10-15 22:50:16,946 - peewee                           (1254) :  DEBUG (peewee:2993) - ('SELECT "t1"."subtitles" FROM "table_episodes" AS "t1" WHERE ("t1"."sonarrSeriesId" = ?)', [156])

我希望SELECT从subtitles列中拾取新值，但实际上它返回的是以前的值u'[]'

如果我用SQlite浏览工具打开数据库，我可以看到新的值。有什么想法吗

Answer 1

可能与连接之间的隔离有关。更新可能未提交，因此执行读取的连接尚未看到它