创建SQL告警规则
功能介绍
该接口用于创建SQL告警,目前每个账户最多可以创建共200个关键词告警与SQL告警
调用方法
请参见如何调用API。
URI
POST /v2/{project_id}/lts/alarms/sql-alarm-rule
参数 |
是否必选 |
参数类型 |
描述 |
---|---|---|---|
project_id |
是 |
String |
参数解释: 项目ID,可以从调用API处获取,也可以从控制台获取。获取方式请参见:获取项目ID。 约束限制: 不涉及。 取值范围: 不涉及。 默认取值: 不涉及。 最小长度:32 最大长度:32 |
请求参数
参数 |
是否必选 |
参数类型 |
描述 |
---|---|---|---|
X-Auth-Token |
是 |
String |
参数解释: 从IAM服务获取的用户Token,获取方式请参见:获取用户Token。 约束限制: 不涉及。 取值范围: 不涉及。 默认取值: 不涉及。 最小长度:1000 最大长度:2000 |
Content-Type |
是 |
String |
参数解释: 用于定义消息体的格式,该字段填为:application/json;charset=utf8。 约束限制: 不涉及。 取值范围: 不涉及。 默认取值: 不涉及。 最小长度:30 最大长度:30 |
参数 |
是否必选 |
参数类型 |
描述 |
---|---|---|---|
sql_alarm_rule_name |
是 |
String |
参数解释: SQL告警规则名称。 约束限制: 名称只支持输入英文、数字、中文、中划线、下划线,且不能以中划线、下划线开头或结尾。最大长度不超过128个字符。 取值范围: 不涉及。 最小长度:1 最大长度:128 |
is_css_sql |
否 |
Boolean |
参数解释: 是否管道符sql查询。 取值范围: 不涉及。 默认取值: false 缺省值:false |
sql_alarm_rule_description |
否 |
String |
参数解释: SQL告警信息描述。 取值范围: 不涉及。 最小长度:0 最大长度:128 |
sql_requests |
是 |
Array of SqlRequest objects |
参数解释: SQL详细信息。 取值范围: 不涉及。 |
frequency |
是 |
CreateSqlAlarmRuleFrequency object |
参数解释: 告警统计周期。 取值范围: 不涉及。 |
condition_expression |
是 |
String |
参数解释: 告警触发条件表达式。 取值范围: 不涉及。 最小长度:1 最大长度:1024 |
sql_alarm_level |
是 |
String |
参数解释: 告警级别。 取值范围:
枚举值:
|
sql_alarm_send |
是 |
Boolean |
参数解释: 告警是否发送。 取值范围:
|
domain_id |
是 |
String |
参数解释: domainId。 取值范围: 不涉及。 最小长度:32 最大长度:32 |
trigger_condition_count |
否 |
Integer |
参数解释: 触发条件:触发周期。 取值范围: 不涉及。 默认取值: 1 |
trigger_condition_frequency |
否 |
Integer |
参数解释: 触发条件:触发周期。 取值范围: 不涉及。 默认取值: 1 |
whether_recovery_policy |
否 |
Boolean |
参数解释: 是否打开恢复通知。 取值范围: 不涉及。 默认取值: false |
recovery_policy |
否 |
Integer |
参数解释: 恢复策略周期。 取值范围: 不涉及。 默认取值: 3 |
notification_frequency |
是 |
Integer |
参数解释: 通知频率,单位(分钟)。 取值范围: 不涉及。 默认取值: 0 枚举值:
|
alarm_action_rule_name |
否 |
String |
参数解释: 告警行动规则名称。 取值范围: 不涉及。 |
tags |
否 |
Array of tagsBody objects |
参数解释: 告警标签。 取值范围: 不涉及。 |
参数 |
是否必选 |
参数类型 |
描述 |
---|---|---|---|
is_time_range_relative |
否 |
Boolean |
参数解释: 是否相对时间时间。 取值范围: 不涉及。 默认取值: true |
log_stream_id |
是 |
String |
参数解释: 日志流id。 取值范围: 不涉及。 最小长度:36 最大长度:36 |
log_stream_name |
否 |
String |
参数解释: 日志流名称。 取值范围: 不涉及。 最小长度:1 最大长度:64 |
log_group_id |
是 |
String |
参数解释: 日志组id。 取值范围: 不涉及。 最小长度:36 最大长度:36 |
log_group_name |
否 |
String |
参数解释: 日志组名称。 取值范围: 不涉及。 最小长度:1 最大长度:64 |
sql |
是 |
String |
参数解释: sql语句。 取值范围: 不涉及。 最小长度:1 最大长度:1024 |
sql_request_title |
是 |
String |
参数解释: 图表名称。 取值范围: 不涉及。 最小长度:1 最大长度:64 |
search_time_range |
是 |
Integer |
参数解释: 查询执行任务时最近数据的时间范围(当search_time_range_unit为minute,则最大值为60;当search_time_range_unit为hour,则最大值为24)。 取值范围:
默认取值: 1 最小值:1 最大值:60 |
search_time_range_unit |
是 |
String |
参数解释: 查询时间单位。 取值范围:
默认取值: minute 枚举值:
|
参数 |
是否必选 |
参数类型 |
描述 |
---|---|---|---|
type |
是 |
String |
参数解释: 统计周期类型。 取值范围:
枚举值:
|
cron_expr |
否 |
String |
参数解释: 当字段type为"CRON"时取该字段。 示例: 0/9 * * * * 从每小时的第0分钟开始,每9分钟执行一次 0 18 * * * 每天18点0分发送一次 取值范围: 不涉及 最小长度:1 最大长度:1024 |
hour_of_day |
否 |
Integer |
参数解释: 当字段type为"DAILY"或者"WEEKLY"时取该字段。 取值范围: 不涉及 默认值: 0 |
day_of_week |
否 |
Integer |
参数解释: 当字段type为"WEEKLY"时取该字段(周日~周六)。 取值范围: 不涉及 默认值: 0 |
fixed_rate |
否 |
Integer |
参数解释: 当字段type为"FIXED_RATE"时取该字段(当fixed_rate_unit单位为minute,最大值60;当fixed_rate_unit单位为hour,最大值24)。 取值范围: 不涉及 默认值: 0 最小值:1 最大值:60 |
fixed_rate_unit |
否 |
String |
参数解释: 时间单位枚举值 取值范围:
默认值: 0 枚举值:
|
参数 |
是否必选 |
参数类型 |
描述 |
---|---|---|---|
key |
是 |
String |
参数解释: 标签键。 约束限制:
取值范围:
默认取值: 不涉及。 |
value |
否 |
String |
参数解释: 标签值。 约束限制: 标签是以键值对(key-value)的形式表示,key和value为一一对应关系。 取值范围:
默认取值: 不涉及。 |
响应参数
状态码:200
参数 |
参数类型 |
描述 |
---|---|---|
sql_alarm_rule_id |
String |
参数解释: SQL告警规则id。 取值范围: 不涉及。 最小长度:36 最大长度:36 |
状态码:400
参数 |
参数类型 |
描述 |
---|---|---|
error_code |
String |
错误码。 |
error_msg |
String |
调用失败响应信息描述。 枚举值:
|
状态码:500
参数 |
参数类型 |
描述 |
---|---|---|
error_code |
String |
错误码。 |
error_msg |
String |
调用失败响应信息描述。 枚举值:
|
请求示例
创建SQL告警规则
POST https://{endpoint}/v2/{project_id}/lts/alarms/sql-alarm-rule
{
"sql_alarm_rule_name" : "huawei",
"is_css_sql" : false,
"sql_alarm_rule_description" : "huawei",
"sql_requests" : [ {
"log_stream_id" : "1",
"log_group_id" : "1",
"sql" : "select count(*) as t",
"sql_request_title" : "demo",
"search_time_range" : 10,
"search_time_range_unit" : "minute"
} ],
"frequency" : {
"type" : "FIXED_RATE",
"cron_expr" : "",
"hour_of_day" : 0,
"day_of_week" : 0,
"fixed_rate" : 10,
"fixed_rate_unit" : "minute"
},
"condition_expression" : "t>0",
"sql_alarm_level" : "Critical",
"sql_alarm_send" : true,
"domain_id" : "",
"notification_frequency" : 30,
"alarm_action_rule_name" : "",
"notification_save_rule" : {
"language" : "zh-cn",
"timezone" : "Asia/Shanghai",
"user_name" : "huawei",
"template_name" : "消息模板名称",
"topics" : [ {
"name" : "huawei",
"topic_urn" : "urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei",
"display_name" : "",
"push_policy" : 0
} ]
}
}
响应示例
状态码:200
请求响应成功。
{
"sql_alarm_rule_id" : ""
}
状态码:400
BadRequest 非法请求 建议根据error_msg直接修改该请求。
{
"error_code" : "LTS.2005",
"error_msg" : "Alarm rule params validator error."
}
状态码:500
表明服务端能被请求访问到,但是服务内部出错。
{
"error_code" : "LTS.2001",
"error_msg" : "Failed to create alarm rule."
}
SDK代码示例
SDK代码示例如下。
创建SQL告警规则
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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 |
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.*;
import java.util.List;
import java.util.ArrayList;
public class CreateSqlAlarmRuleSolution {
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");
String projectId = "{project_id}";
ICredential auth = new BasicCredentials()
.withProjectId(projectId)
.withAk(ak)
.withSk(sk);
LtsClient client = LtsClient.newBuilder()
.withCredential(auth)
.withRegion(LtsRegion.valueOf("<YOUR REGION>"))
.build();
CreateSqlAlarmRuleRequest request = new CreateSqlAlarmRuleRequest();
CreateSqlAlarmRuleRequestBody body = new CreateSqlAlarmRuleRequestBody();
List<Topics> listNotificationSaveRuleTopics = new ArrayList<>();
listNotificationSaveRuleTopics.add(
new Topics()
.withName("huawei")
.withTopicUrn("urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei")
.withDisplayName("")
.withPushPolicy(0)
);
SqlNotificationSaveRule notificationSaveRulebody = new SqlNotificationSaveRule();
notificationSaveRulebody.withLanguage(SqlNotificationSaveRule.LanguageEnum.fromValue("zh-cn"))
.withTimezone("Asia/Shanghai")
.withUserName("huawei")
.withTopics(listNotificationSaveRuleTopics)
.withTemplateName("消息模板名称");
CreateSqlAlarmRuleFrequency frequencybody = new CreateSqlAlarmRuleFrequency();
frequencybody.withType(CreateSqlAlarmRuleFrequency.TypeEnum.fromValue("FIXED_RATE"))
.withCronExpr("")
.withHourOfDay(0)
.withDayOfWeek(0)
.withFixedRate(10)
.withFixedRateUnit(CreateSqlAlarmRuleFrequency.FixedRateUnitEnum.fromValue("minute"));
List<SqlRequest> listbodySqlRequests = new ArrayList<>();
listbodySqlRequests.add(
new SqlRequest()
.withLogStreamId("1")
.withLogGroupId("1")
.withSql("select count(*) as t")
.withSqlRequestTitle("demo")
.withSearchTimeRange(10)
.withSearchTimeRangeUnit(SqlRequest.SearchTimeRangeUnitEnum.fromValue("minute"))
);
body.withAlarmActionRuleName("");
body.withNotificationFrequency(CreateSqlAlarmRuleRequestBody.NotificationFrequencyEnum.NUMBER_30);
body.withNotificationSaveRule(notificationSaveRulebody);
body.withDomainId("");
body.withSqlAlarmSend(true);
body.withSqlAlarmLevel(CreateSqlAlarmRuleRequestBody.SqlAlarmLevelEnum.fromValue("Critical"));
body.withConditionExpression("t>0");
body.withFrequency(frequencybody);
body.withSqlRequests(listbodySqlRequests);
body.withSqlAlarmRuleDescription("huawei");
body.withIsCssSql(false);
body.withSqlAlarmRuleName("huawei");
request.withBody(body);
try {
CreateSqlAlarmRuleResponse response = client.createSqlAlarmRule(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());
}
}
}
|
创建SQL告警规则
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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
# coding: utf-8
import os
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 = os.environ["CLOUD_SDK_AK"]
sk = os.environ["CLOUD_SDK_SK"]
projectId = "{project_id}"
credentials = BasicCredentials(ak, sk, projectId)
client = LtsClient.new_builder() \
.with_credentials(credentials) \
.with_region(LtsRegion.value_of("<YOUR REGION>")) \
.build()
try:
request = CreateSqlAlarmRuleRequest()
listTopicsNotificationSaveRule = [
Topics(
name="huawei",
topic_urn="urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei",
display_name="",
push_policy=0
)
]
notificationSaveRulebody = SqlNotificationSaveRule(
language="zh-cn",
timezone="Asia/Shanghai",
user_name="huawei",
topics=listTopicsNotificationSaveRule,
template_name="消息模板名称"
)
frequencybody = CreateSqlAlarmRuleFrequency(
type="FIXED_RATE",
cron_expr="",
hour_of_day=0,
day_of_week=0,
fixed_rate=10,
fixed_rate_unit="minute"
)
listSqlRequestsbody = [
SqlRequest(
log_stream_id="1",
log_group_id="1",
sql="select count(*) as t",
sql_request_title="demo",
search_time_range=10,
search_time_range_unit="minute"
)
]
request.body = CreateSqlAlarmRuleRequestBody(
alarm_action_rule_name="",
notification_frequency=30,
notification_save_rule=notificationSaveRulebody,
domain_id="",
sql_alarm_send=True,
sql_alarm_level="Critical",
condition_expression="t>0",
frequency=frequencybody,
sql_requests=listSqlRequestsbody,
sql_alarm_rule_description="huawei",
is_css_sql=False,
sql_alarm_rule_name="huawei"
)
response = client.create_sql_alarm_rule(request)
print(response)
except exceptions.ClientRequestException as e:
print(e.status_code)
print(e.request_id)
print(e.error_code)
print(e.error_msg)
|
创建SQL告警规则
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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 |
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")
projectId := "{project_id}"
auth := basic.NewCredentialsBuilder().
WithAk(ak).
WithSk(sk).
WithProjectId(projectId).
Build()
client := lts.NewLtsClient(
lts.LtsClientBuilder().
WithRegion(region.ValueOf("<YOUR REGION>")).
WithCredential(auth).
Build())
request := &model.CreateSqlAlarmRuleRequest{}
displayNameTopics:= ""
pushPolicyTopics:= int32(0)
var listTopicsNotificationSaveRule = []model.Topics{
{
Name: "huawei",
TopicUrn: "urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei",
DisplayName: &displayNameTopics,
PushPolicy: &pushPolicyTopics,
},
}
timezoneNotificationSaveRule:= "Asia/Shanghai"
notificationSaveRulebody := &model.SqlNotificationSaveRule{
Language: model.GetSqlNotificationSaveRuleLanguageEnum().ZH_CN,
Timezone: &timezoneNotificationSaveRule,
UserName: "huawei",
Topics: listTopicsNotificationSaveRule,
TemplateName: "消息模板名称",
}
cronExprFrequency:= ""
hourOfDayFrequency:= int32(0)
dayOfWeekFrequency:= int32(0)
fixedRateFrequency:= int32(10)
fixedRateUnitFrequency:= model.GetCreateSqlAlarmRuleFrequencyFixedRateUnitEnum().MINUTE
frequencybody := &model.CreateSqlAlarmRuleFrequency{
Type: model.GetCreateSqlAlarmRuleFrequencyTypeEnum().FIXED_RATE,
CronExpr: &cronExprFrequency,
HourOfDay: &hourOfDayFrequency,
DayOfWeek: &dayOfWeekFrequency,
FixedRate: &fixedRateFrequency,
FixedRateUnit: &fixedRateUnitFrequency,
}
var listSqlRequestsbody = []model.SqlRequest{
{
LogStreamId: "1",
LogGroupId: "1",
Sql: "select count(*) as t",
SqlRequestTitle: "demo",
SearchTimeRange: int32(10),
SearchTimeRangeUnit: model.GetSqlRequestSearchTimeRangeUnitEnum().MINUTE,
},
}
alarmActionRuleNameCreateSqlAlarmRuleRequestBody:= ""
sqlAlarmRuleDescriptionCreateSqlAlarmRuleRequestBody:= "huawei"
isCssSqlCreateSqlAlarmRuleRequestBody:= false
request.Body = &model.CreateSqlAlarmRuleRequestBody{
AlarmActionRuleName: &alarmActionRuleNameCreateSqlAlarmRuleRequestBody,
NotificationFrequency: model.GetCreateSqlAlarmRuleRequestBodyNotificationFrequencyEnum().E_30,
NotificationSaveRule: notificationSaveRulebody,
DomainId: "",
SqlAlarmSend: true,
SqlAlarmLevel: model.GetCreateSqlAlarmRuleRequestBodySqlAlarmLevelEnum().CRITICAL,
ConditionExpression: "t>0",
Frequency: frequencybody,
SqlRequests: listSqlRequestsbody,
SqlAlarmRuleDescription: &sqlAlarmRuleDescriptionCreateSqlAlarmRuleRequestBody,
IsCssSql: &isCssSqlCreateSqlAlarmRuleRequestBody,
SqlAlarmRuleName: "huawei",
}
response, err := client.CreateSqlAlarmRule(request)
if err == nil {
fmt.Printf("%+v\n", response)
} else {
fmt.Println(err)
}
}
|
更多编程语言的SDK代码示例,请参见API Explorer的代码示例页签,可生成自动对应的SDK代码示例。
创建SQL告警规则
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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 |
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.*;
import java.util.List;
import java.util.ArrayList;
public class CreateSqlAlarmRuleSolution {
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");
String projectId = "{project_id}";
ICredential auth = new BasicCredentials()
.withProjectId(projectId)
.withAk(ak)
.withSk(sk);
LtsClient client = LtsClient.newBuilder()
.withCredential(auth)
.withRegion(LtsRegion.valueOf("<YOUR REGION>"))
.build();
CreateSqlAlarmRuleRequest request = new CreateSqlAlarmRuleRequest();
CreateSqlAlarmRuleRequestBody body = new CreateSqlAlarmRuleRequestBody();
List<Topics> listNotificationSaveRuleTopics = new ArrayList<>();
listNotificationSaveRuleTopics.add(
new Topics()
.withName("huawei")
.withTopicUrn("urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei")
.withDisplayName("")
.withPushPolicy(0)
);
SqlNotificationSaveRule notificationSaveRulebody = new SqlNotificationSaveRule();
notificationSaveRulebody.withLanguage(SqlNotificationSaveRule.LanguageEnum.fromValue("zh-cn"))
.withTimezone("Asia/Shanghai")
.withUserName("huawei")
.withTopics(listNotificationSaveRuleTopics)
.withTemplateName("消息模板名称");
CreateSqlAlarmRuleFrequency frequencybody = new CreateSqlAlarmRuleFrequency();
frequencybody.withType(CreateSqlAlarmRuleFrequency.TypeEnum.fromValue("FIXED_RATE"))
.withCronExpr("")
.withHourOfDay(0)
.withDayOfWeek(0)
.withFixedRate(10)
.withFixedRateUnit(CreateSqlAlarmRuleFrequency.FixedRateUnitEnum.fromValue("minute"));
List<SqlRequest> listbodySqlRequests = new ArrayList<>();
listbodySqlRequests.add(
new SqlRequest()
.withLogStreamId("1")
.withLogGroupId("1")
.withSql("select count(*) as t")
.withSqlRequestTitle("demo")
.withSearchTimeRange(10)
.withSearchTimeRangeUnit(SqlRequest.SearchTimeRangeUnitEnum.fromValue("minute"))
);
body.withAlarmActionRuleName("");
body.withNotificationFrequency(CreateSqlAlarmRuleRequestBody.NotificationFrequencyEnum.NUMBER_30);
body.withNotificationSaveRule(notificationSaveRulebody);
body.withDomainId("");
body.withSqlAlarmSend(true);
body.withSqlAlarmLevel(CreateSqlAlarmRuleRequestBody.SqlAlarmLevelEnum.fromValue("Critical"));
body.withConditionExpression("t>0");
body.withFrequency(frequencybody);
body.withSqlRequests(listbodySqlRequests);
body.withSqlAlarmRuleDescription("huawei");
body.withIsCssSql(false);
body.withSqlAlarmRuleName("huawei");
request.withBody(body);
try {
CreateSqlAlarmRuleResponse response = client.createSqlAlarmRule(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());
}
}
}
|
创建SQL告警规则
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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
# coding: utf-8
import os
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 = os.environ["CLOUD_SDK_AK"]
sk = os.environ["CLOUD_SDK_SK"]
projectId = "{project_id}"
credentials = BasicCredentials(ak, sk, projectId)
client = LtsClient.new_builder() \
.with_credentials(credentials) \
.with_region(LtsRegion.value_of("<YOUR REGION>")) \
.build()
try:
request = CreateSqlAlarmRuleRequest()
listTopicsNotificationSaveRule = [
Topics(
name="huawei",
topic_urn="urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei",
display_name="",
push_policy=0
)
]
notificationSaveRulebody = SqlNotificationSaveRule(
language="zh-cn",
timezone="Asia/Shanghai",
user_name="huawei",
topics=listTopicsNotificationSaveRule,
template_name="消息模板名称"
)
frequencybody = CreateSqlAlarmRuleFrequency(
type="FIXED_RATE",
cron_expr="",
hour_of_day=0,
day_of_week=0,
fixed_rate=10,
fixed_rate_unit="minute"
)
listSqlRequestsbody = [
SqlRequest(
log_stream_id="1",
log_group_id="1",
sql="select count(*) as t",
sql_request_title="demo",
search_time_range=10,
search_time_range_unit="minute"
)
]
request.body = CreateSqlAlarmRuleRequestBody(
alarm_action_rule_name="",
notification_frequency=30,
notification_save_rule=notificationSaveRulebody,
domain_id="",
sql_alarm_send=True,
sql_alarm_level="Critical",
condition_expression="t>0",
frequency=frequencybody,
sql_requests=listSqlRequestsbody,
sql_alarm_rule_description="huawei",
is_css_sql=False,
sql_alarm_rule_name="huawei"
)
response = client.create_sql_alarm_rule(request)
print(response)
except exceptions.ClientRequestException as e:
print(e.status_code)
print(e.request_id)
print(e.error_code)
print(e.error_msg)
|
创建SQL告警规则
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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 |
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")
projectId := "{project_id}"
auth := basic.NewCredentialsBuilder().
WithAk(ak).
WithSk(sk).
WithProjectId(projectId).
Build()
client := lts.NewLtsClient(
lts.LtsClientBuilder().
WithRegion(region.ValueOf("<YOUR REGION>")).
WithCredential(auth).
Build())
request := &model.CreateSqlAlarmRuleRequest{}
displayNameTopics:= ""
pushPolicyTopics:= int32(0)
var listTopicsNotificationSaveRule = []model.Topics{
{
Name: "huawei",
TopicUrn: "urn:smn:cn-north-7:1b06fc5dc0814a4da1594a9ade9cb93c:huawei",
DisplayName: &displayNameTopics,
PushPolicy: &pushPolicyTopics,
},
}
timezoneNotificationSaveRule:= "Asia/Shanghai"
notificationSaveRulebody := &model.SqlNotificationSaveRule{
Language: model.GetSqlNotificationSaveRuleLanguageEnum().ZH_CN,
Timezone: &timezoneNotificationSaveRule,
UserName: "huawei",
Topics: listTopicsNotificationSaveRule,
TemplateName: "消息模板名称",
}
cronExprFrequency:= ""
hourOfDayFrequency:= int32(0)
dayOfWeekFrequency:= int32(0)
fixedRateFrequency:= int32(10)
fixedRateUnitFrequency:= model.GetCreateSqlAlarmRuleFrequencyFixedRateUnitEnum().MINUTE
frequencybody := &model.CreateSqlAlarmRuleFrequency{
Type: model.GetCreateSqlAlarmRuleFrequencyTypeEnum().FIXED_RATE,
CronExpr: &cronExprFrequency,
HourOfDay: &hourOfDayFrequency,
DayOfWeek: &dayOfWeekFrequency,
FixedRate: &fixedRateFrequency,
FixedRateUnit: &fixedRateUnitFrequency,
}
var listSqlRequestsbody = []model.SqlRequest{
{
LogStreamId: "1",
LogGroupId: "1",
Sql: "select count(*) as t",
SqlRequestTitle: "demo",
SearchTimeRange: int32(10),
SearchTimeRangeUnit: model.GetSqlRequestSearchTimeRangeUnitEnum().MINUTE,
},
}
alarmActionRuleNameCreateSqlAlarmRuleRequestBody:= ""
sqlAlarmRuleDescriptionCreateSqlAlarmRuleRequestBody:= "huawei"
isCssSqlCreateSqlAlarmRuleRequestBody:= false
request.Body = &model.CreateSqlAlarmRuleRequestBody{
AlarmActionRuleName: &alarmActionRuleNameCreateSqlAlarmRuleRequestBody,
NotificationFrequency: model.GetCreateSqlAlarmRuleRequestBodyNotificationFrequencyEnum().E_30,
NotificationSaveRule: notificationSaveRulebody,
DomainId: "",
SqlAlarmSend: true,
SqlAlarmLevel: model.GetCreateSqlAlarmRuleRequestBodySqlAlarmLevelEnum().CRITICAL,
ConditionExpression: "t>0",
Frequency: frequencybody,
SqlRequests: listSqlRequestsbody,
SqlAlarmRuleDescription: &sqlAlarmRuleDescriptionCreateSqlAlarmRuleRequestBody,
IsCssSql: &isCssSqlCreateSqlAlarmRuleRequestBody,
SqlAlarmRuleName: "huawei",
}
response, err := client.CreateSqlAlarmRule(request)
if err == nil {
fmt.Printf("%+v\n", response)
} else {
fmt.Println(err)
}
}
|
更多编程语言的SDK代码示例,请参见API Explorer的代码示例页签,可生成自动对应的SDK代码示例。
状态码
状态码 |
描述 |
---|---|
200 |
请求响应成功。 |
400 |
BadRequest 非法请求 建议根据error_msg直接修改该请求。 |
500 |
表明服务端能被请求访问到,但是服务内部出错。 |
错误码
请参见错误码。