X-Git-Url: https://dev.e-taxonomy.eu/gitweb/cdmlib-apps.git/blobdiff_plain/a26a9112201bcf78a2d1e7eb232721891e691467..a881d4d7c3f5f4340420416bd79c781723606014:/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 897a3192..607d5537 100644 --- 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 @@ -13,15 +13,25 @@ import java.lang.reflect.Method; import org.apache.log4j.Logger; -import eu.etaxonomy.cdm.common.AccountStore; +import eu.etaxonomy.cdm.config.AccountStore; import eu.etaxonomy.cdm.database.CdmDataSource; import eu.etaxonomy.cdm.database.DatabaseTypeEnum; import eu.etaxonomy.cdm.database.ICdmDataSource; public class CdmDestinations { + @SuppressWarnings("unused") private static Logger logger = Logger.getLogger(CdmDestinations.class); + public static ICdmDataSource cdm_pesi2019_final(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_pesi_2019final"; + String cdmUserName = "edit"; + int port = 3306; + return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null); + } + public static ICdmDataSource cdm_local_redlist_animalia(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "localhost"; @@ -38,6 +48,14 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } + public static ICdmDataSource cdm_additivity_ontology(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.171"; + String cdmDB = "cdm_production_additivity_ontology"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + public static ICdmDataSource cdm_redlist_animalia_production_final(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; @@ -70,6 +88,22 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } + public static ICdmDataSource cdm_local_cdmtest_mysql(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_test"; + String cdmUserName = "root"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_local_uzbekistan(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_uzbekistan"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + public static ICdmDataSource cdm_local_redlist_gefaesspflanzen(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "127.0.0.1"; @@ -121,6 +155,14 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } + public static ICdmDataSource cdm_local_greece(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_test_greece"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + public static ICdmDataSource cdm_local_test_bogota(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "127.0.0.1"; @@ -129,13 +171,40 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_local_euromed(){ - DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; - String cdmServer = "127.0.0.1"; - String cdmDB = "euroMed"; - String cdmUserName = "edit"; - return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); - } + public static ICdmDataSource cdm_local_casearia(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_casearia"; + String cdmUserName = "edit"; //root on pesiimport2 + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_local_mysql_pesi_euromed(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_pesi_euromed"; + String cdmUserName = "edit"; + int port = 3306; + return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null); + } + + public static ICdmDataSource cdm_local_euromed(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_euromed"; + String cdmUserName = "edit"; + int port = 3306; + return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null); + } + + public static ICdmDataSource cdm_local_mysql_tmpTest(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "tmpTest"; + String cdmUserName = "edit"; + int port = 3306; + return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null); + } public static ICdmDataSource cdm_local_euromed2(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; @@ -211,7 +280,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_euroMed_production(){ + public static ICdmDataSource cdm_production_euromed(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_euromed"; @@ -275,7 +344,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_germanSL_production(){ + public static ICdmDataSource cdm_production_germanSL(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_rl_german_sl"; @@ -283,6 +352,13 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } + public static ICdmDataSource local_cyprus(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "localhost"; + String cdmDB = "cdm_cyprus"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } public static ICdmDataSource cdm_test_cyprus(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; @@ -292,7 +368,15 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_cyprus_production(){ + public static ICdmDataSource cdm_test_bupleurum(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.175"; + String cdmDB = "cdm_test_bupleurum"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_production_cyprus(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_cyprus"; @@ -300,6 +384,30 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } + public static ICdmDataSource cdm_production_casearia(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.171"; + String cdmDB = "cdm_production_casearia"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_production_uzbekistan(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.171"; + String cdmDB = "cdm_production_flora_uzbekistan"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_phycobank_production(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.171"; + String cdmDB = "cdm_production_phycobank"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + public static ICdmDataSource cdm_production_flora_cuba(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; @@ -308,7 +416,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_greece_checklist_production(){ + public static ICdmDataSource cdm_production_greece_checklist(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_flora_greece"; @@ -316,7 +424,15 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_mexico_rubiaceae_production(){ + public static ICdmDataSource cdm_production_lichenes(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.171"; + String cdmDB = "cdm_production_lichenes"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_production_mexico_rubiaceae(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_rubiaceae_mexico"; @@ -324,7 +440,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_bogota_production(){ + public static ICdmDataSource cdm_production_bogota(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_flora_bogota"; @@ -332,7 +448,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_cyprus_production_tunnel(){ + public static ICdmDataSource cdm_production_tunnel_cyprus(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "127.0.0.1"; int port = 13306; @@ -341,16 +457,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null); } -// public static ICdmDataSource cdm_cyprus_dev_tunnel(){ -// DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; -// String cdmServer = "127.0.0.1"; -// int port = 13306; -// String cdmDB = "cdm_cyprus"; -// String cdmUserName = "edit"; -// return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null); -// } - - public static ICdmDataSource cdm_campanulaceae_production(){ + public static ICdmDataSource cdm_production_campanulaceae(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_campanulaceae"; @@ -382,7 +489,28 @@ 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_mexico(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_mexico"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + public static ICdmDataSource cdm_local_mexico2(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_mexico2"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } public static ICdmDataSource cdm_local_palmae(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; @@ -395,7 +523,7 @@ public class CdmDestinations { public static ICdmDataSource cdm_local_cuba(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "127.0.0.1"; - String cdmDB = "cdm_local_flora_cuba"; + String cdmDB = "cdm_flora_cuba"; String cdmUserName = "edit"; return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } @@ -403,7 +531,15 @@ public class CdmDestinations { public static ICdmDataSource cdm_local_caryo(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "127.0.0.1"; - String cdmDB = "cdm_local_caryophyllales"; + String cdmDB = "cdm_caryo_spp"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_local_algaterranew(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "127.0.0.1"; + String cdmDB = "cdm_production_algaterranew"; String cdmUserName = "root"; return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } @@ -454,7 +590,7 @@ public class CdmDestinations { public static ICdmDataSource cdm_local_caryo_spp(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "127.0.0.1"; - String cdmDB = "cdm_caryo_spp"; + String cdmDB = "cdm_local_caryophyllales_spp"; String cdmUserName = "edit"; return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } @@ -467,7 +603,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_globis_production(){ + public static ICdmDataSource cdm_production_globis(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_globis"; @@ -490,11 +626,13 @@ public class CdmDestinations { String cdmUserName = "edit"; return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - - - public static ICdmDataSource NULL(){ - return null; - } + public static ICdmDataSource cdm_mexico_flora(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "132.248.13.83"; + String cdmDB = "cdm_flora_mexico"; + String cdmUserName = "bgbm-developer"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } public static ICdmDataSource localH2(){ @@ -588,7 +726,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_salvador_production(){ + public static ICdmDataSource cdm_production_salvador(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_salvador"; @@ -604,6 +742,22 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } + public static ICdmDataSource cdm_int_flora_malesiana(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.201"; + String cdmDB = "cdm_integration_flora_malesiana"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + + public static ICdmDataSource cdm_test_caryo_spp(){ + DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; + String cdmServer = "160.45.63.175"; + String cdmDB = "cdm_caryo_spp"; + String cdmUserName = "edit"; + return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); + } + public static ICdmDataSource cdm_production_cichorieae(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; @@ -628,7 +782,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource cdm_production_caryophyllales(){ + public static ICdmDataSource cdm_production_caryophyllales_genus(){ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "160.45.63.171"; String cdmDB = "cdm_production_caryophyllales"; @@ -692,7 +846,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource proibiosphere_chenopodium_local() { + public static ICdmDataSource cdm_local_proibiosphere_chenopodium() { DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "localhost"; String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot"; @@ -700,7 +854,7 @@ public class CdmDestinations { return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null); } - public static ICdmDataSource proibiosphere_spiders_local() { + public static ICdmDataSource cdm_local_proibiosphere_spiders() { DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL; String cdmServer = "localhost"; String cdmDB = "cdm_production_proibiosphere_spiders_pilot";