2 * Copyright © 2016-2017 European Support Limited.
4 package org.openecomp.core.tools.exportinfo;
6 import com.datastax.driver.core.ResultSet;
7 import com.datastax.driver.core.ResultSetFuture;
8 import com.datastax.driver.core.Session;
9 import com.google.common.collect.Sets;
10 import com.google.common.util.concurrent.FutureCallback;
11 import com.google.common.util.concurrent.Futures;
12 import org.apache.commons.io.FileUtils;
13 import org.openecomp.core.nosqldb.impl.cassandra.CassandraSessionFactory;
14 import org.openecomp.core.tools.importinfo.ImportProperties;
15 import org.openecomp.core.tools.util.Utils;
16 import org.openecomp.core.tools.util.ZipUtils;
17 import org.openecomp.core.zusammen.impl.CassandraConnectionInitializer;
18 import org.openecomp.sdc.logging.api.Logger;
19 import org.openecomp.sdc.logging.api.LoggerFactory;
20 import org.yaml.snakeyaml.Yaml;
23 import java.io.IOException;
24 import java.io.InputStream;
25 import java.nio.file.Path;
26 import java.nio.file.Paths;
27 import java.time.LocalDateTime;
28 import java.time.format.DateTimeFormatter;
29 import java.util.HashSet;
30 import java.util.List;
33 import java.util.concurrent.CountDownLatch;
34 import java.util.concurrent.Executor;
35 import java.util.concurrent.ExecutorService;
36 import java.util.concurrent.Executors;
37 import java.util.stream.Collectors;
39 import static java.nio.file.Files.createDirectories;
42 public final class ExportDataCommand {
43 private static final Logger logger = LoggerFactory.getLogger(ExportDataCommand.class);
44 public static final String JOIN_DELIMITER = "$#";
45 public static final String JOIN_DELIMITER_SPLITTER = "\\$\\#";
46 public static final String MAP_DELIMITER = "!@";
47 public static final String MAP_DELIMITER_SPLITTER = "\\!\\@";
48 public static final int THREAD_POOL_SIZE = 6;
49 public static final String NULL_REPRESENTATION = "nnuullll";
51 private ExportDataCommand() {
54 public static void exportData(String filterItem) {
55 ExecutorService executor = null;
57 CassandraConnectionInitializer.setCassandraConnectionPropertiesToSystem();
58 Path rootDir = Paths.get(ImportProperties.ROOT_DIRECTORY);
60 try (Session session = CassandraSessionFactory.getSession()) {
61 final Set<String> filteredItems = Sets.newHashSet(filterItem);
62 Set<String> fis = filteredItems.stream().map(fi -> fi.replaceAll("\\r", "")).collect(Collectors.toSet());
63 Map<String, List<String>> queries;
64 Yaml yaml = new Yaml();
65 try (InputStream is = ExportDataCommand.class.getResourceAsStream("/queries.yaml")) {
66 queries = (Map<String, List<String>>) yaml.load(is);
68 List<String> queriesList = queries.get("queries");
69 List<String> itemsColumns = queries.get("item_columns");
70 Set<String> vlms = new HashSet<>();
71 CountDownLatch doneQueries = new CountDownLatch(queriesList.size());
72 executor = Executors.newFixedThreadPool(THREAD_POOL_SIZE);
73 for (int i = 0; i < queriesList.size(); i++) {
74 executeQuery(session, queriesList.get(i), fis, itemsColumns.get(i), vlms, doneQueries, executor);
77 if (!vlms.isEmpty()) {
78 CountDownLatch doneVmls = new CountDownLatch(queriesList.size());
79 for (int i = 0; i < queriesList.size(); i++) {
80 executeQuery(session, queriesList.get(i), vlms, itemsColumns.get(i), null, doneVmls, executor);
87 FileUtils.forceDelete(rootDir.toFile());
88 } catch (Exception ex) {
89 Utils.logError(logger, ex);
91 if (executor != null) {
99 private static void executeQuery(final Session session, final String query, final Set<String> filteredItems, final String filteredColumn,
100 final Set<String> vlms, final CountDownLatch donequerying, Executor executor) {
101 ResultSetFuture resultSetFuture = session.executeAsync(query);
102 Futures.addCallback(resultSetFuture, new FutureCallback<ResultSet>() {
104 public void onSuccess(ResultSet resultSet) {
106 Utils.printMessage(logger, "Start to serialize " + query);
107 new ExportSerializer().serializeResult(resultSet, filteredItems, filteredColumn, vlms);
108 donequerying.countDown();
109 } catch (Exception e){
110 Utils.logError(logger, "Serialization failed :" + query, e);
116 public void onFailure(Throwable t) {
117 Utils.logError(logger, "Query failed :" + query, t);
123 private static void zipPath(Path rootDir) throws IOException {
124 LocalDateTime date = LocalDateTime.now();
125 DateTimeFormatter formatter = DateTimeFormatter.ISO_LOCAL_DATE_TIME;
126 String dateStr = date.format(formatter);
127 dateStr = dateStr.replaceAll(":", "_");
128 String zipFile = System.getProperty("user.home") + File.separatorChar + "onboarding_import" + dateStr + ".zip";
129 ZipUtils.createZip(zipFile, rootDir);
130 Utils.printMessage(logger, "Exported file :" + zipFile);
134 public static void initDir(Path rootDir) throws IOException {
135 if (rootDir.toFile().exists()) {
136 FileUtils.forceDelete(rootDir.toFile());
138 createDirectories(rootDir);