/**
* Copyright (C) 2007 EDIT
-* European Distributed Institute of Taxonomy
+* 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.common;
-import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import org.apache.log4j.Logger;
public class CdmDestinations {
@SuppressWarnings("unused")
private static Logger logger = Logger.getLogger(CdmDestinations.class);
-
- /**
- * Intended to be used for imports
- */
- public static ICdmDataSource import_a(){
+
+ public static ICdmDataSource cdm_redlist_animalia_localhost(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "localhost";
- String cdmDB = "import_a";
- String cdmUserName = "root";
+ String cdmDB = "cdm_bfn_imports_animalia";
+ String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
- public static ICdmDataSource cdm_test_alex(){
+ 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;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_production_palmae";
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_bfn_imports_plants";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_test_useSummary(){
+ public static ICdmDataSource cdm_redlist_lumbricidae(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "localhost";
- String cdmDB = "palmae_2011_07_17";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_rl_lumbricidae";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_test_jaxb(){
+
+ public static ICdmDataSource cdm_testDB_localhost(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_test_jaxb";
- String cdmUserName = "edit";
+ String cdmServer = "localhost";
+ String cdmDB = "testDB";
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_test_jaxb2(){
+
+ public static ICdmDataSource cdm_test_useSummary(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_test_jaxb2";
- String cdmUserName = "edit";
+ String cdmServer = "localhost";
+ String cdmDB = "palmae_2011_07_17";
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
- public static ICdmDataSource cdm_test_andreasM(){
+ public static ICdmDataSource cdm_test_local_mysql(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_test_andreasM";
- String cdmUserName = "edit";
+ 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_test_andreasM2(){
+
+
+ public static ICdmDataSource cdm_test_local_mysql_moose(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_test_andreasM2";
+ String cdmServer = "127.0.0.1";
+ String cdmDB = "moose";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_test_local_mysql(){
+
+ public static ICdmDataSource cdm_test_local_mysql_standardliste(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_test";
- String cdmUserName = "edit";
+ String cdmDB = "standardliste";
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
+
public static ICdmDataSource cdm_test_local_mysql_dwca(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "dwca";
+ String cdmDB = "dwca";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
+
public static ICdmDataSource cdm_test_local_mysql_fdac(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "fdac";
+ String cdmDB = "fdac";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_test_local_mysql_test(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "test";
- String cdmUserName = "edit";
+ String cdmDB = "test";
+ String cdmUserName = "edit"; //root on pesiimport2
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_portal(){
+ public static ICdmDataSource cdm_test_local_euromed(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_portal";
- String cdmUserName = "edit";
+ String cdmServer = "127.0.0.1";
+ String cdmDB = "euroMed";
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_portal_test(){
+
+ public static ICdmDataSource cdm_test_local_euromed2(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_portal_test";
- String cdmUserName = "edit";
+ String cdmServer = "127.0.0.1";
+ String cdmDB = "euroMed2";
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_test_patricia(){
+ public static ICdmDataSource cdm_test_local_euromed3(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_test_patricia";
- String cdmUserName = "edit";
+ String cdmServer = "127.0.0.1";
+ String cdmDB = "euroMed3";
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- //
- public static ICdmDataSource cdm_test_andreasK1(){
+
+ public static ICdmDataSource cdm_test_col(){
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_col";
+ String cdmUserName = "edit";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource cdm_test_col2(){
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_col2";
+ String cdmUserName = "edit";
+ 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;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_test_andreasK1";
- String cdmUserName = "edit";
+ String cdmServer = "127.0.0.1";
+ String cdmDB = "EDITImport";
+ String cdmUserName = "edit"; //root on pesiimport2
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_pesi_erms(){
+ public static ICdmDataSource cdm_test_euroMed(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_pesi_erms";
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_test_euromed";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_campanulaceae(){
+
+ public static ICdmDataSource cdm_corvidae_dev(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_campanulaceae";
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_corvidae";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
public static ICdmDataSource cdm_ildis_dev(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.201";
+ String cdmServer = "160.45.63.175";
String cdmDB = "cdm_edit_ildis";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
//
// public static ICdmDataSource cdm_ildis_production(){
// DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
-// String cdmServer = "160.45.63.151";
+// String cdmServer = "160.45.63.171";
// String cdmDB = "cdm_edit_ildis";
// String cdmUserName = "edit";
// return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
// }
-
+
+
+ public static ICdmDataSource cdm_redlist_moose_dev(){
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_mt_moose";
+ String cdmUserName = "edit";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource cdm_redlist_moose_production(){
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_rl_moose";
+ String cdmUserName = "edit";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource cdm_redlist_standardlist_dev(){
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_mt_standardliste";
+ String cdmUserName = "edit";
+ 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.201";
+ String cdmServer = "160.45.63.175";
String cdmDB = "cdm_cyprus";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_cyprus_production(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.151";
+ String cdmServer = "160.45.63.171";
String cdmDB = "cdm_production_cyprus";
String cdmUserName = "edit";
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";
String cdmUserName = "edit";
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";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_campanulaceae_production(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.151";
+ String cdmServer = "160.45.63.171";
String cdmDB = "cdm_production_campanulaceae";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_flora_malesiana_preview(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.201";
- 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.151";
- String cdmDB = "cdm_production_flora_malesiana";
- String cdmUserName = "edit";
- return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
- }
-
- public static ICdmDataSource cdm_flora_central_africa_preview(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.201";
- String cdmDB = "cdm_edit_flora_central_africa";
- String cdmUserName = "edit";
- return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
- }
-
- public static ICdmDataSource cdm_flora_central_africa_production(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.151";
- String cdmDB = "cdm_production_flora_central_africa";
- String cdmUserName = "edit";
- return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
- }
-
- public static ICdmDataSource cdm_pesi_euroMed(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_pesi_euroMed";
- String cdmUserName = "edit";
- return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
- }
-
- public static ICdmDataSource cdm_pesi_all(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_pesi_all";
- 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";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_portal_test_localhost2(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_local_cichorieae(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_local_dipera(){
+
+
+
+ public static ICdmDataSource cdm_local_palmae(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_diptera";
+ String cdmDB = "cdm_edit_caryo";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_local_palmae(){
+
+ public static ICdmDataSource cdm_local_caryo(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_palmae";
+ 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";
+ String cdmDB = "cdm_edit_globis";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_local_globis(){
+
+ 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 = "127.0.0.1";
- String cdmDB = "cdm_globis";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_globis";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_local_cichorieae_d(){
+
+ public static ICdmDataSource cdm_local_globis(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_cichorieae_d";
- String cdmUserName = "root";
+ String cdmDB = "cdm_globis";
+ String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_local_postgres_CdmTest(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
String cdmServer = "127.0.0.1";
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;
}
-
-
+
+
public static ICdmDataSource localH2(){
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", "");
}
-
- public static ICdmDataSource localH2Diptera(){
- return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");
+
+ public static ICdmDataSource localH2Armeria(){
+ return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
+ }
+
+ public static ICdmDataSource localH2Standardliste(){
+ return CdmDataSource.NewH2EmbeddedInstance("standardliste", "sa", "");
}
-
-
+
public static ICdmDataSource localH2Cichorieae(){
return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
}
-
+
public static ICdmDataSource localH2Palmae(){
return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
}
-
+
public static ICdmDataSource localH2EuroMed(){
return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
}
-
+
public static ICdmDataSource localH2Erms(){
return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
}
-
- public static ICdmDataSource localH2_viola(){
- return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");
- }
-
- public static ICdmDataSource localH2_LIAS(){
- return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");
- }
-
- public static ICdmDataSource localH2_Erythroneura(){
- return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");
- }
-
- public static ICdmDataSource localH2_Cicad(){
- return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");
- }
-
- public static ICdmDataSource localH2_ValRosandraFRIDAKey(){
- return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");
- }
-
- public static ICdmDataSource localH2_FreshwaterAquaticInsects(){
- return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");
- }
-
- public static ICdmDataSource cdm_portal_test_pollux(){
+
+
+ public static ICdmDataSource cdm_algaterra_preview(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.11";
- String cdmDB = "cdm_portal_test";
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_edit_algaterra";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
- public static ICdmDataSource cdm_algaterra_preview(){
+ public static ICdmDataSource cdm_algaterra_production(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.201";
- String cdmDB = "cdm_edit_algaterra";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_algaterra";
String cdmUserName = "edit";
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";
- String cdmDB = "cdm_edit_cichorieae_a";
+ String cdmDB = "cdm_edit_cichorieae_a";
String cdmUserName = "edit";
int port = 15432;
return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
public static ICdmDataSource cdm_cichorieae_preview(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.201";
- String cdmDB = "cdm_edit_cichorieae";
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_edit_cichorieae";
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.151";
+ String cdmServer = "160.45.63.171";
// String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_production_cichorieae";
+ String cdmDB = "cdm_production_cichorieae";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
+
public static ICdmDataSource cdm_production_palmae(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.151";
- String cdmDB = "cdm_production_palmae";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_palmae";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
-
- public static ICdmDataSource cdm_production_diptera(){
+
+ public static ICdmDataSource cdm_production_flora_deutschland(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "160.45.63.151";
- String cdmDB = "cdm_production_diptera";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_rl_standardliste";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource local_cdm_edit_cichorieae_a(){
+
+ public static ICdmDataSource cdm_production_caryophyllales(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_cichorieae_a";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_caryophyllales";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource local_cdm_edit_cichorieae_b(){
+
+ public static ICdmDataSource cdm_production_redlist_gefaesspflanzen(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_cichorieae_b";
+ 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_edit_palmae_a(){
+ 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;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_edit_palmae_a";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_diptera";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
- public static ICdmDataSource cdm_edit_diptera_preview_B(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_diptera_b";
- String cdmUserName = "edit";
- int port = 13306;
- return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
- }
-
public static ICdmDataSource cdm_edit_cichorieae_preview(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_cichorieae";
+ String cdmDB = "cdm_edit_cichorieae";
String cdmUserName = "edit";
int port = 13306;
return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
}
- public static ICdmDataSource cdm_edit_palmae_preview(){
+ public static ICdmDataSource cdm_edit_cichorieae_preview_direct(){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "127.0.0.1";
- String cdmDB = "cdm_edit_palmae";
+ String cdmServer = "160.45.63.175";
+ String cdmDB = "cdm_edit_cichorieae";
String cdmUserName = "edit";
- int port = 13306;
+ int port = 3306;
return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
- }
-
- public static ICdmDataSource cdm_edit_salvador(){
- DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_edit_salvador";
- String cdmUserName = "edit";
- return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_import_salvador() {
+
+ public static ICdmDataSource cdm_production_piB(String database){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "cdm_import_salvador";
+ String cdmServer = "160.45.63.171";
+ String cdmDB = "cdm_production_" + database + "_pilot";
String cdmUserName = "edit";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
- public static ICdmDataSource cdm_salvador_production() {
+
+ public static ICdmDataSource cdm_local_piB(String database){
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
- String cdmServer = "192.168.2.10";
- String cdmDB = "salvador_cdm";
- String cdmUserName = "salvador";
+ String cdmServer = "127.0.0.1";
+ String cdmDB = "piB_" + database;
+ String cdmUserName = "root";
return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
}
-
-
-// public static ICdmDataSource LAPTOP_HP(){
-// DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
-// String cdmServer = "LAPTOPHP";
-// String cdmDB = "cdmTest";
-// String cdmUserName = "edit";
-// return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
-// }
-
-
-
+ /**
+ * patricia
+ */
+ public static ICdmDataSource mon_cdm() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_local";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource proibiosphere_chenopodium_local() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource proibiosphere_ants_local() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_production_proibiosphere_ants_pilot";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource proibiosphere_fungi_local() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_production_proibiosphere_fungi_pilot";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource proibiosphere_campylopus_local() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_production_proibiosphere_campylopus_pilot";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+
+ public static ICdmDataSource proibiosphere_eupolybothrus_local() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_production_proibiosphere_eupolybothrus_pilot";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+ public static ICdmDataSource proibiosphere_spiders_local() {
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
+ String cdmServer = "localhost";
+ String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
+ String cdmUserName = "root";
+ return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
+ }
+
+
+
/**
* initializes source
* TODO only supports MySQL and PostgreSQL
- *
+ *
* @param dbType
* @param cdmServer
* @param cdmDB
* @param pwd
* @return
*/
- private static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
+ public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
//establish connection
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");
/**
- * Accepts a string array and tries to find a method returning an ICdmDataSource with
+ * Accepts a string array and tries to find a method returning an ICdmDataSource with
* the name of the given first string in the array
- *
+ *
* @param args
* @return
*/
public static ICdmDataSource chooseDestination(String[] args) {
- if(args == null)
- return null;
-
- if(args.length != 1)
- return null;
-
+ if(args == null) {
+ return null;
+ }
+
+ if(args.length != 1) {
+ return null;
+ }
+
String possibleDestination = args[0];
-
+
Method[] methods = CdmDestinations.class.getMethods();
-
+
for (Method method : methods){
if(method.getName().equals(possibleDestination)){
try {
return (ICdmDataSource) method.invoke(null, null);
- } catch (IllegalArgumentException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (IllegalAccessException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (InvocationTargetException e) {
- // TODO Auto-generated catch block
+ } catch (Exception e) {
e.printStackTrace();
+ throw new RuntimeException(e);
}
}
}