ref #9030 add Cyprus Flowering period activator

diff --git a/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java b/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java
index 373a26886cc73e7aa54f1c687321c0cc940f1ceb..5e45b9795f45ec54616e61bfcd6c314f1a80c418 100644 (file)
--- a/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java
+++ b/app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java
@@ -489,7 +489,13 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-
+    public static ICdmDataSource cdm_local_cyprus(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "cdm_cyprus";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
        public static ICdmDataSource cdm_local_palmae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

diff --git a/app-import/src/main/java/eu/etaxonomy/cdm/app/cyprus/CyprusPhenologyActivator.java b/app-import/src/main/java/eu/etaxonomy/cdm/app/cyprus/CyprusPhenologyActivator.java
new file mode 100644 (file)
index 0000000..fb9ffda
--- /dev/null
+++ b/app-import/src/main/java/eu/etaxonomy/cdm/app/cyprus/CyprusPhenologyActivator.java
@@ -0,0 +1,98 @@
+/**
+* Copyright (C) 2016 EDIT
+* European Distributed Institute of Taxonomy
+* http://www.e-taxonomy.eu
+*
+* The contents of this file are subject to the Mozilla Public License Version 1.1
+* See LICENSE.TXT at the top of this package for the full license terms.
+*/
+package eu.etaxonomy.cdm.app.cyprus;
+
+import java.io.File;
+import java.util.UUID;
+
+import org.apache.log4j.Logger;
+
+import eu.etaxonomy.cdm.app.common.CdmDestinations;
+import eu.etaxonomy.cdm.common.URI;
+import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
+import eu.etaxonomy.cdm.database.DbSchemaValidation;
+import eu.etaxonomy.cdm.database.ICdmDataSource;
+import eu.etaxonomy.cdm.io.common.CdmDefaultImport;
+import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;
+import eu.etaxonomy.cdm.io.common.ImportResult;
+import eu.etaxonomy.cdm.io.fact.temporal.in.PhenologyExcelImportConfigurator;
+import eu.etaxonomy.cdm.model.reference.Reference;
+import eu.etaxonomy.cdm.model.reference.ReferenceFactory;
+
+/**
+ * Import for Flora of Cyprus flowering periods/phenology.
+ *
+ * https://dev.e-taxonomy.eu/redmine/issues/9030
+ *
+ * @author a.mueller
+ * @since 11.06.2021
+ */
+public class CyprusPhenologyActivator {
+
+    @SuppressWarnings("unused")
+    private static final Logger logger = Logger.getLogger(CyprusPhenologyActivator.class);
+
+    //database validation status (create, update, validate ...)
+
+//    static final ICdmDataSource cdmDestination = CdmDestinations.localH2();
+    static final ICdmDataSource cdmDestination = CdmDestinations.cdm_local_cyprus();
+//    static final ICdmDataSource cdmDestination = CdmDestinations.cdm_production_cyprus();
+
+    static DbSchemaValidation hbm2dll = cdmDestination.getDatabaseType() == DatabaseTypeEnum.H2 ? DbSchemaValidation.CREATE : DbSchemaValidation.VALIDATE;
+
+    static final String fileName = "Cyprus_flowering-period.xls";
+
+    static final UUID uuidSourceRef = UUID.fromString("fe24e1e9-b2df-446d-8abd-62d914d02e15");
+
+    //check - import
+    static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
+
+    private void doImport(ICdmDataSource cdmDestination){
+
+        //make Source
+        URI source = fileName();
+//        URI source = uzbekistanChecklist_local();
+
+        PhenologyExcelImportConfigurator config = PhenologyExcelImportConfigurator.NewInstance(source, cdmDestination);
+        config.setCheck(check);
+        config.setDbSchemaValidation(hbm2dll);
+        config.setFloweringStartColumnLabel("flowering period start");
+        config.setFloweringEndColumnLabel("flowering period end");
+//        config.setFruitingStartColumnLabel("начало плодоношения");
+//        config.setFruitingEndColumnLabel("конец плодоношения");
+
+        config.setSourceReference(getSourceReference());
+
+        CdmDefaultImport<PhenologyExcelImportConfigurator> myImport = new CdmDefaultImport<>();
+        ImportResult result = myImport.invoke(config);
+        System.out.println(result.createReport());
+    }
+
+    private URI fileName(){
+        return URI.create("file:////BGBM-PESIHPC/Cyprus/" + fileName);
+    }
+    @SuppressWarnings("unused")
+    private URI fileName_local(){
+        File file = new File("C:\\Users\\a.mueller\\BGBM\\Data\\Cyprus\\" + fileName);
+        return URI.fromFile(file);
+    }
+
+    private Reference getSourceReference(){
+        Reference result = ReferenceFactory.newGeneric();
+        result.setTitle(fileName);
+        result.setUuid(uuidSourceRef);
+        return result;
+    }
+
+    public static void main(String[] args) {
+        CyprusPhenologyActivator me = new CyprusPhenologyActivator();
+        me.doImport(cdmDestination);
+        System.exit(0);
+    }
+}
\ No newline at end of file