两个sqlite数据库拼接

环境：jupyter-lab - python3.6 , linux x64 unbuntu ,sqlite3

目的：两个相同结构的数据库相连接（类似append）

dbfile1上连接dbfile2的所有内容。

cons = sql.connect(dbfile1)
sqls1 = 'attach database "'+dbfile2+'" as s;'
cons.execute(sqls1)
cons.execute("BEGIN")
for row in cons.execute("SELECT * FROM s.sqlite_master WHERE type='table'"):
    combine = "INSERT INTO "+ row[1] + " SELECT * FROM s." + row[1]
    cons.execute(combine)
cons.commit()
cons.execute("detach database s")   
cons.close()