final commit of Taraxacum import on behalf of anahit
[cdmlib.git] / app-import / src / main / java / eu / etaxonomy / cdm / app / common / CdmDestinations.java
index 8d932fae491ba3e3bd5c5b1f9b7e5280d8f73497..c7e0f41dbf1a157eaaaf2a8f688f923010e4ed00 100644 (file)
@@ -17,6 +17,7 @@ import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
 import eu.etaxonomy.cdm.database.ICdmDataSource;\r
 \r
 public class CdmDestinations {\r
+       @SuppressWarnings("unused")\r
        private static Logger logger = Logger.getLogger(CdmDestinations.class);\r
        \r
        public static ICdmDataSource cdm_1_1(){\r
@@ -87,6 +88,30 @@ public class CdmDestinations {
                String cdmUserName = "edit";\r
                return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
        }\r
+\r
+       public static ICdmDataSource cdm_test_andreas_diptera(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_test_andreas_diptera"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_test_andreas_palmae(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_test_andreas_palmae"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_test_andreas_cichorieae(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_test_andreas_cichorieae"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
        \r
        public static ICdmDataSource cdm_test_andreasM(){\r
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
@@ -205,7 +230,7 @@ public class CdmDestinations {
        \r
        public static ICdmDataSource cdm_local_cichorieae(){\r
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
-               String cdmServer = "172.0.0.1";\r
+               String cdmServer = "127.0.0.1";\r
                String cdmDB = "cdm_edit_cichorieae";\r
                String cdmUserName = "edit";\r
                return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
@@ -213,15 +238,68 @@ public class CdmDestinations {
        \r
        public static ICdmDataSource cdm_local_dipera(){\r
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
-               String cdmServer = "172.0.0.1";\r
+               String cdmServer = "127.0.0.1";\r
                String cdmDB = "cdm_edit_diptera";\r
                String cdmUserName = "edit";\r
                return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
        }\r
        \r
+       public static ICdmDataSource cdm_bgbm24_palmae_a(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               int port = 3306;\r
+               String cdmDB = "cdm_edit_palmae_a";\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_bgbm24_cichorieae_a(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               int port = 3306;\r
+               String cdmDB = "cdm_edit_cichorieae_a";\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_bgbm24_dipera_a(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               int port = 3306;\r
+               String cdmDB = "cdm_edit_diptera_a";\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+       public static ICdmDataSource cdm_bgbm24_palmae_b(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               int port = 3306;\r
+               String cdmDB = "cdm_edit_palmae_b";\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_bgbm24_cichorieae_b(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               int port = 3306;\r
+               String cdmDB = "cdm_edit_cichorieae_b";\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, port , cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_bgbm24_dipera_b(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "127.0.0.1";\r
+               int port = 3306;\r
+               String cdmDB = "cdm_edit_diptera_b";\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+       \r
        public static ICdmDataSource cdm_local_palmae(){\r
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
-               String cdmServer = "172.0.0.1";\r
+               String cdmServer = "127.0.0.1";\r
                String cdmDB = "cdm_edit_palmae";\r
                String cdmUserName = "edit";\r
                return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
@@ -236,6 +314,27 @@ public class CdmDestinations {
                return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");\r
        }\r
        \r
+       public static ICdmDataSource localH2(String database, String username, String filePath){\r
+               return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);\r
+       }\r
+       \r
+       public static ICdmDataSource localH2Salvador(){\r
+               return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");\r
+       }\r
+       \r
+       public static ICdmDataSource localH2Diptera(){\r
+               return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");\r
+       }\r
+       \r
+       \r
+       public static ICdmDataSource localH2Cichorieae(){\r
+               return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");\r
+       }\r
+       \r
+       public static ICdmDataSource localH2Palmae(){\r
+               return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");\r
+       }\r
+       \r
        public static ICdmDataSource localH2_viola(){\r
                return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");\r
        }\r
@@ -316,14 +415,42 @@ public class CdmDestinations {
                return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
        }\r
        \r
-       public static ICdmDataSource cdm_edit_palmae_177(){\r
+       public static ICdmDataSource cdm_edit_diptera_preview_B(){\r
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
-               String cdmServer = "87.106.88.177";\r
-               String cdmDB = "cdm_edit_palmae"; \r
+               String cdmServer = "127.0.0.1";\r
+               String cdmDB = "cdm_edit_diptera_b"; \r
                String cdmUserName = "edit";\r
-               return makeDestination(cdmServer, cdmDB, 80, cdmUserName, null);\r
+               int port = 13306;\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
        }\r
-               \r
+       \r
+       public static ICdmDataSource cdm_edit_cichorieae_preview_B(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "127.0.0.1";\r
+               String cdmDB = "cdm_edit_cichorieae_b"; \r
+               String cdmUserName = "edit";\r
+               int port = 13306;\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+\r
+       public static ICdmDataSource cdm_edit_palmae_preview_A(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "127.0.0.1";\r
+               String cdmDB = "cdm_edit_palmae_a"; \r
+               String cdmUserName = "edit";\r
+               int port = 13306;\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }               \r
+       \r
+       public static ICdmDataSource cdm_edit_palmae_preview_B(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "127.0.0.1";\r
+               String cdmDB = "cdm_edit_palmae_b"; \r
+               String cdmUserName = "edit";\r
+               int port = 13306;\r
+               return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);\r
+       }\r
+       \r
        public static ICdmDataSource cdm_v1_palmae(){\r
                DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
                String cdmServer = "192.168.2.10";\r
@@ -340,6 +467,45 @@ public class CdmDestinations {
                return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
        }\r
        \r
+       public static ICdmDataSource cdm_import_cichorieae() {\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_import_cichorieae"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_import_diptera() {\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_import_diptera"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_import_palmae() {\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_import_palmae"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_import_salvador() {\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_import_salvador"; \r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       public static ICdmDataSource cdm_salvador_production() {\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "salvador_cdm"; \r
+               String cdmUserName = "salvador";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
        \r
        \r
 //     public static ICdmDataSource LAPTOP_HP(){\r
@@ -359,7 +525,7 @@ public class CdmDestinations {
                //establish connection\r
                pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);\r
                //TODO not MySQL\r
-               ICdmDataSource destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);\r
+               ICdmDataSource destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);\r
                return destination;\r
 \r
        }\r