Project

General

Profile

Download (6.64 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.vibrant;
11

    
12
import java.util.UUID;
13

    
14
import org.apache.log4j.Logger;
15

    
16
import eu.etaxonomy.cdm.app.common.BerlinModelSources;
17
import eu.etaxonomy.cdm.app.common.CdmDestinations;
18
import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
19
import eu.etaxonomy.cdm.database.DbSchemaValidation;
20
import eu.etaxonomy.cdm.database.ICdmDataSource;
21
import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportConfigurator;
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.IImportConfigurator.EDITOR;
26
import eu.etaxonomy.cdm.io.common.Source;
27
import eu.etaxonomy.cdm.io.pesi.out.PesiTransformer;
28
import eu.etaxonomy.cdm.model.name.NomenclaturalCode;
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 bas 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 IopiActivator {
41
	@SuppressWarnings("unused")
42
	private static final Logger logger = Logger.getLogger(IopiActivator.class);
43

    
44
	//database validation status (create, update, validate ...)
45
	static DbSchemaValidation hbm2dll = DbSchemaValidation.CREATE;
46
	static final Source berlinModelSource = BerlinModelSources.iopi();
47
	
48
//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql();
49
	static final ICdmDataSource cdmDestination = cdm_test_local_iopi();
50
	
51
	static final boolean useSingleClassification = false;
52
	static final Integer sourceSecId = null; //7000000; 
53
	static final UUID classificationUuid = null; //UUID.fromString("aa3fbaeb-f5dc-4e75-8d60-c8f93beb7ba6");
54
	
55
	static final UUID sourceRefUuid = UUID.fromString("df68c748-3c64-4b96-9a47-db51fb9d387e");
56
	
57
	// set to zero for unlimited nameFacts
58
	static final int maximumNumberOfNameFacts = 0;
59
	
60
	static final int partitionSize = 1500;
61
	
62
	//check - import
63
	static final CHECK check = CHECK.CHECK_AND_IMPORT;
64

    
65
	//editor - import
66
	static final EDITOR editor = EDITOR.EDITOR_AS_EDITOR;
67
	
68
	//NomeclaturalCode
69
	static final NomenclaturalCode nomenclaturalCode = NomenclaturalCode.ICBN;
70

    
71
	//ignore null
72
	static final boolean ignoreNull = true;
73
	
74
	static boolean useClassification = true;
75
	
76
	
77
// **************** ALL *********************	
78

    
79
	//authors
80
	static final boolean doAuthors = true;
81
	//references
82
	static final DO_REFERENCES doReferences =  DO_REFERENCES.ALL;
83
	//names
84
	static final boolean doTaxonNames = true;
85
	static final boolean doRelNames = true;
86
	static final boolean doNameStatus = true;
87
	
88
	//taxa
89
	static final boolean doTaxa = true;
90
	static final boolean doRelTaxa = true;
91
	static final boolean doFacts = true;
92

    
93
	//etc.
94

    
95
	
96
// **************** SELECTED *********************
97

    
98
//	static final boolean doUser = true;
99
//	//authors
100
//	static final boolean doAuthors = false;
101
//	//references
102
//	static final DO_REFERENCES doReferences =  DO_REFERENCES.NONE;
103
//	//names
104
//	static final boolean doTaxonNames = false;
105
//	static final boolean doRelNames = false;
106
//	static final boolean doNameStatus = false;
107
//	static final boolean doTypes = false;
108
//	static final boolean doNameFacts = false;
109
//	
110
//	//taxa 
111
//	static final boolean doTaxa = false;
112
//	static final boolean doRelTaxa = false;
113
//	static final boolean doFacts = false;
114
//	
115
//	//etc.
116
//	static final boolean doMarker = false;
117

    
118
	
119
//******** ALWAYS IGNORE *****************************
120
	
121
	static final boolean doUser = false;
122
	static final boolean doOccurences = false;
123
	static final boolean doCommonNames = false;
124
	static final boolean doTypes = false;  
125
	static final boolean doNameFacts = false;
126
	static final boolean doMarker = false;
127

    
128
	
129
	public void importIopi (Source source, ICdmDataSource destination, DbSchemaValidation hbm2dll){
130
		System.out.println("Start import from BerlinModel("+ berlinModelSource.getDatabase() + ") to " + cdmDestination.getDatabase() + " ...");
131
		//make BerlinModel Source
132
				
133
		BerlinModelImportConfigurator config = BerlinModelImportConfigurator.NewInstance(source,  destination);
134
		
135
		config.setClassificationUuid(classificationUuid);
136
		config.setSourceSecId(sourceSecId);
137
		
138
		config.setNomenclaturalCode(nomenclaturalCode);
139

    
140
		config.setIgnoreNull(ignoreNull);
141
		config.setDoAuthors(doAuthors);
142
		config.setDoReferences(doReferences);
143
		config.setDoTaxonNames(doTaxonNames);
144
		config.setDoRelNames(doRelNames);
145
		config.setDoNameStatus(doNameStatus);
146
		config.setDoTypes(doTypes);
147
		config.setDoNameFacts(doNameFacts);
148
		config.setUseClassification(useClassification);
149
		config.setSourceRefUuid(sourceRefUuid);
150
		
151
		config.setDoTaxa(doTaxa);
152
		config.setDoRelTaxa(doRelTaxa);
153
		config.setDoFacts(doFacts);
154
		config.setDoOccurrence(doOccurences);
155
		config.setDoCommonNames(doCommonNames);
156
		
157
		config.setDoMarker(doMarker);
158
		config.setDoUser(doUser);
159
		config.setEditor(editor);
160
		config.setDbSchemaValidation(hbm2dll);
161
		
162
		// maximum number of name facts to import
163
		config.setMaximumNumberOfNameFacts(maximumNumberOfNameFacts);
164

    
165
		config.setUseSingleClassification(useSingleClassification);
166
		
167
		config.setCheck(check);
168
		config.setEditor(editor);
169
		config.setRecordsPerTransaction(partitionSize);
170

    
171
		
172
		// invoke import
173
		CdmDefaultImport<BerlinModelImportConfigurator> bmImport = new CdmDefaultImport<BerlinModelImportConfigurator>();
174
		bmImport.invoke(config);
175
		
176
		System.out.println("End import from BerlinModel ("+ source.getDatabase() + ")...");
177
		
178
	}
179
	
180
	/**
181
	 * @param args
182
	 */
183
	public static void main(String[] args) {
184
		IopiActivator importActivator = new IopiActivator();
185
		Source source = berlinModelSource;
186
		ICdmDataSource cdmRepository = CdmDestinations.chooseDestination(args) != null ? CdmDestinations.chooseDestination(args) : cdmDestination;
187
		
188
		importActivator.importIopi(source, cdmRepository, hbm2dll);
189

    
190
	}
191
	
192
	public static ICdmDataSource cdm_test_local_iopi(){
193
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
194
		String cdmServer = "127.0.0.1";
195
		String cdmDB = "iopi"; 
196
		String cdmUserName = "root";
197
		return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
198
	}
199
	
200

    
201
}
(2-2/4)