使用python循环调用多个SQL数据库

import sqlite3

# 数据库文件列表
db_files = ['db1.sqlite', 'db2.sqlite', 'db3.sqlite']

for db_file in db_files:
    try:
        # 连接到SQLite数据库
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()
        
        # 执行查询
        cursor.execute("SELECT * FROM some_table")
        results = cursor.fetchall()
        
        # 处理结果
        for row in results:
            print(row)
        
        # 关闭连接
        cursor.close()
        conn.close()
    except sqlite3.Error as e:
        print(f"Error accessing {db_file}: {e}")

import time

for db_file in db_files:
    retries = 3
    while retries > 0:
        try:
            conn = sqlite3.connect(db_file, timeout=30)
            # 其他代码...
            break
        except sqlite3.OperationalError as e:
            retries -= 1
            time.sleep(5)
            if retries == 0:
                print(f"Failed to connect to {db_file} after multiple attempts")

cursor.execute("SELECT * FROM some_table WHERE condition LIMIT 1000")

try:
    conn.execute("BEGIN TRANSACTION")
    # 执行多个数据库操作
    conn.execute("COMMIT")
except sqlite3.Error as e:
    conn.execute("ROLLBACK")
    print(f"Transaction failed: {e}")