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