datasource.js 9.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. define([
  2. 'angular',
  3. 'lodash',
  4. 'moment',
  5. 'kbn',
  6. './queryBuilder',
  7. './indexPattern',
  8. './queryCtrl',
  9. './directives'
  10. ],
  11. function (angular, _, moment, kbn, ElasticQueryBuilder, IndexPattern) {
  12. 'use strict';
  13. var module = angular.module('grafana.services');
  14. module.factory('ElasticDatasource', function($q, backendSrv, templateSrv) {
  15. function ElasticDatasource(datasource) {
  16. this.type = 'elasticsearch';
  17. this.basicAuth = datasource.basicAuth;
  18. this.url = datasource.url;
  19. this.name = datasource.name;
  20. this.index = datasource.index;
  21. this.timeField = datasource.jsonData.timeField;
  22. this.indexPattern = new IndexPattern(datasource.index, datasource.jsonData.interval);
  23. this.queryBuilder = new ElasticQueryBuilder({
  24. timeField: this.timeField
  25. });
  26. }
  27. ElasticDatasource.prototype._request = function(method, url, data) {
  28. var options = {
  29. url: this.url + "/" + url,
  30. method: method,
  31. data: data
  32. };
  33. if (this.basicAuth) {
  34. options.withCredentials = true;
  35. options.headers = {
  36. "Authorization": this.basicAuth
  37. };
  38. }
  39. return backendSrv.datasourceRequest(options);
  40. };
  41. ElasticDatasource.prototype._get = function(url) {
  42. return this._request('GET', this.indexPattern.getIndexForToday() + url)
  43. .then(function(results) {
  44. return results.data;
  45. });
  46. };
  47. ElasticDatasource.prototype._post = function(url, data) {
  48. return this._request('POST', url, data)
  49. .then(function(results) {
  50. return results.data;
  51. });
  52. };
  53. ElasticDatasource.prototype.annotationQuery = function(annotation, rangeUnparsed) {
  54. var range = {};
  55. var timeField = annotation.timeField || '@timestamp';
  56. var queryString = annotation.query || '*';
  57. var tagsField = annotation.tagsField || 'tags';
  58. var titleField = annotation.titleField || 'desc';
  59. var textField = annotation.textField || null;
  60. range[timeField]= {
  61. from: rangeUnparsed.from,
  62. to: rangeUnparsed.to,
  63. };
  64. var queryInterpolated = templateSrv.replace(queryString);
  65. var filter = { "bool": { "must": [{ "range": range }] } };
  66. var query = { "bool": { "should": [{ "query_string": { "query": queryInterpolated } }] } };
  67. var data = {
  68. "fields": [timeField, "_source"],
  69. "query" : { "filtered": { "query" : query, "filter": filter } },
  70. "size": 10000
  71. };
  72. return this._request('POST', annotation.index + '/_search', data).then(function(results) {
  73. var list = [];
  74. var hits = results.data.hits.hits;
  75. var getFieldFromSource = function(source, fieldName) {
  76. if (!fieldName) { return; }
  77. var fieldNames = fieldName.split('.');
  78. var fieldValue = source;
  79. for (var i = 0; i < fieldNames.length; i++) {
  80. fieldValue = fieldValue[fieldNames[i]];
  81. if (!fieldValue) {
  82. console.log('could not find field in annotatation: ', fieldName);
  83. return '';
  84. }
  85. }
  86. if (_.isArray(fieldValue)) {
  87. fieldValue = fieldValue.join(', ');
  88. }
  89. return fieldValue;
  90. };
  91. for (var i = 0; i < hits.length; i++) {
  92. var source = hits[i]._source;
  93. var fields = hits[i].fields;
  94. var time = source[timeField];
  95. if (_.isString(fields[timeField]) || _.isNumber(fields[timeField])) {
  96. time = fields[timeField];
  97. }
  98. var event = {
  99. annotation: annotation,
  100. time: moment.utc(time).valueOf(),
  101. title: getFieldFromSource(source, titleField),
  102. tags: getFieldFromSource(source, tagsField),
  103. text: getFieldFromSource(source, textField)
  104. };
  105. list.push(event);
  106. }
  107. return list;
  108. });
  109. };
  110. ElasticDatasource.prototype.testDatasource = function() {
  111. return this._get('/_stats').then(function() {
  112. return { status: "success", message: "Data source is working", title: "Success" };
  113. }, function(err) {
  114. if (err.data && err.data.error) {
  115. return { status: "error", message: err.data.error, title: "Error" };
  116. } else {
  117. return { status: "error", message: err.status, title: "Error" };
  118. }
  119. });
  120. };
  121. ElasticDatasource.prototype.getQueryHeader = function(timeRange) {
  122. var header = {search_type: "count", "ignore_unavailable": true};
  123. var from = kbn.parseDate(timeRange.from);
  124. var to = kbn.parseDate(timeRange.to);
  125. header.index = this.indexPattern.getIndexList(from, to);
  126. return angular.toJson(header);
  127. };
  128. ElasticDatasource.prototype.query = function(options) {
  129. var payload = "";
  130. var target;
  131. var sentTargets = [];
  132. var header = this.getQueryHeader(options.range);
  133. var timeFrom = this.translateTime(options.range.from);
  134. var timeTo = this.translateTime(options.range.to);
  135. for (var i = 0; i < options.targets.length; i++) {
  136. target = options.targets[i];
  137. if (target.hide) {return;}
  138. var esQuery = this.queryBuilder.build(target, timeFrom, timeTo);
  139. payload += header + '\n';
  140. payload += angular.toJson(esQuery) + '\n';
  141. sentTargets.push(target);
  142. }
  143. payload = payload.replace(/\$interval/g, options.interval);
  144. payload = payload.replace(/\$timeFrom/g, this.translateTime(options.range.from));
  145. payload = payload.replace(/\$timeTo/g, this.translateTime(options.range.to));
  146. payload = payload.replace(/\$maxDataPoints/g, options.maxDataPoints);
  147. payload = templateSrv.replace(payload, options.scopedVars);
  148. var processTimeSeries = _.bind(this._processTimeSeries, this, sentTargets);
  149. return this._post('/_msearch?search_type=count', payload).then(processTimeSeries);
  150. };
  151. ElasticDatasource.prototype.translateTime = function(date) {
  152. if (_.isString(date)) {
  153. return date;
  154. }
  155. return date.getTime();
  156. };
  157. // This is quite complex
  158. // neeed to recurise down the nested buckets to build series
  159. ElasticDatasource.prototype._processBuckets = function(aggs, target, series, level, parentName) {
  160. var seriesName, value, metric, i, y, bucket, aggDef, esAgg;
  161. function addMetricPoint(seriesName, value, time) {
  162. var current = series[seriesName];
  163. if (!current) {
  164. current = series[seriesName] = {target: seriesName, datapoints: []};
  165. }
  166. current.datapoints.push([value, time]);
  167. }
  168. aggDef = target.bucketAggs[level];
  169. esAgg = aggs[aggDef.id];
  170. for (i = 0; i < esAgg.buckets.length; i++) {
  171. bucket = esAgg.buckets[i];
  172. // if last agg collect series
  173. if (level === target.bucketAggs.length - 1) {
  174. for (y = 0; y < target.metrics.length; y++) {
  175. metric = target.metrics[y];
  176. seriesName = parentName;
  177. switch(metric.type) {
  178. case 'count': {
  179. seriesName += ' count';
  180. value = bucket.doc_count;
  181. addMetricPoint(seriesName, value, bucket.key);
  182. break;
  183. }
  184. case 'percentiles': {
  185. var values = bucket[metric.id].values;
  186. for (var prop in values) {
  187. addMetricPoint(seriesName + ' ' + prop, values[prop], bucket.key);
  188. }
  189. break;
  190. }
  191. case 'extended_stats': {
  192. var stats = bucket[metric.id];
  193. for (var statIndex in metric.stats) {
  194. var statName = metric.stats[statIndex];
  195. addMetricPoint(seriesName + ' ' + statName, stats[statName], bucket.key);
  196. }
  197. break;
  198. }
  199. default: {
  200. seriesName += ' ' + metric.field + ' ' + metric.type;
  201. value = bucket[metric.id].value;
  202. addMetricPoint(seriesName, value, bucket.key);
  203. break;
  204. }
  205. }
  206. }
  207. }
  208. else {
  209. this._processBuckets(bucket, target, series, level+1, parentName + ' ' + bucket.key);
  210. }
  211. }
  212. };
  213. ElasticDatasource.prototype._processTimeSeries = function(targets, results) {
  214. var series = [];
  215. for (var i = 0; i < results.responses.length; i++) {
  216. var response = results.responses[i];
  217. if (response.error) {
  218. throw { message: response.error };
  219. }
  220. var aggregations = response.aggregations;
  221. var target = targets[i];
  222. var querySeries = {};
  223. this._processBuckets(aggregations, target, querySeries, 0, target.refId);
  224. for (var prop in querySeries) {
  225. if (querySeries.hasOwnProperty(prop)) {
  226. series.push(querySeries[prop]);
  227. }
  228. }
  229. }
  230. return { data: series };
  231. };
  232. ElasticDatasource.prototype.metricFindQuery = function() {
  233. return this._get('/_mapping').then(function(res) {
  234. var fields = {};
  235. for (var indexName in res) {
  236. var index = res[indexName];
  237. var mappings = index.mappings;
  238. if (!mappings) { continue; }
  239. for (var typeName in mappings) {
  240. var properties = mappings[typeName].properties;
  241. for (var field in properties) {
  242. var prop = properties[field];
  243. if (prop.type && field[0] !== '_') {
  244. fields[field] = prop;
  245. }
  246. }
  247. }
  248. }
  249. fields = _.map(_.keys(fields), function(field) {
  250. return {text: field};
  251. });
  252. return fields;
  253. });
  254. };
  255. return ElasticDatasource;
  256. });
  257. });