rdbms.vm.js 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  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 RdbmsViewModel() {
  17. var self = this;
  18. self.selectedServer = ko.observable();
  19. self.servers = ko.observable({});
  20. self.selectedDatabase = ko.observable(0);
  21. self.databases = ko.observableArray([]);
  22. self.query = ko.mapping.fromJS({
  23. 'id': -1,
  24. 'query': '',
  25. 'name': null,
  26. 'description': null,
  27. 'errors': []
  28. });
  29. self.rows = ko.observableArray();
  30. self.columns = ko.observableArray();
  31. self.filter = ko.observable("");
  32. self.isLoading = ko.observable(false);
  33. self.isReady = ko.observable(false);
  34. self.server = ko.computed({
  35. 'read': function() {
  36. if (self.servers() && self.selectedServer()) {
  37. return self.servers()[self.selectedServer()];
  38. } else{
  39. return "";
  40. }
  41. },
  42. 'write': function(value) {
  43. self.selectedServer(value);
  44. }
  45. });
  46. self.database = ko.computed({
  47. 'read': function() {
  48. if (self.databases) {
  49. return self.databases()[self.selectedDatabase()];
  50. } else{
  51. return "";
  52. }
  53. },
  54. 'write': function(value) {
  55. self.selectedDatabase(self.databases.indexOf(value));
  56. }
  57. });
  58. self.selectedServer.subscribe(function(value) {
  59. self.fetchDatabases();
  60. });
  61. self.updateResults = function(results) {
  62. var rows = [];
  63. self.columns(results.columns);
  64. $.each(results.rows, function(i, result_row) {
  65. var row = [];
  66. $.each(self.columns(), function(j, column) {
  67. row.push(result_row[column]);
  68. });
  69. rows.push(row);
  70. });
  71. self.rows(rows);
  72. };
  73. self.updateServers = function(servers) {
  74. self.servers(servers);
  75. if (servers) {
  76. self.selectedServer(Object.keys(servers)[0]);
  77. }
  78. };
  79. self.updateDatabases = function(databases) {
  80. self.databases(databases);
  81. self.selectedDatabase.valueHasMutated();
  82. };
  83. self.updateQuery = function(design) {
  84. self.query.query(design.query);
  85. self.query.id(design.id);
  86. self.query.name(design.name);
  87. self.query.description(design.desc);
  88. self.database(design.database);
  89. self.server(design.server);
  90. };
  91. self.chooseServer = function(value, e) {
  92. self.selectedServer(value);
  93. };
  94. self.chooseDatabase = function(value, e) {
  95. self.selectedDatabase(self.databases.indexOf(value));
  96. };
  97. self.explainQuery = function() {
  98. var data = ko.mapping.toJS(self.query);
  99. data.database = self.database();
  100. data.server = self.selectedServer();
  101. var request = {
  102. url: '/rdbms/api/explain/',
  103. dataType: 'json',
  104. type: 'POST',
  105. success: function(data) {
  106. if (data.status === 0) {
  107. $(document).trigger('explain.query', data);
  108. self.updateResults(data.results);
  109. self.query.id(data.design);
  110. $(document).trigger('explained.query', data);
  111. } else {
  112. self.query.errors.removeAll();
  113. self.query.errors.push(data.message);
  114. }
  115. },
  116. error: $.noop,
  117. data: data
  118. };
  119. $.ajax(request);
  120. };
  121. self.fetchQuery = function(id) {
  122. var _id = id || self.query.id();
  123. if (_id && _id != -1) {
  124. var request = {
  125. url: '/rdbms/api/query/' + _id + '/get',
  126. dataType: 'json',
  127. type: 'GET',
  128. success: function(data) {
  129. self.updateQuery(data.design);
  130. },
  131. error: $.noop
  132. };
  133. $.ajax(request);
  134. }
  135. };
  136. self.saveQuery = function() {
  137. var self = this;
  138. if (self.query.query() && self.query.name()) {
  139. var data = ko.mapping.toJS(self.query);
  140. data['desc'] = data['description'];
  141. data['server'] = self.selectedServer();
  142. data['database'] = self.database();
  143. var url = '/rdbms/api/query/';
  144. if (self.query.id() && self.query.id() != -1) {
  145. url += self.query.id() + '/';
  146. }
  147. var request = {
  148. url: url,
  149. dataType: 'json',
  150. type: 'POST',
  151. success: function(data) {
  152. $(document).trigger('saved.query', data);
  153. },
  154. error: function() {
  155. $(document).trigger('error.query');
  156. },
  157. data: data
  158. };
  159. $.ajax(request);
  160. }
  161. };
  162. self.executeQuery = function() {
  163. var data = ko.mapping.toJS(self.query);
  164. data.database = self.database();
  165. data.server = self.selectedServer();
  166. var request = {
  167. url: '/rdbms/api/execute/',
  168. dataType: 'json',
  169. type: 'POST',
  170. success: function(data) {
  171. if (data.status === 0) {
  172. $(document).trigger('execute.query', data);
  173. self.updateResults(data.results);
  174. self.query.id(data.design);
  175. $(document).trigger('executed.query', data);
  176. } else {
  177. self.query.errors.removeAll();
  178. self.query.errors.push(data.message);
  179. }
  180. },
  181. error: $.noop,
  182. data: data
  183. };
  184. $.ajax(request);
  185. };
  186. self.fetchServers = function() {
  187. var request = {
  188. url: '/rdbms/api/servers/',
  189. dataType: 'json',
  190. type: 'GET',
  191. success: function(data) {
  192. self.updateServers(data.servers);
  193. self.fetchDatabases();
  194. },
  195. error: $.noop
  196. };
  197. $.ajax(request);
  198. };
  199. self.fetchDatabases = function() {
  200. if (self.selectedServer()) {
  201. var request = {
  202. url: '/rdbms/api/servers/' + self.selectedServer() + '/databases/',
  203. dataType: 'json',
  204. type: 'GET',
  205. success: function(data) {
  206. self.updateDatabases(data.databases);
  207. },
  208. error: $.noop
  209. };
  210. $.ajax(request);
  211. }
  212. };
  213. }