collections.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570
  1. // Defaults
  2. var SOURCES = [
  3. 'file',
  4. // 'hbase',
  5. // 'hive'
  6. ];
  7. var SOURCE_TYPES = [
  8. 'log',
  9. 'separated',
  10. // 'morphlines'
  11. ];
  12. var FIELD_TYPES = [
  13. "alphaOnlySort",
  14. "ancestor_path",
  15. "boolean",
  16. "currency",
  17. "date",
  18. "descendent_path",
  19. "double",
  20. "float",
  21. "int",
  22. "location",
  23. "location_rpt",
  24. "long",
  25. "lowercase",
  26. "pdate",
  27. "pdouble",
  28. "pfloat",
  29. "pint",
  30. "plong",
  31. "point",
  32. "random",
  33. "string",
  34. "tdate",
  35. "tdouble",
  36. "text_ar",
  37. "text_bg",
  38. "text_ca",
  39. "text_char_norm",
  40. "text_cjk",
  41. "text_cz",
  42. "text_da",
  43. "text_de",
  44. "text_el",
  45. "text_en",
  46. "text_en_splitting",
  47. "text_en_splitting_tight",
  48. "text_es",
  49. "text_eu",
  50. "text_fa",
  51. "text_fi",
  52. "text_fr",
  53. "text_ga",
  54. "text_general",
  55. "text_general_rev",
  56. "text_gl",
  57. "text_greek",
  58. "text_hi",
  59. "text_hu",
  60. "text_hy",
  61. "text_id",
  62. "text_it",
  63. "text_ja",
  64. "text_lv",
  65. "text_nl",
  66. "text_no",
  67. "text_pt",
  68. "text_ro",
  69. "text_ru",
  70. "text_sv",
  71. "text_th",
  72. "text_tr",
  73. "text_ws",
  74. "tfloat",
  75. "tint",
  76. "tlong"
  77. ];
  78. var FIELD_SEPARATORS = [
  79. ',',
  80. '\t',
  81. ];
  82. var FIELD_QUOTE_CHARACTERS = [
  83. '"',
  84. "'"
  85. ];
  86. // View Models
  87. var HiveViewModel = function() {
  88. var self = this;
  89. self.databases = ko.observableArray();
  90. self.database = ko.observable().extend({'errors': null});
  91. self.table = ko.observable().extend({'errors': null});
  92. self.database.subscribe(function() {
  93. self.loadTables();
  94. });
  95. self.table.subscribe(function() {
  96. self.loadColumns();
  97. });
  98. self.loadDatabases = function() {
  99. return $.get("/beeswax/api/autocomplete").done(function(data) {
  100. if (data.databases.length > 0) {
  101. self.databases($.map(data.databases, function(database) { return new HiveDatabase(database); }));
  102. self.database(self.databases()[0]);
  103. }
  104. })
  105. .fail(function (xhr, textStatus, errorThrown) {
  106. $(document).trigger("error", xhr.responseText);
  107. });
  108. };
  109. self.loadTables = function() {
  110. return $.get("/beeswax/api/autocomplete/" + self.database().name()).done(function(data) {
  111. if (data.tables.length > 0) {
  112. self.database().tables($.map(data.tables, function(table) { return new HiveTable(table); }));
  113. self.table(self.database().tables()[0]);
  114. }
  115. })
  116. .fail(function (xhr, textStatus, errorThrown) {
  117. $(document).trigger("error", xhr.responseText);
  118. });
  119. };
  120. self.loadColumns = function() {
  121. return $.get("/beeswax/api/autocomplete/" + self.database().name() + '/' + self.table().name()).done(function(data) {
  122. if (data.columns.length > 0) {
  123. self.table().columns(data.columns);
  124. }
  125. })
  126. .fail(function (xhr, textStatus, errorThrown) {
  127. $(document).trigger("error", xhr.responseText);
  128. });
  129. };
  130. // self.loadDatabases();
  131. };
  132. var HBaseViewModel = function() {
  133. var self = this;
  134. self.clusters = ko.observableArray();
  135. self.cluster = ko.observable().extend({'errors': null});
  136. self.table = ko.observable().extend({'errors': null});
  137. self.indexMapping = {};
  138. self.cluster.subscribe(function() {
  139. self.loadTables();
  140. });
  141. self.loadClusters = function() {
  142. return $.get("/hbase/api/getClusters").done(function(data) {
  143. if (data.data.length > 0) {
  144. self.clusters($.map(data.data, function(cluster) { return new HBaseCluster(cluster.name); }));
  145. self.cluster(self.clusters()[0]);
  146. }
  147. })
  148. .fail(function (xhr, textStatus, errorThrown) {
  149. $(document).trigger("error", xhr.responseText);
  150. });
  151. };
  152. self.loadTables = function() {
  153. return $.get("/hbase/api/getTableList/" + self.cluster().name()).done(function(data) {
  154. if (data.data.length > 0) {
  155. // @TODO(Abe): Check if enabled
  156. self.cluster().tables($.map(data.data, function(table) { return new HBaseTable(table.name); }));
  157. self.table(self.cluster().tables()[0]);
  158. }
  159. })
  160. .fail(function (xhr, textStatus, errorThrown) {
  161. $(document).trigger("error", xhr.responseText);
  162. });
  163. };
  164. // self.loadClusters();
  165. };
  166. var CreateCollectionViewModel = function() {
  167. var self = this;
  168. // Models
  169. self.collection = new Collection();
  170. self.source = ko.observable(SOURCES[0]).extend({'errors': null});
  171. self.fieldSeparator = ko.observable().extend({'errors': null});
  172. self.fieldQuoteCharacter = ko.observable().extend({'errors': null});
  173. self.file = ko.observable().extend({'errors': null});
  174. self.sourceType = ko.observable().extend({'errors': null});
  175. self.morphlines = ko.mapping.fromJS({'name': 'message', 'expression': '%{SYSLOGTIMESTAMP:timestamp} %{SYSLOGHOST:hostname} %{DATA:program}(?:\[%{POSINT:pid}\])?: %{GREEDYDATA:msg}'});
  176. self.morphlines.name = self.morphlines.name.extend({'errors': null});
  177. self.morphlines.expression = self.morphlines.expression.extend({'errors': null});
  178. // UI
  179. self.hive = new HiveViewModel();
  180. self.hbase = new HBaseViewModel();
  181. self.wizard = new Wizard();
  182. self.exampleSchema = ko.observable();
  183. self.isLoading = ko.observable();
  184. self.sources = ko.mapping.fromJS(SOURCES);
  185. self.fieldTypes = ko.mapping.fromJS(FIELD_TYPES);
  186. self.fieldSeparators = ko.mapping.fromJS(FIELD_SEPARATORS);
  187. self.fieldQuoteCharacters = ko.mapping.fromJS(FIELD_QUOTE_CHARACTERS);
  188. self.sourceTypes = ko.mapping.fromJS(SOURCE_TYPES);
  189. self.allCollectionChanges = ko.computed(function() {
  190. ko.toJS(self.collection.fields);
  191. if ('fetchExampleSchema' in self) {
  192. self.fetchExampleSchema();
  193. }
  194. });
  195. self.parseFields = function() {
  196. if (self.source() == 'file') {
  197. self.isLoading(true);
  198. return $.post("/collectionmanager/api/fields/parse/", {
  199. 'source': self.source(),
  200. 'type': self.sourceType(),
  201. 'path': self.file(),
  202. 'separator': self.fieldSeparator(),
  203. 'quote': self.fieldQuoteCharacter(),
  204. 'morphlines': ko.mapping.toJSON(self.morphlines)
  205. }).done(function(data) {
  206. if (data.status == 0) {
  207. self.collection.fields(inferFields(data.data, self.collection));
  208. // Find unique key default field
  209. var message = null;
  210. var first = null;
  211. ko.utils.arrayForEach(self.collection.fields(), function(field) {
  212. if (!first) {
  213. first = field;
  214. }
  215. if (field.name() == 'message') {
  216. message = field;
  217. }
  218. });
  219. if (message) {
  220. self.collection.uniqueKeyField(message.name());
  221. } else if (first) {
  222. self.collection.uniqueKeyField(first.name());
  223. }
  224. self.fetchExampleSchema();
  225. } else {
  226. $(document).trigger("error", data.message);
  227. }
  228. self.isLoading(false);
  229. }).fail(function (xhr, textStatus, errorThrown) {
  230. $(document).trigger("error", xhr.responseText);
  231. self.isLoading(false);
  232. });
  233. }
  234. };
  235. self.fetchExampleSchema = function() {
  236. self.isLoading(true);
  237. var collection = ko.mapping.toJS(self.collection);
  238. return $.post("/collectionmanager/api/schema/example/", {
  239. 'collection': ko.mapping.toJSON(collection)
  240. }).done(function(data) {
  241. if (data.status == 0) {
  242. self.exampleSchema(data.example);
  243. } else {
  244. $(document).trigger("error", data.message);
  245. }
  246. self.isLoading(false);
  247. })
  248. .fail(function (xhr, textStatus, errorThrown) {
  249. $(document).trigger("error", xhr.responseText);
  250. self.isLoading(false);
  251. });
  252. };
  253. self.save = function() {
  254. if (self.wizard.currentPage().validate()) {
  255. self.isLoading(true);
  256. var collection = ko.mapping.toJS(self.collection);
  257. collection.fields = ko.utils.arrayMap(collection.fields, function(field) {
  258. delete field['uniqueKeyField'];
  259. return field;
  260. });
  261. switch(self.source()) {
  262. case 'file':
  263. return $.post("/collectionmanager/api/collections/create/", {
  264. 'collection': ko.mapping.toJSON(collection),
  265. 'type': self.sourceType(),
  266. 'path': self.file(),
  267. 'source': self.source()
  268. }).done(function(data) {
  269. if (data.status == 0) {
  270. window.location.href = '/collectionmanager';
  271. } else {
  272. $(document).trigger("error", data.message);
  273. }
  274. self.isLoading(false);
  275. })
  276. .fail(function (xhr, textStatus, errorThrown) {
  277. $(document).trigger("error", xhr.responseText);
  278. self.isLoading(false);
  279. });
  280. case 'hive':
  281. return $.post("/collectionmanager/api/collections/create/", {
  282. 'collection': ko.toJSON(collection),
  283. 'database': self.hive.database().name(),
  284. 'table': self.hive.table().name(),
  285. 'source': self.source()
  286. }).done(function(data) {
  287. if (data.status == 0) {
  288. window.location.href = '/collectionmanager';
  289. } else {
  290. $(document).trigger("error", data.message);
  291. }
  292. self.isLoading(false);
  293. })
  294. .fail(function (xhr, textStatus, errorThrown) {
  295. $(document).trigger("error", xhr.responseText);
  296. self.isLoading(false);
  297. });
  298. }
  299. }
  300. };
  301. };
  302. var EditCollectionViewModel = function() {
  303. var self = this;
  304. // Models
  305. self.collection = ko.observable();
  306. self.sourceType = ko.observable().extend({'errors': null});
  307. // UI
  308. self.fieldTypes = ko.mapping.fromJS(FIELD_TYPES);
  309. self.sourceTypes = ko.mapping.fromJS(SOURCE_TYPES);
  310. self.isLoading = ko.observable();
  311. self.collection.subscribe(function(collection) {
  312. if (collection) {
  313. self.fetchFields();
  314. }
  315. });
  316. self.fetchFields = function() {
  317. if (self.collection()) {
  318. self.isLoading(true);
  319. return $.get("/collectionmanager/api/collections/" + self.collection().name() + "/metadata/").done(function(data) {
  320. if (data.status == 0) {
  321. self.collection().fields(inferFields(data.fields, self.collection()));
  322. self.collection().uniqueKeyField(data.unique_key);
  323. self.sourceType(data.type);
  324. } else {
  325. $(document).trigger("error", data.message);
  326. }
  327. self.isLoading(false);
  328. })
  329. .fail(function (xhr, textStatus, errorThrown) {
  330. $(document).trigger("error", xhr.responseText);
  331. self.isLoading(false);
  332. });
  333. }
  334. };
  335. self.updateCollection = function() {
  336. self.isLoading(true);
  337. var data = ko.mapping.toJS(self.collection);
  338. return $.post("/collectionmanager/api/collections/" + self.collection().name() + "/update/", {
  339. 'collection': ko.mapping.toJSON(data),
  340. 'type': self.sourceType()
  341. }).done(function(data) {
  342. if (data.status == 0) {
  343. $(document).trigger("info", data.message);
  344. } else {
  345. $(document).trigger("error", data.message);
  346. }
  347. self.isLoading(false);
  348. })
  349. .fail(function (xhr, textStatus, errorThrown) {
  350. $(document).trigger("error", xhr.responseText);
  351. self.isLoading(false);
  352. });
  353. };
  354. };
  355. var ManageCollectionsViewModel = function() {
  356. var self = this;
  357. // Models
  358. self.collections = ko.observableArray();
  359. // UI
  360. self.isLoading = ko.observable();
  361. self.filteredCollections = ko.observableArray();
  362. self.selectedCollections = ko.computed(function() {
  363. return ko.utils.arrayFilter(self.collections(), function(collection) {
  364. return collection.selected();
  365. });
  366. });
  367. self.toggleCollectionSelect = function(collection, e) {
  368. ko.utils.arrayForEach(self.collections(), function(other_collection) {
  369. if(ko.unwrap(other_collection).name() == collection.name()) {
  370. other_collection.selected(!other_collection.selected());
  371. } else {
  372. if (!e.ctrlKey && !e.shiftKey) {
  373. other_collection.selected(false);
  374. }
  375. }
  376. });
  377. };
  378. self.importCollection = function(collection, e) {
  379. self.isLoading(true);
  380. return $.post("/collectionmanager/api/collections/import/", {
  381. 'collection': ko.mapping.toJSON(collection)
  382. }).done(function(data) {
  383. self.isLoading(false);
  384. $(document).trigger("info", data.message);
  385. self.fetchCollections();
  386. })
  387. .fail(function (xhr, textStatus, errorThrown) {
  388. self.isLoading(false);
  389. $(document).trigger("error", xhr.responseText);
  390. });
  391. };
  392. self.filterTest = function(obj, filter) {
  393. return ko.unwrap(obj).name().indexOf(filter) != -1;
  394. };
  395. self.addData = function(collection, path) {
  396. self.isLoading(true);
  397. return $.post("/collectionmanager/api/collections/" + collection.name() + "/data/", {
  398. 'collection': ko.mapping.toJSON(collection),
  399. 'source': 'file',
  400. 'path': path
  401. }).done(function(data) {
  402. self.isLoading(false);
  403. $(document).trigger("info", data.message);
  404. })
  405. .fail(function (xhr, textStatus, errorThrown) {
  406. self.isLoading(false);
  407. $(document).trigger("error", xhr.responseText);
  408. });
  409. };
  410. self.fetchCollections = function() {
  411. self.isLoading(true);
  412. return $.get("/collectionmanager/api/collections/").done(function(data) {
  413. if (data.status == 0) {
  414. var collections = [];
  415. ko.utils.arrayForEach(data.collections, function(collection) {
  416. var new_collection = ko.observable(new Collection(collection.name)).extend({'selectable': null});
  417. new_collection().hasHueCollection(collection.hue);
  418. new_collection().hasSolrCollection(collection.solr);
  419. collections.push(new_collection);
  420. });
  421. self.collections(collections);
  422. } else {
  423. $(document).trigger("error", data.message);
  424. }
  425. self.isLoading(false);
  426. })
  427. .fail(function (xhr, textStatus, errorThrown) {
  428. $(document).trigger("error", xhr.responseText);
  429. self.isLoading(false);
  430. });
  431. };
  432. self.removeCollections = function(collection) {
  433. self.isLoading(true);
  434. var collections = self.filteredCollections();
  435. if (collections.length == 0) {
  436. collections = ($.isArray(collection)) ? collection : [collection];
  437. }
  438. return $.post("/collectionmanager/api/collections/remove/", {
  439. 'collections': ko.mapping.toJSON(collections)
  440. }).done(function(data) {
  441. if (data.status == 0) {
  442. // Remove collections
  443. collection_names = ko.utils.arrayMap(collections, function(collection) {
  444. return ko.unwrap(collection).name();
  445. });
  446. var index = 0;
  447. var remove = [];
  448. ko.utils.arrayForEach(self.collections(), function(collection) {
  449. collection = ko.unwrap(collection);
  450. if (collection_names.indexOf(collection.name()) != -1) {
  451. remove.push(index);
  452. }
  453. index++;
  454. });
  455. remove.reverse();
  456. ko.utils.arrayForEach(remove, function(index) {
  457. self.collections.splice(index, 1);
  458. });
  459. } else {
  460. $(document).trigger("error", data.message);
  461. }
  462. self.isLoading(false);
  463. })
  464. .fail(function (xhr, textStatus, errorThrown) {
  465. $(document).trigger("error", xhr.responseText);
  466. self.isLoading(false);
  467. });
  468. };
  469. };
  470. var CollectionsViewModel = function() {
  471. var self = this;
  472. // Models
  473. self.page = ko.observable();
  474. // UI
  475. self.create = new CreateCollectionViewModel();
  476. self.manage = new ManageCollectionsViewModel();
  477. self.edit = new EditCollectionViewModel();
  478. self.isLoading = ko.computed(function() {
  479. return self.create.isLoading() || self.manage.isLoading() || self.edit.isLoading();
  480. });
  481. };
  482. // Utils
  483. function getFileBrowseButton(inputElement) {
  484. return $("<button>").addClass("btn").addClass("fileChooserBtn").text("..").click(function (e) {
  485. e.preventDefault();
  486. $("#filechooser").jHueFileChooser({
  487. initialPath: inputElement.val(),
  488. onFileChoose: function (filePath) {
  489. inputElement.val(filePath);
  490. inputElement.trigger("change");
  491. $("#chooseFile").modal("hide");
  492. },
  493. selectFolder: false,
  494. createFolder: false
  495. });
  496. $("#chooseFile").modal("show");
  497. });
  498. }
  499. function inferFields(field_data, collection) {
  500. var fields = [];
  501. $.each(field_data, function(index, value) {
  502. // 0 => name
  503. // 1 => type
  504. // 2 => required
  505. // 3 => indexed
  506. // 4 => stored
  507. var field = new Field(collection, value[0], value[1], value[2], value[3]);
  508. field.saved(true);
  509. fields.push(field);
  510. });
  511. return fields;
  512. }