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

import pymysql

# 数据库连接参数
db_configs = [
    {
        'host': 'db1.example.com',
        'port': 3306,
        'user': 'user1',
        'password': 'password1',
        'database': 'database1'
    },
    {
        'host': 'db2.example.com',
        'port': 3306,
        'user': 'user2',
        'password': 'password2',
        'database': 'database2'
    }
]

# 循环调用多个数据库
for db_config in db_configs:
    try:
        # 建立数据库连接
        conn = pymysql.connect(
            host=db_config['host'],
            port=db_config['port'],
            user=db_config['user'],
            password=db_config['password'],
            database=db_config['database']
        )
        
        # 创建游标对象
        cursor = conn.cursor()
        
        # 执行SQL查询
        sql = "SELECT * FROM table_name"
        cursor.execute(sql)
        
        # 获取查询结果
        result = cursor.fetchall()
        
        # 处理查询结果
        for row in result:
            # 进行相应的操作
            
        # 关闭游标和连接
        cursor.close()
        conn.close()
        
    except Exception as e:
        print(f"Error occurred: {e}")