Copy a sqlite table from a disk database to a memory database in python

Question

Hey Everyone. I am trying to figure out how to copy a disk based sqlite table to a memory database in python.I know the schema of the table. Is there any easy way to do this?

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 = ""

# This will dump all the tables from test.db to a query
for line in old_db.iterdump():
    query += line

# 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.