DBbrain 慢日志查询api 接口怎么调用，示例来了

DBbrain 提供了慢日志top sql 的模板查询功能，并且可以用api 调用接口获得top 慢日志。

但是文档没有提供示例，也没有接入explorer 工具中，该怎么调试接口呢？

本文以python 为例提供一个参考示例，其他代码可以自行实现。

接口文档：按照Sql模板查询指定时间段内的慢日志统计结果：https://cloud.tencent.com/document/api/1130/39556

代码示例：

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.common.abstract_client import AbstractClient

from tencentcloud.dbbrain.v20191016 import dbbrain_client, models

from tencentcloud.dbbrain.v20191016.dbbrain_client import DbbrainClient

try:

cred = credential.Credential("xx", "xx")

httpProfile = HttpProfile()

httpProfile.endpoint = "dbbrain.tencentcloudapi.com"

clientProfile = ClientProfile()

clientProfile.httpProfile = httpProfile

client = DbbrainClient(cred, "ap-xx", clientProfile)

req = models.DescribeSlowLogTopSqlsRequest()

params = '{"InstanceId":"cdb-","StartTime":"2020-03-06 00:00:00","EndTime":"2020-03-06 23:59:59","Offset":0,"Limit":7}'

req.from_json_string(params)

resp = client.DescribeSlowLogTopSqls(req)

print(resp.to_json_string())

except TencentCloudSDKException as err:

print(err)