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
.CdmApplicationController
;
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
.agent
.Team
;
31 import eu
.etaxonomy
.cdm
.model
.description
.Feature
;
32 import eu
.etaxonomy
.cdm
.model
.description
.FeatureNode
;
33 import eu
.etaxonomy
.cdm
.model
.description
.FeatureTree
;
34 import eu
.etaxonomy
.cdm
.model
.reference
.Reference
;
35 import eu
.etaxonomy
.cdm
.model
.reference
.ReferenceFactory
;
42 public class CyprusActivator
{
43 private static final Logger logger
= Logger
.getLogger(CyprusActivator
.class);
45 //database validation status (create, update, validate ...)
46 static DbSchemaValidation hbm2dll
= DbSchemaValidation
.CREATE
;
47 static final URI source
= cyprus_local();
50 // static final ICdmDataSource cdmDestination = CdmDestinations.localH2();
51 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_local_postgres_CdmTest();
52 static final ICdmDataSource cdmDestination
= CdmDestinations
.cdm_test_local_mysql();
53 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_dev();
54 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_dev_tunnel();
58 public static final UUID featureTreeUuid
= UUID
.fromString("14d1e912-5ec2-4d10-878b-828788b70a87");
61 static final UUID classificationUuid
= UUID
.fromString("0c2b5d25-7b15-4401-8b51-dd4be0ee5cab");
64 static final CHECK check
= CHECK
.IMPORT_WITHOUT_CHECK
;
67 static final boolean doTaxa
= true;
68 static final boolean doDeduplicate
= true;
71 private void doImport(ICdmDataSource cdmDestination
){
74 CyprusImportConfigurator config
= CyprusImportConfigurator
.NewInstance(source
, cdmDestination
);
75 config
.setClassificationUuid(classificationUuid
);
76 config
.setDoTaxa(doTaxa
);
77 config
.setCheck(check
);
78 // config.setDefaultLanguageUuid(defaultLanguageUuid);
79 // config.setDoPrintKeys(doPrintKeys);
80 config
.setDbSchemaValidation(hbm2dll
);
82 CdmDefaultImport myImport
= new CdmDefaultImport();
87 System
.out
.println("Start import from ("+ source
.toString() + ") ...");
88 config
.setSourceReference(getSourceReference(config
.getSourceReferenceTitle()));
89 myImport
.invoke(config
);
90 System
.out
.println("End import from ("+ source
.toString() + ")...");
93 FeatureTree tree
= makeFeatureNodes(myImport
.getCdmAppController().getTermService());
94 myImport
.getCdmAppController().getFeatureTreeService().saveOrUpdate(tree
);
99 CdmApplicationController app
= myImport
.getCdmAppController();
100 int count
= app
.getAgentService().deduplicate(Person
.class, null, null);
101 logger
.warn("Deduplicated " + count
+ " persons.");
102 count
= app
.getAgentService().deduplicate(Team
.class, null, null);
103 logger
.warn("Deduplicated " + count
+ " teams.");
104 count
= app
.getReferenceService().deduplicate(Reference
.class, null, null);
105 logger
.warn("Deduplicated " + count
+ " references.");
110 private Reference
getSourceReference(String string
) {
111 Reference result
= ReferenceFactory
.newGeneric();
112 result
.setTitleCache(string
);
116 private FeatureTree
makeFeatureNodes(ITermService service
){
117 CyprusTransformer transformer
= new CyprusTransformer();
119 FeatureTree result
= FeatureTree
.NewInstance(featureTreeUuid
);
120 result
.setTitleCache("Cyprus Feature Tree");
121 FeatureNode root
= result
.getRoot();
124 newNode
= FeatureNode
.NewInstance(Feature
.DISTRIBUTION());
125 root
.addChild(newNode
);
127 newNode
= FeatureNode
.NewInstance(Feature
.SYSTEMATICS());
128 root
.addChild(newNode
);
130 newNode
= FeatureNode
.NewInstance(Feature
.STATUS());
131 root
.addChild(newNode
);
133 //red data book category
134 String
[] featureList
= new String
[]{"Red Book"};
135 addFeataureNodesByStringList(featureList
, root
, transformer
, service
);
142 public static URI
cyprus_local() {
145 sourceUrl
= new URI("file:/C:/localCopy/Data/zypern/Zypern.xls");
147 } catch (URISyntaxException e
) {
153 public void addFeataureNodesByStringList(String
[] featureStringList
, FeatureNode root
, IInputTransformer transformer
, ITermService termService
){
155 for (String featureString
: featureStringList
){
157 featureUuid
= transformer
.getFeatureUuid(featureString
);
158 Feature feature
= (Feature
)termService
.find(featureUuid
);
159 if (feature
!= null){
160 FeatureNode child
= FeatureNode
.NewInstance(feature
);
161 root
.addChild(child
);
164 } catch (UndefinedTransformerMethodException e
) {
165 logger
.error("getFeatureUuid is not implemented in transformer. Features could not be added");
173 public static void main(String
[] args
) {
174 CyprusActivator me
= new CyprusActivator();
175 me
.doImport(cdmDestination
);