app-import/src/main/java/eu/etaxonomy/cdm/app/cyprus/CyprusSpecimenActivator.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
  15 import org.apache.log4j.Logger;
  16
  17 import eu.etaxonomy.cdm.app.common.CdmDestinations;
  18 import eu.etaxonomy.cdm.database.DbSchemaValidation;
  19 import eu.etaxonomy.cdm.database.ICdmDataSource;
  20 import eu.etaxonomy.cdm.io.common.CdmDefaultImport;
  21 import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;
  22 import eu.etaxonomy.cdm.io.specimen.excel.in.SpecimenCdmExcelImportConfigurator;
  23 import eu.etaxonomy.cdm.model.reference.Reference;
  24 import eu.etaxonomy.cdm.model.reference.ReferenceFactory;
  25
  26 /**
  27  * @author a.mueller
  28  * @created 16.12.2010
  29  * @version 1.0
  30  */
  31 public class CyprusSpecimenActivator {
  32         @SuppressWarnings("unused")
  33         private static final Logger logger = Logger.getLogger(CyprusSpecimenActivator.class);
  34
  35         //database validation status (create, update, validate ...)
  36         static DbSchemaValidation hbm2dll = DbSchemaValidation.VALIDATE;
  37         static final URI source = cyprus_specimen_local();
  38
  39
  40 //      static final ICdmDataSource cdmDestination = CdmDestinations.localH2();
  41 //      static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql();
  42         static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_dev();
  43 //      static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_production();
  44
  45
  46         //check - import
  47         static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
  48
  49         //taxa
  50 //      static final boolean doTaxa = false;
  51 //      static final boolean doDeduplicate = false;
  52 //      static final boolean doDistribution = true;
  53
  54
  55         private void doImport(ICdmDataSource cdmDestination){
  56
  57                 //make Source
  58                 SpecimenCdmExcelImportConfigurator config= SpecimenCdmExcelImportConfigurator.NewInstance(source, cdmDestination);
  59                 config.setCheck(check);
  60                 config.setDbSchemaValidation(hbm2dll);
  61
  62                 CdmDefaultImport myImport = new CdmDefaultImport();
  63
  64
  65                 //...
  66                 if (true){
  67                         System.out.println("Start import from ("+ source.toString() + ") ...");
  68                         config.setSourceReference(getSourceReference(config.getSourceReferenceTitle()));
  69                         myImport.invoke(config);
  70
  71                         System.out.println("End import from ("+ source.toString() + ")...");
  72                 }
  73
  74         }
  75
  76         private Reference getSourceReference(String string) {
  77                 Reference result = ReferenceFactory.newGeneric();
  78                 result.setTitleCache(string, true);
  79                 return result;
  80         }
  81
  82         //Cyprus
  83         public static URI cyprus_specimen_local() {
  84                 URI sourceUrl;
  85                 try {
  86                         sourceUrl = new URI("file:/C:/localCopy/Data/zypern/Cyprus-specimens-import02_AM.xls");
  87                         return sourceUrl;
  88                 } catch (URISyntaxException e) {
  89                         e.printStackTrace();
  90                         return null;
  91                 }
  92         }
  93
  94
  95
  96         /**
  97          * @param args
  98          */
  99         public static void main(String[] args) {
 100                 CyprusSpecimenActivator me = new CyprusSpecimenActivator();
 101                 me.doImport(cdmDestination);
 102         }
 103
 104 }