decd0cee9a835d8b6ebf98ba2c82db1716bb2ce8
[sdc.git] /
1 /**
2  * Copyright © 2016-2017 European Support Limited.
3  */
4 package org.openecomp.core.tools.exportinfo;
5
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;
21
22 import java.io.File;
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;
31 import java.util.Map;
32 import java.util.Set;
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;
38
39 import static java.nio.file.Files.createDirectories;
40
41
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";
50
51     private ExportDataCommand() {
52     }
53
54     public static void exportData(String filterItem) {
55         ExecutorService executor = null;
56         try {
57             CassandraConnectionInitializer.setCassandraConnectionPropertiesToSystem();
58             Path rootDir = Paths.get(ImportProperties.ROOT_DIRECTORY);
59             initDir(rootDir);
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);
67                 }
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);
75                 }
76                 doneQueries.await();
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);
81                     }
82
83                     doneVmls.await();
84                 }
85             }
86             zipPath(rootDir);
87             FileUtils.forceDelete(rootDir.toFile());
88         } catch (Exception ex) {
89             Utils.logError(logger, ex);
90         } finally {
91             if (executor != null) {
92                 executor.shutdown();
93             }
94         }
95
96     }
97
98
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>() {
103             @Override
104             public void onSuccess(ResultSet resultSet) {
105                 try {
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);
111                     System.exit(-1);
112                 }
113             }
114
115             @Override
116             public void onFailure(Throwable t) {
117                 Utils.logError(logger, "Query failed :" + query, t);
118                 System.exit(-1);
119             }
120         }, executor);
121     }
122
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);
131     }
132
133
134     public static void initDir(Path rootDir) throws IOException {
135         if (rootDir.toFile().exists()) {
136             FileUtils.forceDelete(rootDir.toFile());
137         }
138         createDirectories(rootDir);
139     }
140
141 }