我创建了一个sqlite db并将其上传到托管.
然后我从我的脚本中检索它并尝试插入一些数据,但execute()返回一个
DatabaseError(文件已加密或不是数据库).
urllib.urlretrieve('http://%s/%s' % (HOST, NAME_DB), NAME_DB)
con = sqlite3.connect(NAME_DB)
cur = con.cursor()
cur.execute('insert into log(date, count, average) values(date("now"), ?, ?)', (1, 1.2))
con.commit()
con.close()
Traceback (most recent call last):
File "mylog.py", line 17, in
cur.execute('insert into log(date, count, average) values(date("now"), ?, ?)', (1, 1.2))
sqlite3.DatabaseError: file is encrypted or is not a database
如果我使用sqlite CLI插入数据,则不会发生此类错误.请你帮助我好吗?