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_mexico(){
 501         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 502         String cdmServer = "127.0.0.1";
 503         String cdmDB = "cdm_mexico";
 504         String cdmUserName = "edit";
 505         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 506     }
 507     public static ICdmDataSource cdm_local_mexico2(){
 508         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 509         String cdmServer = "127.0.0.1";
 510         String cdmDB = "cdm_mexico2";
 511         String cdmUserName = "edit";
 512         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 513     }
 514
 515         public static ICdmDataSource cdm_local_palmae(){
 516                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 517                 String cdmServer = "127.0.0.1";
 518                 String cdmDB = "cdm_edit_caryo";
 519                 String cdmUserName = "edit";
 520                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 521         }
 522
 523     public static ICdmDataSource cdm_local_cuba(){
 524         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 525         String cdmServer = "127.0.0.1";
 526         String cdmDB = "cdm_flora_cuba";
 527         String cdmUserName = "edit";
 528         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 529     }
 530
 531         public static ICdmDataSource cdm_local_caryo(){
 532                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 533                 String cdmServer = "127.0.0.1";
 534                 String cdmDB = "cdm_caryo_spp";
 535                 String cdmUserName = "edit";
 536                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 537         }
 538
 539         public static ICdmDataSource cdm_local_algaterranew(){
 540                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 541                 String cdmServer = "127.0.0.1";
 542                 String cdmDB = "cdm_production_algaterranew";
 543                 String cdmUserName = "root";
 544                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 545         }
 546
 547         public static ICdmDataSource cdm_test_globis(){
 548                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 549                 String cdmServer = "160.45.63.175";
 550                 String cdmDB = "cdm_edit_globis";
 551                 String cdmUserName = "edit";
 552                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 553         }
 554
 555     public static ICdmDataSource cdm_local_edaphobase(){
 556         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 557         String cdmServer = "127.0.0.1";
 558         String cdmDB = "edaphobase";
 559         String cdmUserName = "edit";
 560         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 561     }
 562
 563     public static ICdmDataSource cdm_postgres_edaphobase(){
 564         DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 565         String cdmServer = "130.133.70.26";
 566         String cdmDB = "cdm_edaphobase";
 567         String cdmUserName = "edaphobase";
 568         int port = 5433;
 569         return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 570     }
 571
 572     public static ICdmDataSource cdm_test_postgres_edaphobase(){
 573         DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 574         String cdmServer = "160.45.63.175";
 575         String cdmDB = "cdm_edaphobase";
 576         String cdmUserName = "edaphobase";
 577         int port = 5432;
 578         return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 579     }
 580
 581     public static ICdmDataSource cdm_test_postgres__ssh_edaphobase(){
 582         DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 583         String cdmServer = "localhost";
 584         String cdmDB = "cdm_edaphobase";
 585         String cdmUserName = "edaphobase";
 586         int port = 13306;
 587         return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 588     }
 589
 590     public static ICdmDataSource cdm_local_caryo_spp(){
 591         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 592         String cdmServer = "127.0.0.1";
 593         String cdmDB = "cdm_caryo_spp";
 594         String cdmUserName = "edit";
 595         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 596     }
 597
 598     public static ICdmDataSource cdm_local_caryo_spp2(){
 599         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 600         String cdmServer = "127.0.0.1";
 601         String cdmDB = "cdm_caryo_spp2";
 602         String cdmUserName = "edit";
 603         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 604     }
 605
 606         public static ICdmDataSource cdm_production_globis(){
 607                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 608                 String cdmServer = "160.45.63.171";
 609                 String cdmDB = "cdm_production_globis";
 610                 String cdmUserName = "edit";
 611                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 612         }
 613
 614         public static ICdmDataSource cdm_local_globis(){
 615                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 616                 String cdmServer = "127.0.0.1";
 617                 String cdmDB = "cdm_globis";
 618                 String cdmUserName = "edit";
 619                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 620         }
 621
 622         public static ICdmDataSource cdm_local_postgres_CdmTest(){
 623                 DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 624                 String cdmServer = "127.0.0.1";
 625                 String cdmDB = "CdmTest";
 626                 String cdmUserName = "edit";
 627                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 628         }
 629
 630
 631         public static ICdmDataSource localH2(){
 632                 return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
 633         }
 634
 635         public static ICdmDataSource localH2Edapho(){
 636         return CdmDataSource.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
 637     }
 638
 639         public static ICdmDataSource localH2Salvador(){
 640                 return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
 641         }
 642
 643         public static ICdmDataSource localH2Armeria(){
 644                 return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
 645         }
 646
 647         public static ICdmDataSource localH2Standardliste(){
 648                 return CdmDataSource.NewH2EmbeddedInstance("standardliste", "sa", "");
 649         }
 650
 651         public static ICdmDataSource localH2Cichorieae(){
 652                 return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
 653         }
 654
 655         public static ICdmDataSource localH2Palmae(){
 656                 return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
 657         }
 658
 659         public static ICdmDataSource localH2EuroMed(){
 660                 return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
 661         }
 662
 663         public static ICdmDataSource localH2Erms(){
 664                 return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
 665         }
 666
 667
 668     public static ICdmDataSource cdm_test_test1(){
 669         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 670         String cdmServer = "160.45.63.175";
 671         String cdmDB = "cdm_test1";
 672         String cdmUserName = "edit";
 673         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 674         }
 675     public static ICdmDataSource cdm_test_test2(){
 676         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 677         String cdmServer = "160.45.63.175";
 678         String cdmDB = "cdm_test2";
 679         String cdmUserName = "edit";
 680         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 681     }
 682     public static ICdmDataSource cdm_test_test3(){
 683         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 684         String cdmServer = "160.45.63.175";
 685         String cdmDB = "cdm_test3";
 686         String cdmUserName = "edit";
 687         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 688     }
 689
 690     public static ICdmDataSource cdm_test_phycobank(){
 691         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 692         String cdmServer = "160.45.63.175";
 693         String cdmDB = "cdm_phycobank";
 694         String cdmUserName = "edit";
 695         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 696     }
 697
 698         public static ICdmDataSource cdm_test_algaterra(){
 699                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 700                 String cdmServer = "160.45.63.175";
 701                 String cdmDB = "cdm_edit_algaterra";
 702                 String cdmUserName = "edit";
 703                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 704         }
 705
 706         public static ICdmDataSource cdm_algaterra_production(){
 707                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 708                 String cdmServer = "160.45.63.171";
 709                 String cdmDB = "cdm_production_algaterra";
 710                 String cdmUserName = "edit";
 711                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 712         }
 713
 714     public static ICdmDataSource cdm_test_salvador(){
 715         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 716         String cdmServer = "160.45.63.175";
 717         String cdmDB = "cdm_salvador";
 718         String cdmUserName = "edit";
 719         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 720     }
 721
 722     public static ICdmDataSource cdm_production_salvador(){
 723         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 724         String cdmServer = "160.45.63.171";
 725         String cdmDB = "cdm_production_salvador";
 726         String cdmUserName = "edit";
 727         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 728     }
 729
 730         public static ICdmDataSource cdm_test_cichorieae(){
 731                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 732                 String cdmServer = "160.45.63.175";
 733                 String cdmDB = "cdm_edit_cichorieae";
 734                 String cdmUserName = "edit";
 735                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 736         }
 737
 738         public static ICdmDataSource cdm_test_caryo_spp(){
 739         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 740         String cdmServer = "160.45.63.175";
 741         String cdmDB = "cdm_caryo_spp";
 742         String cdmUserName = "edit";
 743         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 744     }
 745
 746         public static ICdmDataSource cdm_production_cichorieae(){
 747                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 748                 String cdmServer = "160.45.63.171";
 749                 String cdmDB = "cdm_production_cichorieae";
 750                 String cdmUserName = "edit";
 751                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 752         }
 753
 754         public static ICdmDataSource cdm_production_palmae(){
 755                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 756                 String cdmServer = "160.45.63.171";
 757                 String cdmDB = "cdm_production_palmae";
 758                 String cdmUserName = "edit";
 759                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 760         }
 761
 762         public static ICdmDataSource cdm_production_flora_deutschland(){
 763                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 764                 String cdmServer = "160.45.63.171";
 765                 String cdmDB = "cdm_production_rl_standardliste";
 766                 String cdmUserName = "edit";
 767                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 768         }
 769
 770         public static ICdmDataSource cdm_production_caryophyllales_genus(){
 771                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 772                 String cdmServer = "160.45.63.171";
 773                 String cdmDB = "cdm_production_caryophyllales";
 774                 String cdmUserName = "edit";
 775                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 776         }
 777
 778         public static ICdmDataSource cdm_production_caryophyllales_spp(){
 779         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 780         String cdmServer = "160.45.63.171";
 781         String cdmDB = "cdm_production_caryophyllales_spp";
 782         String cdmUserName = "edit";
 783         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 784     }
 785
 786         public static ICdmDataSource cdm_production_caryophyllales_nepenthaceae(){
 787         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 788         String cdmServer = "160.45.63.171";
 789         String cdmDB = "cdm_production_caryo_nepenthaceae";
 790         String cdmUserName = "edit";
 791         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 792     }
 793
 794         public static ICdmDataSource cdm_local_caryophyllales_nepenthaceae(){
 795         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 796         String cdmServer = "127.0.0.1";
 797         String cdmDB = "cdm_local_caryo_nepenthaceae";
 798         String cdmUserName = "root";
 799         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 800     }
 801
 802         public static ICdmDataSource cdm_production_redlist_gefaesspflanzen(){
 803                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 804                 String cdmServer = "160.45.63.171";
 805                 String cdmDB = "cdm_production_rl_plantae";
 806                 String cdmUserName = "edit";
 807                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 808         }
 809
 810     public static ICdmDataSource cdm_production_edaphobase(){
 811         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 812         String cdmServer = "160.45.63.171";
 813         String cdmDB = "cdm_production_edaphobase";
 814         String cdmUserName = "edit";
 815         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 816     }
 817
 818         public static ICdmDataSource cdm_production_piB(String database){
 819                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 820                 String cdmServer = "160.45.63.171";
 821                 String cdmDB = "cdm_production_" + database + "_pilot";
 822                 String cdmUserName = "edit";
 823                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 824         }
 825
 826         public static ICdmDataSource cdm_local_piB(String database){
 827                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 828                 String cdmServer = "127.0.0.1";
 829                 String cdmDB = "piB_" + database;
 830                 String cdmUserName = "root";
 831                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 832         }
 833
 834    public static ICdmDataSource cdm_local_proibiosphere_chenopodium() {
 835         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 836         String cdmServer = "localhost";
 837         String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
 838         String cdmUserName = "root";
 839         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 840    }
 841
 842    public static ICdmDataSource cdm_local_proibiosphere_spiders() {
 843        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 844        String cdmServer = "localhost";
 845        String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
 846        String cdmUserName = "root";
 847        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 848    }
 849
 850    public static ICdmDataSource cdm_test_pesi_fauna_europaea(){
 851        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 852        String cdmServer = "160.45.63.175";
 853        String cdmDB = "cdm_pesi_fauna_europaea";
 854        String cdmUserName = "edit";
 855        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 856    }
 857
 858
 859
 860         /**
 861          * initializes source
 862          * TODO only supports MySQL and PostgreSQL
 863          *
 864          * @param dbType
 865          * @param cdmServer
 866          * @param cdmDB
 867          * @param port
 868          * @param cdmUserName
 869          * @param pwd
 870          * @return
 871          */
 872         public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
 873                 //establish connection
 874                 pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
 875                 ICdmDataSource destination;
 876                 if(dbType.equals(DatabaseTypeEnum.MySQL)){
 877                         destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
 878                 } else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
 879                         destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
 880                 } else {
 881                         //TODO others
 882                         throw new RuntimeException("Unsupported DatabaseType");
 883                 }
 884                 return destination;
 885
 886         }
 887
 888
 889         /**
 890          * Accepts a string array and tries to find a method returning an ICdmDataSource with
 891          * the name of the given first string in the array
 892          *
 893          * @param args
 894          * @return
 895          */
 896         public static ICdmDataSource chooseDestination(String[] args) {
 897                 if(args == null) {
 898             return null;
 899         }
 900
 901                 if(args.length != 1) {
 902             return null;
 903         }
 904
 905                 String possibleDestination = args[0];
 906
 907                 Method[] methods = CdmDestinations.class.getMethods();
 908
 909                 for (Method method : methods){
 910                         if(method.getName().equals(possibleDestination)){
 911                                 try {
 912                                         return (ICdmDataSource) method.invoke(null, null);
 913                                 } catch (Exception e) {
 914                                         e.printStackTrace();
 915                                         throw new RuntimeException(e);
 916                                 }
 917                         }
 918                 }
 919                 return null;
 920         }
 921
 922 }
 923