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