datasource.js 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. define([
  2. 'angular',
  3. 'lodash',
  4. 'app/core/utils/datemath',
  5. './influx_series',
  6. './query_builder',
  7. './directives',
  8. './query_ctrl',
  9. ],
  10. function (angular, _, dateMath, InfluxSeries, InfluxQueryBuilder) {
  11. 'use strict';
  12. var module = angular.module('grafana.services');
  13. module.factory('InfluxDatasource', function($q, $http, templateSrv) {
  14. function InfluxDatasource(datasource) {
  15. this.type = 'influxdb';
  16. this.urls = _.map(datasource.url.split(','), function(url) {
  17. return url.trim();
  18. });
  19. this.username = datasource.username;
  20. this.password = datasource.password;
  21. this.name = datasource.name;
  22. this.database = datasource.database;
  23. this.basicAuth = datasource.basicAuth;
  24. this.supportAnnotations = true;
  25. this.supportMetrics = true;
  26. }
  27. InfluxDatasource.prototype.query = function(options) {
  28. var timeFilter = getTimeFilter(options);
  29. var queryTargets = [];
  30. var i, y;
  31. var allQueries = _.map(options.targets, function(target) {
  32. if (target.hide) { return []; }
  33. queryTargets.push(target);
  34. // build query
  35. var queryBuilder = new InfluxQueryBuilder(target);
  36. var query = queryBuilder.build();
  37. query = query.replace(/\$interval/g, (target.interval || options.interval));
  38. return query;
  39. }).join("\n");
  40. // replace grafana variables
  41. allQueries = allQueries.replace(/\$timeFilter/g, timeFilter);
  42. // replace templated variables
  43. allQueries = templateSrv.replace(allQueries, options.scopedVars);
  44. return this._seriesQuery(allQueries).then(function(data) {
  45. if (!data || !data.results) {
  46. return [];
  47. }
  48. var seriesList = [];
  49. for (i = 0; i < data.results.length; i++) {
  50. var result = data.results[i];
  51. if (!result || !result.series) { continue; }
  52. var alias = (queryTargets[i] || {}).alias;
  53. if (alias) {
  54. alias = templateSrv.replace(alias, options.scopedVars);
  55. }
  56. var targetSeries = new InfluxSeries({ series: data.results[i].series, alias: alias }).getTimeSeries();
  57. for (y = 0; y < targetSeries.length; y++) {
  58. seriesList.push(targetSeries[y]);
  59. }
  60. }
  61. return { data: seriesList };
  62. });
  63. };
  64. InfluxDatasource.prototype.annotationQuery = function(annotation, rangeUnparsed) {
  65. var timeFilter = getTimeFilter({ range: rangeUnparsed });
  66. var query = annotation.query.replace('$timeFilter', timeFilter);
  67. query = templateSrv.replace(query);
  68. return this._seriesQuery(query).then(function(data) {
  69. if (!data || !data.results || !data.results[0]) {
  70. throw { message: 'No results in response from InfluxDB' };
  71. }
  72. return new InfluxSeries({ series: data.results[0].series, annotation: annotation }).getAnnotations();
  73. });
  74. };
  75. InfluxDatasource.prototype.metricFindQuery = function (query) {
  76. var interpolated;
  77. try {
  78. interpolated = templateSrv.replace(query);
  79. }
  80. catch (err) {
  81. return $q.reject(err);
  82. }
  83. return this._seriesQuery(interpolated).then(function (results) {
  84. if (!results || results.results.length === 0) { return []; }
  85. var influxResults = results.results[0];
  86. if (!influxResults.series) {
  87. return [];
  88. }
  89. var series = influxResults.series[0];
  90. if (query.indexOf('SHOW MEASUREMENTS') === 0) {
  91. return _.map(series.values, function(value) { return { text: value[0], expandable: true }; });
  92. }
  93. var flattenedValues = _.flatten(series.values);
  94. return _.map(flattenedValues, function(value) { return { text: value, expandable: true }; });
  95. });
  96. };
  97. InfluxDatasource.prototype._seriesQuery = function(query) {
  98. return this._influxRequest('GET', '/query', {q: query, epoch: 'ms'});
  99. };
  100. InfluxDatasource.prototype.testDatasource = function() {
  101. return this.metricFindQuery('SHOW MEASUREMENTS LIMIT 1').then(function () {
  102. return { status: "success", message: "Data source is working", title: "Success" };
  103. });
  104. };
  105. InfluxDatasource.prototype._influxRequest = function(method, url, data) {
  106. var self = this;
  107. var currentUrl = self.urls.shift();
  108. self.urls.push(currentUrl);
  109. var params = {
  110. u: self.username,
  111. p: self.password,
  112. };
  113. if (self.database) {
  114. params.db = self.database;
  115. }
  116. if (method === 'GET') {
  117. _.extend(params, data);
  118. data = null;
  119. }
  120. var options = {
  121. method: method,
  122. url: currentUrl + url,
  123. params: params,
  124. data: data,
  125. precision: "ms",
  126. inspect: { type: 'influxdb' },
  127. };
  128. options.headers = options.headers || {};
  129. if (self.basicAuth) {
  130. options.headers.Authorization = self.basicAuth;
  131. }
  132. return $http(options).then(function(result) {
  133. return result.data;
  134. }, function(err) {
  135. if (err.status !== 0 || err.status >= 300) {
  136. if (err.data && err.data.error) {
  137. throw { message: 'InfluxDB Error Response: ' + err.data.error, data: err.data, config: err.config };
  138. }
  139. else {
  140. throw { messsage: 'InfluxDB Error: ' + err.message, data: err.data, config: err.config };
  141. }
  142. }
  143. });
  144. };
  145. function getTimeFilter(options) {
  146. var from = getInfluxTime(options.rangeRaw.from, false);
  147. var until = getInfluxTime(options.rangeRaw.to, true);
  148. var fromIsAbsolute = from[from.length-1] === 's';
  149. if (until === 'now()' && !fromIsAbsolute) {
  150. return 'time > ' + from;
  151. }
  152. return 'time > ' + from + ' and time < ' + until;
  153. }
  154. function getInfluxTime(date, roundUp) {
  155. if (_.isString(date)) {
  156. if (date === 'now') {
  157. return 'now()';
  158. }
  159. if (date.indexOf('now-') >= 0 && date.indexOf('/') === -1) {
  160. return date.replace('now', 'now()').replace('-', ' - ');
  161. }
  162. date = dateMath.parse(date, roundUp);
  163. }
  164. return (date.valueOf() / 1000).toFixed(0) + 's';
  165. }
  166. return InfluxDatasource;
  167. });
  168. });