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_distribution();
  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_production();
  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 = false;
  68         static final boolean doDeduplicate = false;
  69         static final boolean doDistribution = true;
  70
  71
  72         private void doImport(ICdmDataSource cdmDestination){
  73
  74                 //make Source
  75                 CyprusImportConfigurator config= CyprusImportConfigurator.NewInstance(source, cdmDestination);
  76                 config.setClassificationUuid(classificationUuid);
  77                 config.setCheck(check);
  78                 config.setDoDistribution(doDistribution);
  79                 config.setDoTaxa(doTaxa);
  80 //              config.setDefaultLanguageUuid(defaultLanguageUuid);
  81 //              config.setDoPrintKeys(doPrintKeys);
  82                 config.setDbSchemaValidation(hbm2dll);
  83
  84                 CdmDefaultImport myImport = new CdmDefaultImport();
  85
  86
  87                 //...
  88                 if (true){
  89                         System.out.println("Start import from ("+ source.toString() + ") ...");
  90                         config.setSourceReference(getSourceReference(config.getSourceReferenceTitle()));
  91                         myImport.invoke(config);
  92                         if (doTaxa){
  93                                 FeatureTree tree = makeFeatureNodes(myImport.getCdmAppController().getTermService());
  94                                 myImport.getCdmAppController().getFeatureTreeService().saveOrUpdate(tree);
  95                         }
  96
  97                         System.out.println("End import from ("+ source.toString() + ")...");
  98                 }
  99
 100
 101
 102                 //deduplicate
 103                 if (doDeduplicate){
 104                         CdmApplicationController app = myImport.getCdmAppController();
 105                         int count = app.getAgentService().deduplicate(Person.class, null, null);
 106                         logger.warn("Deduplicated " + count + " persons.");
 107 //                      count = app.getAgentService().deduplicate(Team.class, null, null);
 108 //                      logger.warn("Deduplicated " + count + " teams.");
 109                         count = app.getReferenceService().deduplicate(Reference.class, null, null);
 110                         logger.warn("Deduplicated " + count + " references.");
 111                 }
 112
 113         }
 114
 115         private Reference getSourceReference(String string) {
 116                 Reference result = ReferenceFactory.newGeneric();
 117                 result.setTitleCache(string);
 118                 return result;
 119         }
 120
 121         private FeatureTree makeFeatureNodes(ITermService service){
 122                 CyprusTransformer transformer = new CyprusTransformer();
 123
 124                 FeatureTree result = FeatureTree.NewInstance(featureTreeUuid);
 125                 result.setTitleCache("Cyprus Feature Tree");
 126                 FeatureNode root = result.getRoot();
 127                 FeatureNode newNode;
 128
 129                 newNode = FeatureNode.NewInstance(Feature.STATUS());
 130                 root.addChild(newNode);
 131
 132                 newNode = FeatureNode.NewInstance(Feature.DISTRIBUTION());
 133                 root.addChild(newNode);
 134
 135                 newNode = FeatureNode.NewInstance(Feature.SYSTEMATICS());
 136                 root.addChild(newNode);
 137
 138                 //user defined features
 139                 String [] featureList = new String[]{"Red Book", "Endemism"};
 140                 addFeataureNodesByStringList(featureList, root, transformer, service);
 141
 142                 return result;
 143         }
 144
 145
 146         //Cyprus
 147         public static URI cyprus_local() {
 148                 URI sourceUrl;
 149                 try {
 150                         sourceUrl = new URI("file:/C:/localCopy/Data/zypern/Zypern.xls");
 151                         return sourceUrl;
 152                 } catch (URISyntaxException e) {
 153                         e.printStackTrace();
 154                         return null;
 155                 }
 156         }
 157         //Cyprus distriution
 158         public static URI cyprus_distribution() {
 159                 URI sourceUrl;
 160                 try {
 161                         sourceUrl = new URI("file:/C:/localCopy/Data/zypern/Zypern_distribution.xls");
 162                         return sourceUrl;
 163                 } catch (URISyntaxException e) {
 164                         e.printStackTrace();
 165                         return null;
 166                 }
 167         }
 168
 169         public void addFeataureNodesByStringList(String[] featureStringList, FeatureNode root, IInputTransformer transformer, ITermService termService){
 170                 try {
 171                         for (String featureString : featureStringList){
 172                         UUID featureUuid;
 173                         featureUuid = transformer.getFeatureUuid(featureString);
 174                         Feature feature = (Feature)termService.find(featureUuid);
 175                         if (feature != null){
 176                                 FeatureNode child = FeatureNode.NewInstance(feature);
 177                                 root.addChild(child);
 178                         }
 179                 }
 180                 } catch (UndefinedTransformerMethodException e) {
 181                         logger.error("getFeatureUuid is not implemented in transformer. Features could not be added");
 182                 }
 183         }
 184
 185
 186         /**
 187          * @param args
 188          */
 189         public static void main(String[] args) {
 190                 CyprusActivator me = new CyprusActivator();
 191                 me.doImport(cdmDestination);
 192         }
 193
 194 }