impala-dashboard.ko.js 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. // Licensed to Cloudera, Inc. under one
  2. // or more contributor license agreements. See the NOTICE file
  3. // distributed with this work for additional information
  4. // regarding copyright ownership. Cloudera, Inc. licenses this file
  5. // to you under the Apache License, Version 2.0 (the
  6. // "License"); you may not use this file except in compliance
  7. // with the License. You may obtain a copy of the License at
  8. //
  9. // http://www.apache.org/licenses/LICENSE-2.0
  10. //
  11. // Unless required by applicable law or agreed to in writing, software
  12. // distributed under the License is distributed on an "AS IS" BASIS,
  13. // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. // See the License for the specific language governing permissions and
  15. // limitations under the License.
  16. function magicLayout(vm) {
  17. loadLayout(vm, vm.initial.layout);
  18. $(document).trigger("magicLayout");
  19. }
  20. function loadLayout(viewModel, json_layout) {
  21. var _columns = [];
  22. $(json_layout).each(function (cnt, json_col) {
  23. var _rows = [];
  24. $(json_col.rows).each(function (rcnt, json_row) {
  25. var row = new Row([], viewModel);
  26. $(json_row.widgets).each(function (wcnt, widget) {
  27. row.addWidget(new Widget({
  28. size:widget.size,
  29. id: widget.id,
  30. name: widget.name,
  31. widgetType: widget.widgetType,
  32. properties: widget.properties,
  33. offset: widget.offset,
  34. loading: true,
  35. vm: viewModel
  36. }));
  37. });
  38. _rows.push(row);
  39. });
  40. var column = new Column(json_col.size, _rows);
  41. _columns = _columns.concat(column);
  42. });
  43. viewModel.columns(_columns);
  44. }
  45. // End dashboard lib
  46. var Query = function (vm, query) {
  47. var self = this;
  48. self.qs = ko.mapping.fromJS([{'q': ''}]);
  49. self.fqs = ko.mapping.fromJS([]);
  50. self.toggleFacet = function (data) {
  51. var fq = self.getFacetFilter(data.widget.id());
  52. if (fq == null) {
  53. self.fqs.push(ko.mapping.fromJS({
  54. 'id': data.widget.id(),
  55. 'field': data.widget.field(),
  56. 'filter': [data.facet[0]],
  57. 'type': 'field'
  58. }));
  59. } else {
  60. $.each(self.fqs(), function (index, fq) {
  61. if (fq.id() == data.widget.id()) {
  62. if (fq.filter.indexOf(data.facet[0]) > -1) {
  63. fq.filter.remove(data.facet[0]);
  64. if (fq.filter().length == 0) {
  65. self.fqs.remove(fq);
  66. }
  67. } else {
  68. fq.filter.push(data.facet[0]);
  69. }
  70. }
  71. });
  72. }
  73. vm.search();
  74. }
  75. self.getFacetFilter = function (facet_id) {
  76. var _facet = null;
  77. $.each(self.fqs(), function (index, facet) {
  78. if (facet.id() == facet_id) {
  79. _facet = facet;
  80. return false;
  81. }
  82. });
  83. return _facet;
  84. }
  85. }
  86. var Dashboard = function (vm, dashboard) {
  87. var self = this;
  88. self.facets = ko.mapping.fromJS(dashboard.facets);
  89. self.properties = ko.mapping.fromJS(dashboard.properties);
  90. self.dropdownDbs = ko.observableArray([]);
  91. self.selectedDropdownDb = ko.observable("");
  92. self.dropdownTables = ko.observableArray([]);
  93. self.selectedDropdownTable = ko.observable("");
  94. self.updateDropdownDatabases = function(databases) {
  95. if (databases) {
  96. var i = databases.indexOf("_impala_builtins"); // Blacklist of system databases
  97. if (i != -1) {
  98. databases.splice(i, 1);
  99. }
  100. self.dropdownDbs(databases);
  101. }
  102. };
  103. self.fields = ko.computed(function () {
  104. return self.properties()[0].fields();
  105. });
  106. self.fieldNames = ko.computed(function () {
  107. return $.map(self.fields(), function (field) { return field.name()});
  108. });
  109. self.resultsetShowFieldList = ko.observable(true);
  110. self.resultsetFieldsFilter = ko.observable(""); // For UI
  111. self.resultsetSelectedFields = ko.observableArray(self.fieldNames());
  112. self.resultsetSelectedFields.subscribe(function(value) {
  113. vm.search();
  114. });
  115. self.resultsetFilteredFields = ko.computed(function() {
  116. var _fields = [];
  117. $.each(self.fields(), function (index, field) {
  118. if (self.resultsetFieldsFilter() == "" || field.name().toLowerCase().indexOf(self.resultsetFieldsFilter().toLowerCase()) > -1){
  119. _fields.push(field);
  120. }
  121. });
  122. return _fields;
  123. });
  124. self.selectedNewFacetField = ko.observable();
  125. self.addFacet = function(facet_json) {
  126. $.post("/impala/dashboard/new_facet", {
  127. "dashboard": ko.mapping.toJSON(self),
  128. "facet_json": ko.mapping.toJSON(facet_json),
  129. "field": self.selectedNewFacetField(),
  130. }, function (data) {
  131. if (data.status == 0) {
  132. var facet = ko.mapping.fromJS(data.facet);
  133. facet.properties.limit.subscribe(function () {
  134. vm.search();
  135. });
  136. self.facets.push(facet);
  137. vm.search();
  138. } else {
  139. $(document).trigger("error", data.message);
  140. }
  141. }).fail(function (xhr, textStatus, errorThrown) {});
  142. }
  143. self.getFacetById = function (facet_id) {
  144. var _facet = null;
  145. $.each(self.facets(), function (index, facet) {
  146. if (facet.id == facet_id) {
  147. _facet = facet;
  148. return false;
  149. }
  150. });
  151. return _facet;
  152. }
  153. }
  154. var ImpalaDashboardViewModel = function (query_json, dashboard_json) {
  155. var self = this;
  156. self.isEditing = ko.observable(true);
  157. self.toggleEditing = function () {
  158. self.isEditing(! self.isEditing());
  159. };
  160. self.isRetrievingResults = ko.observable(false);
  161. self.previewColumns = ko.observable("");
  162. self.columns = ko.observable([]);
  163. loadLayout(self, dashboard_json.layout);
  164. self.query = new Query(self, query_json);
  165. self.dashboard = new Dashboard(self, dashboard_json);
  166. self.results = ko.observableArray([]);
  167. self.results_facet = ko.observableArray([]);
  168. self.results_cols = ko.observableArray([]);
  169. self.init = function(callback) {
  170. self.search();
  171. callback();
  172. }
  173. self.search = function (callback) {
  174. self.isRetrievingResults(true);
  175. self.results.removeAll();
  176. var multiQs = $.map(self.dashboard.facets(), function(facet) {
  177. return $.post("/impala/dashboard/query", {
  178. "query": ko.mapping.toJSON(self.query),
  179. "dashboard": ko.mapping.toJSON(self.dashboard),
  180. "layout": ko.mapping.toJSON(self.columns),
  181. "facet": ko.mapping.toJSON(facet),
  182. }, function (data) {return data});
  183. });
  184. $.when.apply($, [
  185. $.post("/impala/dashboard/query", {
  186. "query": ko.mapping.toJSON(self.query),
  187. "dashboard": ko.mapping.toJSON(self.dashboard),
  188. "layout": ko.mapping.toJSON(self.columns),
  189. }, function (data) {
  190. self.isRetrievingResults(false);
  191. if (data.status == 0) {
  192. self.results_cols(data.cols)
  193. $.each(data.data, function (index, row) {
  194. self.results.push(row);
  195. });
  196. } else {
  197. $(document).trigger("error", data.message);
  198. }
  199. })
  200. ].concat(multiQs)
  201. )
  202. .done(function() {
  203. if (multiQs.length > 0) {
  204. for (var i = 1; i < arguments.length; i++) {
  205. var facet = arguments[i][0];
  206. removeFrom(self.results_facet, facet.id);
  207. self.results_facet.push(ko.mapping.fromJS(facet));
  208. }
  209. }
  210. })
  211. .fail(function (xhr, textStatus, errorThrown) {
  212. $(document).trigger("error", textStatus);
  213. });
  214. };
  215. function removeFrom(collection, item_id) {
  216. $.each(collection(), function (index, item) {
  217. if (item.id() == item_id) {
  218. collection.remove(item);
  219. return false;
  220. }
  221. });
  222. }
  223. self.getFacetFromResult = function (facet_id) {
  224. var _facet = null;
  225. $.each(self.results_facet(), function (index, facet) {
  226. if (facet.id() == facet_id) {
  227. _facet = facet;
  228. return false;
  229. }
  230. });
  231. return _facet;
  232. }
  233. function bareWidgetBuilder(name, type){
  234. return new Widget({
  235. size: 12,
  236. id: UUID(),
  237. name: name,
  238. widgetType: type
  239. });
  240. }
  241. self.draggableFacet = ko.observable(bareWidgetBuilder("Facet", "facet-widget"));
  242. self.draggableResultset = ko.observable(bareWidgetBuilder("Grid Results", "resultset-widget"));
  243. self.draggableHistogram = ko.observable(bareWidgetBuilder("Histogram", "histogram-widget"));
  244. self.draggableBar = ko.observable(bareWidgetBuilder("Bar Chart", "bar-widget"));
  245. self.draggableMap = ko.observable(bareWidgetBuilder("Map", "map-widget"));
  246. self.draggableLine = ko.observable(bareWidgetBuilder("Line Chart", "line-widget"));
  247. self.draggablePie = ko.observable(bareWidgetBuilder("Pie Chart", "pie-widget"));
  248. self.draggableFilter = ko.observable(bareWidgetBuilder("Filter Bar", "filter-widget"));
  249. };