Project

General

Profile

Download (11.1 KB) Statistics
| Branch: | Revision:
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.cuba;
11

    
12
import java.net.URI;
13
import java.util.UUID;
14

    
15
import org.apache.log4j.Logger;
16

    
17
import eu.etaxonomy.cdm.api.application.CdmApplicationController;
18
import eu.etaxonomy.cdm.api.application.ICdmApplicationConfiguration;
19
import eu.etaxonomy.cdm.api.service.ITermService;
20
import eu.etaxonomy.cdm.app.common.CdmDestinations;
21
import eu.etaxonomy.cdm.database.DbSchemaValidation;
22
import eu.etaxonomy.cdm.database.ICdmDataSource;
23
import eu.etaxonomy.cdm.io.common.CdmDefaultImport;
24
import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;
25
import eu.etaxonomy.cdm.io.cuba.CubaImportConfigurator;
26
import eu.etaxonomy.cdm.io.cuba.CubaTransformer;
27
import eu.etaxonomy.cdm.model.agent.Person;
28
import eu.etaxonomy.cdm.model.agent.Team;
29
import eu.etaxonomy.cdm.model.description.Feature;
30
import eu.etaxonomy.cdm.model.description.FeatureNode;
31
import eu.etaxonomy.cdm.model.description.FeatureTree;
32
import eu.etaxonomy.cdm.model.reference.Reference;
33
import eu.etaxonomy.cdm.model.reference.ReferenceFactory;
34

    
35
/**
36
 * @author a.mueller
37
 * @created 04.01.2016
38
 */
