Python和sqlite3 -导入和导出数据库。

I'm trying to write a script to import a database file. I wrote the script to export the file like so:

我正在编写一个脚本来导入数据库文件。我编写了这样的脚本来导出文件:

import sqlite3

con = sqlite3.connect('../sqlite.db')
with open('../dump.sql', 'w') as f:
    for line in con.iterdump():
        f.write('%s\n' % line)

Now I want to be able to import that database. I have tried :

现在我想要导入那个数据库。我有尝试:

import sqlite3

con = sqlite3.connect('../sqlite.db')
f = open('../dump.sql','r')
str = f.read()
con.execute(str)

but I'm not allowed to execute more than one statement. Is there a way to get it to run an SQL script directly?

但不允许执行多个语句。有办法让它直接运行SQL脚本吗?

2 个解决方案

#1

sql = f.read() # watch out for built-in `str`
cur.executescript(sql)

Documentation.

文档。

#2

Try using

试着用

con.executescript(str)

Documentation

文档

Connection.executescript(sql_script)
    This is a nonstandard shortcut that creates an intermediate cursor object
    by calling the cursor method, then calls the cursor’s executescript
    method with the parameters given.

Or create the cursor first

或者先创建光标

import sqlite3

con = sqlite3.connect('../sqlite.db')
f = open('../dump.sql','r')
str = f.read()
cur = con.cursor()
cur.execute(str)

#1

sql = f.read() # watch out for built-in `str`
cur.executescript(sql)