python sqlite3备份内存数据库到磁盘挂起

2024-05-15 23:05:27 发布

您现在位置:Python中文网/ 问答频道 /正文

此脚本挂起在con.backup

#!/usr/bin/env python3
import sqlite3
con = sqlite3.connect(":memory:")
cur = con.cursor()
cur.execute("CREATE TABLE t (a INTEGER PRIMARY KEY)")
cur.execute("INSERT INTO t (a) VALUES (NULL)")
bkp = sqlite3.connect('database.db')
con.backup(bkp)
bkp.close()
con.close()

但是,如果我对INSERT进行评论,它将非常有效:

#!/usr/bin/env python3
import sqlite3
con = sqlite3.connect(":memory:")
cur = con.cursor()
cur.execute("CREATE TABLE t (a INTEGER PRIMARY KEY)")
# cur.execute("INSERT INTO t (a) VALUES (NULL)")
bkp = sqlite3.connect('database.db')
con.backup(bkp)
bkp.close()
con.close()

知道我做错了什么吗


Tags: importenvcloseexecutebinusrconnectcon