Project

General

Profile

Download (5.03 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.pesi.erms;
11

    
12
import java.util.UUID;
13

    
14
import org.apache.log4j.Logger;
15

    
16
import eu.etaxonomy.cdm.api.application.CdmApplicationController;
17
import eu.etaxonomy.cdm.app.common.CdmDestinations;
18
import eu.etaxonomy.cdm.app.pesi.FaunaEuropaeaSources;
19
import eu.etaxonomy.cdm.database.DbSchemaValidation;
20
import eu.etaxonomy.cdm.database.ICdmDataSource;
21
import eu.etaxonomy.cdm.io.common.CdmDefaultImport;
22
import eu.etaxonomy.cdm.io.common.Source;
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.pesi.erms.ErmsImportConfigurator;
26
import eu.etaxonomy.cdm.model.common.ISourceable;
27
import eu.etaxonomy.cdm.model.name.NomenclaturalCode;
28
import eu.etaxonomy.cdm.model.name.ZoologicalName;
29

    
30

    
31
/**
32
 * TODO add the following to a wiki page:
33
 * HINT: If you are about to import into a mysql data base running under windows and if you wish to dump and restore the resulting data base under another operation systen 
34
 * you must set the mysql system variable lower_case_table_names = 0 in order to create data base with table compatible names.
35
 * 
36
 * 
37
 * @author a.mueller
38
 *
39
 */
40
public class ErmsActivator {
41
	private static final Logger logger = Logger.getLogger(ErmsActivator.class);
42

    
43
	//database validation status (create, update, validate ...)
44
	static DbSchemaValidation hbm2dll = DbSchemaValidation.CREATE;
45
	static final Source ermsSource = FaunaEuropaeaSources.PESI_ERMS();
46
	static final ICdmDataSource cdmDestination = CdmDestinations.localH2Erms();
47
	static final UUID treeUuid = UUID.fromString("8bd27d84-fd4f-4bfa-bde0-3e6b7311b334");
48
	static final UUID featureTreeUuid = UUID.fromString("33cbf7a8-0c47-4d47-bd11-b7d77a38d0f6");
49
	//static final Object[] featureKeyList = new Integer[]{1,4,5,10,11,12,13,14, 249, 250, 251, 252, 253}; 
50
	
51
	//check - import
52
	static final CHECK check = CHECK.CHECK_AND_IMPORT;
53

    
54
	static final int partitionSize = 2000;
55

    
56

    
57
	//NomeclaturalCode
58
	static final NomenclaturalCode nomenclaturalCode = NomenclaturalCode.ICZN;
59

    
60
	//ignore null
61
	static final boolean ignoreNull = true;
62
	
63
// ***************** ALL ************************************************//
64
	
65
	//references
66
	static final DO_REFERENCES doReferences =  DO_REFERENCES.ALL;
67
	
68
	//taxa
69
	static final boolean doTaxa = true;
70
	static final boolean doRelTaxa = true;
71
	static final boolean doLinks = true;
72
	static final boolean doOccurences = true;
73
	static final boolean doImages = true;
74
	
75
	
76
//******************** NONE ***************************************//
77
	
78

    
79
//	//references
80
//	static final DO_REFERENCES doReferences =  DO_REFERENCES.NONE;
81
//	
82
//	//taxa
83
//	static final boolean doTaxa = false;
84
//	static final boolean doRelTaxa = false;
85
//	static final boolean doLinks = false;
86
//	static final boolean doOccurences = false;
87
//	
88
	
89
	
90
	/**
91
	 * @param args
92
	 */
93
	public static void main(String[] args) {
94
		System.out.println("Start import from ("+ ermsSource.getDatabase() + ") ...");
95
		
96
		//make ERMS Source
97
		Source source = ermsSource;
98
		ICdmDataSource destination = CdmDestinations.chooseDestination(args) != null ? CdmDestinations.chooseDestination(args) : cdmDestination;
99
		
100
		ErmsImportConfigurator ermsImportConfigurator = ErmsImportConfigurator.NewInstance(source,  destination);
101
		
102
		ermsImportConfigurator.setClassificationUuid(treeUuid);
103
		ermsImportConfigurator.setNomenclaturalCode(nomenclaturalCode);
104

    
105
		ermsImportConfigurator.setIgnoreNull(ignoreNull);
106
		ermsImportConfigurator.setDoReferences(doReferences);
107
		
108
		ermsImportConfigurator.setDoTaxa(doTaxa);
109
		ermsImportConfigurator.setDoRelTaxa(doRelTaxa);
110
		ermsImportConfigurator.setDoLinks(doLinks);
111
		ermsImportConfigurator.setDoOccurrence(doOccurences);
112
		ermsImportConfigurator.setDbSchemaValidation(hbm2dll);
113

    
114
		ermsImportConfigurator.setCheck(check);
115
		ermsImportConfigurator.setRecordsPerTransaction(partitionSize);
116

    
117
		// invoke import
118
		CdmDefaultImport<ErmsImportConfigurator> ermsImport = new CdmDefaultImport<ErmsImportConfigurator>();
119
		ermsImport.invoke(ermsImportConfigurator);
120
		
121
		if (ermsImportConfigurator.getCheck().equals(CHECK.CHECK_AND_IMPORT)  || ermsImportConfigurator.getCheck().equals(CHECK.IMPORT_WITHOUT_CHECK)    ){
122
			CdmApplicationController app = ermsImport.getCdmAppController();
123
			ISourceable obj = app.getCommonService().getSourcedObjectByIdInSource(ZoologicalName.class, "1000027", null);
124
			logger.info(obj);
125
			
126
//			//make feature tree
127
//			FeatureTree tree = TreeCreator.flatTree(featureTreeUuid, ermsImportConfigurator.getFeatureMap(), featureKeyList);
128
//			app = ermsImport.getCdmAppController();
129
//			app.getFeatureTreeService().saveOrUpdate(tree);
130
		}
131
		System.out.println("End import from ("+ source.getDatabase() + ")...");
132
	}
133

    
134
}
    (1-1/1)