更新时间:2024-02-06 GMT+08:00
分享

查询用户历史sql

功能介绍

查询用户历史sql

调用方法

请参见如何调用API

URI

GET /v2/{project_id}/lts/history-sql

表1 路径参数

参数

是否必选

参数类型

描述

project_id

String

项目ID,获取方式请参见:获取项目ID,获取账号ID,日志组ID、日志流ID

缺省值:None

最小长度:32

最大长度:32

表2 Query参数

参数

是否必选

参数类型

描述

log_group_id

String

日志组ID,获取方式请参见:获取项目ID,获取账号ID,日志组ID、日志流ID

最小长度:36

最大长度:36

log_stream_id

String

日志流ID,获取方式请参见:获取项目ID,获取账号ID,日志组ID、日志流ID

最小长度:36

最大长度:36

请求参数

表3 请求Header参数

参数

是否必选

参数类型

描述

X-Auth-Token

String

从IAM服务获取的用户Token,获取方式请参见:获取用户Token

最小长度:1

最大长度:10000

Content-Type

String

该字段填为:application/json;charset=UTF-8。

最小长度:30

最大长度:30

响应参数

状态码: 200

表4 响应Body参数

参数

参数类型

描述

results

Array of QuertHistorySQLResultsBody objects

响应结果。

表5 QuertHistorySQLResultsBody

参数

参数类型

描述

last_use_time

Long

上次修改时间,时间戳,毫秒数

sql_statement

String

历史sql语句

状态码: 400

表6 响应Body参数

参数

参数类型

描述

message

ErrorMessagebody object

错误信息body体

表7 ErrorMessagebody

参数

参数类型

描述

code

String

错误码

最小长度:8

最大长度:36

details

String

错误描述

最小长度:2

最大长度:512

状态码: 500

表8 响应Body参数

参数

参数类型

描述

message

ErrorMessagebody object

错误信息body体

表9 ErrorMessagebody

参数

参数类型

描述

code

String

错误码

最小长度:8

最大长度:36

details

String

错误描述

最小长度:2

最大长度:512

请求示例

查询用户历史sql

/v2/2a473356cca5487f8373be891bffc1cf/lts/history-sql?log_group_id=d1f4240d-5ee2-4e0b-9e2c-e25c7978c001&log_stream_id=f3d853be-0576-4dff-aee9-c093e4924b63

响应示例

状态码: 200

查询sql历史成功

{
  "results" : [ {
    "last_use_time" : 1669689650936,
    "sql_statement" : "SELECT *"
  }, {
    "last_use_time" : 1666775421613,
    "sql_statement" : "select count(\"t\") as pv"
  }, {
    "last_use_time" : 1666661494805,
    "sql_statement" : "SELECT count(\"time\")"
  }, {
    "last_use_time" : 1666598233252,
    "sql_statement" : "SELECT count(\"t\") as pv"
  }, {
    "last_use_time" : 1666598226763,
    "sql_statement" : "SELECT count(\"t\") "
  }, {
    "last_use_time" : 1666598222298,
    "sql_statement" : "SELECT count(\"t\") as pv"
  }, {
    "last_use_time" : 1666598221585,
    "sql_statement" : "SELECT count(\"t\") as p"
  }, {
    "last_use_time" : 1666598220276,
    "sql_statement" : "SELECT count(\"t\") as "
  }, {
    "last_use_time" : 1666598212453,
    "sql_statement" : "SELECT count(\"t\")"
  } ]
}

状态码: 400

BadRequest 非法请求建议根据error_msg直接修改该请求

{
  "message" : {
    "code" : "LTS.0603",
    "details" : "group or stream not exist"
  }
}

状态码: 500

表明服务端能被请求访问到,但是服务内部出错

{
  "message" : {
    "code" : "LTS.0203",
    "details" : "Internal Server Error"
  }
}

SDK代码示例

SDK代码示例如下。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
package com.huaweicloud.sdk.test;

import com.huaweicloud.sdk.core.auth.ICredential;
import com.huaweicloud.sdk.core.auth.BasicCredentials;
import com.huaweicloud.sdk.core.exception.ConnectionException;
import com.huaweicloud.sdk.core.exception.RequestTimeoutException;
import com.huaweicloud.sdk.core.exception.ServiceResponseException;
import com.huaweicloud.sdk.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListHistorySqlSolution {

    public static void main(String[] args) {
        // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
        // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
        String ak = System.getenv("CLOUD_SDK_AK");
        String sk = System.getenv("CLOUD_SDK_SK");

        ICredential auth = new BasicCredentials()
                .withAk(ak)
                .withSk(sk);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListHistorySqlRequest request = new ListHistorySqlRequest();
        request.withLogGroupId("<log_group_id>");
        request.withLogStreamId("<log_stream_id>");
        try {
            ListHistorySqlResponse response = client.listHistorySql(request);
            System.out.println(response.toString());
        } catch (ConnectionException e) {
            e.printStackTrace();
        } catch (RequestTimeoutException e) {
            e.printStackTrace();
        } catch (ServiceResponseException e) {
            e.printStackTrace();
            System.out.println(e.getHttpStatusCode());
            System.out.println(e.getRequestId());
            System.out.println(e.getErrorCode());
            System.out.println(e.getErrorMsg());
        }
    }
}
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
# coding: utf-8

from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 import *

if __name__ == "__main__":
    # The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    # In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak = __import__('os').getenv("CLOUD_SDK_AK")
    sk = __import__('os').getenv("CLOUD_SDK_SK")

    credentials = BasicCredentials(ak, sk) \

    client = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListHistorySqlRequest()
        request.log_group_id = "<log_group_id>"
        request.log_stream_id = "<log_stream_id>"
        response = client.list_history_sql(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/region"
)

func main() {
    // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak := os.Getenv("CLOUD_SDK_AK")
    sk := os.Getenv("CLOUD_SDK_SK")

    auth := basic.NewCredentialsBuilder().
        WithAk(ak).
        WithSk(sk).
        Build()

    client := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListHistorySqlRequest{}
	request.LogGroupId = "<log_group_id>"
	request.LogStreamId = "<log_stream_id>"
	response, err := client.ListHistorySql(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

更多编程语言的SDK代码示例,请参见API Explorer的代码示例页签,可生成自动对应的SDK代码示例。

状态码

状态码

描述

200

查询sql历史成功

400

BadRequest 非法请求建议根据error_msg直接修改该请求

500

表明服务端能被请求访问到,但是服务内部出错

错误码

请参见错误码

分享:

    相关文档

    相关产品