SAS中文论坛

标题: COPY A SQLITE DB TABLE FROM DISK INTO MEMORY [打印本页]

作者: shiyiming 时间: 2010-10-22 13:24
标题: COPY A SQLITE DB TABLE FROM DISK INTO MEMORY
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')

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)