app-import/src/main/java/eu/etaxonomy/cdm/app/sdd/CichorieaeActivator.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.sdd;
  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.sdd.in.SDDImportConfigurator;
  23
  24 /**
  25  * @author h.fradin
  26  * @created 24.10.2008
  27  * @version 1.0
  28  */
  29 public class CichorieaeActivator {
  30         private static final Logger logger = Logger.getLogger(CichorieaeActivator.class);
  31
  32         //database validation status (create, update, validate ...)
  33         static DbSchemaValidation hbm2dll = DbSchemaValidation.UPDATE;
  34
  35         /********************************************************************************
  36          * IMPORTANT:
  37          *
  38          * execute the following sql statements before runniung the import
  39          *
  40          * ALTER TABLE `statedata_definedtermbase`  DROP INDEX `modifiers_id`;
  41          * ALTER TABLE `statisticalmeasurementvalue_definedtermbase`  DROP INDEX `modifiers_id`;
  42          *
  43          ********************************************************************************/
  44         static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql();
  45         static final String sddSource = SDDSources.Cichorieae_DA_export_sdd();
  46         //      static final ICdmDataSource cdmDestination = CdmDestinations.cdm_portal_test_localhost();
  47
  48         static final String sourceSecId = "cichorieae-crepis-sdd-import";
  49
  50         //check - import
  51         static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
  52
  53
  54         static final boolean doMatchTaxa = true;
  55
  56         /**
  57          * @param args
  58          */
  59         public static void main(String[] args) {
  60
  61                 logger.info("Start import from SDD ("+ sddSource.toString() + ") ...");
  62
  63                 //make Source
  64                 URI source;
  65                 try {
  66                         source = new URI(sddSource);
  67                         ICdmDataSource destination = cdmDestination;
  68
  69                         SDDImportConfigurator sddImportConfigurator = SDDImportConfigurator.NewInstance(source,  destination);
  70
  71                         sddImportConfigurator.setSourceSecId(sourceSecId);
  72
  73                         sddImportConfigurator.setCheck(check);
  74                         sddImportConfigurator.setDbSchemaValidation(hbm2dll);
  75
  76                         sddImportConfigurator.setReuseExistingTaxaWhenPossible(doMatchTaxa);
  77
  78
  79                         // invoke import
  80                         CdmDefaultImport<SDDImportConfigurator> sddImport = new CdmDefaultImport<SDDImportConfigurator>();
  81                         sddImport.invoke(sddImportConfigurator);
  82
  83                         logger.info("End import from SDD ("+ source.toString() + ")...");
  84                 } catch (URISyntaxException e) {
  85                         // TODO Auto-generated catch block
  86                         e.printStackTrace();
  87                 }
  88         }
  89
  90
  91 }