impala-dashboard.ko.js 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  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. if (self.properties() != null && self.properties().length > 0 && self.properties()[0].fields != null){
  105. return self.properties()[0].fields();
  106. }
  107. return [];
  108. });
  109. self.fieldNames = ko.computed(function () {
  110. return $.map(self.fields(), function (field) { return field.name()});
  111. });
  112. self.resultsetShowFieldList = ko.observable(true);
  113. self.resultsetFieldsFilter = ko.observable(""); // For UI
  114. self.resultsetSelectedFields = ko.observableArray(self.fieldNames());
  115. self.resultsetSelectedFields.subscribe(function(value) {
  116. vm.search();
  117. });
  118. self.resultsetFilteredFields = ko.computed(function() {
  119. var _fields = [];
  120. $.each(self.fields(), function (index, field) {
  121. if (self.resultsetFieldsFilter() == "" || field.name().toLowerCase().indexOf(self.resultsetFieldsFilter().toLowerCase()) > -1){
  122. _fields.push(field);
  123. }
  124. });
  125. return _fields;
  126. });
  127. self.selectedNewFacetField = ko.observable();
  128. self.addFacet = function(facet_json) {
  129. $.post("/impala/dashboard/new_facet", {
  130. "dashboard": ko.mapping.toJSON(self),
  131. "facet_json": ko.mapping.toJSON(facet_json),
  132. "field": self.selectedNewFacetField(),
  133. }, function (data) {
  134. if (data.status == 0) {
  135. var facet = ko.mapping.fromJS(data.facet);
  136. facet.properties.limit.subscribe(function () {
  137. vm.search();
  138. });
  139. self.facets.push(facet);
  140. vm.search();
  141. } else {
  142. $(document).trigger("error", data.message);
  143. }
  144. }).fail(function (xhr, textStatus, errorThrown) {});
  145. }
  146. self.getFacetById = function (facet_id) {
  147. var _facet = null;
  148. $.each(self.facets(), function (index, facet) {
  149. if (facet.id == facet_id) {
  150. _facet = facet;
  151. return false;
  152. }
  153. });
  154. return _facet;
  155. }
  156. }
  157. var ImpalaDashboardViewModel = function (query_json, dashboard_json) {
  158. var self = this;
  159. self.isEditing = ko.observable(false);
  160. self.toggleEditing = function () {
  161. self.isEditing(! self.isEditing());
  162. };
  163. self.isRetrievingResults = ko.observable(false);
  164. self.previewColumns = ko.observable("");
  165. self.columns = ko.observable([]);
  166. loadLayout(self, dashboard_json.layout);
  167. self.query = new Query(self, query_json);
  168. self.dashboard = new Dashboard(self, dashboard_json);
  169. self.results = ko.observableArray([]);
  170. self.results_facet = ko.observableArray([]);
  171. self.results_cols = ko.observableArray([]);
  172. self.inited = ko.observable(self.columns().length > 0);
  173. self.init = function(callback) {
  174. if (self.inited()){
  175. self.search();
  176. }
  177. callback();
  178. }
  179. self.search = function (callback) {
  180. self.isRetrievingResults(true);
  181. self.results.removeAll();
  182. var multiQs = $.map(self.dashboard.facets(), function(facet) {
  183. return $.post("/impala/dashboard/query", {
  184. "query": ko.mapping.toJSON(self.query),
  185. "dashboard": ko.mapping.toJSON(self.dashboard),
  186. "layout": ko.mapping.toJSON(self.columns),
  187. "facet": ko.mapping.toJSON(facet),
  188. }, function (data) {return data});
  189. });
  190. $.when.apply($, [
  191. $.post("/impala/dashboard/query", {
  192. "query": ko.mapping.toJSON(self.query),
  193. "dashboard": ko.mapping.toJSON(self.dashboard),
  194. "layout": ko.mapping.toJSON(self.columns),
  195. }, function (data) {
  196. self.isRetrievingResults(false);
  197. if (data.status == 0) {
  198. self.results_cols(data.cols)
  199. $.each(data.data, function (index, row) {
  200. self.results.push(row);
  201. });
  202. } else {
  203. $(document).trigger("error", data.message);
  204. }
  205. })
  206. ].concat(multiQs)
  207. )
  208. .done(function() {
  209. if (multiQs.length > 0) {
  210. for (var i = 1; i < arguments.length; i++) {
  211. var facet = arguments[i][0];
  212. removeFrom(self.results_facet, facet.id);
  213. self.results_facet.push(ko.mapping.fromJS(facet));
  214. }
  215. }
  216. })
  217. .fail(function (xhr, textStatus, errorThrown) {
  218. $(document).trigger("error", textStatus);
  219. });
  220. };
  221. function removeFrom(collection, item_id) {
  222. $.each(collection(), function (index, item) {
  223. if (item.id() == item_id) {
  224. collection.remove(item);
  225. return false;
  226. }
  227. });
  228. }
  229. self.getFacetFromResult = function (facet_id) {
  230. var _facet = null;
  231. $.each(self.results_facet(), function (index, facet) {
  232. if (facet.id() == facet_id) {
  233. _facet = facet;
  234. return false;
  235. }
  236. });
  237. return _facet;
  238. }
  239. self.getWidgetById = function (widget_id) {
  240. var _widget = null;
  241. $.each(self.columns(), function (i, col) {
  242. $.each(col.rows(), function (j, row) {
  243. $.each(row.widgets(), function (z, widget) {
  244. if (widget.id() == widget_id){
  245. _widget = widget;
  246. }
  247. });
  248. });
  249. });
  250. return _widget;
  251. }
  252. function bareWidgetBuilder(name, type){
  253. return new Widget({
  254. size: 12,
  255. id: UUID(),
  256. name: name,
  257. widgetType: type
  258. });
  259. }
  260. self.draggableFacet = ko.observable(bareWidgetBuilder("Facet", "facet-widget"));
  261. self.draggableResultset = ko.observable(bareWidgetBuilder("Grid Results", "resultset-widget"));
  262. self.draggableHistogram = ko.observable(bareWidgetBuilder("Histogram", "histogram-widget"));
  263. self.draggableBar = ko.observable(bareWidgetBuilder("Bar Chart", "bar-widget"));
  264. self.draggableMap = ko.observable(bareWidgetBuilder("Map", "map-widget"));
  265. self.draggableLine = ko.observable(bareWidgetBuilder("Line Chart", "line-widget"));
  266. self.draggablePie = ko.observable(bareWidgetBuilder("Pie Chart", "pie-widget"));
  267. self.draggableFilter = ko.observable(bareWidgetBuilder("Filter Bar", "filter-widget"));
  268. };