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