39
public class CubaActivator {
40
	private static final Logger logger = Logger.getLogger(CubaActivator.class);
41

    
42
	//database validation status (create, update, validate ...)
43
	static DbSchemaValidation hbm2dll = DbSchemaValidation.CREATE;
44

    
45
//    static final ICdmDataSource cdmDestination = CdmDestinations.localH2();
46
  static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql_test();
47
//    static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cuba_production();
48

    
49
	static boolean invers = false;
50

    
51
    boolean doAsteraceae = include;
52
    boolean doConvolvulaceae = include;
53
    boolean doCyperaceae = include;
54
    boolean doDicotA_C = include;
55
    boolean doDicotD_M = include;
56
    boolean doDicotN_Z = include;
57
    boolean doEuphorbiaceae = include;
58
    boolean doFabaceae = include;
59
    boolean doGymnospermae = include;
60
    boolean doLamVerbenaceae = include;
61
    boolean doMalpighiaceae = include;
62
    boolean doMelastomataceae = include;
63
    boolean doMonocots = include;
64
    boolean doMyrtaceae = include;
65
    boolean doOrchidaceae = include;
66
    boolean doRubiaceae = include;
67
    boolean doUrticaceae = include;
68

    
69
    static boolean include = !invers;
70

    
71

    
72
	//feature tree uuid
73
	public static final UUID featureTreeUuid = UUID.fromString("dad6b9b5-693f-4367-a7aa-076cc9c99476");
74

    
75
	//classification
76
	static final UUID classificationUuid = UUID.fromString("5de394de-9c76-4b97-b04d-71be31c7f44b");
77
	private static final String classificationName = "Cuba Checklist";
78

    
79
	static final String sourceReferenceTitle = "Cuba Checklist Word Documents";
80

    
81
	//check - import
82
	static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
83

    
84
	boolean doVocabularies = (hbm2dll == DbSchemaValidation.CREATE);
85
	static final boolean doTaxa = true;
86
	static final boolean doDeduplicate = false;
87

    
88

    
89
	private void doImport(ICdmDataSource cdmDestination){
90

    
91
	    URI source = monocots();  //just any
92

    
93
		//make Source
94
		CubaImportConfigurator config= CubaImportConfigurator.NewInstance(source, cdmDestination);
95
		config.setClassificationUuid(classificationUuid);
96
        config.setClassificationName(classificationName);
97
        config.setCheck(check);
98
//		config.setDoDistribution(doDistribution);
99
		config.setDoTaxa(doTaxa);
100
		config.setDbSchemaValidation(hbm2dll);
101
		config.setSourceReferenceTitle(sourceReferenceTitle);
102
		config.setDoVocabularies(doVocabularies);
103

    
104
		CdmDefaultImport<CubaImportConfigurator> myImport = new CdmDefaultImport<CubaImportConfigurator>();
105

    
106

    
107
		//...
108
        if (doAsteraceae){
109
            doSingleSource(asteraceae(), config, myImport, doVocabularies);
110
        }
111
        if (doConvolvulaceae){
112
            doSingleSource(convolvulaceae(), config, myImport, doVocabularies);
113
        }
114
        if (doCyperaceae){
115
            doSingleSource(cyperaceae(), config, myImport, doVocabularies);
116
        }
117
        if (doDicotA_C){
118
            doSingleSource(dicotA_C(), config, myImport, doVocabularies);
119
        }
120
        if (doDicotD_M){
121
            doSingleSource(dicotD_M(), config, myImport, doVocabularies);
122
        }
123
        if (doDicotN_Z){
124
            doSingleSource(dicotN_Z(), config, myImport, doVocabularies);
125
        }
126
        if (doEuphorbiaceae){
127
            doSingleSource(euphorbiaceae(), config, myImport, doVocabularies);
128
        }
129
        if (doFabaceae){
130
            doSingleSource(fabaceae(), config, myImport, doVocabularies);
131
        }
132
        if (doGymnospermae){
133
            doSingleSource(gymnospermae(), config, myImport, doVocabularies);
134
        }
135
        if (doLamVerbenaceae){
136
            doSingleSource(lamVerbenaceae(), config, myImport, doVocabularies);
137
        }
138
        if (doMalpighiaceae){
139
            doSingleSource(malpighiaceae(), config, myImport, doVocabularies);
140
        }
141
        if (doMelastomataceae){
142
            doSingleSource(melastomataceae(), config, myImport, doVocabularies);
143
        }
144
        if (doMonocots){
145
            doSingleSource(monocots(), config, myImport, doVocabularies);
146
        }
147
        if (doMyrtaceae){
148
            doSingleSource(myrtaceae(), config, myImport, doVocabularies);
149
        }
150
        if (doOrchidaceae){
151
            doSingleSource(orchidaceae(), config, myImport, doVocabularies);
152
        }
153
        if (doRubiaceae){
154
            doSingleSource(rubiaceae(), config, myImport, doVocabularies);
155
        }
156
        if (doUrticaceae){
157
            doSingleSource(urticaceae(), config, myImport, doVocabularies);
158
        }
159

    
160

    
161

    
162
		//deduplicate
163
		if (doDeduplicate){
164
		    logger.warn("Start deduplication ...");
165

    
166
		    ICdmApplicationConfiguration app = myImport.getCdmAppController();
167
			if (app == null){
168
                app = CdmApplicationController.NewInstance(cdmDestination, hbm2dll, false);
169
            }
170
			int count = app.getAgentService().deduplicate(Person.class, null, null);
171
			logger.warn("Deduplicated " + count + " persons.");
172
			count = app.getAgentService().deduplicate(Team.class, null, null);
173
			logger.warn("Deduplicated " + count + " teams.");
174
			count = app.getReferenceService().deduplicate(Reference.class, null, null);
175
			logger.warn("Deduplicated " + count + " references.");
176
		}
177

    
178
		System.exit(0);
179

    
180
	}
181

    
182
    /**
183
     * @param source
184
     * @param config
185
     * @param myImport
186
     */
187
    private void doSingleSource(URI source, CubaImportConfigurator config,
188
            CdmDefaultImport<CubaImportConfigurator> myImport, boolean doVocabularies) {
189
        config.setSource(source);
190
        String fileName = source.toString();
191
        fileName = fileName.substring(fileName.lastIndexOf("/") + 1 );
192

    
193
        String message = "Start import from ("+ fileName + ") ...";
194
        System.out.println(message);
195
        logger.warn(message);
196
        config.setSourceReference(getSourceReference(fileName));
197
        config.setDoVocabularies(doVocabularies);
198
        myImport.invoke(config);
199

    
200
        if (doVocabularies){
201
            FeatureTree tree = makeFeatureNodes(myImport.getCdmAppController().getTermService());
202
            myImport.getCdmAppController().getFeatureTreeService().saveOrUpdate(tree);
203
            this.doVocabularies = false;
204
        }
205
        System.out.println("End import from ("+ source.toString() + ")...");
206
    }
207

    
208
    private final Reference<?> inRef = ReferenceFactory.newGeneric();
209
	private Reference<?> getSourceReference(String string) {
210
		Reference<?> result = ReferenceFactory.newGeneric();
211
		result.setTitleCache(string, true);
212
		result.setInReference(inRef);
213
		inRef.setTitleCache(sourceReferenceTitle, true);
214
		return result;
215
	}
216

    
217
	private FeatureTree makeFeatureNodes(ITermService service){
218
//		CyprusTransformer transformer = new CyprusTransformer();
219

    
220
		FeatureTree result = FeatureTree.NewInstance(featureTreeUuid);
221
		result.setTitleCache("Cuba Feature Tree", true);
222
		FeatureNode root = result.getRoot();
223
		FeatureNode newNode;
224

    
225
//		newNode = FeatureNode.NewInstance(Feature.STATUS());
226
//		root.addChild(newNode);
227

    
228
		newNode = FeatureNode.NewInstance(Feature.DISTRIBUTION());
229
		root.addChild(newNode);
230

    
231
		Feature featurAltFam = (Feature)service.find(CubaTransformer.uuidAlternativeFamily);
232
		newNode = FeatureNode.NewInstance(featurAltFam);
233
		root.addChild(newNode);
234

    
235
	    Feature featurAltFam2 = (Feature)service.find(CubaTransformer.uuidAlternativeFamily2);
236
	    newNode = FeatureNode.NewInstance(featurAltFam2);
237
	    root.addChild(newNode);
238

    
239
//		newNode = FeatureNode.NewInstance(Feature.SYSTEMATICS());
240
//		root.addChild(newNode);
241

    
242
		//user defined features
243
//		String [] featureList = new String[]{"Red Book", "Endemism"};
244
//		addFeataureNodesByStringList(featureList, root, transformer, service);
245

    
246
		return result;
247
	}
248

    
249

    
250
	//Monocots
251
	public static URI monocots() {
252
	    return URI.create("file:////BGBM-PESIHPC/Cuba/Monocot.xlsx");
253
	}
254
	//Cyperaceae
255
	public static URI cyperaceae() {
256
	    return URI.create("file:////BGBM-PESIHPC/Cuba/Cyper_Poaceae.xlsx");
257
	}
258
    //Fabaceae
259
    public static URI fabaceae() {
260
        return URI.create("file:////BGBM-PESIHPC/Cuba/Fabaceae.xlsx");
261
    }
262
    //Urticaceae
263
    public static URI urticaceae() {
264
        return URI.create("file:////BGBM-PESIHPC/Cuba/Urticaceae.xlsx");
265
    }
266
    //Asteraceae
267
    public static URI asteraceae() {
268
        return URI.create("file:////BGBM-PESIHPC/Cuba/Asteraceae.xlsx");
269
    }
270
    //Convolvulaceae
271
    public static URI convolvulaceae() {
272
        return URI.create("file:////BGBM-PESIHPC/Cuba/Convolvulaceae.xlsx");
273
    }
274
    //dicot A-C
275
    public static URI dicotA_C() {
276
        return URI.create("file:////BGBM-PESIHPC/Cuba/dicotA_C.xlsx");
277
    }
278
    //dicot D-M
279
    public static URI dicotD_M() {
280
        return URI.create("file:////BGBM-PESIHPC/Cuba/dicotD_M.xlsx");
281
    }
282
    //dicot N-Z
283
    public static URI dicotN_Z() {
284
        return URI.create("file:////BGBM-PESIHPC/Cuba/dicotN_Z.xlsx");
285
    }
286
    //Euphorbiaceae
287
    public static URI euphorbiaceae() {
288
        return URI.create("file:////BGBM-PESIHPC/Cuba/Euphorbiaceae.xlsx");
289
    }
290
    //Gymnospermae
291
    public static URI gymnospermae() {
292
        return URI.create("file:////BGBM-PESIHPC/Cuba/gymnospermae.xlsx");
293
    }
294
    //Lam.Verbenaceae
295
    public static URI lamVerbenaceae() {
296
        return URI.create("file:////BGBM-PESIHPC/Cuba/Lam_Verbenaceae.xlsx");
297
    }
298
    //Malpighiaceae
299
    public static URI malpighiaceae() {
300
        return URI.create("file:////BGBM-PESIHPC/Cuba/Malpighiaceae.xlsx");
301
    }
302
    //Melastomataceae
303
    public static URI melastomataceae() {
304
        return URI.create("file:////BGBM-PESIHPC/Cuba/Melastomataceae.xlsx");
305
    }
306
    //Myrtaceae
307
    public static URI myrtaceae() {
308
        return URI.create("file:////BGBM-PESIHPC/Cuba/Myrtaceae.xlsx");
309
    }
310
    //Orchidaceae
311
    public static URI orchidaceae() {
312
        return URI.create("file:////BGBM-PESIHPC/Cuba/Orchidaceae.xlsx");
313
    }
314
    //Rubiaceae
315
    public static URI rubiaceae() {
316
        return URI.create("file:////BGBM-PESIHPC/Cuba/Rubiaceae.xlsx");
317
    }
318

    
319
	/**
320
	 * @param args
321
	 */
322
	public static void main(String[] args) {
323
	    CubaActivator me = new CubaActivator();
324
		me.doImport(cdmDestination);
325
	}
326

    
327
}
    (1-1/1)