datasource.js 6.3 KB

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