代码示例

本文提供了云数据库 MySQL 版的 Python SDK 的代码示例供参考。

前提条件

• 已完成 SDK 的下载与安装。
• 已完成客户端的初始化。

请求超时时间设置

使用 SDK 调用 MySQL 接口时，默认无超时时间限制。您可以在发起接口调用请求时，在代码的最后加上 _request_timeout 参数来指定请求的超时时间（单位：秒），若未在该时间内完成，请求即会终止并报超时错误。例如，您可以在调用 DescribeDBInstance 接口时，通过如下代码将超时时间设置为 10 秒。

resp = api_instance.describe_db_instance(volcenginesdkrdsmysql.DescribeDBInstanceRequest(
    instance_id="mysql-************",
    _configuration=configuration,
), _request_timeout=10)

创建 MySQL 实例

关于下述 SDK 代码中所使用参数的定义、取值范围等信息，请参见 CreateDBInstance。

本示例中所创建的 MySQL 实例配置如下：

from  pprint  import  pprint

import  volcenginesdkrdsmysql

import  volcenginesdkcore

from  volcenginesdkcore.rest  import  ApiException

if  __name__ ==  "__main__":
        configuration = volcenginesdkcore.Configuration()
        configuration.ak =  "Your AK"
        configuration.sk =  "Your SK"
        configuration.region =  "Your Region"
    try:
                api_instance = volcenginesdkrdsmysql.RDSMYSQLApi(volcenginesdkcore.ApiClient(configuration))
                resp = api_instance.create_db_instance(volcenginesdkrdsmysql.CreateDBInstanceRequest(            
                        instance_name="Your Instance Name",
                        region="beijing",
                        zone="cn-beijing-a",
                        db_engine="MySQL",
                        db_engine_version="MySQL_Community_5_7",
                        instance_type="HA",
                        instance_spec_name="rds.mysql.1c2g",
                        storage_type="LocalSSD", 
                        storage_space_gb=100,
                        vpc_id="vpc-****",
                        number=1,
                        super_account_name="****", 
                        super_account_password="****",
                        charge_type="Prepaid",
                        auto_renew=True,
                        prepaid_period="Month",
                        used_time=1,
                        project_name="default",
                        subnet_id="subnet-****",
                        _configuration=configuration,
                ))
                pprint(resp)
    except  ApiException  as  e:
        print("Exception: %s\n"  % e)

查询 MySQL 实例信息

关于下述 SDK 请求中所使用参数的定义、取值范围等信息，请参见 DescribeDBInstance。

import  volcenginesdkrdsmysql

import  volcenginesdkcore

from  volcenginesdkcore.rest  import  ApiException

if  __name__ ==  "__main__":
        configuration = volcenginesdkcore.Configuration()
        configuration.ak =  "Your AK"
        configuration.sk =  "Your SK"
        configuration.region =  "Your Region"
    try:
        # 查询指定 MySQL 实例信息
                api_instance = volcenginesdkrdsmysql.RDSMYSQLApi(volcenginesdkcore.ApiClient(configuration))
                resp = api_instance.describe_db_instance(volcenginesdkrdsmysql.DescribeDBInstanceRequest(
            instance_id="mysql-************",
        ))
        pprint(resp)
    except  ApiException  as  e:
        print("Exception: %s\n"  % e)