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
String cdmUserName = "edit";\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
-\r
+ \r
+ /**\r
+ * Intended to be used for imports\r
+ */\r
+ public static ICdmDataSource cdm_import(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_import";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
\r
public static ICdmDataSource cdm_test(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
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
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ //\r
+ public static ICdmDataSource cdm_test_andreasK1(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_andreasK1";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+ public static ICdmDataSource cdm_test_andreasK2(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_andreasK2";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+\r
public static ICdmDataSource cdm_pesi_erms(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
String cdmServer = "192.168.2.10";\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_local_cichorieae(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\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
+ }\r
+ \r
+ public static ICdmDataSource cdm_local_dipera(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\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 = "127.0.0.1";\r
+ String cdmDB = "cdm_edit_palmae";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+ \r
public static ICdmDataSource NULL(){\r
return null;\r
}\r
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
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_v1_cichorieae(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_v1_cichorieae"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
public static ICdmDataSource cdm_edit_diptera(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
String cdmServer = "192.168.2.10";\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_edit_diptera_177(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "87.106.88.177";\r
+ String cdmDB = "cdm_edit_diptera"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, 80, cdmUserName, null);\r
+ }\r
+ \r
+ public static ICdmDataSource cdm_v1_diptera(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_v1_diptera"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
public static ICdmDataSource cdm_edit_palmae(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
String cdmServer = "192.168.2.10";\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_edit_diptera_preview_B(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "127.0.0.1";\r
+ String cdmDB = "cdm_edit_diptera_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_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
+ String cdmDB = "cdm_v1_palmae"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
public static ICdmDataSource cdm_edit_salvador(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
String cdmServer = "192.168.2.10";\r
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
// DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;\r
// String cdmServer = "LAPTOPHP";\r
//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