首页 > 代码库 > 【sqlite】python备份数据库
【sqlite】python备份数据库
备份整个数据库的方法:
# coding=utf-8 import sqlite3 def testBakSqlite(): conn = sqlite3.connect("sqlite_db_mine/testDB.db") with open(‘testDB.sql.bak‘,‘w‘) as f: for line in conn.iterdump(): data = line + ‘\n‘ data = data.encode("utf-8") f.write(data) testBakSqlite()
如果想要备份其中的一个表,没有很好的办法。下面是一些网上的讨论。
http://stackoverflow.com/questions/6677540/how-do-i-dump-a-single-sqlite3-table-in-python
You can copy only the single table in an in memory db:
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)
Pro: Simplicity and reliability: you don‘t have to re-write any library method, and you are more assured that the code is compatible with future versions of the sqlite3 module.
Con: You need to load the whole table in memory, which may or may not be a big deal depending on how big the table is, and how much memory is available.
【sqlite】python备份数据库
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。