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