How to copy a sqlite table from a disk database to a memory database in python? [duplicate]

Question

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

Answer 1

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 

Answer 2

Check out the SQLite Backup API. The example is in C, but this should show you how it's done efficiently.