2 * Copyright (C) 2007 EDIT
3 * European Distributed Institute of Taxonomy
4 * http://www.e-taxonomy.eu
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.
10 package eu
.etaxonomy
.cdm
.app
.wp6
.cichorieae
;
13 import java
.util
.UUID
;
15 import org
.apache
.log4j
.Logger
;
17 import eu
.etaxonomy
.cdm
.api
.application
.CdmApplicationController
;
18 import eu
.etaxonomy
.cdm
.app
.berlinModelImport
.BerlinModelSources
;
19 import eu
.etaxonomy
.cdm
.app
.berlinModelImport
.TreeCreator
;
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
.berlinModel
.in
.BerlinModelImportConfigurator
;
24 import eu
.etaxonomy
.cdm
.io
.common
.CdmDefaultImport
;
25 import eu
.etaxonomy
.cdm
.io
.common
.Source
;
26 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.CHECK
;
27 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.DO_REFERENCES
;
28 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.EDITOR
;
29 import eu
.etaxonomy
.cdm
.model
.common
.ISourceable
;
30 import eu
.etaxonomy
.cdm
.model
.description
.Feature
;
31 import eu
.etaxonomy
.cdm
.model
.description
.FeatureNode
;
32 import eu
.etaxonomy
.cdm
.model
.description
.FeatureTree
;
33 import eu
.etaxonomy
.cdm
.model
.name
.NomenclaturalCode
;
34 import eu
.etaxonomy
.cdm
.model
.name
.ZoologicalName
;
38 * TODO add the following to a wiki page:
39 * 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
40 * you must set the mysql system variable lower_case_table_names = 0 in order to create data base with table compatible names.
46 public class CichorieaeActivator
{
47 private static final Logger logger
= Logger
.getLogger(CichorieaeActivator
.class);
49 //database validation status (create, update, validate ...)
50 static DbSchemaValidation hbm2dll
= DbSchemaValidation
.CREATE
;
51 static final Source berlinModelSource
= BerlinModelSources
.EDIT_CICHORIEAE();
52 static final ICdmDataSource cdmDestination
= CdmDestinations
.localH2Cichorieae();
54 static final UUID secUuid
= UUID
.fromString("6924c75d-e0d0-4a6d-afb7-3dd8c71195ca");
55 static final int sourceSecId
= 7800000;
57 static final UUID featureTreeUuid
= UUID
.fromString("ae9615b8-bc60-4ed0-ad96-897f9226d568");
58 static final Object
[] featureKeyList
= new Integer
[]{1, 31, 4, 98, 41};
60 static final String mediaUrlString
= "http://wp5.e-taxonomy.eu/dataportal/cichorieae/media/protolog/";
62 //static final File mediaPath = new File("/Volumes/protolog/protolog/");
64 static final File mediaPath
= new File("\\\\media\\editwp6\\protolog");
65 // set to zero for unlimited nameFacts
66 static final int maximumNumberOfNameFacts
= 0;
70 static final CHECK check
= CHECK
.CHECK_AND_IMPORT
;
73 static final EDITOR editor
= EDITOR
.EDITOR_AS_EDITOR
;
76 static final NomenclaturalCode nomenclaturalCode
= NomenclaturalCode
.ICBN
;
79 static final boolean ignoreNull
= true;
82 // **************** ALL *********************
84 static final boolean doAuthors
= true;
86 static final DO_REFERENCES doReferences
= DO_REFERENCES
.ALL
;
88 static final boolean doTaxonNames
= true;
89 static final boolean doRelNames
= true;
90 static final boolean doNameStatus
= true;
91 static final boolean doTypes
= true;
92 static final boolean doNameFacts
= false;
95 static final boolean doTaxa
= true;
96 static final boolean doRelTaxa
= true;
97 static final boolean doFacts
= true;
98 static final boolean doOccurences
= true;
101 static final boolean doMarker
= true;
102 static final boolean doUser
= true;
105 // **************** SELECTED *********************
108 // static final boolean doAuthors = false;
110 // static final DO_REFERENCES doReferences = DO_REFERENCES.NONE;
112 // static final boolean doTaxonNames = false;
113 // static final boolean doRelNames = false;
114 // static final boolean doNameStatus = false;
115 // static final boolean doTypes = false;
116 // static final boolean doNameFacts = false;
119 // static final boolean doTaxa = true;
120 // static final boolean doRelTaxa = false;
121 // static final boolean doFacts = false;
122 // static final boolean doOccurences = false;
125 // static final boolean doMarker = true;
126 // static final boolean doUser = true;
132 public static void main(String
[] args
) {
133 System
.out
.println("Start import from BerlinModel("+ berlinModelSource
.getDatabase() + ") to " + cdmDestination
.getDatabase() + " ...");
135 //make BerlinModel Source
136 Source source
= berlinModelSource
;
137 ICdmDataSource destination
= cdmDestination
;
139 BerlinModelImportConfigurator bmImportConfigurator
= BerlinModelImportConfigurator
.NewInstance(source
, destination
);
141 bmImportConfigurator
.setSecUuid(secUuid
);
142 bmImportConfigurator
.setSourceSecId(sourceSecId
);
144 bmImportConfigurator
.setNomenclaturalCode(nomenclaturalCode
);
146 bmImportConfigurator
.setIgnoreNull(ignoreNull
);
147 bmImportConfigurator
.setDoAuthors(doAuthors
);
148 bmImportConfigurator
.setDoReferences(doReferences
);
149 bmImportConfigurator
.setDoTaxonNames(doTaxonNames
);
150 bmImportConfigurator
.setDoRelNames(doRelNames
);
151 bmImportConfigurator
.setDoNameStatus(doNameStatus
);
152 bmImportConfigurator
.setDoTypes(doTypes
);
153 bmImportConfigurator
.setDoNameFacts(doNameFacts
);
155 bmImportConfigurator
.setDoTaxa(doTaxa
);
156 bmImportConfigurator
.setDoRelTaxa(doRelTaxa
);
157 bmImportConfigurator
.setDoFacts(doFacts
);
158 bmImportConfigurator
.setDoOccurrence(doOccurences
);
160 bmImportConfigurator
.setDoMarker(doMarker
);
161 bmImportConfigurator
.setDoUser(doUser
);
162 bmImportConfigurator
.setDbSchemaValidation(hbm2dll
);
164 // mediaResourceLocations
165 if ( mediaPath
.exists() && mediaPath
.isDirectory()){
166 bmImportConfigurator
.setMediaUrl(mediaUrlString
);
167 bmImportConfigurator
.setMediaPath(mediaPath
);
169 logger
.warn("Could not configure mediaResourceLocations");
172 // maximum number of name facts to import
173 bmImportConfigurator
.setMaximumNumberOfNameFacts(maximumNumberOfNameFacts
);
176 bmImportConfigurator
.setCheck(check
);
177 bmImportConfigurator
.setEditor(editor
);
180 CdmDefaultImport
<BerlinModelImportConfigurator
> bmImport
= new CdmDefaultImport
<BerlinModelImportConfigurator
>();
181 bmImport
.invoke(bmImportConfigurator
);
183 if (doFacts
&& bmImportConfigurator
.getCheck().equals(CHECK
.CHECK_AND_IMPORT
) || bmImportConfigurator
.getCheck().equals(CHECK
.IMPORT_WITHOUT_CHECK
) ){
184 CdmApplicationController app
= bmImport
.getCdmAppController();
185 ISourceable obj
= app
.getCommonService().getSourcedObjectByIdInSource(ZoologicalName
.class, "1000027", null);
189 FeatureTree tree
= TreeCreator
.flatTree(featureTreeUuid
, bmImportConfigurator
.getFeatureMap(), featureKeyList
);
190 FeatureNode imageNode
= FeatureNode
.NewInstance(Feature
.IMAGE());
191 tree
.getRoot().addChild(imageNode
);
192 FeatureNode distributionNode
= FeatureNode
.NewInstance(Feature
.DISTRIBUTION());
193 tree
.getRoot().addChild(distributionNode
, 2);
194 app
.getDescriptionService().saveFeatureTree(tree
);
197 System
.out
.println("End import from BerlinModel ("+ source
.getDatabase() + ")...");