ref #2937 start GermanSL import

[cdmlib-apps.git] / app-import / src / main / java / eu / etaxonomy / cdm / app / common / CdmDestinations.java

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 25a860a5bc4c886c79c0ed1c356ff56f51874a81..bc15b8253fc41b53a8f7d5dc860ff3c609c7bfea 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
@@ -30,13 +30,13 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-          public static ICdmDataSource cdm_redlist_animalia_production(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.171";
-               String cdmDB = "cdm_production_rl_animals";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-           }
+    public static ICdmDataSource cdm_redlist_animalia_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rl_animals";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
 
        public static ICdmDataSource cdm_redlist_plant_localhost(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
@@ -160,6 +160,22 @@ public class CdmDestinations {
         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
     }
 
+    public static ICdmDataSource cdm_col_local(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "col_test";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_col2_local(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "col_test2";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
 
        public static ICdmDataSource cdm_local_EDITImport(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
@@ -177,14 +193,6 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_pesi_euromed(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_pesi_euromed";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
        public static ICdmDataSource cdm_corvidae_dev(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
@@ -235,6 +243,23 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+       public static ICdmDataSource cdm_redlist_germanSL_preview(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_rl_german_sl";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_germanSL_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rl_german_sl";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+
        public static ICdmDataSource cdm_cyprus_dev(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
@@ -251,6 +276,22 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+    public static ICdmDataSource cdm_cuba_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_flora_cuba";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_mexico_rubiaceae_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_rubiaceae_mexico";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
        public static ICdmDataSource cdm_cyprus_production_tunnel(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
@@ -277,22 +318,6 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_flora_malesiana_preview(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.175";
-               String cdmDB = "cdm_edit_flora_malesiana";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
-       public static ICdmDataSource cdm_flora_malesiana_production(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "160.45.63.171";
-               String cdmDB = "cdm_production_flora_malesiana";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
        public static ICdmDataSource cdm_portal_test_localhost(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
@@ -322,11 +347,19 @@ public class CdmDestinations {
        public static ICdmDataSource cdm_local_palmae(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_edit_palmae";
+               String cdmDB = "cdm_edit_caryo";
                String cdmUserName = "edit";
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+       public static ICdmDataSource cdm_local_caryo(){
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+               String cdmServer = "127.0.0.1";
+               String cdmDB = "cdm_local_caryophyllales";
+               String cdmUserName = "root";
+               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+       }
+
        public static ICdmDataSource cdm_globis_dev(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.175";
@@ -335,6 +368,14 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+    public static ICdmDataSource cdm_local_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "127.0.0.1";
+        String cdmDB = "edaphobase";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
        public static ICdmDataSource cdm_globis_production(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
                String cdmServer = "160.45.63.171";
@@ -359,14 +400,6 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
-       public static ICdmDataSource cdm_local_tdwg2010(){
-               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-               String cdmServer = "127.0.0.1";
-               String cdmDB = "cdm_tdwg2010";
-               String cdmUserName = "edit";
-               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
-       }
-
 
        public static ICdmDataSource NULL(){
                return null;
@@ -377,9 +410,9 @@ public class CdmDestinations {
                return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
        }
 
-       public static ICdmDataSource localH2(String database, String username, String filePath){
-               return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
-       }
+       public static ICdmDataSource localH2Edapho(){
+        return CdmDataSource.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
+    }
 
        public static ICdmDataSource localH2Salvador(){
                return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
@@ -426,6 +459,22 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+    public static ICdmDataSource cdm_salvador_preview(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.175";
+        String cdmDB = "cdm_salvador";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
+    public static ICdmDataSource cdm_salvador_production(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_salvador";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
        public static ICdmDataSource cdm_edit_cichorieae_local_PG(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
                String cdmServer = "127.0.0.1";
@@ -476,6 +525,22 @@ public class CdmDestinations {
                return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
        }
 
+       public static ICdmDataSource cdm_production_redlist_gefaesspflanzen(){
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+               String cdmServer = "160.45.63.171";
+               String cdmDB = "cdm_production_rl_plantae";
+               String cdmUserName = "edit";
+               return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+       }
+
+    public static ICdmDataSource cdm_production_edaphobase(){
+        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+        String cdmServer = "160.45.63.171";
+        String cdmDB = "cdm_production_edaphobase";
+        String cdmUserName = "edit";
+        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+    }
+
 
        public static ICdmDataSource cdm_production_diptera(){
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
@@ -598,9 +663,9 @@ public class CdmDestinations {
                pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
                ICdmDataSource destination;
                if(dbType.equals(DatabaseTypeEnum.MySQL)){
-                       destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
+                       destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
                } else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
-                       destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
+                       destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
                } else {
                        //TODO others
                        throw new RuntimeException("Unsupported DatabaseType");