合并多个名称不同的sqlite3相同数据库

import sqlite3

def merge_databases(source_dbs, target_db):
    # 连接到目标数据库
    conn_target = sqlite3.connect(target_db)
    cursor_target = conn_target.cursor()

    # 遍历源数据库文件
    for source_db in source_dbs:
        # 连接到源数据库
        conn_source = sqlite3.connect(source_db)
        cursor_source = conn_source.cursor()

        # 获取源数据库中的所有表名
        cursor_source.execute("SELECT name FROM sqlite_master WHERE type='table';")
        tables = cursor_source.fetchall()

        # 将每个表从源数据库复制到目标数据库
        for table in tables:
            table_name = table[0]
            cursor_source.execute(f"SELECT * FROM {table_name};")
            data = cursor_source.fetchall()

            # 创建表（如果目标数据库中不存在）
            create_table_sql = f"CREATE TABLE IF NOT EXISTS {table_name} AS SELECT * FROM {table_name} LIMIT 0;"
            cursor_target.execute(create_table_sql)

            # 插入数据
            insert_sql = f"INSERT INTO {table_name} VALUES ({','.join(['?']*len(data[0]))});"
            cursor_target.executemany(insert_sql, data)

        # 关闭源数据库连接
        conn_source.close()

    # 提交更改并关闭目标数据库连接
    conn_target.commit()
    conn_target.close()

# 示例用法
source_dbs = ['db1.db', 'db2.db', 'db3.db']
target_db = 'merged.db'
merge_databases(source_dbs, target_db)