COPY A SQLITE DB TABLE FROM DISK INTO MEMORY

shiyiming · 发表于 2010-10-22 13:24:07

From Wensui Liu's blog

################################################## # A DEMO HOW TO COPY A SQLITE DB TABLE FROM DISK # # INTO MEMORY # ################################################## import sqlite3 # CONNECT TO THE IN-MEMORY DATABASE con = sqlite3.connect(":memory:") cur = con.cursor() # ATTACH SQLITE DB IN THE DISK cur.execute("attach 'd:\mydb' as filedb") # COPY THE TABLE INTO IN-MEMORY DB cur.execute("create table memory_tbl as select * from filedb.mytab") # RELEASE THE DB IN THE DISK cur.execute("detach filedb") # FETCH ROWS FROM IN-MEMORY DB cur.execute("select Sepal_Length, Species from memory_tbl limit 3") for row in cur.fetchall(): print row # OUTPUT: # (5.0999999999999996, u'setosa') # (4.9000000000000004, u'setosa') # (4.7000000000000002, u'setosa')

		自动登录	找回密码
密码			立即注册