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
.cyprus
;
13 import java
.net
.URISyntaxException
;
14 import java
.util
.UUID
;
16 import org
.apache
.log4j
.Logger
;
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
.common
.mapping
.IInputTransformer
;
26 import eu
.etaxonomy
.cdm
.io
.common
.mapping
.UndefinedTransformerMethodException
;
27 import eu
.etaxonomy
.cdm
.io
.cyprus
.CyprusImportConfigurator
;
28 import eu
.etaxonomy
.cdm
.io
.cyprus
.CyprusTransformer
;
29 import eu
.etaxonomy
.cdm
.model
.agent
.Person
;
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
.reference
.Reference
;
34 import eu
.etaxonomy
.cdm
.model
.reference
.ReferenceFactory
;
40 public class CyprusActivator
{
41 private static final Logger logger
= Logger
.getLogger(CyprusActivator
.class);
43 //database validation status (create, update, validate ...)
44 static DbSchemaValidation hbm2dll
= DbSchemaValidation
.CREATE
;
45 // static final URI source = cyprus_distribution();
46 static final URI source
= cyprus_local();
49 static final ICdmDataSource cdmDestination
= CdmDestinations
.localH2();
50 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_local_postgres_CdmTest();
51 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql();
52 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_dev();
53 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_production();
57 public static final UUID featureTreeUuid
= UUID
.fromString("14d1e912-5ec2-4d10-878b-828788b70a87");
60 static final UUID classificationUuid
= UUID
.fromString("0c2b5d25-7b15-4401-8b51-dd4be0ee5cab");
63 static final CHECK check
= CHECK
.IMPORT_WITHOUT_CHECK
;
66 static final boolean doTaxa
= true;
67 static final boolean doDeduplicate
= false;
68 static final boolean doDistribution
= false;
71 private void doImport(ICdmDataSource cdmDestination
){
74 CyprusImportConfigurator config
= CyprusImportConfigurator
.NewInstance(source
, cdmDestination
);
75 config
.setClassificationUuid(classificationUuid
);
76 config
.setCheck(check
);
77 config
.setDoDistribution(doDistribution
);
78 config
.setDoTaxa(doTaxa
);
79 config
.setDbSchemaValidation(hbm2dll
);
81 CdmDefaultImport myImport
= new CdmDefaultImport();
86 System
.out
.println("Start import from ("+ source
.toString() + ") ...");
87 config
.setSourceReference(getSourceReference(config
.getSourceReferenceTitle()));
88 myImport
.invoke(config
);
90 FeatureTree tree
= makeFeatureNodes(myImport
.getCdmAppController().getTermService());
91 myImport
.getCdmAppController().getFeatureTreeService().saveOrUpdate(tree
);
94 System
.out
.println("End import from ("+ source
.toString() + ")...");
101 ICdmApplicationConfiguration app
= myImport
.getCdmAppController();
102 int count
= app
.getAgentService().deduplicate(Person
.class, null, null);
103 logger
.warn("Deduplicated " + count
+ " persons.");
104 // count = app.getAgentService().deduplicate(Team.class, null, null);
105 // logger.warn("Deduplicated " + count + " teams.");
106 count
= app
.getReferenceService().deduplicate(Reference
.class, null, null);
107 logger
.warn("Deduplicated " + count
+ " references.");
112 private Reference
getSourceReference(String string
) {
113 Reference result
= ReferenceFactory
.newGeneric();
114 result
.setTitleCache(string
, true);
118 private FeatureTree
makeFeatureNodes(ITermService service
){
119 CyprusTransformer transformer
= new CyprusTransformer();
121 FeatureTree result
= FeatureTree
.NewInstance(featureTreeUuid
);
122 result
.setTitleCache("Cyprus Feature Tree", true);
123 FeatureNode root
= result
.getRoot();
126 newNode
= FeatureNode
.NewInstance(Feature
.STATUS());
127 root
.addChild(newNode
);
129 newNode
= FeatureNode
.NewInstance(Feature
.DISTRIBUTION());
130 root
.addChild(newNode
);
132 newNode
= FeatureNode
.NewInstance(Feature
.SYSTEMATICS());
133 root
.addChild(newNode
);
135 //user defined features
136 String
[] featureList
= new String
[]{"Red Book", "Endemism"};
137 addFeataureNodesByStringList(featureList
, root
, transformer
, service
);
144 public static URI
cyprus_local() {
147 sourceUrl
= new URI("file:/C:/localCopy/Data/zypern/Zypern.xls");
149 } catch (URISyntaxException e
) {
155 public static URI
cyprus_distribution() {
158 sourceUrl
= new URI("file:/C:/localCopy/Data/zypern/Zypern_distribution_RH_corr.xls");
160 } catch (URISyntaxException e
) {
166 public void addFeataureNodesByStringList(String
[] featureStringList
, FeatureNode root
, IInputTransformer transformer
, ITermService termService
){
168 for (String featureString
: featureStringList
){
170 featureUuid
= transformer
.getFeatureUuid(featureString
);
171 Feature feature
= (Feature
)termService
.find(featureUuid
);
172 if (feature
!= null){
173 FeatureNode child
= FeatureNode
.NewInstance(feature
);
174 root
.addChild(child
);
177 } catch (UndefinedTransformerMethodException e
) {
178 logger
.error("getFeatureUuid is not implemented in transformer. Features could not be added");
186 public static void main(String
[] args
) {
187 CyprusActivator me
= new CyprusActivator();
188 me
.doImport(cdmDestination
);