3 import org
.apache
.log4j
.Logger
;
5 import eu
.etaxonomy
.cdm
.common
.CdmUtils
;
6 import eu
.etaxonomy
.cdm
.database
.CdmDataSource
;
7 import eu
.etaxonomy
.cdm
.database
.DatabaseTypeEnum
;
8 import eu
.etaxonomy
.cdm
.database
.ICdmDataSource
;
10 public class CdmDestinations
{
11 private static Logger logger
= Logger
.getLogger(CdmDestinations
.class);
13 public static ICdmDataSource
cdm_1_1(){
14 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
15 String cdmServer
= "192.168.2.10";
16 String cdmDB
= "cdm_1_1"; // values: "cdm_1_1" "cdm_build"
17 String cdmUserName
= "edit";
18 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
22 public static ICdmDataSource
cdm_build(){
23 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
24 String cdmServer
= "192.168.2.10";
25 String cdmDB
= "cdm_build"; // values: "cdm_1_1" "cdm_build"
26 String cdmUserName
= "edit";
27 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
31 public static ICdmDataSource
cdm_test(){
32 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
33 String cdmServer
= "192.168.2.10";
34 String cdmDB
= "cdm_test"; // values: "cdm_1_1" "cdm_build"
35 String cdmUserName
= "edit";
36 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
40 public static ICdmDataSource
cdm_test_andreasM(){
41 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
42 String cdmServer
= "192.168.2.10";
43 String cdmDB
= "cdm_test_andreasM";
44 String cdmUserName
= "edit";
45 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
49 public static ICdmDataSource
cdm_editor2(){
50 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
51 String cdmServer
= "192.168.2.10";
52 String cdmDB
= "cdm_editor_test2";
53 String cdmUserName
= "edit";
54 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
57 public static ICdmDataSource
cdm_edit_cichorieae(){
58 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
59 String cdmServer
= "192.168.2.10";
60 String cdmDB
= "cdm_edit_cichorieae";
61 String cdmUserName
= "edit";
62 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
65 public static ICdmDataSource
cdm_edit_diptera(){
66 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
67 String cdmServer
= "192.168.2.10";
68 String cdmDB
= "cdm_edit_diptera";
69 String cdmUserName
= "edit";
70 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
73 public static ICdmDataSource
cdm_edit_palmae(){
74 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
75 String cdmServer
= "192.168.2.10";
76 String cdmDB
= "cdm_edit_palmae";
77 String cdmUserName
= "edit";
78 return makeDestination(cdmServer
, cdmDB
, -1, cdmUserName
, null);
82 // public static ICdmDataSource LAPTOP_HP(){
83 // DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
84 // String cdmServer = "LAPTOPHP";
85 // String cdmDB = "cdmTest";
86 // String cdmUserName = "edit";
87 // return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
93 * @return true, if connection establisehd
95 private static ICdmDataSource
makeDestination(String cdmServer
, String cdmDB
, int port
, String cdmUserName
, String pwd
){
96 //establish connection
99 pwd
= CdmUtils
.readInputLine("Please insert password for " + CdmUtils
.Nz(cdmUserName
) + ": ");
102 ICdmDataSource destination
= CdmDataSource
.NewMySqlInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
);
104 } catch (Exception e
) {