python获取RDS信息并遍历结果

阿里官方API：https://help.aliyun.com/document_detail/26226.html?spm=5176.product26090.6.819.CyyA4l

脚本如下：

#!/usr/bin/env python
# coding=utf-8
from aliyunsdkcore import client
from aliyunsdkrds.request.v20140815 import DescribeDBInstancesRequest
import json
import pymysql

#参数传入
accessKey = sys[0]
accessSecret = sys[1]
region =sys[2]

# 获得cn-qingdao ecs列表
clt = client.AcsClient(accessKey, accessSecret, region)

request = DescribeDBInstancesRequest.DescribeDBInstancesRequest()
request.set_accept_format('json')
request.set_PageSize(100)  # 每页条数
request.set_PageNumber(1)  # 第几页
response = json.loads(clt.do_action_with_exception(request), encoding='utf-8')

for info in response.get('Items').get('DBInstance'):
    rds_no = info.get('DBInstance