app-import/src/main/java/eu/etaxonomy/cdm/app/cyprus/CyprusActivator.java

   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.cyprus;
  11
  12 import java.net.URI;
  13 import java.net.URISyntaxException;
  14 import java.util.UUID;
  15
  16 import org.apache.log4j.Logger;
  17
  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;
  36
  37 /**
  38  * @author a.mueller
  39  * @created 16.12.2010
  40  * @version 1.0
  41  */
  42 public class CyprusActivator {
  43         private static final Logger logger = Logger.getLogger(CyprusActivator.class);
  44
  45         //database validation status (create, update, validate ...)
  46         static DbSchemaValidation hbm2dll = DbSchemaValidation.CREATE;
  47         static final URI source = cyprus_local();
  48
  49
  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();
  55
  56
  57         //feature tree uuid
  58         public static final UUID featureTreeUuid = UUID.fromString("14d1e912-5ec2-4d10-878b-828788b70a87");
  59
  60         //classification
  61         static final UUID classificationUuid = UUID.fromString("0c2b5d25-7b15-4401-8b51-dd4be0ee5cab");
  62
  63         //check - import
  64         static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
  65
  66         //taxa
  67         static final boolean doTaxa = true;
  68         static final boolean doDeduplicate = true;
  69
  70
  71         private void doImport(ICdmDataSource cdmDestination){
  72
  73                 //make Source
  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);
  81
  82                 CdmDefaultImport myImport = new CdmDefaultImport();
  83
  84
  85                 //...
  86                 if (true){
  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() + ")...");
  91                 }
  92
  93                 FeatureTree tree = makeFeatureNodes(myImport.getCdmAppController().getTermService());
  94                 myImport.getCdmAppController().getFeatureTreeService().saveOrUpdate(tree);
  95
  96
  97                 //deduplicate
  98                 if (doDeduplicate){
  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.");
 106                 }
 107
 108         }
 109
 110         private Reference getSourceReference(String string) {
 111                 Reference result = ReferenceFactory.newGeneric();
 112                 result.setTitleCache(string);
 113                 return result;
 114         }
 115
 116         private FeatureTree makeFeatureNodes(ITermService service){
 117                 CyprusTransformer transformer = new CyprusTransformer();
 118
 119                 FeatureTree result = FeatureTree.NewInstance(featureTreeUuid);
 120                 result.setTitleCache("Cyprus Feature Tree");
 121                 FeatureNode root = result.getRoot();
 122                 FeatureNode newNode;
 123
 124                 newNode = FeatureNode.NewInstance(Feature.DISTRIBUTION());
 125                 root.addChild(newNode);
 126
 127                 newNode = FeatureNode.NewInstance(Feature.SYSTEMATICS());
 128                 root.addChild(newNode);
 129
 130                 newNode = FeatureNode.NewInstance(Feature.STATUS());
 131                 root.addChild(newNode);
 132
 133                 //red data book category
 134                 String [] featureList = new String[]{"Red Book"};
 135                 addFeataureNodesByStringList(featureList, root, transformer, service);
 136
 137                 return result;
 138         }
 139
 140
 141         //Cyprus
 142         public static URI cyprus_local() {
 143                 URI sourceUrl;
 144                 try {
 145                         sourceUrl = new URI("file:/C:/localCopy/Data/zypern/Zypern.xls");
 146                         return sourceUrl;
 147                 } catch (URISyntaxException e) {
 148                         e.printStackTrace();
 149                         return null;
 150                 }
 151         }
 152
 153         public void addFeataureNodesByStringList(String[] featureStringList, FeatureNode root, IInputTransformer transformer, ITermService termService){
 154                 try {
 155                         for (String featureString : featureStringList){
 156                         UUID featureUuid;
 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);
 162                         }
 163                 }
 164                 } catch (UndefinedTransformerMethodException e) {
 165                         logger.error("getFeatureUuid is not implemented in transformer. Features could not be added");
 166                 }
 167         }
 168
 169
 170         /**
 171          * @param args
 172          */
 173         public static void main(String[] args) {
 174                 CyprusActivator me = new CyprusActivator();
 175                 me.doImport(cdmDestination);
 176         }
 177
 178 }