sqoop.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452
  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. //// Menu items
  17. function highlightMainMenu(mainSection) {
  18. $(".nav-pills li").removeClass("active");
  19. $("a[href='#" + mainSection + "']").parent().addClass("active");
  20. }
  21. function highlightMenu(section) {
  22. $(".nav-list li").removeClass("active");
  23. $("li[data-section='" + section + "']").addClass("active");
  24. }
  25. function showMainSection(mainSection) {
  26. if ($("#" + mainSection).is(":hidden")) {
  27. $(".mainSection").hide();
  28. $("#" + mainSection).show();
  29. highlightMainMenu(mainSection);
  30. }
  31. }
  32. function showSection(mainSection, section) {
  33. showMainSection(mainSection);
  34. $(document).trigger('show_section', section);
  35. if ($("#" + section).is(":hidden")) {
  36. $(".section").hide();
  37. $("#" + section).show();
  38. highlightMenu(section);
  39. $(document).trigger('shown_section', section);
  40. }
  41. }
  42. function showSubsection(mainSection, section, subSection) {
  43. showSection(mainSection, section);
  44. if ($("#" + subSection).is(":hidden")) {
  45. $(".subSection").hide();
  46. $("#" + subSection).show();
  47. }
  48. }
  49. //// Constructors
  50. function create_connection(attrs, options) {
  51. var options = options || {};
  52. options.modelDict = attrs || {};
  53. var node = new connections.Connection(options);
  54. // Need a copy of the forms so that when editing
  55. // we don't re-use forms.
  56. $.each(viewModel.connector().con_forms(), function(index, form) {
  57. node.connector.push($.extend(true, {}, form));
  58. });
  59. $.each(viewModel.framework().con_forms(), function(index, form) {
  60. node.framework.push($.extend(true, {}, form));
  61. });
  62. return node;
  63. }
  64. function create_job(attrs, options) {
  65. var options = options || {};
  66. options.modelDict = attrs || {};
  67. var node = new jobs.Job(options);
  68. return node;
  69. }
  70. //// View Models
  71. var viewModel = new (function() {
  72. var self = this;
  73. self.jobWizard = new wizard.Wizard();
  74. self.sqoop_errors = ko.observableArray([]);
  75. self.errors = ko.observable({});
  76. self.warnings = ko.observable({});
  77. self.framework = ko.observable();
  78. self.connectors = ko.observableArray();
  79. self.connections = ko.observableArray();
  80. self.jobs = ko.observableArray();
  81. self.connection = ko.observable();
  82. self.editConnection = ko.observable();
  83. self.modal = {
  84. 'name': ko.observable()
  85. };
  86. self.filter = ko.observable("");
  87. self.shownSection = ko.observable("");
  88. self.isDirty = ko.observable(false);
  89. self.isLoading = ko.observable(false);
  90. self.isReady = ko.observable(false);
  91. self.isReady.subscribe(function(value) { // fixes problem with too fast rendering engines that display chunks of html before KO bindings
  92. if (value){
  93. $(document).trigger('isready');
  94. }
  95. });
  96. // Must always have a value.
  97. self.connector = ko.computed(function() {
  98. // Fall back to first connector so that a connector is selected when we are creating a connection.
  99. if (!self.connection()) {
  100. return self.connectors()[0];
  101. }
  102. var connectorArr = ko.utils.arrayFilter(self.connectors(), function (connector) {
  103. return connector.id() == self.connection().connector_id();
  104. });
  105. return (connectorArr.length > 0) ? connectorArr[0] : self.connectors()[0];
  106. });
  107. self.persistedJobs = ko.computed(function() {
  108. return ko.utils.arrayFilter(self.jobs(), function (job) {
  109. return job.persisted();
  110. });
  111. });
  112. self.persistedConnections = ko.computed(function() {
  113. return ko.utils.arrayFilter(self.connections(), function (connection) {
  114. return connection.persisted();
  115. });
  116. });
  117. self.filteredJobs = ko.computed(function() {
  118. var filter = self.filter().toLowerCase();
  119. return ko.utils.arrayFilter(self.persistedJobs(), function (job) {
  120. if (job.name()) {
  121. return job.name().toLowerCase().indexOf(filter) > -1 || job.type().toLowerCase().indexOf(filter) > -1;
  122. } else {
  123. return false;
  124. }
  125. });
  126. });
  127. self.selectedJobs = ko.computed(function() {
  128. return ko.utils.arrayFilter(self.jobs(), function (job) {
  129. return job.selected();
  130. });
  131. });
  132. self.job = ko.computed(function() {
  133. if (self.selectedJobs().length > 0) {
  134. return self.selectedJobs()[0];
  135. }
  136. return null;
  137. });
  138. self.allJobsSelected = ko.computed(function () {
  139. return self.selectedJobs().length > 0 && self.selectedJobs().length == self.jobs().length;
  140. });
  141. // Update forms for connectors, jobs, and connections.
  142. // In sqoop, the connector and framework provides
  143. // attributes that need to be filled in for connections
  144. // and jobs. The framework and connector will provide
  145. // different forms for IMPORT and EXPORT jobs.
  146. self.framework.subscribe(function(value) {
  147. // We assume that the framework components
  148. // are not going to change so we do not update connection
  149. // and job objects unless they lack forms.
  150. if (value) {
  151. if (self.editConnection() && self.editConnection().framework().length == 0) {
  152. self.editConnection().framework(value.con_forms());
  153. }
  154. if (self.job() && self.job().framework().length == 0) {
  155. var type = self.job().type().toUpperCase();
  156. self.job().framework(value.job_forms[type]());
  157. }
  158. }
  159. });
  160. self.connector.subscribe(function(value) {
  161. // We assume that the connectors component
  162. // are not going to change so we do not update connection
  163. // and job objects unless they lack forms.
  164. if (value) {
  165. if (self.editConnection() && self.editConnection().connector().length == 0) {
  166. self.editConnection().connector(value.con_forms());
  167. }
  168. if (self.job() && self.job().connector().length == 0) {
  169. var type = self.job().type().toUpperCase();
  170. self.job().connector(value.job_forms[type]());
  171. }
  172. }
  173. });
  174. // Forms are swapped between IMPORT and EXPORT types.
  175. // Use of "beforeChange" subscription event to
  176. // remove subscriptions and help with swapping.
  177. var job_type_subscriptions = [];
  178. var old_connector_forms = {
  179. 'IMPORT': null,
  180. 'EXPORT': null
  181. };
  182. var old_framework_forms = {
  183. 'IMPORT': null,
  184. 'EXPORT': null
  185. };
  186. self.job.subscribe(function(old_job) {
  187. if (job_type_subscriptions) {
  188. $.each(job_type_subscriptions, function(index, subscription) {
  189. subscription.dispose();
  190. });
  191. }
  192. }, self, "beforeChange");
  193. self.job.subscribe(function(job) {
  194. if (job) {
  195. var type = job.type().toUpperCase();
  196. if (self.connector() && job.connector().length == 0) {
  197. job.connector(self.connector().job_forms[type]());
  198. }
  199. if (self.framework() && job.framework().length == 0) {
  200. job.framework(self.framework().job_forms[type]());
  201. }
  202. job_type_subscriptions.push(job.type.subscribe(function(new_type) {
  203. var connector = old_connector_forms[new_type] || self.connector().job_forms[new_type]();
  204. var framework = old_framework_forms[new_type] || self.framework().job_forms[new_type]();
  205. old_connector_forms[new_type] = null;
  206. old_framework_forms[new_type] = null;
  207. job.connector(connector);
  208. job.framework(framework);
  209. }));
  210. job_type_subscriptions.push(job.type.subscribe(function(old_type) {
  211. if (job.connector().length > 0) {
  212. old_connector_forms[old_type] = job.connector();
  213. }
  214. if (job.framework().length > 0) {
  215. old_framework_forms[old_type] = job.framework();
  216. }
  217. }, self, "beforeChange"));
  218. }
  219. });
  220. self.editConnection.subscribe(function() {
  221. if (self.editConnection()) {
  222. if (self.connector() && self.editConnection().connector().length == 0) {
  223. self.editConnection().connector(self.connector().con_forms());
  224. }
  225. if (self.framework() && !self.editConnection().framework().length == 0) {
  226. self.editConnection().framework(self.framework().con_forms());
  227. }
  228. }
  229. });
  230. self.job.subscribe(function() {
  231. self.errors({});
  232. self.warnings({});
  233. });
  234. self.newConnection = function() {
  235. var self = this;
  236. if (!self.connection() || self.connection().persisted()) {
  237. var conn = create_connection();
  238. self.editConnection(conn);
  239. }
  240. };
  241. self.saveConnection = function() {
  242. var connection = self.editConnection();
  243. if (connection) {
  244. connection.connector_id(self.connector().id());
  245. connection.save();
  246. }
  247. };
  248. self.getConnectionById = function(id) {
  249. var connection = null;
  250. $.each(self.connections(), function(index, conn) {
  251. if (conn.id() == id) {
  252. connection = conn;
  253. }
  254. });
  255. return connection;
  256. };
  257. self.chooseConnectionById = function(id) {
  258. var self = this;
  259. self.editConnection(self.getConnectionById(id) || self.editConnection());
  260. };
  261. self.deselectAllConnections = function() {
  262. $.each(self.connections(), function(index, value) {
  263. value.selected(false);
  264. });
  265. };
  266. self.newJob = function(defaultName) {
  267. var self = this;
  268. if (!self.job() || self.job().persisted()) {
  269. var job = create_job();
  270. job.name(defaultName);
  271. self.jobs.push(job);
  272. self.deselectAllJobs();
  273. job.selected(true);
  274. }
  275. };
  276. self.saveJob = function() {
  277. var job = self.job();
  278. if (job) {
  279. if (!self.connection()) {
  280. $(document).trigger('connection_missing.job', [self, null, {}]);
  281. return;
  282. }
  283. job.connector_id((self.connector()) ? self.connector().id() : null);
  284. job.connection_id((self.connection()) ? self.connection().id() : null);
  285. job.save();
  286. }
  287. };
  288. self.chooseJobById = function(id) {
  289. var found_job = false;
  290. $.each(self.jobs(), function(index, job) {
  291. if (job.id() == id) {
  292. found_job = true;
  293. job.selected(true);
  294. } else {
  295. job.selected(false);
  296. }
  297. });
  298. return found_job;
  299. };
  300. self.toggleAllJobsSelected = function() {
  301. if (!self.allJobsSelected()) {
  302. self.selectAllJobs();
  303. } else {
  304. self.deselectAllJobs();
  305. }
  306. };
  307. self.selectAllJobs = function() {
  308. $.each(self.jobs(), function(index, value) {
  309. value.selected(true);
  310. });
  311. };
  312. self.deselectAllJobs = function() {
  313. $.each(self.jobs(), function(index, value) {
  314. value.selected(false);
  315. });
  316. };
  317. self.label = function(component, name) {
  318. var self = this;
  319. return self[component]().resources[name + '.label'];
  320. };
  321. self.help = function(component, name) {
  322. var self = this;
  323. return self[component]().resources[name + '.help'];
  324. };
  325. self.getDatabaseByConnectionId = function(id) {
  326. var self = this;
  327. var connection = self.getConnectionById(id);
  328. if (connection) {
  329. var connection_string = connection.connectionString();
  330. if (connection_string) {
  331. var connection_string_parts = connection.connectionString().split(':');
  332. if (connection_string_parts.length > 2) {
  333. return connection_string_parts[1].toUpperCase();
  334. }
  335. }
  336. }
  337. return null;
  338. };
  339. self.showModal = function(name) {
  340. var self = this;
  341. self.modal.name(name);
  342. $('#modal-container').modal();
  343. };
  344. self.showDeleteJobModal = function() {
  345. var self = this;
  346. var name = 'delete-job-modal';
  347. self.showModal(name);
  348. };
  349. self.showDeleteConnectionModal = function() {
  350. var self = this;
  351. var name = 'delete-connection-modal';
  352. self.showModal(name);
  353. }
  354. self.showFileChooser = function showFileChooser() {
  355. var inputPath = this;
  356. var path = inputPath.value();
  357. $("#filechooser").jHueFileChooser({
  358. initialPath: path,
  359. onFolderChoose: function (filePath) {
  360. inputPath.value(filePath);
  361. $("#chooseFile").modal("hide");
  362. },
  363. onFileChoose:function (filePath) {
  364. inputPath.value(filePath);
  365. $("#chooseFile").modal("hide");
  366. },
  367. createFolder: false,
  368. selectFolder: true,
  369. uploadFile:true
  370. });
  371. $("#chooseFile").modal("show");
  372. };
  373. })();
  374. //// Event handling
  375. function set_framework(e, framework, options) {
  376. viewModel.framework(framework);
  377. }
  378. function set_connectors(e, connectors, options) {
  379. viewModel.connectors(connectors);
  380. }
  381. function set_connections(e, connections, options) {
  382. viewModel.connections(connections);
  383. if (viewModel.connections().length > 0) {
  384. viewModel.connection(viewModel.connections()[0]);
  385. }
  386. }
  387. function set_jobs(e, jobs, options) {
  388. viewModel.jobs.removeAll();
  389. viewModel.jobs(jobs);
  390. }
  391. function update_job_submissions(e, submissions, options) {
  392. $.each(submissions, function(index, submission) {
  393. var job = jobs.getJob(submission.job());
  394. if (job) {
  395. job.submission(submission);
  396. }
  397. });
  398. }
  399. $(document).on('loaded.framework', set_framework);
  400. $(document).on('loaded.connectors', set_connectors);
  401. $(document).on('loaded.connections', set_connections);
  402. $(document).on('loaded.jobs', set_jobs);
  403. $(document).on('loaded.submissions', update_job_submissions);