python sqlite3写入内存_如何在Python sqlite3中将现有的数据库文件加载到内存？

这里是我为我的烧瓶应用程序写的代码段：

import sqlite3

from StringIO import StringIO

def init_sqlite_db(app):

# Read database to tempfile

con = sqlite3.connect(app.config['SQLITE_DATABASE'])

tempfile = StringIO()

for line in con.iterdump():

tempfile.write('%s\n' % line)

con.close()

tempfile.seek(0)

# Create a database in memory and import from tempfile

app.sqlite = sqlite3.connect(":memory:")

app.sqlite.cursor().executescript(tempfile.read())

app.sqlite.commit()

app.sqlite.row_factory = sqlite3.Row