sql

Documentation

Index

• Variables

Variables

var InsertAPIAlarmHistory string = `` /* 174-byte string literal not displayed */

var InsertAPIMapStats string = `` /* 166-byte string literal not displayed */

Api被调用统计信息

var InsertAPIStats string = `` /* 160-byte string literal not displayed */

API 记录语句

var InsertAPIs string = `INSERT INTO app_apis (app_name, api, api_type) VALUES (?, ?, ?) ;`

var InsertAgent string = `` /* 187-byte string literal not displayed */

agent 信息入库

var InsertAgentInfo string = `INSERT INTO agents (app_name, agent_id, start_time, agent_info) 
VALUES ( ?, ?, ?, ?);`

agent info 信息入库

var InsertApiAlert string = `` /* 141-byte string literal not displayed */

var InsertApp string = `
INSERT
INTO apps(app_name)
VALUES (?)`

App 名 信息入库

var InsertExceptionStats string = `` /* 163-byte string literal not displayed */

InsertExceptionStats ....

var InsertMethod string = `INSERT INTO app_methods (app_name, method_id, method_info, line, type) 
VALUES (?, ?, ?, ?, ?);`

app method 信息入库

var InsertMethodStats string = `` /* 166-byte string literal not displayed */

InsertMethodStats ...

var InsertRuntimeAlert string = `` /* 149-byte string literal not displayed */

var InsertRuntimeStat string = `
	INSERT
	INTO agent_runtime(app_name, agent_id, input_date, metrics, runtime_type)
	VALUES (?, ?, ?, ?, ?);`

insert runtime stat 信息入库

var InsertSQL string = `INSERT INTO app_sqls (app_name, sql_id, sql_info) 
VALUES (?, ?, ?);`

sql语句 信息入库

var InsertSQLAlert string = `` /* 143-byte string literal not displayed */

var InsertSQLStats string = `` /* 131-byte string literal not displayed */

InserSQLStats ...

var InsertSpan string = `` /* 256-byte string literal not displayed */

插入span

var InsertSpanChunk string = `INSERT INTO traces_chunk(trace_id, span_id, cid, event_list) VALUES (?, ?, ?, ?)`

插入span chunk

var InsertSrvType string = `
INSERT
INTO service_type(service_type, info)
VALUES (?, ?) ;`

插入服务类型

var InsertString string = `INSERT INTO app_strs (app_name, str_id, str_info) 
VALUES (?, ?, ?);`

string 信息入库

var InsertTargetMap string = `` /* 187-byte string literal not displayed */

var InsertTraceIndex string = `` /* 148-byte string literal not displayed */

插入trace索引

var InsertUnknowParentMap string = `` /* 187-byte string literal not displayed */

var LoadAgents string = `SELECT service_type, agent_id, start_time, ip, is_live, host_name FROM agents WHERE app_name=?;`

var LoadAlert string = `SELECT alerts FROM alerts_policy WHERE id=?;`

加载策略详情

var LoadApps string = `SELECT app_name FROM apps;`

var LoadDubboApis string = `SELECT app_name, api, api_type  FROM app_apis;`

var LoadPolicys string = `SELECT name, owner, api_alerts, channel, group,
 policy_id, update_date, users FROM alerts_app ;`

加载所有策略

var LoadUers string = `SELECT id, email, mobile FROM account ;`

var LoaddefaultPolicy string = `SELECT alerts FROM alerts_policy WHERE name='apm-default-policy' ALLOW FILTERING;`

加载默认策略详情

var UpdateAgentState string = `UPDATE agents  SET is_live=?, end_time=? WHERE app_name =? AND agent_id =?;`

更新agent 在线信息