python自带数据库sqlite储存长数据,如何将sqlite表从磁盘数据库复制到python中的内存数据库？...

How to copy a disk based sqlite table to a memory database in python? I know the schema of the table.

解决方案

this code is more general but maybe it can help you:

import sqlite3

new_db = sqlite3.connect(':memory:') # create a memory database

old_db = sqlite3.connect('test.db')

query = "".join(line for line in old_db.iterdump())

# Dump old database in the new one.

new_db.executescript(query)

EDIT : for getting your specify table you can just change in the for loop like this:

name_table = "test_table" # name of the table that you want to get.

for line in old_db.iterdump():

if name_table in line:

query = line

break