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