1
|
/**
|
2
|
* Copyright (C) 2007 EDIT
|
3
|
* European Distributed Institute of Taxonomy
|
4
|
* http://www.e-taxonomy.eu
|
5
|
*
|
6
|
* The contents of this file are subject to the Mozilla Public License Version 1.1
|
7
|
* See LICENSE.TXT at the top of this package for the full license terms.
|
8
|
*/
|
9
|
|
10
|
package eu.etaxonomy.cdm.app.pesi;
|
11
|
|
12
|
import java.util.UUID;
|
13
|
|
14
|
import org.apache.log4j.Logger;
|
15
|
|
16
|
import eu.etaxonomy.cdm.api.application.ICdmRepository;
|
17
|
import eu.etaxonomy.cdm.app.common.CdmDestinations;
|
18
|
import eu.etaxonomy.cdm.app.common.PesiDestinations;
|
19
|
import eu.etaxonomy.cdm.app.common.PesiSources;
|
20
|
import eu.etaxonomy.cdm.database.DbSchemaValidation;
|
21
|
import eu.etaxonomy.cdm.database.ICdmDataSource;
|
22
|
import eu.etaxonomy.cdm.io.common.CdmDefaultImport;
|
23
|
import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;
|
24
|
import eu.etaxonomy.cdm.io.common.IImportConfigurator.DO_REFERENCES;
|
25
|
import eu.etaxonomy.cdm.io.common.Source;
|
26
|
import eu.etaxonomy.cdm.io.pesi.erms.ErmsImportConfigurator;
|
27
|
import eu.etaxonomy.cdm.io.pesi.out.PesiTransformer;
|
28
|
import eu.etaxonomy.cdm.model.name.TaxonName;
|
29
|
|
30
|
/**
|
31
|
* @author a.mueller
|
32
|
*/
|
33
|
public class ErmsImportActivator {
|
34
|
|
35
|
private static final Logger logger = Logger.getLogger(ErmsImportActivator.class);
|
36
|
|
37
|
// static final Source ermsSource = PesiSources.PESI2019_ERMS_2018();
|
38
|
static final Source ermsSource = PesiSources.PESI2019_ERMS_2019();
|
39
|
|
40
|
// static final ICdmDataSource cdmDestination = CdmDestinations.test_cdm_pesi_erms();
|
41
|
|
42
|
// static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql_erms();
|
43
|
// static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql_erms2();
|
44
|
static final ICdmDataSource cdmDestination = CdmDestinations.cdm_pesi2019_final();
|
45
|
|
46
|
|
47
|
static final boolean includeExport2PESI = false;
|
48
|
static final Source pesiDestination = !includeExport2PESI ? null :
|
49
|
cdmDestination.getDatabase().equals(CdmDestinations.cdm_test_local_mysql_erms().getDatabase())?
|
50
|
PesiDestinations.pesi_test_local_CDM_ERMS2PESI():
|
51
|
PesiDestinations.pesi_test_local_CDM_ERMS2PESI_2() ;
|
52
|
|
53
|
static final UUID classificationUuid = UUID.fromString("6fa988a9-10b7-48b0-a370-2586fbc066eb");
|
54
|
static final String classificationName = "ERMS 2019";
|
55
|
static final String sourceRefTitle = "ERMS export for PESI";
|
56
|
|
57
|
//check - import
|
58
|
static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
|
59
|
static final int partitionSize = 5000;
|
60
|
|
61
|
// ***************** ALL ************************************************//
|
62
|
|
63
|
static final DO_REFERENCES doReferences = DO_REFERENCES.ALL;
|
64
|
static final boolean doTaxa = true;
|
65
|
static final boolean doRelTaxa = doTaxa; //should always run with doTaxa because dependent on state from doTaxa
|
66
|
static final boolean doSourceUse = true;
|
67
|
static final boolean doCommonNames = true;
|
68
|
static final boolean doNotes = true;
|
69
|
static final boolean doDistributions = true;
|
70
|
static final boolean doLinks = true;
|
71
|
static final boolean doImages = true;
|
72
|
|
73
|
//******************** NONE ***************************************//
|
74
|
|
75
|
// static final DO_REFERENCES doReferences = DO_REFERENCES.NONE;
|
76
|
// static final boolean doTaxa = false;
|
77
|
// static final boolean doRelTaxa = doTaxa; //should always run with doTaxa because depends on state from doTaxa
|
78
|
//
|
79
|
// static final boolean doSourceUse = false;
|
80
|
// static final boolean doCommonNames = false;
|
81
|
// static final boolean doNotes = false;
|
82
|
// static final boolean doDistributions = false;
|
83
|
// static final boolean doLinks = false;
|
84
|
// static final boolean doImages = false;
|
85
|
|
86
|
// private static DbSchemaValidation hbm2dll = (doReferences == DO_REFERENCES.ALL)? DbSchemaValidation.CREATE:DbSchemaValidation.VALIDATE;
|
87
|
private static DbSchemaValidation hbm2dll = DbSchemaValidation.VALIDATE;
|
88
|
|
89
|
private void doImport(Source source, ICdmDataSource destination, DbSchemaValidation hbm2dll){
|
90
|
System.out.println("Start import from ("+ ermsSource.getDatabase() + ") to " + destination.getDatabase() + " ..." );
|
91
|
|
92
|
//make ERMS Source
|
93
|
|
94
|
ErmsImportConfigurator config = ErmsImportConfigurator.NewInstance(source, destination);
|
95
|
|
96
|
config.setClassificationUuid(classificationUuid);
|
97
|
|
98
|
config.setDoReferences(doReferences);
|
99
|
|
100
|
config.setDoTaxa(doTaxa);
|
101
|
config.setDoRelTaxa(doRelTaxa);
|
102
|
config.setDoSourceUse(doSourceUse);
|
103
|
config.setDoLinks(doLinks);
|
104
|
config.setDoDistributions(doDistributions);
|
105
|
config.setDoVernaculars(doCommonNames);
|
106
|
config.setDoNotes(doNotes);
|
107
|
config.setDoImages(doImages);
|
108
|
|
109
|
config.setDbSchemaValidation(hbm2dll);
|
110
|
|
111
|
config.setCheck(check);
|
112
|
config.setRecordsPerTransaction(partitionSize);
|
113
|
config.setSourceRefUuid(PesiTransformer.uuidSourceRefErms);
|
114
|
config.setClassificationName(classificationName);
|
115
|
config.setSourceReferenceTitle(sourceRefTitle);
|
116
|
|
117
|
// invoke import
|
118
|
CdmDefaultImport<ErmsImportConfigurator> ermsImport = new CdmDefaultImport<>();
|
119
|
ermsImport.invoke(config);
|
120
|
|
121
|
if (config.getCheck().equals(CHECK.CHECK_AND_IMPORT) || config.getCheck().equals(CHECK.IMPORT_WITHOUT_CHECK) ){
|
122
|
ICdmRepository app = ermsImport.getCdmAppController();
|
123
|
TaxonName obj = app.getCommonService().getSourcedObjectByIdInSource(TaxonName.class, "1000027", null);
|
124
|
logger.info(obj);
|
125
|
}
|
126
|
System.out.println("End import from ("+ source.getDatabase() + ") to " + destination.getDatabase() + "...");
|
127
|
}
|
128
|
|
129
|
public static void main(String[] args) {
|
130
|
ICdmDataSource cdmDB = CdmDestinations.chooseDestination(args) != null ? CdmDestinations.chooseDestination(args) : cdmDestination;
|
131
|
ErmsImportActivator ermsImport = new ErmsImportActivator();
|
132
|
ermsImport.doImport(ermsSource, cdmDB, hbm2dll);
|
133
|
|
134
|
if (includeExport2PESI && check != CHECK.CHECK_ONLY){
|
135
|
PesiExportActivatorERMS ermsExport = new PesiExportActivatorERMS();
|
136
|
ermsExport.doTaxa = doTaxa;
|
137
|
ermsExport.doTreeIndex = doTaxa;
|
138
|
ermsExport.doRelTaxa = doRelTaxa;
|
139
|
ermsExport.doDescriptions = doImages;
|
140
|
|
141
|
ermsExport.doExport(cdmDB, pesiDestination);
|
142
|
}
|
143
|
System.exit(0);
|
144
|
}
|
145
|
}
|