spark.vm.js 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317
  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 s4() {
  17. return Math.floor((1 + Math.random()) * 0x10000)
  18. .toString(16)
  19. .substring(1);
  20. }
  21. function UUID() {
  22. return s4() + s4() + '-' + s4() + '-' + s4() + '-' + s4() + '-' + s4() + s4() + s4();
  23. }
  24. var Result = function (snippet, result) {
  25. var self = this;
  26. self.id = ko.observable(typeof result != "undefined" && result.id != "undefined" && result.id != null ? result.id : UUID());
  27. self.type = ko.observable('table');
  28. self.handle = ko.observable({});
  29. self.meta = ko.observableArray();
  30. self.data = ko.observableArray();
  31. self.clear = function() {
  32. //self.handle = ko.observable({});
  33. self.meta.removeAll();
  34. self.data.removeAll();
  35. };
  36. }
  37. var TYPE_EDITOR_MAP = {
  38. 'hive': 'text/x-hiveql',
  39. 'impala': 'text/x-impalaql',
  40. 'python': 'text/x-python',
  41. 'scala': 'text/x-scala',
  42. 'pig': 'text/x-pig'
  43. }
  44. var Snippet = function (notebook, snippet) {
  45. var self = this;
  46. self.id = ko.observable(typeof snippet.id != "undefined" && snippet.id != null ? snippet.id : UUID());
  47. self.type = ko.observable(typeof snippet.type != "undefined" && snippet.type != null ? snippet.type : "hive");
  48. self.editorMode = ko.observable(TYPE_EDITOR_MAP[self.type()]);
  49. self.statement = ko.observable(typeof snippet.statement != "undefined" && snippet.statement != null ? snippet.statement : '');
  50. self.statement = ko.observable("");
  51. self.status = ko.observable("loading");
  52. self.size = ko.observable(typeof snippet.size != "undefined" && snippet.size != null ? snippet.size : 12).extend({ numeric: 0 });
  53. self.offset = ko.observable(typeof snippet.offset != "undefined" && snippet.offset != null ? snippet.offset : 0).extend({ numeric: 0 });
  54. self.isLoading = ko.computed(function(){
  55. return self.status() == "loading";
  56. });
  57. self.klass = ko.computed(function () {
  58. return "snippet card card-widget";
  59. });
  60. self.editorKlass = ko.computed(function(){
  61. return "editor span" + self.size() + (self.offset() * 1 > 0 ? " offset" + self.offset() : "");
  62. });
  63. self.resultsKlass = ko.computed(function(){
  64. return "results " + self.type();
  65. });
  66. self.expand = function () {
  67. self.size(self.size() + 1);
  68. $("#snippet_" + self.id()).trigger("resize");
  69. }
  70. self.compress = function () {
  71. self.size(self.size() - 1);
  72. $("#snippet_" + self.id()).trigger("resize");
  73. }
  74. self.moveLeft = function () {
  75. self.offset(self.offset() - 1);
  76. }
  77. self.moveRight = function () {
  78. self.offset(self.offset() + 1);
  79. }
  80. self.remove = function (notebook, snippet) {
  81. notebook.snippets.remove(snippet);
  82. }
  83. self.result = new Result(snippet, snippet.result);
  84. // init()
  85. // checkStatus()
  86. self.create_session = function() {
  87. $.post("/spark/api/create_session", {
  88. notebook: ko.mapping.toJSON(notebook),
  89. snippet: ko.mapping.toJSON(self)
  90. }, function (data) {
  91. if (data.status == 0) {
  92. notebook.sessions.push(ko.mapping.fromJS(data.session));
  93. self.status('ready');
  94. }
  95. else {
  96. $(document).trigger("error", data.message);
  97. }
  98. }).fail(function (xhr, textStatus, errorThrown) {
  99. $(document).trigger("error", xhr.responseText);
  100. });
  101. };
  102. self.execute = function() {
  103. $(".jHueNotify").hide();
  104. logGA('/execute/' + self.type());
  105. self.result.clear();
  106. self.status('running');
  107. $.post("/spark/api/execute", {
  108. notebook: ko.mapping.toJSON(notebook),
  109. snippet: ko.mapping.toJSON(self)
  110. }, function (data) {
  111. if (data.status == 0) {
  112. $.each(data.handle, function(key, val) {
  113. self.result.handle()[key] = val;
  114. });
  115. self.checkStatus();
  116. }
  117. else {
  118. $(document).trigger("error", data.message);
  119. }
  120. }).fail(function (xhr, textStatus, errorThrown) {
  121. $(document).trigger("error", xhr.responseText);
  122. });
  123. };
  124. self.checkStatus = function() {
  125. $.post("/spark/api/check_status", {
  126. notebook: ko.mapping.toJSON(notebook),
  127. snippet: ko.mapping.toJSON(self)
  128. }, function (data) {
  129. if (data.status == 0) {
  130. self.status(data.query_status.status);
  131. if (self.status() == 'running') {
  132. setTimeout(self.checkStatus, 1000);
  133. } else {
  134. self.fetchResult();
  135. }
  136. }
  137. else {
  138. $(document).trigger("error", data.message);
  139. }
  140. }).fail(function (xhr, textStatus, errorThrown) {
  141. $(document).trigger("error", xhr.responseText);
  142. });
  143. };
  144. self.fetchResult = function() {
  145. $.post("/spark/api/fetch_result", {
  146. notebook: ko.mapping.toJSON(notebook),
  147. snippet: ko.mapping.toJSON(self)
  148. }, function (data) {
  149. if (data.status == 0) {
  150. self.result.meta(data.result.meta);
  151. self.result.data(data.result.data);
  152. // move resultsets to n rows
  153. // check if N rows fetched...
  154. }
  155. else {
  156. $(document).trigger("error", data.message);
  157. }
  158. }).fail(function (xhr, textStatus, errorThrown) {
  159. $(document).trigger("error", xhr.responseText);
  160. });
  161. };
  162. self.fetchResultMetadata = function() {
  163. };
  164. self.cancel = function() {
  165. };
  166. }
  167. var Notebook = function (vm, notebook) {
  168. var self = this;
  169. self.id = ko.observable(typeof notebook.id != "undefined" && notebook.id != null ? notebook.id : null);
  170. self.uuid = ko.observable(typeof notebook.uuid != "undefined" && notebook.uuid != null ? notebook.uuid : UUID());
  171. self.name = ko.observable(typeof notebook.name != "undefined" && notebook.name != null ? notebook.name : 'My Notebook');
  172. self.snippets = ko.observableArray();
  173. self.selectedSnippet = ko.observable('scala');
  174. self.availableSnippets = ko.observableArray(['hive', 'scala', 'sql', 'python', 'pig', 'impala']); // presto, mysql, oracle, sqlite, postgres, phoenix
  175. self.sessions = ko.observableArray(); // [{'hive': {...}, 'scala': {...}]
  176. self.getSession = function(session_type) {
  177. var _s = null;
  178. $.each(self.sessions(), function (index, s) {
  179. if (s.type() == session_type) {
  180. _s = s;
  181. return false;
  182. }
  183. });
  184. return _s;
  185. };
  186. self.addSnippet = function(snippet) {
  187. var _snippet = new Snippet(self, snippet);
  188. self.snippets.push(_snippet);
  189. if (self.getSession(self.selectedSnippet()) == null) {
  190. _snippet.create_session();
  191. }
  192. };
  193. self.newSnippet = function() {
  194. var snippet = new Snippet(self, {type: self.selectedSnippet()});
  195. self.snippets.push(snippet);
  196. if (self.getSession(self.selectedSnippet()) == null) {
  197. snippet.create_session();
  198. }
  199. };
  200. if (notebook.snippets) {
  201. $.each(notebook.snippets, function(index, snippet) {
  202. self.addSnippet(snippet);
  203. });
  204. }
  205. self.save = function () {
  206. $.post("/spark/api/notebook/save", {
  207. "notebook": ko.mapping.toJSON(self)
  208. }, function (data) {
  209. if (data.status == 0) {
  210. self.id(data.id);
  211. $(document).trigger("info", data.message);
  212. if (window.location.search.indexOf("notebook") == -1) {
  213. window.location.hash = '#notebook=' + data.id;
  214. }
  215. }
  216. else {
  217. $(document).trigger("error", data.message);
  218. }
  219. }).fail(function (xhr, textStatus, errorThrown) {
  220. $(document).trigger("error", xhr.responseText);
  221. });
  222. };
  223. }
  224. function EditorViewModel(notebooks) {
  225. var self = this;
  226. self.notebooks = ko.observableArray();
  227. self.selectedNotebook = ko.observable();
  228. self.isEditing = ko.observable(true);
  229. self.isEditing.subscribe(function(newVal){
  230. $(document).trigger("editingToggled");
  231. });
  232. self.toggleEditing = function () {
  233. self.isEditing(! self.isEditing());
  234. };
  235. self.init = function() {
  236. $.each(notebooks, function(index, notebook) {
  237. self.loadNotebook(notebook);
  238. if (self.selectedNotebook() == null){
  239. self.selectedNotebook(self.notebooks()[0]);
  240. }
  241. });
  242. };
  243. self.loadNotebook = function(notebook) {
  244. self.notebooks.push(new Notebook(self, notebook));
  245. };
  246. self.newNotebook = function() {
  247. self.notebooks.push(new Notebook(self, {}));
  248. self.selectedNotebook(self.notebooks()[self.notebooks().length - 1]);
  249. };
  250. self.saveNotebook = function() {
  251. self.selectedNotebook().save();
  252. };
  253. }
  254. function logGA(page) {
  255. if (typeof trackOnGA == 'function') {
  256. trackOnGA('editor/' + page);
  257. }
  258. }