fix:IP Behavior Pattern增加total字段

1 files changed, 1 insertions, 1 deletions

diff --git a/cn-admin/src/main/resources/db/R__AZ_magic_api_file.sql b/cn-admin/src/main/resources/db/R__AZ_magic_api_file.sql
index c7daaf1..aedfe95 100644
--- a/cn-admin/src/main/resources/db/R__AZ_magic_api_file.sql
+++ b/cn-admin/src/main/resources/db/R__AZ_magic_api_file.sql
@@ -563,7 +563,7 @@ INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/app/relate/App相关
 INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/app/relate/group.json', '{\n  \"properties\" : { },\n  \"id\" : \"a0e6aa98e5234950886370156c75ea39\",\n  \"name\" : \"relate\",\n  \"type\" : \"api\",\n  \"parentId\" : \"aa40fc70df5949c294c4517f5b0c5076\",\n  \"path\" : \"/relate\",\n  \"createTime\" : 1686292816212,\n  \"updateTime\" : null,\n  \"createBy\" : \"ljy\",\n  \"updateBy\" : null,\n  \"paths\" : [ ],\n  \"options\" : [ ]\n}');
 INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/behavior/', 'this is directory');
 INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/behavior/group.json', '{\n  \"properties\" : { },\n  \"id\" : \"0959f0f79ce246fe93a6ee7027c9ec9c\",\n  \"name\" : \"behavior\",\n  \"type\" : \"api\",\n  \"parentId\" : \"fb8cd5c4ffb84924b04c05e93f9fe47d\",\n  \"path\" : \"/behavior\",\n  \"createTime\" : 1697610462916,\n  \"updateTime\" : null,\n  \"createBy\" : \"admin\",\n  \"updateBy\" : null,\n  \"paths\" : [ ],\n  \"options\" : [ ]\n}');
-INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/behavior/IPBehaviorPattern.ms', '{\n  \"properties\" : { },\n  \"id\" : \"ae13474905654459b55f20ccd5246c7e\",\n  \"script\" : null,\n  \"groupId\" : \"0959f0f79ce246fe93a6ee7027c9ec9c\",\n  \"name\" : \"IPBehaviorPattern\",\n  \"createTime\" : null,\n  \"updateTime\" : 1698214491736,\n  \"lock\" : null,\n  \"createBy\" : null,\n  \"updateBy\" : \"ljy\",\n  \"path\" : \"/ip\",\n  \"method\" : \"GET\",\n  \"parameters\" : [ {\n    \"name\" : \"resource\",\n    \"value\" : \"1.1.1.1\",\n    \"description\" : null,\n    \"required\" : true,\n    \"dataType\" : \"String\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  }, {\n    \"name\" : \"startTime\",\n    \"value\" : \"1697510885\",\n    \"description\" : null,\n    \"required\" : false,\n    \"dataType\" : \"Long\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  }, {\n    \"name\" : \"endTime\",\n    \"value\" : \"1697610885\",\n    \"description\" : null,\n    \"required\" : false,\n    \"dataType\" : \"Long\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  } ],\n  \"options\" : [ ],\n  \"requestBody\" : \"\",\n  \"headers\" : [ ],\n  \"paths\" : [ ],\n  \"responseBody\" : \"{\\n    \\\"status\\\": 200,\\n    \\\"code\\\": 200,\\n    \\\"queryKey\\\": \\\"bba4691dbcc32f9a9a51b727e145323f\\\",\\n    \\\"success\\\": true,\\n    \\\"message\\\": null,\\n    \\\"statistics\\\": {\\n        \\\"elapsed\\\": 19,\\n        \\\"rows_read\\\": 454303,\\n        \\\"bytes_read\\\": 57437850,\\n        \\\"result_size\\\": 283,\\n        \\\"result_rows\\\": 1\\n    },\\n    \\\"job\\\": null,\\n    \\\"formatType\\\": \\\"json\\\",\\n    \\\"meta\\\": [{\\n        \\\"name\\\": \\\"asymmetric_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"bulky_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"cbr_streaming_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"download_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"interactive_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"pseudo_unidirectional_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"streaming_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"unidirectional_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"random_looking_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }, {\\n        \\\"name\\\": \\\"bidirectional_sessions\\\",\\n        \\\"type\\\": \\\"long\\\",\\n        \\\"category\\\": \\\"Metric\\\"\\n    }],\\n    \\\"data\\\": {\\n        \\\"resultType\\\": \\\"table\\\",\\n        \\\"result\\\": [{\\n            \\\"asymmetric_sessions\\\": \\\"4\\\",\\n            \\\"bulky_sessions\\\": \\\"0\\\",\\n            \\\"cbr_streaming_sessions\\\": \\\"0\\\",\\n            \\\"download_sessions\\\": \\\"0\\\",\\n            \\\"interactive_sessions\\\": \\\"7\\\",\\n            \\\"pseudo_unidirectional_sessions\\\": \\\"0\\\",\\n            \\\"streaming_sessions\\\": \\\"0\\\",\\n            \\\"unidirectional_sessions\\\": \\\"0\\\",\\n            \\\"random_looking_sessions\\\": \\\"0\\\",\\n            \\\"bidirectional_sessions\\\": \\\"140\\\"\\n        }]\\n    },\\n    \\\"originalUrl\\\": \\\"http://192.168.44.55:9999/?query=SELECT SUM(asymmetric_sessions) AS asymmetric_sessions, SUM(bulky_sessions) AS bulky_sessions, SUM(cbr_streaming_sessions) AS cbr_streaming_sessions, SUM(download_sessions) AS download_sessions, SUM(interactive_sessions) AS interactive_sessions, SUM(pseudo_unidirectional_sessions) AS pseudo_unidirectional_sessions, SUM(streaming_sessions) AS streaming_sessions, SUM(unidirectional_sessions) AS unidirectional_sessions, SUM(random_looking_sessions) AS random_looking_sessions, SUM(bidirectional_sessions) AS bidirectional_sessions FROM metric_ip WHERE stat_time >= 1697510885 AND stat_time < 1697610885 AND side = \'server\' AND ip = \'1.1.1.1\'&format=json&option=real-time\\\",\\n    \\\"msg\\\": \\\"OK\\\"\\n}\",\n  \"description\" : null,\n  \"requestBodyDefinition\" : null,\n  \"responseBodyDefinition\" : {\n    \"name\" : \"\",\n    \"value\" : \"\",\n    \"description\" : \"\",\n    \"required\" : false,\n    \"dataType\" : \"Object\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : \"\",\n    \"error\" : \"\",\n    \"expression\" : \"\",\n    \"children\" : [ {\n      \"name\" : \"status\",\n      \"value\" : \"200\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Integer\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"code\",\n      \"value\" : \"200\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Integer\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"queryKey\",\n      \"value\" : \"bba4691dbcc32f9a9a51b727e145323f\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"success\",\n      \"value\" : \"true\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Boolean\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"message\",\n      \"value\" : \"null\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"statistics\",\n      \"value\" : \"\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Object\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ {\n        \"name\" : \"elapsed\",\n        \"value\" : \"19\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"rows_read\",\n        \"value\" : \"454303\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"bytes_read\",\n        \"value\" : \"57437850\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"result_size\",\n        \"value\" : \"283\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"result_rows\",\n        \"value\" : \"1\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      } ]\n    }, {\n      \"name\" : \"job\",\n      \"value\" : \"null\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Object\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"formatType\",\n      \"value\" : \"json\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"meta\",\n      \"value\" : \"\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Array\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ {\n        \"name\" : \"\",\n        \"value\" : \"\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Object\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ {\n          \"name\" : \"name\",\n          \"value\" : \"asymmetric_sessions\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"String\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ ]\n        }, {\n          \"name\" : \"type\",\n          \"value\" : \"long\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"String\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ ]\n        }, {\n          \"name\" : \"category\",\n          \"value\" : \"Metric\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"String\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ ]\n        } ]\n      } ]\n    }, {\n      \"name\" : \"data\",\n      \"value\" : \"\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Object\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ {\n        \"name\" : \"resultType\",\n        \"value\" : \"table\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"String\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"result\",\n        \"value\" : \"\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Array\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ {\n          \"name\" : \"\",\n          \"value\" : \"\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"Object\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ {\n            \"name\" : \"asymmetric_sessions\",\n            \"value\" : \"4\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"bulky_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"cbr_streaming_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"download_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"interactive_sessions\",\n            \"value\" : \"7\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"pseudo_unidirectional_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"streaming_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"unidirectional_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"random_looking_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"bidirectional_sessions\",\n            \"value\" : \"140\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          } ]\n        } ]\n      } ]\n    }, {\n      \"name\" : \"originalUrl\",\n      \"value\" : \"http://192.168.44.55:9999/?query=SELECT SUM(asymmetric_sessions) AS asymmetric_sessions, SUM(bulky_sessions) AS bulky_sessions, SUM(cbr_streaming_sessions) AS cbr_streaming_sessions, SUM(download_sessions) AS download_sessions, SUM(interactive_sessions) AS interactive_sessions, SUM(pseudo_unidirectional_sessions) AS pseudo_unidirectional_sessions, SUM(streaming_sessions) AS streaming_sessions, SUM(unidirectional_sessions) AS unidirectional_sessions, SUM(random_looking_sessions) AS random_looking_sessions, SUM(bidirectional_sessions) AS bidirectional_sessions FROM metric_ip WHERE stat_time >= 1697510885 AND stat_time < 1697610885 AND side = \'server\' AND ip = \'1.1.1.1\'&format=json&option=real-time\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"msg\",\n      \"value\" : \"OK\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    } ]\n  }\n}\r\n================================\r\nimport net.geedge.common.utils.FreeMarkerUtil as freeMarkerUtil;\r\nimport net.geedge.common.utils.JSONUtil as jsonUtil;\r\nimport \'@/pre/timeHandleNone\' as timeHandle;\r\nimport \'@/post/tableNotToHump\' as postHandle;\r\nimport \'@/public/getGalaxyResult\' as getGalaxyResult;\r\n/**\r\n * 入参整理 包括调用公共函数\r\n */\r\nvar parameter={\r\n    \"resource\":resource,\r\n    \"startTime\":startTime,\r\n    \"endTime\":endTime\r\n}\r\ntimeHandle(parameter);\r\n/**\r\n * 接口sql相关内容整理 通过freemarker模板生成最后执行语句\r\n */\r\nvar q = \"{\\r\\n    \\\"query\\\": \\\"SELECT SUM(asymmetric_sessions) AS asymmetric, SUM(bulky_sessions) AS bulky, SUM(cbr_streaming_sessions) AS cbr_streaming, SUM(download_sessions) AS download, SUM(interactive_sessions) AS interactive, SUM(pseudo_unidirectional_sessions) AS pseudo_unidirectional, SUM(streaming_sessions) AS streaming, SUM(unidirectional_sessions) AS unidirectional, SUM(random_looking_sessions) AS random_looking, SUM(bidirectional_sessions) AS bidirectional FROM metric_ip WHERE stat_time >= ${startTime} AND stat_time < ${endTime} AND side = \'server\' AND ip = \'${resource}\'\\\",\\r\\n    \\\"option\\\": \\\"real-time\\\",\\r\\n    \\\"format\\\": \\\"json\\\"\\r\\n}\"\r\nvar result  = freeMarkerUtil.processTemplateIntoString(\"v1EntityDetailIpRelatePorts\",q,parameter);\r\n\r\n/**\r\n * 调用galaxy接口获取结果信息\r\n */\r\nvar res = jsonUtil.toBean(result,HashMap.class);\r\nvar galaxyRes = getGalaxyResult(res);\r\n/**\r\n * 处理galaxy返回的数据结果 将新结果返回前端界面\r\n */\r\nvar result = postHandle(galaxyRes);\r\n\r\nreturn result');
+INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/behavior/IPBehaviorPattern.ms', '{\n  \"properties\" : { },\n  \"id\" : \"ae13474905654459b55f20ccd5246c7e\",\n  \"script\" : null,\n  \"groupId\" : \"0959f0f79ce246fe93a6ee7027c9ec9c\",\n  \"name\" : \"IPBehaviorPattern\",\n  \"createTime\" : null,\n  \"updateTime\" : 1700043952834,\n  \"lock\" : null,\n  \"createBy\" : null,\n  \"updateBy\" : \"admin\",\n  \"path\" : \"/ip\",\n  \"method\" : \"GET\",\n  \"parameters\" : [ {\n    \"name\" : \"resource\",\n    \"value\" : \"20.189.173.9\",\n    \"description\" : null,\n    \"required\" : true,\n    \"dataType\" : \"String\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  }, {\n    \"name\" : \"startTime\",\n    \"value\" : \"1700039043\",\n    \"description\" : null,\n    \"required\" : false,\n    \"dataType\" : \"Long\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  }, {\n    \"name\" : \"endTime\",\n    \"value\" : \"1700042643\",\n    \"description\" : null,\n    \"required\" : false,\n    \"dataType\" : \"Long\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  } ],\n  \"options\" : [ ],\n  \"requestBody\" : \"\",\n  \"headers\" : [ ],\n  \"paths\" : [ ],\n  \"responseBody\" : \"{\\n    \\\"status\\\": 200,\\n    \\\"code\\\": 200,\\n    \\\"queryKey\\\": \\\"d003f29870614dbb48fa7d94c33aa130\\\",\\n    \\\"success\\\": true,\\n    \\\"message\\\": null,\\n    \\\"statistics\\\": {\\n        \\\"elapsed\\\": 2,\\n        \\\"rows_read\\\": 10414,\\n        \\\"bytes_read\\\": 1318102,\\n        \\\"result_size\\\": 191,\\n        \\\"result_rows\\\": 1\\n    },\\n    \\\"job\\\": null,\\n    \\\"formatType\\\": \\\"json\\\",\\n    \\\"meta\\\": [\\n        {\\n            \\\"name\\\": \\\"asymmetric\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"bulky\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"cbr_streaming\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"download\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"interactive\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"pseudo_unidirectional\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"streaming\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"unidirectional\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"random_looking\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        },\\n        {\\n            \\\"name\\\": \\\"bidirectional\\\",\\n            \\\"type\\\": \\\"long\\\",\\n            \\\"category\\\": \\\"Metric\\\"\\n        }\\n    ],\\n    \\\"data\\\": {\\n        \\\"resultType\\\": \\\"table\\\",\\n        \\\"result\\\": [\\n            {\\n                \\\"asymmetric\\\": \\\"0\\\",\\n                \\\"bulky\\\": \\\"0\\\",\\n                \\\"cbr_streaming\\\": \\\"0\\\",\\n                \\\"download\\\": \\\"0\\\",\\n                \\\"interactive\\\": \\\"0\\\",\\n                \\\"pseudo_unidirectional\\\": \\\"0\\\",\\n                \\\"streaming\\\": \\\"0\\\",\\n                \\\"unidirectional\\\": \\\"0\\\",\\n                \\\"random_looking\\\": \\\"0\\\",\\n                \\\"bidirectional\\\": \\\"0\\\"\\n            }\\n        ]\\n    },\\n    \\\"originalUrl\\\": \\\"http://192.168.44.55:9999/sql/?query=SELECT SUM(asymmetric_sessions) AS asymmetric, SUM(bulky_sessions) AS bulky, SUM(cbr_streaming_sessions) AS cbr_streaming, SUM(download_sessions) AS download, SUM(interactive_sessions) AS interactive, SUM(pseudo_unidirectional_sessions) AS pseudo_unidirectional, SUM(streaming_sessions) AS streaming, SUM(unidirectional_sessions) AS unidirectional, SUM(random_looking_sessions) AS random_looking, SUM(bidirectional_sessions) AS bidirectional FROM metric_ip WHERE stat_time >= 1700039043 AND stat_time < 1700042643 AND side = \'server\' AND ip = \'20.189.173.9\'&format=json&option=real-time\\\",\\n    \\\"msg\\\": \\\"OK\\\"\\n}\",\n  \"description\" : null,\n  \"requestBodyDefinition\" : null,\n  \"responseBodyDefinition\" : {\n    \"name\" : \"\",\n    \"value\" : \"\",\n    \"description\" : \"\",\n    \"required\" : false,\n    \"dataType\" : \"Object\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : \"\",\n    \"error\" : \"\",\n    \"expression\" : \"\",\n    \"children\" : [ {\n      \"name\" : \"status\",\n      \"value\" : \"200\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Integer\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"code\",\n      \"value\" : \"200\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Integer\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"queryKey\",\n      \"value\" : \"bba4691dbcc32f9a9a51b727e145323f\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"success\",\n      \"value\" : \"true\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Boolean\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"message\",\n      \"value\" : \"null\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"statistics\",\n      \"value\" : \"\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Object\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ {\n        \"name\" : \"elapsed\",\n        \"value\" : \"19\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"rows_read\",\n        \"value\" : \"454303\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"bytes_read\",\n        \"value\" : \"57437850\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"result_size\",\n        \"value\" : \"283\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"result_rows\",\n        \"value\" : \"1\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Integer\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      } ]\n    }, {\n      \"name\" : \"job\",\n      \"value\" : \"null\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Object\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"formatType\",\n      \"value\" : \"json\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"meta\",\n      \"value\" : \"\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Array\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ {\n        \"name\" : \"\",\n        \"value\" : \"\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Object\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ {\n          \"name\" : \"name\",\n          \"value\" : \"asymmetric_sessions\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"String\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ ]\n        }, {\n          \"name\" : \"type\",\n          \"value\" : \"long\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"String\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ ]\n        }, {\n          \"name\" : \"category\",\n          \"value\" : \"Metric\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"String\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ ]\n        } ]\n      } ]\n    }, {\n      \"name\" : \"data\",\n      \"value\" : \"\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"Object\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ {\n        \"name\" : \"resultType\",\n        \"value\" : \"table\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"String\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ ]\n      }, {\n        \"name\" : \"result\",\n        \"value\" : \"\",\n        \"description\" : \"\",\n        \"required\" : false,\n        \"dataType\" : \"Array\",\n        \"type\" : null,\n        \"defaultValue\" : null,\n        \"validateType\" : \"\",\n        \"error\" : \"\",\n        \"expression\" : \"\",\n        \"children\" : [ {\n          \"name\" : \"\",\n          \"value\" : \"\",\n          \"description\" : \"\",\n          \"required\" : false,\n          \"dataType\" : \"Object\",\n          \"type\" : null,\n          \"defaultValue\" : null,\n          \"validateType\" : \"\",\n          \"error\" : \"\",\n          \"expression\" : \"\",\n          \"children\" : [ {\n            \"name\" : \"asymmetric_sessions\",\n            \"value\" : \"4\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"bulky_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"cbr_streaming_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"download_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"interactive_sessions\",\n            \"value\" : \"7\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"pseudo_unidirectional_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"streaming_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"unidirectional_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"random_looking_sessions\",\n            \"value\" : \"0\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          }, {\n            \"name\" : \"bidirectional_sessions\",\n            \"value\" : \"140\",\n            \"description\" : \"\",\n            \"required\" : false,\n            \"dataType\" : \"String\",\n            \"type\" : null,\n            \"defaultValue\" : null,\n            \"validateType\" : \"\",\n            \"error\" : \"\",\n            \"expression\" : \"\",\n            \"children\" : [ ]\n          } ]\n        } ]\n      } ]\n    }, {\n      \"name\" : \"originalUrl\",\n      \"value\" : \"http://192.168.44.55:9999/?query=SELECT SUM(asymmetric_sessions) AS asymmetric_sessions, SUM(bulky_sessions) AS bulky_sessions, SUM(cbr_streaming_sessions) AS cbr_streaming_sessions, SUM(download_sessions) AS download_sessions, SUM(interactive_sessions) AS interactive_sessions, SUM(pseudo_unidirectional_sessions) AS pseudo_unidirectional_sessions, SUM(streaming_sessions) AS streaming_sessions, SUM(unidirectional_sessions) AS unidirectional_sessions, SUM(random_looking_sessions) AS random_looking_sessions, SUM(bidirectional_sessions) AS bidirectional_sessions FROM metric_ip WHERE stat_time >= 1697510885 AND stat_time < 1697610885 AND side = \'server\' AND ip = \'1.1.1.1\'&format=json&option=real-time\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    }, {\n      \"name\" : \"msg\",\n      \"value\" : \"OK\",\n      \"description\" : \"\",\n      \"required\" : false,\n      \"dataType\" : \"String\",\n      \"type\" : null,\n      \"defaultValue\" : null,\n      \"validateType\" : \"\",\n      \"error\" : \"\",\n      \"expression\" : \"\",\n      \"children\" : [ ]\n    } ]\n  }\n}\r\n================================\r\nimport net.geedge.common.utils.FreeMarkerUtil as freeMarkerUtil;\r\nimport net.geedge.common.utils.JSONUtil as jsonUtil;\r\nimport \'@/pre/timeHandleNone\' as timeHandle;\r\nimport \'@/post/tableNotToHump\' as postHandle;\r\nimport \'@/public/getGalaxyResult\' as getGalaxyResult;\r\n/**\r\n * 入参整理 包括调用公共函数\r\n */\r\nvar parameter={\r\n    \"resource\":resource,\r\n    \"startTime\":startTime,\r\n    \"endTime\":endTime\r\n}\r\ntimeHandle(parameter);\r\n/**\r\n * 接口sql相关内容整理 通过freemarker模板生成最后执行语句\r\n */\r\nvar q = \"{\\r\\n    \\\"query\\\": \\\"SELECT SUM(asymmetric_sessions) AS asymmetric, SUM(bulky_sessions) AS bulky, SUM(cbr_streaming_sessions) AS cbr_streaming, SUM(download_sessions) AS download, SUM(interactive_sessions) AS interactive, SUM(pseudo_unidirectional_sessions) AS pseudo_unidirectional, SUM(streaming_sessions) AS streaming, SUM(unidirectional_sessions) AS unidirectional, SUM(random_looking_sessions) AS random_looking, SUM(bidirectional_sessions) AS bidirectional,SUM(common_sessions) AS total FROM metric_ip WHERE stat_time >= ${startTime} AND stat_time < ${endTime} AND side = \'server\' AND ip = \'${resource}\'\\\",\\r\\n    \\\"option\\\": \\\"real-time\\\",\\r\\n    \\\"format\\\": \\\"json\\\"\\r\\n}\"\r\nvar result  = freeMarkerUtil.processTemplateIntoString(\"v1EntityDetailIpRelatePorts\",q,parameter);\r\n\r\n/**\r\n * 调用galaxy接口获取结果信息\r\n */\r\nvar res = jsonUtil.toBean(result,HashMap.class);\r\nvar galaxyRes = getGalaxyResult(res);\r\n/**\r\n * 处理galaxy返回的数据结果 将新结果返回前端界面\r\n */\r\nvar result = postHandle(galaxyRes);\r\n\r\nreturn result');
 INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/domain/', 'this is directory');
 INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/domain/group.json', '{\n  \"properties\" : { },\n  \"id\" : \"6b5bf79b1e8440dfa26ddb61649bad8f\",\n  \"name\" : \"domain\",\n  \"type\" : \"api\",\n  \"parentId\" : \"fb8cd5c4ffb84924b04c05e93f9fe47d\",\n  \"path\" : \"/domain\",\n  \"createTime\" : 1686293011974,\n  \"updateTime\" : null,\n  \"createBy\" : \"ljy\",\n  \"updateBy\" : null,\n  \"paths\" : [ ],\n  \"options\" : [ ]\n}');
 INSERT INTO `magic_api_file` VALUES ('/api/v1/entity/detail/domain/relate/', 'this is directory');