python连接阿里云数据库_RDS SDK for Python使用参考

创建实例

调用示例from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkrds.request.v20140815.DescribeDBInstancePerformanceRequest import DescribeDBInstancePerformanceRequest

from aliyunsdkrds.request.v20140815.CreateDBInstanceRequest import CreateDBInstanceRequest

client = AcsClient(

"",

"",

"cn-hangzhou"

);

request =CreateDBInstanceRequest();

request.set_Engine("PostgreSQL");

request.set_EngineVersion("10.0");

request.set_DBInstanceClass("pg.n1.micro.1");

request.set_DBInstanceStorage("20");

request.set_DBInstanceNetType("Intranet");

request.set_DBInstanceDescription("aaa");

request.set_SecurityIPList("127.0.0.1");

request.set_PayType("Postpaid");

request.set_ZoneId("cn-hangzhou-b");

request.set_InstanceNetworkType("Classic");

request.set_Period("Month");

request.set_UsedTime("2");

try:

response = client.do_action_with_exception(request)

print response

except ServerException as e:

print e

except ClientException as e:

print e

返回结果{

"OrderId":"20279634xxxxxxx",

"DBInstanceId":"pgm-xxxxxxx",

"RequestId":"BAF2A62B-804B-4C6C-BEE4-BAD2CA4C79E1"

}

实例变配

调用示例from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkrds.request.v20140815.DescribeDBInstancePerformanceRequest import DescribeDBInstancePerformanceRequest

from aliyunsdkrds.request.v20140815.ModifyDBInstanceSpecRequest import ModifyDBInstanceSpecRequest

client = AcsClient(

"",

"",

"cn-hangzhou"

);

request =ModifyDBInstanceSpecRequest();

request.set_DBInstanceId("pgm-xxxxxxx");

request.set_PayType("Postpaid");

request.set_DBInstanceClass("pg.n2.small.1");

try:

response = client.do_action_with_exception(request)

print response

except ServerException as e:

print e

except ClientException as e:

print e

返回结果{"RequestId":"B77F7694-B632-4C2A-BEA5-F8E44AD3A97E"}

创建只读实例

调用示例from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkrds.request.v20140815.DescribeDBInstancePerformanceRequest import DescribeDBInstancePerformanceRequest

from aliyunsdkrds.request.v20140815.CreateReadOnlyDBInstanceRequest import CreateReadOnlyDBInstanceRequest

client = AcsClient(

"",

"",

"cn-hangzhou"

);

request =CreateReadOnlyDBInstanceRequest();

request.set_DBInstanceId("rm-xxxxxxx");

request.set_EngineVersion("5.6");

request.set_DBInstanceClass("rds.mysql.s1.small");

request.set_DBInstanceStorage("20");

request.set_DBInstanceDescription("testDesc");

request.set_PayType("Postpaid");

request.set_ZoneId("cn-hangzhou-b");

request.set_InstanceNetworkType("Classic");

try:

response = client.do_action_with_exception(request)

print response

except ServerException as e:

print e

except ClientException as e:

print e

返回结果{

"OrderId": "1214369xxxxxxx",

"ConnectionString": "rr-bpxxxxxxx.mysql.rds.aliyuncs.com",

"DBInstanceId": "rr-bpxxxxxxx",

"Port": "3306",

"RequestId": "1E43AAE0-BEE8-43DA-860D-EAF2AA0724DC"

}

重启实例

调用示例from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkrds.request.v20140815.DescribeDBInstancePerformanceRequest import DescribeDBInstancePerformanceRequest

from aliyunsdkrds.request.v20140815.RestartDBInstanceRequest import RestartDBInstanceRequest

client = AcsClient(

"",

"",

"cn-hangzhou"

);

request =RestartDBInstanceRequest();

request.set_DBInstanceId("rm-bpxxxxxxx");

try:

response = client.do_action_with_exception(request)

print response

except ServerException as e:

print e

except ClientException as e:

print e

返回结果{"RequestId":"EED6E546-099A-4434-AB09-C85DD396E17B"}

实例列表

调用示例from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkrds.request.v20140815.DescribeDBInstancePerformanceRequest import DescribeDBInstancePerformanceRequest

from aliyunsdkrds.request.v20140815.DescribeDBInstancesRequest import DescribeDBInstancesRequest

client = AcsClient(

"",

"",

"cn-hangzhou"

);

request =DescribeDBInstancesRequest();

print response

try:

response = client.do_action_with_exception(request)

print response

except ServerException as e:

print e

except ClientException as e:

print e

返回结果{

"Items": {

"DBInstance": [

{

"LockMode": "Unlock",

"DBInstanceNetType": "Intranet",

"DBInstanceClass": "rds.mysql.s2.large",

"ResourceGroupId": "rg-acfxxxxxxx",

"DBInstanceId": "rm-bpxxxxxxx",

"VpcCloudInstanceId": "",

"ZoneId": "cn-hangzhou-f",

"ReadOnlyDBInstanceIds": {

"ReadOnlyDBInstanceId": []

},

"InstanceNetworkType": "Classic",

"ConnectionMode": "Standard",

"Engine": "MySQL",

"MutriORsignle": false,

"InsId": 1,

"ExpireTime": "",

"CreateTime": "2018-11-07T15:52Z",

"DBInstanceType": "Primary",

"RegionId": "cn-hangzhou",

"EngineVersion": "5.7",

"LockReason": "",

"DBInstanceStatus": "Running",

"PayType": "Postpaid"

},

{

"LockMode": "Unlock",

"DBInstanceNetType": "Intranet",

"DBInstanceClass": "rds.mysql.s2.large",

"ResourceGroupId": "rg-acfxxxxxxx",

"DBInstanceId": "rm-bpxxxxxxx",

"VpcCloudInstanceId": "",

"ZoneId": "cn-hangzhou-g",

"ReadOnlyDBInstanceIds": {

"ReadOnlyDBInstanceId": []

},

"InstanceNetworkType": "Classic",

"ConnectionMode": "Standard",

"Engine": "MySQL",

"MutriORsignle": false,

"InsId": 1,

"ExpireTime": "2019-11-07T16:00:00Z",

"CreateTime": "2018-11-07T15:42Z",

"DBInstanceType": "Primary",

"RegionId": "cn-hangzhou",

"EngineVersion": "5.7",

"LockReason": "",

"DBInstanceStatus": "Running",

"PayType": "Prepaid"

}

]

},

"TotalRecordCount": 209,

"PageNumber": 1,

"RequestId": "0C5793A6-80C3-4AC0-A5E1-CCA25F387AE6",

"PageRecordCount": 30

}