python获取RDS信息并遍历结果

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

脚本如下：

#!/usr/bin/env python# coding=utf-8from aliyunsdkcore import clientfrom aliyunsdkrds.request.v20140815 import DescribeDBInstancesRequestimport jsonimport 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('DBInstanceId');    rds_name = info.get('DBInstanceDescription')    region = info.get('RegionId')    zone = info.get('ZoneId')    engine = info.get('Engine')    engineVersion = info.get('EngineVersion')    payType = info.get('PayType')    rdsNetType = info.get('DBInstanceNetType')    rdsClass = info.get('DBInstanceClass')    rdsStatus = info.get('DBInstanceStatus')    creteTime = info.get('CreateTime')    expireTime = info.get('ExpireTime')