基础网络CDB使用API批量切换私有网络

import os
from re import A
import sys
import csv
import json
import time
from tencentcloud.common import credential
from tencentcloud.common.profile.client_profile import ClientProfile
from tencentcloud.common.profile.http_profile import HttpProfile
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models
try:
    # 实例化一个认证对象，入参需要传入腾讯云账户secretId，secretKey,此处还需注意密钥对的保密
    # 密钥可前往https://console.cloud.tencent.com/cam/capi网站进行获取
    cred = credential.Credential("AKIxxxx", "dChxxx")
    # 实例化一个http选项，可选的，没有特殊需求可以跳过
    httpProfile = HttpProfile()
    httpProfile.endpoint = "cdb.tencentcloudapi.com"

    # 实例化一个client选项，可选的，没有特殊需求可以跳过
    clientProfile = ClientProfile()
    clientProfile.httpProfile = httpProfile
    # 实例化要请求产品的client对象,clientProfile是可选的
    client = cdb_client.CdbClient(cred, "ap-guangzhou", clientProfile)

except TencentCloudSDKException as err:
    print(err)


if __name__ == '__main__':
    #读取csv文件中的实例id、内网ip等信息
    with open("/Users/vicjiang/Desktop/cdb_list.csv",encoding="utf-8",mode="r") as f:
        reader = csv.DictReader(f)
        for row in reader:
            print(row["实例ID"],row["内网 IP"],row["目标VPC"],row["目标子网"])
            # 实例化一个请求对象,每个接口都会对应一个request对象
            req = models.ModifyDBInstanceVipVportRequest()
            params = {
                "InstanceId": row["实例ID"],
                "DstIp": row["内网 IP"],
                "UniqVpcId": row["目标VPC"],
                "UniqSubnetId": row["目标子网"],
                # 保留基础网络ip 168小时（7天）
                "ReleaseDuration": 168
            }
            req.from_json_string(json.dumps(params))

            # 返回的resp是一个ModifyDBInstanceVipVportResponse的实例，与请求对象对应
            resp = client.ModifyDBInstanceVipVport(req)
            # 输出json格式的字符串回包
            print(resp.to_json_string())
            # 加1秒等待时间，每秒切换1台
            time.sleep( 1 )