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