擅长:python、mysql、java
<p>只能复制内存数据库中的单个表:</p>
<pre><code>import sqlite3
def getTableDump(db_file, table_to_dump):
conn = sqlite3.connect(':memory:')
cu = conn.cursor()
cu.execute("attach database '" + db_file + "' as attached_db")
cu.execute("select sql from attached_db.sqlite_master "
"where type='table' and name='" + table_to_dump + "'")
sql_create_table = cu.fetchone()[0]
cu.execute(sql_create_table);
cu.execute("insert into " + table_to_dump +
" select * from attached_db." + table_to_dump)
conn.commit()
cu.execute("detach database attached_db")
return "\n".join(conn.iterdump())
TABLE_TO_DUMP = 'table_to_dump'
DB_FILE = 'db_file'
print getTableDump(DB_FILE, TABLE_TO_DUMP)
</code></pre>
<p><strong>专业版</strong>:
简单性和可靠性:您不必重新编写任何库方法,而且您更确信代码与未来版本的sqlite3模块兼容。</p>
<p><strong>继续</strong>:
您需要将整个表加载到内存中,这可能是一个大问题,也可能不是一个大问题,这取决于表的大小和可用内存的大小。</p>