\r
import org.apache.log4j.Logger;\r
\r
-import eu.etaxonomy.cdm.common.CdmUtils;\r
+import eu.etaxonomy.cdm.common.AccountStore;\r
import eu.etaxonomy.cdm.database.CdmDataSource;\r
import eu.etaxonomy.cdm.database.DatabaseTypeEnum;\r
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
}\r
\r
\r
+ public static ICdmDataSource cdm_test_anahit(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_anahit"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+ public static ICdmDataSource cdm_test_anahit2(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_anahit2"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+ public static ICdmDataSource cdm_test_jaxb(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_jaxb"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+ public static ICdmDataSource cdm_test_jaxb2(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_jaxb2"; \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
String cdmServer = "192.168.2.10";\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_test_andreasM3(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_andreasM3"; \r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
\r
public static ICdmDataSource cdm_editor2(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_test_patricia(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_patricia";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+\r
+ public static ICdmDataSource cdm_test_niels1(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_niels1";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
+ public static ICdmDataSource cdm_test_niels2(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "192.168.2.10";\r
+ String cdmDB = "cdm_test_niels2";\r
+ String cdmUserName = "edit";\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
+ String cdmDB = "cdm_pesi_erms";\r
+ String cdmUserName = "edit";\r
+ return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+ }\r
+ \r
public static ICdmDataSource cdm_portal_test_localhost(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
String cdmServer = "127.0.0.1";\r
return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
}\r
\r
+ public static ICdmDataSource cdm_portal_test_localhost2(){\r
+ DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+ String cdmServer = "127.0.0.1";\r
+ String cdmDB = "cdm_portal_test2";\r
+ String cdmUserName = "edit";\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
+ \r
+ public static ICdmDataSource localH2_LIAS(){\r
+ return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");\r
+ }\r
+ \r
+ public static ICdmDataSource localH2_Erythroneura(){\r
+ return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");\r
+ }\r
+ \r
+ public static ICdmDataSource localH2_Cicad(){\r
+ return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");\r
+ }\r
+ \r
+ public static ICdmDataSource localH2_ValRosandraFRIDAKey(){\r
+ return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");\r
+ }\r
+ \r
+ public static ICdmDataSource localH2_FreshwaterAquaticInsects(){\r
+ return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");\r
+ }\r
+ \r
public static ICdmDataSource cdm_portal_test_pollux(){\r
DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
String cdmServer = "192.168.2.11";\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
+ String cdmDB = "cdm_edit_salvador"; \r
+ String cdmUserName = "edit";\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
*/\r
private static ICdmDataSource makeDestination(String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){\r
//establish connection\r
- AccountStore accounts = new AccountStore();\r
- String strServer = "cdm-server";\r
- boolean doStore = false;\r
- try {\r
- if (pwd == null){\r
- pwd = accounts.getPassword(strServer, cdmServer, cdmUserName);\r
- if(pwd == null){\r
- doStore = true;\r
- pwd = CdmUtils.readInputLine("Please insert password for " + CdmUtils.Nz(cdmUserName) + ": ");\r
- } else {\r
- logger.info("using stored password for "+CdmUtils.Nz(cdmUserName));\r
- }\r
- }\r
- //TODO not MySQL\r
- ICdmDataSource destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);\r
- // on success store userName, pwd in property file\r
- if(doStore){\r
- accounts.setPassword(strServer, cdmServer, cdmUserName, pwd);\r
- logger.info("password stored in "+accounts.accountsFile);\r
- }\r
- return destination;\r
- } catch (Exception e) {\r
- if(doStore){\r
- accounts.removePassword(strServer, cdmServer, cdmUserName);\r
- logger.info("password removed from "+accounts.accountsFile);\r
- }\r
- logger.error(e);\r
- return null;\r
- }\r
+ pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);\r
+ //TODO not MySQL\r
+ ICdmDataSource destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);\r
+ return destination;\r
+\r
}\r
\r
}\r