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