app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java

   1 /**
   2 * Copyright (C) 2007 EDIT
   3 * European Distributed Institute of Taxonomy
   4 * http://www.e-taxonomy.eu
   5 *
   6 * The contents of this file are subject to the Mozilla Public License Version 1.1
   7 * See LICENSE.TXT at the top of this package for the full license terms.
   8 */
   9
  10 package eu.etaxonomy.cdm.app.common;
  11
  12 import java.lang.reflect.Method;
  13
  14 import org.apache.log4j.Logger;
  15
  16 import eu.etaxonomy.cdm.common.AccountStore;
  17 import eu.etaxonomy.cdm.database.CdmDataSource;
  18 import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
  19 import eu.etaxonomy.cdm.database.ICdmDataSource;
  20
  21 public class CdmDestinations {
  22         @SuppressWarnings("unused")
  23         private static Logger logger = Logger.getLogger(CdmDestinations.class);
  24
  25         public static ICdmDataSource cdm_local_redlist_animalia(){
  26                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  27                 String cdmServer = "localhost";
  28                 String cdmDB = "cdm_bfn_imports_animalia";
  29                 String cdmUserName = "edit";
  30                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  31         }
  32
  33     public static ICdmDataSource cdm_redlist_animalia_production(){
  34         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  35         String cdmServer = "160.45.63.171";
  36         String cdmDB = "cdm_production_rl_animalia";
  37         String cdmUserName = "edit";
  38         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  39     }
  40
  41     public static ICdmDataSource cdm_redlist_animalia_production_final(){
  42         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  43         String cdmServer = "160.45.63.171";
  44         String cdmDB = "cdm_production_rl_animalia_final";
  45         String cdmUserName = "edit";
  46         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  47     }
  48
  49         public static ICdmDataSource cdm_local_redlist_plant(){
  50                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  51                 String cdmServer = "localhost";
  52                 String cdmDB = "cdm_bfn_imports_plants";
  53                 String cdmUserName = "edit";
  54                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  55         }
  56
  57         public static ICdmDataSource cdm_local_testDB(){
  58                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  59                 String cdmServer = "localhost";
  60                 String cdmDB = "testDB";
  61                 String cdmUserName = "root";
  62                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  63         }
  64
  65     public static ICdmDataSource cdm_local_test_mysql(){
  66         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  67         String cdmServer = "127.0.0.1";
  68         String cdmDB = "test";
  69         String cdmUserName = "root";
  70         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  71     }
  72
  73         public static ICdmDataSource cdm_local_redlist_gefaesspflanzen(){
  74                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  75                 String cdmServer = "127.0.0.1";
  76                 String cdmDB = "rl2020_gefaesspflanzen";
  77                 String cdmUserName = "root";
  78                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  79         }
  80
  81
  82         public static ICdmDataSource cdm_local_test_mysql_moose(){
  83                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  84                 String cdmServer = "127.0.0.1";
  85                 String cdmDB = "moose";
  86                 String cdmUserName = "edit";
  87                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  88         }
  89
  90         public static ICdmDataSource cdm_local_test_mysql_standardliste(){
  91                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  92                 String cdmServer = "127.0.0.1";
  93                 String cdmDB = "standardliste";
  94                 String cdmUserName = "root";
  95                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  96         }
  97
  98
  99         public static ICdmDataSource cdm_local_test_mysql_dwca(){
 100                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 101                 String cdmServer = "127.0.0.1";
 102                 String cdmDB = "dwca";
 103                 String cdmUserName = "edit";
 104                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 105         }
 106
 107
 108         public static ICdmDataSource cdm_local_mysql_fdac(){
 109                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 110                 String cdmServer = "127.0.0.1";
 111                 String cdmDB = "fdac";
 112                 String cdmUserName = "edit";
 113                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 114         }
 115
 116         public static ICdmDataSource cdm_test_local_mysql_test(){
 117                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 118                 String cdmServer = "127.0.0.1";
 119                 String cdmDB = "test";
 120                 String cdmUserName = "edit";     //root on pesiimport2
 121                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 122         }
 123
 124     public static ICdmDataSource cdm_local_test_bogota(){
 125         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 126         String cdmServer = "127.0.0.1";
 127         String cdmDB = "cdm_local_flora_bogota";
 128         String cdmUserName = "edit";     //root on pesiimport2
 129         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 130     }
 131
 132         public static ICdmDataSource cdm_local_euromed(){
 133                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 134                 String cdmServer = "127.0.0.1";
 135                 String cdmDB = "euroMed";
 136                 String cdmUserName = "edit";
 137                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 138         }
 139
 140         public static ICdmDataSource cdm_local_euromed2(){
 141                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 142                 String cdmServer = "127.0.0.1";
 143                 String cdmDB = "euroMed2";
 144                 String cdmUserName = "edit";
 145                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 146         }
 147     public static ICdmDataSource cdm_local_euromed_caucasus(){
 148         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 149         String cdmServer = "127.0.0.1";
 150         String cdmDB = "euromed_caucasus";
 151         String cdmUserName = "edit";
 152         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 153     }
 154
 155
 156
 157         public static ICdmDataSource cdm_local_test_euromed3(){
 158                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 159                 String cdmServer = "127.0.0.1";
 160                 String cdmDB = "euroMed3";
 161                 String cdmUserName = "root";
 162                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 163         }
 164
 165     public static ICdmDataSource cdm_test_col(){
 166         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 167         String cdmServer = "160.45.63.175";
 168         String cdmDB = "cdm_col";
 169         String cdmUserName = "edit";
 170         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 171     }
 172
 173     public static ICdmDataSource cdm_test_col2(){
 174         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 175         String cdmServer = "160.45.63.175";
 176         String cdmDB = "cdm_col2";
 177         String cdmUserName = "edit";
 178         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 179     }
 180
 181     public static ICdmDataSource cdm_local_col(){
 182         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 183         String cdmServer = "127.0.0.1";
 184         String cdmDB = "col_test";
 185         String cdmUserName = "edit";
 186         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 187     }
 188
 189     public static ICdmDataSource cdm_local_col2(){
 190         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 191         String cdmServer = "127.0.0.1";
 192         String cdmDB = "col_test2";
 193         String cdmUserName = "edit";
 194         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 195     }
 196
 197
 198         public static ICdmDataSource cdm_local_EDITImport(){
 199                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 200                 String cdmServer = "127.0.0.1";
 201                 String cdmDB = "EDITImport";
 202                 String cdmUserName = "edit";     //root on pesiimport2
 203                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 204         }
 205
 206         public static ICdmDataSource cdm_test_euroMed(){
 207                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 208                 String cdmServer = "160.45.63.175";
 209                 String cdmDB = "cdm_test_euromed";
 210                 String cdmUserName = "edit";
 211                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 212         }
 213
 214     public static ICdmDataSource cdm_euroMed_production(){
 215         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 216         String cdmServer = "160.45.63.171";
 217         String cdmDB = "cdm_production_euromed";
 218         String cdmUserName = "edit";
 219         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 220     }
 221
 222     public static ICdmDataSource cdm_production_euromed_caucasus(){
 223         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 224         String cdmServer = "160.45.63.171";
 225         String cdmDB = "cdm_production_euromed_caucasus";
 226         String cdmUserName = "edit";
 227         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 228     }
 229
 230         public static ICdmDataSource cdm_test_corvidae(){
 231                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 232                 String cdmServer = "160.45.63.175";
 233                 String cdmDB = "cdm_corvidae";
 234                 String cdmUserName = "edit";
 235                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 236         }
 237
 238    public static ICdmDataSource cdm_test_redlist_mammalia(){
 239         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 240         String cdmServer = "160.45.63.175";
 241         String cdmDB = "cdm_rl_mammalia";
 242         String cdmUserName = "edit";
 243         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 244     }
 245
 246         public static ICdmDataSource cdm_test_redlist_moose(){
 247                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 248                 String cdmServer = "160.45.63.175";
 249                 String cdmDB = "cdm_mt_moose";
 250                 String cdmUserName = "edit";
 251                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 252         }
 253
 254         public static ICdmDataSource cdm_redlist_moose_production(){
 255                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 256                 String cdmServer = "160.45.63.171";
 257                 String cdmDB = "cdm_production_rl_moose";
 258                 String cdmUserName = "edit";
 259                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 260         }
 261
 262         public static ICdmDataSource cdm_test_redlist_standardlist(){
 263                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 264                 String cdmServer = "160.45.63.175";
 265                 String cdmDB = "cdm_mt_standardliste";
 266                 String cdmUserName = "edit";
 267                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 268         }
 269
 270         public static ICdmDataSource cdm_test_redlist_germanSL(){
 271         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 272         String cdmServer = "160.45.63.175";
 273         String cdmDB = "cdm_rl_german_sl";
 274         String cdmUserName = "edit";
 275         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 276     }
 277
 278     public static ICdmDataSource cdm_germanSL_production(){
 279         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 280         String cdmServer = "160.45.63.171";
 281         String cdmDB = "cdm_production_rl_german_sl";
 282         String cdmUserName = "edit";
 283         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 284     }
 285
 286
 287         public static ICdmDataSource cdm_test_cyprus(){
 288                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 289                 String cdmServer = "160.45.63.175";
 290                 String cdmDB = "cdm_cyprus";
 291                 String cdmUserName = "edit";
 292                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 293         }
 294
 295         public static ICdmDataSource cdm_cyprus_production(){
 296                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 297                 String cdmServer = "160.45.63.171";
 298                 String cdmDB = "cdm_production_cyprus";
 299                 String cdmUserName = "edit";
 300                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 301         }
 302
 303     public static ICdmDataSource cdm_production_flora_cuba(){
 304         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 305         String cdmServer = "160.45.63.171";
 306         String cdmDB = "cdm_production_flora_cuba";
 307         String cdmUserName = "edit";
 308         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 309     }
 310
 311     public static ICdmDataSource cdm_greece_checklist_production(){
 312         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 313         String cdmServer = "160.45.63.171";
 314         String cdmDB = "cdm_production_flora_greece";
 315         String cdmUserName = "edit";
 316         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 317     }
 318
 319     public static ICdmDataSource cdm_mexico_rubiaceae_production(){
 320         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 321         String cdmServer = "160.45.63.171";
 322         String cdmDB = "cdm_production_rubiaceae_mexico";
 323         String cdmUserName = "edit";
 324         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 325     }
 326
 327     public static ICdmDataSource cdm_bogota_production(){
 328         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 329         String cdmServer = "160.45.63.171";
 330         String cdmDB = "cdm_production_flora_bogota";
 331         String cdmUserName = "edit";
 332         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 333     }
 334
 335         public static ICdmDataSource cdm_cyprus_production_tunnel(){
 336                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 337                 String cdmServer = "127.0.0.1";
 338                 int port = 13306;
 339                 String cdmDB = "cdm_production_cyprus";
 340                 String cdmUserName = "edit";
 341                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 342         }
 343
 344 //      public static ICdmDataSource cdm_cyprus_dev_tunnel(){
 345 //              DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 346 //              String cdmServer = "127.0.0.1";
 347 //              int port = 13306;
 348 //              String cdmDB = "cdm_cyprus";
 349 //              String cdmUserName = "edit";
 350 //              return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 351 //      }
 352
 353         public static ICdmDataSource cdm_campanulaceae_production(){
 354                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 355                 String cdmServer = "160.45.63.171";
 356                 String cdmDB = "cdm_production_campanulaceae";
 357                 String cdmUserName = "edit";
 358                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 359         }
 360
 361         public static ICdmDataSource cdm_local_portal_test(){
 362                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 363                 String cdmServer = "127.0.0.1";
 364                 String cdmDB = "cdm_portal_test";
 365                 String cdmUserName = "edit";
 366                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 367         }
 368
 369         public static ICdmDataSource cdm_local_portal_test2(){
 370                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 371                 String cdmServer = "127.0.0.1";
 372                 String cdmDB = "cdm_portal_test2";
 373                 String cdmUserName = "edit";
 374                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 375         }
 376
 377         public static ICdmDataSource cdm_local_cichorieae(){
 378                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 379                 String cdmServer = "127.0.0.1";
 380                 String cdmDB = "cdm_edit_cichorieae";
 381                 String cdmUserName = "edit";
 382                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 383         }
 384
 385
 386
 387         public static ICdmDataSource cdm_local_palmae(){
 388                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 389                 String cdmServer = "127.0.0.1";
 390                 String cdmDB = "cdm_edit_caryo";
 391                 String cdmUserName = "edit";
 392                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 393         }
 394
 395     public static ICdmDataSource cdm_local_cuba(){
 396         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 397         String cdmServer = "127.0.0.1";
 398         String cdmDB = "cdm_local_flora_cuba";
 399         String cdmUserName = "edit";
 400         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 401     }
 402
 403         public static ICdmDataSource cdm_local_caryo(){
 404                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 405                 String cdmServer = "127.0.0.1";
 406                 String cdmDB = "cdm_local_caryophyllales";
 407                 String cdmUserName = "root";
 408                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 409         }
 410
 411         public static ICdmDataSource cdm_test_globis(){
 412                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 413                 String cdmServer = "160.45.63.175";
 414                 String cdmDB = "cdm_edit_globis";
 415                 String cdmUserName = "edit";
 416                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 417         }
 418
 419     public static ICdmDataSource cdm_local_edaphobase(){
 420         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 421         String cdmServer = "127.0.0.1";
 422         String cdmDB = "edaphobase";
 423         String cdmUserName = "edit";
 424         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 425     }
 426
 427     public static ICdmDataSource cdm_postgres_edaphobase(){
 428         DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 429         String cdmServer = "130.133.70.26";
 430         String cdmDB = "cdm_edaphobase";
 431         String cdmUserName = "edaphobase";
 432         int port = 5433;
 433         return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 434     }
 435
 436     public static ICdmDataSource cdm_test_postgres_edaphobase(){
 437         DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 438         String cdmServer = "160.45.63.175";
 439         String cdmDB = "cdm_edaphobase";
 440         String cdmUserName = "edaphobase";
 441         int port = 5432;
 442         return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 443     }
 444
 445     public static ICdmDataSource cdm_test_postgres__ssh_edaphobase(){
 446         DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 447         String cdmServer = "localhost";
 448         String cdmDB = "cdm_edaphobase";
 449         String cdmUserName = "edaphobase";
 450         int port = 13306;
 451         return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 452     }
 453
 454     public static ICdmDataSource cdm_local_caryo_spp(){
 455         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 456         String cdmServer = "127.0.0.1";
 457         String cdmDB = "cdm_caryo_spp";
 458         String cdmUserName = "edit";
 459         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 460     }
 461
 462     public static ICdmDataSource cdm_local_caryo_spp2(){
 463         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 464         String cdmServer = "127.0.0.1";
 465         String cdmDB = "cdm_caryo_spp2";
 466         String cdmUserName = "edit";
 467         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 468     }
 469
 470         public static ICdmDataSource cdm_globis_production(){
 471                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 472                 String cdmServer = "160.45.63.171";
 473                 String cdmDB = "cdm_production_globis";
 474                 String cdmUserName = "edit";
 475                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 476         }
 477
 478         public static ICdmDataSource cdm_local_globis(){
 479                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 480                 String cdmServer = "127.0.0.1";
 481                 String cdmDB = "cdm_globis";
 482                 String cdmUserName = "edit";
 483                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 484         }
 485
 486         public static ICdmDataSource cdm_local_postgres_CdmTest(){
 487                 DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 488                 String cdmServer = "127.0.0.1";
 489                 String cdmDB = "CdmTest";
 490                 String cdmUserName = "edit";
 491                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 492         }
 493
 494
 495         public static ICdmDataSource NULL(){
 496                 return null;
 497         }
 498
 499
 500         public static ICdmDataSource localH2(){
 501                 return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
 502         }
 503
 504         public static ICdmDataSource localH2Edapho(){
 505         return CdmDataSource.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
 506     }
 507
 508         public static ICdmDataSource localH2Salvador(){
 509                 return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
 510         }
 511
 512         public static ICdmDataSource localH2Armeria(){
 513                 return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
 514         }
 515
 516         public static ICdmDataSource localH2Standardliste(){
 517                 return CdmDataSource.NewH2EmbeddedInstance("standardliste", "sa", "");
 518         }
 519
 520         public static ICdmDataSource localH2Cichorieae(){
 521                 return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
 522         }
 523
 524         public static ICdmDataSource localH2Palmae(){
 525                 return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
 526         }
 527
 528         public static ICdmDataSource localH2EuroMed(){
 529                 return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
 530         }
 531
 532         public static ICdmDataSource localH2Erms(){
 533                 return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
 534         }
 535
 536
 537     public static ICdmDataSource cdm_test_test1(){
 538         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 539         String cdmServer = "160.45.63.175";
 540         String cdmDB = "cdm_test1";
 541         String cdmUserName = "edit";
 542         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 543         }
 544     public static ICdmDataSource cdm_test_test2(){
 545         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 546         String cdmServer = "160.45.63.175";
 547         String cdmDB = "cdm_test2";
 548         String cdmUserName = "edit";
 549         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 550     }
 551     public static ICdmDataSource cdm_test_test3(){
 552         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 553         String cdmServer = "160.45.63.175";
 554         String cdmDB = "cdm_test3";
 555         String cdmUserName = "edit";
 556         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 557     }
 558
 559     public static ICdmDataSource cdm_test_phycobank(){
 560         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 561         String cdmServer = "160.45.63.175";
 562         String cdmDB = "cdm_phycobank";
 563         String cdmUserName = "edit";
 564         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 565     }
 566
 567         public static ICdmDataSource cdm_test_algaterra(){
 568                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 569                 String cdmServer = "160.45.63.175";
 570                 String cdmDB = "cdm_edit_algaterra";
 571                 String cdmUserName = "edit";
 572                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 573         }
 574
 575         public static ICdmDataSource cdm_algaterra_production(){
 576                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 577                 String cdmServer = "160.45.63.171";
 578                 String cdmDB = "cdm_production_algaterra";
 579                 String cdmUserName = "edit";
 580                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 581         }
 582
 583     public static ICdmDataSource cdm_test_salvador(){
 584         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 585         String cdmServer = "160.45.63.175";
 586         String cdmDB = "cdm_salvador";
 587         String cdmUserName = "edit";
 588         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 589     }
 590
 591     public static ICdmDataSource cdm_salvador_production(){
 592         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 593         String cdmServer = "160.45.63.171";
 594         String cdmDB = "cdm_production_salvador";
 595         String cdmUserName = "edit";
 596         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 597     }
 598
 599         public static ICdmDataSource cdm_test_cichorieae(){
 600                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 601                 String cdmServer = "160.45.63.175";
 602                 String cdmDB = "cdm_edit_cichorieae";
 603                 String cdmUserName = "edit";
 604                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 605         }
 606
 607         public static ICdmDataSource cdm_production_cichorieae(){
 608                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 609                 String cdmServer = "160.45.63.171";
 610                 String cdmDB = "cdm_production_cichorieae";
 611                 String cdmUserName = "edit";
 612                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 613         }
 614
 615         public static ICdmDataSource cdm_production_palmae(){
 616                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 617                 String cdmServer = "160.45.63.171";
 618                 String cdmDB = "cdm_production_palmae";
 619                 String cdmUserName = "edit";
 620                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 621         }
 622
 623         public static ICdmDataSource cdm_production_flora_deutschland(){
 624                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 625                 String cdmServer = "160.45.63.171";
 626                 String cdmDB = "cdm_production_rl_standardliste";
 627                 String cdmUserName = "edit";
 628                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 629         }
 630
 631         public static ICdmDataSource cdm_production_caryophyllales(){
 632                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 633                 String cdmServer = "160.45.63.171";
 634                 String cdmDB = "cdm_production_caryophyllales";
 635                 String cdmUserName = "edit";
 636                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 637         }
 638
 639         public static ICdmDataSource cdm_production_caryophyllales_spp(){
 640         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 641         String cdmServer = "160.45.63.171";
 642         String cdmDB = "cdm_production_caryophyllales_spp";
 643         String cdmUserName = "edit";
 644         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 645     }
 646
 647         public static ICdmDataSource cdm_production_caryophyllales_nepenthaceae(){
 648         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 649         String cdmServer = "160.45.63.171";
 650         String cdmDB = "cdm_production_caryo_nepenthaceae";
 651         String cdmUserName = "edit";
 652         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 653     }
 654
 655         public static ICdmDataSource cdm_local_caryophyllales_nepenthaceae(){
 656         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 657         String cdmServer = "127.0.0.1";
 658         String cdmDB = "cdm_local_caryo_nepenthaceae";
 659         String cdmUserName = "root";
 660         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 661     }
 662
 663         public static ICdmDataSource cdm_production_redlist_gefaesspflanzen(){
 664                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 665                 String cdmServer = "160.45.63.171";
 666                 String cdmDB = "cdm_production_rl_plantae";
 667                 String cdmUserName = "edit";
 668                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 669         }
 670
 671     public static ICdmDataSource cdm_production_edaphobase(){
 672         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 673         String cdmServer = "160.45.63.171";
 674         String cdmDB = "cdm_production_edaphobase";
 675         String cdmUserName = "edit";
 676         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 677     }
 678
 679         public static ICdmDataSource cdm_production_piB(String database){
 680                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 681                 String cdmServer = "160.45.63.171";
 682                 String cdmDB = "cdm_production_" + database + "_pilot";
 683                 String cdmUserName = "edit";
 684                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 685         }
 686
 687         public static ICdmDataSource cdm_local_piB(String database){
 688                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 689                 String cdmServer = "127.0.0.1";
 690                 String cdmDB = "piB_" + database;
 691                 String cdmUserName = "root";
 692                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 693         }
 694
 695    public static ICdmDataSource proibiosphere_chenopodium_local() {
 696         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 697         String cdmServer = "localhost";
 698         String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
 699         String cdmUserName = "root";
 700         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 701    }
 702
 703    public static ICdmDataSource proibiosphere_spiders_local() {
 704        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 705        String cdmServer = "localhost";
 706        String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
 707        String cdmUserName = "root";
 708        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 709    }
 710
 711    public static ICdmDataSource cdm_test_pesi_fauna_europaea(){
 712        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 713        String cdmServer = "160.45.63.175";
 714        String cdmDB = "cdm_pesi_fauna_europaea";
 715        String cdmUserName = "edit";
 716        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 717    }
 718
 719
 720
 721         /**
 722          * initializes source
 723          * TODO only supports MySQL and PostgreSQL
 724          *
 725          * @param dbType
 726          * @param cdmServer
 727          * @param cdmDB
 728          * @param port
 729          * @param cdmUserName
 730          * @param pwd
 731          * @return
 732          */
 733         public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
 734                 //establish connection
 735                 pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
 736                 ICdmDataSource destination;
 737                 if(dbType.equals(DatabaseTypeEnum.MySQL)){
 738                         destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
 739                 } else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
 740                         destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
 741                 } else {
 742                         //TODO others
 743                         throw new RuntimeException("Unsupported DatabaseType");
 744                 }
 745                 return destination;
 746
 747         }
 748
 749
 750         /**
 751          * Accepts a string array and tries to find a method returning an ICdmDataSource with
 752          * the name of the given first string in the array
 753          *
 754          * @param args
 755          * @return
 756          */
 757         public static ICdmDataSource chooseDestination(String[] args) {
 758                 if(args == null) {
 759             return null;
 760         }
 761
 762                 if(args.length != 1) {
 763             return null;
 764         }
 765
 766                 String possibleDestination = args[0];
 767
 768                 Method[] methods = CdmDestinations.class.getMethods();
 769
 770                 for (Method method : methods){
 771                         if(method.getName().equals(possibleDestination)){
 772                                 try {
 773                                         return (ICdmDataSource) method.invoke(null, null);
 774                                 } catch (Exception e) {
 775                                         e.printStackTrace();
 776                                         throw new RuntimeException(e);
 777                                 }
 778                         }
 779                 }
 780                 return null;
 781         }
 782
 783 }
 784