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.common.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_redlist_animalia_localhost(){
  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_animals";
  37         String cdmUserName = "edit";
  38         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  39     }
  40
  41         public static ICdmDataSource cdm_redlist_plant_localhost(){
  42                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  43                 String cdmServer = "localhost";
  44                 String cdmDB = "cdm_bfn_imports_plants";
  45                 String cdmUserName = "edit";
  46                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  47         }
  48
  49         public static ICdmDataSource cdm_redlist_lumbricidae(){
  50                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  51                 String cdmServer = "160.45.63.171";
  52                 String cdmDB = "cdm_production_rl_lumbricidae";
  53                 String cdmUserName = "edit";
  54                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  55         }
  56
  57         public static ICdmDataSource cdm_testDB_localhost(){
  58                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  59                 String cdmServer = "localhost";
  60                 String cdmDB = "testDB";
  61                 String cdmUserName = "root";
  62                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  63         }
  64
  65         public static ICdmDataSource cdm_test_useSummary(){
  66                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  67                 String cdmServer = "localhost";
  68                 String cdmDB = "palmae_2011_07_17";
  69                 String cdmUserName = "root";
  70                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  71         }
  72
  73         public static ICdmDataSource cdm_test_local_mysql(){
  74                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  75                 String cdmServer = "127.0.0.1";
  76                 String cdmDB = "cdm_test";
  77                 String cdmUserName = "root";
  78                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  79         }
  80
  81
  82         public static ICdmDataSource cdm_test_local_mysql_moose(){
  83                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  84                 String cdmServer = "127.0.0.1";
  85                 String cdmDB = "moose";
  86                 String cdmUserName = "edit";
  87                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  88         }
  89
  90         public static ICdmDataSource cdm_test_local_mysql_standardliste(){
  91                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  92                 String cdmServer = "127.0.0.1";
  93                 String cdmDB = "standardliste";
  94                 String cdmUserName = "root";
  95                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  96         }
  97
  98
  99         public static ICdmDataSource cdm_test_local_mysql_dwca(){
 100                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 101                 String cdmServer = "127.0.0.1";
 102                 String cdmDB = "dwca";
 103                 String cdmUserName = "edit";
 104                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 105         }
 106
 107
 108         public static ICdmDataSource cdm_test_local_mysql_fdac(){
 109                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 110                 String cdmServer = "127.0.0.1";
 111                 String cdmDB = "fdac";
 112                 String cdmUserName = "edit";
 113                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 114         }
 115
 116         public static ICdmDataSource cdm_test_local_mysql_test(){
 117                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 118                 String cdmServer = "127.0.0.1";
 119                 String cdmDB = "test";
 120                 String cdmUserName = "edit";     //root on pesiimport2
 121                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 122         }
 123
 124         public static ICdmDataSource cdm_test_local_euromed(){
 125                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 126                 String cdmServer = "127.0.0.1";
 127                 String cdmDB = "euroMed";
 128                 String cdmUserName = "root";
 129                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 130         }
 131
 132         public static ICdmDataSource cdm_test_local_euromed2(){
 133                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 134                 String cdmServer = "127.0.0.1";
 135                 String cdmDB = "euroMed2";
 136                 String cdmUserName = "root";
 137                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 138         }
 139         public static ICdmDataSource cdm_test_local_euromed3(){
 140                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 141                 String cdmServer = "127.0.0.1";
 142                 String cdmDB = "euroMed3";
 143                 String cdmUserName = "root";
 144                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 145         }
 146
 147     public static ICdmDataSource cdm_test_col(){
 148         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 149         String cdmServer = "160.45.63.175";
 150         String cdmDB = "cdm_col";
 151         String cdmUserName = "edit";
 152         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 153     }
 154
 155     public static ICdmDataSource cdm_test_col2(){
 156         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 157         String cdmServer = "160.45.63.175";
 158         String cdmDB = "cdm_col2";
 159         String cdmUserName = "edit";
 160         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 161     }
 162
 163     public static ICdmDataSource cdm_col_local(){
 164         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 165         String cdmServer = "127.0.0.1";
 166         String cdmDB = "col_test";
 167         String cdmUserName = "edit";
 168         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 169     }
 170
 171     public static ICdmDataSource cdm_col2_local(){
 172         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 173         String cdmServer = "127.0.0.1";
 174         String cdmDB = "col_test2";
 175         String cdmUserName = "edit";
 176         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 177     }
 178
 179
 180         public static ICdmDataSource cdm_local_EDITImport(){
 181                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 182                 String cdmServer = "127.0.0.1";
 183                 String cdmDB = "EDITImport";
 184                 String cdmUserName = "edit";     //root on pesiimport2
 185                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 186         }
 187
 188         public static ICdmDataSource cdm_test_euroMed(){
 189                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 190                 String cdmServer = "160.45.63.175";
 191                 String cdmDB = "cdm_test_euromed";
 192                 String cdmUserName = "edit";
 193                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 194         }
 195
 196         public static ICdmDataSource cdm_pesi_euromed(){
 197                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 198                 String cdmServer = "160.45.63.175";
 199                 String cdmDB = "cdm_pesi_euromed";
 200                 String cdmUserName = "edit";
 201                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 202         }
 203
 204         public static ICdmDataSource cdm_corvidae_dev(){
 205                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 206                 String cdmServer = "160.45.63.175";
 207                 String cdmDB = "cdm_corvidae";
 208                 String cdmUserName = "edit";
 209                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 210         }
 211
 212         public static ICdmDataSource cdm_ildis_dev(){
 213                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 214                 String cdmServer = "160.45.63.175";
 215                 String cdmDB = "cdm_edit_ildis";
 216                 String cdmUserName = "edit";
 217                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 218         }
 219
 220 //
 221 //      public static ICdmDataSource cdm_ildis_production(){
 222 //              DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 223 //              String cdmServer = "160.45.63.171";
 224 //              String cdmDB = "cdm_edit_ildis";
 225 //              String cdmUserName = "edit";
 226 //              return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 227 //      }
 228
 229
 230         public static ICdmDataSource cdm_redlist_moose_dev(){
 231                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 232                 String cdmServer = "160.45.63.175";
 233                 String cdmDB = "cdm_mt_moose";
 234                 String cdmUserName = "edit";
 235                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 236         }
 237
 238         public static ICdmDataSource cdm_redlist_moose_production(){
 239                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 240                 String cdmServer = "160.45.63.171";
 241                 String cdmDB = "cdm_production_rl_moose";
 242                 String cdmUserName = "edit";
 243                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 244         }
 245
 246         public static ICdmDataSource cdm_redlist_standardlist_dev(){
 247                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 248                 String cdmServer = "160.45.63.175";
 249                 String cdmDB = "cdm_mt_standardliste";
 250                 String cdmUserName = "edit";
 251                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 252         }
 253
 254         public static ICdmDataSource cdm_cyprus_dev(){
 255                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 256                 String cdmServer = "160.45.63.175";
 257                 String cdmDB = "cdm_cyprus";
 258                 String cdmUserName = "edit";
 259                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 260         }
 261
 262         public static ICdmDataSource cdm_cyprus_production(){
 263                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 264                 String cdmServer = "160.45.63.171";
 265                 String cdmDB = "cdm_production_cyprus";
 266                 String cdmUserName = "edit";
 267                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 268         }
 269
 270            public static ICdmDataSource cdm_cuba_production(){
 271                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 272                 String cdmServer = "160.45.63.171";
 273                 String cdmDB = "cdm_production_flora_cuba";
 274                 String cdmUserName = "edit";
 275                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 276             }
 277
 278         public static ICdmDataSource cdm_cyprus_production_tunnel(){
 279                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 280                 String cdmServer = "127.0.0.1";
 281                 int port = 13306;
 282                 String cdmDB = "cdm_production_cyprus";
 283                 String cdmUserName = "edit";
 284                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 285         }
 286
 287         public static ICdmDataSource cdm_cyprus_dev_tunnel(){
 288                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 289                 String cdmServer = "127.0.0.1";
 290                 int port = 13306;
 291                 String cdmDB = "cdm_cyprus";
 292                 String cdmUserName = "edit";
 293                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 294         }
 295
 296         public static ICdmDataSource cdm_campanulaceae_production(){
 297                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 298                 String cdmServer = "160.45.63.171";
 299                 String cdmDB = "cdm_production_campanulaceae";
 300                 String cdmUserName = "edit";
 301                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 302         }
 303
 304         public static ICdmDataSource cdm_flora_malesiana_preview(){
 305                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 306                 String cdmServer = "160.45.63.175";
 307                 String cdmDB = "cdm_edit_flora_malesiana";
 308                 String cdmUserName = "edit";
 309                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 310         }
 311
 312         public static ICdmDataSource cdm_flora_malesiana_production(){
 313                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 314                 String cdmServer = "160.45.63.171";
 315                 String cdmDB = "cdm_production_flora_malesiana";
 316                 String cdmUserName = "edit";
 317                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 318         }
 319
 320         public static ICdmDataSource cdm_portal_test_localhost(){
 321                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 322                 String cdmServer = "127.0.0.1";
 323                 String cdmDB = "cdm_portal_test";
 324                 String cdmUserName = "edit";
 325                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 326         }
 327
 328         public static ICdmDataSource cdm_portal_test_localhost2(){
 329                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 330                 String cdmServer = "127.0.0.1";
 331                 String cdmDB = "cdm_portal_test2";
 332                 String cdmUserName = "edit";
 333                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 334         }
 335
 336         public static ICdmDataSource cdm_local_cichorieae(){
 337                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 338                 String cdmServer = "127.0.0.1";
 339                 String cdmDB = "cdm_edit_cichorieae";
 340                 String cdmUserName = "edit";
 341                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 342         }
 343
 344
 345
 346         public static ICdmDataSource cdm_local_palmae(){
 347                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 348                 String cdmServer = "127.0.0.1";
 349                 String cdmDB = "cdm_edit_caryo";
 350                 String cdmUserName = "edit";
 351                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 352         }
 353
 354         public static ICdmDataSource cdm_local_caryo(){
 355                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 356                 String cdmServer = "127.0.0.1";
 357                 String cdmDB = "cdm_local_caryophyllales";
 358                 String cdmUserName = "root";
 359                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 360         }
 361
 362         public static ICdmDataSource cdm_globis_dev(){
 363                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 364                 String cdmServer = "160.45.63.175";
 365                 String cdmDB = "cdm_edit_globis";
 366                 String cdmUserName = "edit";
 367                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 368         }
 369
 370     public static ICdmDataSource cdm_local_edaphobase(){
 371         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 372         String cdmServer = "127.0.0.1";
 373         String cdmDB = "edaphobase";
 374         String cdmUserName = "edit";
 375         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 376     }
 377
 378         public static ICdmDataSource cdm_globis_production(){
 379                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 380                 String cdmServer = "160.45.63.171";
 381                 String cdmDB = "cdm_production_globis";
 382                 String cdmUserName = "edit";
 383                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 384         }
 385
 386         public static ICdmDataSource cdm_local_globis(){
 387                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 388                 String cdmServer = "127.0.0.1";
 389                 String cdmDB = "cdm_globis";
 390                 String cdmUserName = "edit";
 391                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 392         }
 393
 394         public static ICdmDataSource cdm_local_postgres_CdmTest(){
 395                 DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 396                 String cdmServer = "127.0.0.1";
 397                 String cdmDB = "CdmTest";
 398                 String cdmUserName = "edit";
 399                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 400         }
 401
 402         public static ICdmDataSource cdm_local_tdwg2010(){
 403                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 404                 String cdmServer = "127.0.0.1";
 405                 String cdmDB = "cdm_tdwg2010";
 406                 String cdmUserName = "edit";
 407                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 408         }
 409
 410
 411         public static ICdmDataSource NULL(){
 412                 return null;
 413         }
 414
 415
 416         public static ICdmDataSource localH2(){
 417                 return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
 418         }
 419
 420         public static ICdmDataSource localH2Edapho(){
 421         return CdmDataSource.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
 422     }
 423
 424         public static ICdmDataSource localH2(String database, String username, String filePath){
 425                 return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
 426         }
 427
 428         public static ICdmDataSource localH2Salvador(){
 429                 return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
 430         }
 431
 432         public static ICdmDataSource localH2Armeria(){
 433                 return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
 434         }
 435
 436         public static ICdmDataSource localH2Standardliste(){
 437                 return CdmDataSource.NewH2EmbeddedInstance("standardliste", "sa", "");
 438         }
 439
 440         public static ICdmDataSource localH2Cichorieae(){
 441                 return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
 442         }
 443
 444         public static ICdmDataSource localH2Palmae(){
 445                 return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
 446         }
 447
 448         public static ICdmDataSource localH2EuroMed(){
 449                 return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
 450         }
 451
 452         public static ICdmDataSource localH2Erms(){
 453                 return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
 454         }
 455
 456
 457         public static ICdmDataSource cdm_algaterra_preview(){
 458                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 459                 String cdmServer = "160.45.63.175";
 460                 String cdmDB = "cdm_edit_algaterra";
 461                 String cdmUserName = "edit";
 462                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 463         }
 464
 465         public static ICdmDataSource cdm_algaterra_production(){
 466                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 467                 String cdmServer = "160.45.63.171";
 468                 String cdmDB = "cdm_production_algaterra";
 469                 String cdmUserName = "edit";
 470                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 471         }
 472
 473         public static ICdmDataSource cdm_edit_cichorieae_local_PG(){
 474                 DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 475                 String cdmServer = "127.0.0.1";
 476                 String cdmDB = "cdm_edit_cichorieae_a";
 477                 String cdmUserName = "edit";
 478                 int port = 15432;
 479                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 480         }
 481
 482         public static ICdmDataSource cdm_cichorieae_preview(){
 483                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 484                 String cdmServer = "160.45.63.175";
 485                 String cdmDB = "cdm_edit_cichorieae";
 486                 String cdmUserName = "edit";
 487                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 488         }
 489
 490         public static ICdmDataSource cdm_production_cichorieae(){
 491                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 492                 String cdmServer = "160.45.63.171";
 493 //              String cdmServer = "127.0.0.1";
 494                 String cdmDB = "cdm_production_cichorieae";
 495                 String cdmUserName = "edit";
 496                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 497         }
 498
 499         public static ICdmDataSource cdm_production_palmae(){
 500                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 501                 String cdmServer = "160.45.63.171";
 502                 String cdmDB = "cdm_production_palmae";
 503                 String cdmUserName = "edit";
 504                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 505         }
 506
 507         public static ICdmDataSource cdm_production_flora_deutschland(){
 508                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 509                 String cdmServer = "160.45.63.171";
 510                 String cdmDB = "cdm_production_rl_standardliste";
 511                 String cdmUserName = "edit";
 512                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 513         }
 514
 515         public static ICdmDataSource cdm_production_caryophyllales(){
 516                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 517                 String cdmServer = "160.45.63.171";
 518                 String cdmDB = "cdm_production_caryophyllales";
 519                 String cdmUserName = "edit";
 520                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 521         }
 522
 523
 524     public static ICdmDataSource cdm_production_edaphobase(){
 525         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 526         String cdmServer = "160.45.63.171";
 527         String cdmDB = "cdm_production_edaphobase";
 528         String cdmUserName = "edit";
 529         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 530     }
 531
 532
 533         public static ICdmDataSource cdm_production_diptera(){
 534                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 535                 String cdmServer = "160.45.63.171";
 536                 String cdmDB = "cdm_production_diptera";
 537                 String cdmUserName = "edit";
 538                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 539         }
 540
 541         public static ICdmDataSource cdm_edit_cichorieae_preview(){
 542                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 543                 String cdmServer = "127.0.0.1";
 544                 String cdmDB = "cdm_edit_cichorieae";
 545                 String cdmUserName = "edit";
 546                 int port = 13306;
 547                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 548         }
 549
 550         public static ICdmDataSource cdm_edit_cichorieae_preview_direct(){
 551                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 552                 String cdmServer = "160.45.63.175";
 553                 String cdmDB = "cdm_edit_cichorieae";
 554                 String cdmUserName = "edit";
 555                 int port = 3306;
 556                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 557         }
 558
 559         public static ICdmDataSource cdm_production_piB(String database){
 560                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 561                 String cdmServer = "160.45.63.171";
 562                 String cdmDB = "cdm_production_" + database + "_pilot";
 563                 String cdmUserName = "edit";
 564                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 565         }
 566
 567         public static ICdmDataSource cdm_local_piB(String database){
 568                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 569                 String cdmServer = "127.0.0.1";
 570                 String cdmDB = "piB_" + database;
 571                 String cdmUserName = "root";
 572                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 573         }
 574
 575         /**
 576      * patricia
 577      */
 578     public static ICdmDataSource mon_cdm() {
 579         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 580         String cdmServer = "localhost";
 581         String cdmDB = "cdm_local";
 582         String cdmUserName = "root";
 583         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 584     }
 585
 586    public static ICdmDataSource proibiosphere_chenopodium_local() {
 587         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 588         String cdmServer = "localhost";
 589         String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
 590         String cdmUserName = "root";
 591         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 592     }
 593
 594    public static ICdmDataSource proibiosphere_ants_local() {
 595        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 596        String cdmServer = "localhost";
 597        String cdmDB = "cdm_production_proibiosphere_ants_pilot";
 598        String cdmUserName = "root";
 599        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 600    }
 601
 602    public static ICdmDataSource proibiosphere_fungi_local() {
 603        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 604        String cdmServer = "localhost";
 605        String cdmDB = "cdm_production_proibiosphere_fungi_pilot";
 606        String cdmUserName = "root";
 607        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 608    }
 609
 610    public static ICdmDataSource proibiosphere_campylopus_local() {
 611        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 612        String cdmServer = "localhost";
 613        String cdmDB = "cdm_production_proibiosphere_campylopus_pilot";
 614        String cdmUserName = "root";
 615        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 616    }
 617
 618
 619    public static ICdmDataSource proibiosphere_eupolybothrus_local() {
 620        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 621        String cdmServer = "localhost";
 622        String cdmDB = "cdm_production_proibiosphere_eupolybothrus_pilot";
 623        String cdmUserName = "root";
 624        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 625    }
 626
 627    public static ICdmDataSource proibiosphere_spiders_local() {
 628        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 629        String cdmServer = "localhost";
 630        String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
 631        String cdmUserName = "root";
 632        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 633    }
 634
 635
 636
 637         /**
 638          * initializes source
 639          * TODO only supports MySQL and PostgreSQL
 640          *
 641          * @param dbType
 642          * @param cdmServer
 643          * @param cdmDB
 644          * @param port
 645          * @param cdmUserName
 646          * @param pwd
 647          * @return
 648          */
 649         public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
 650                 //establish connection
 651                 pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
 652                 ICdmDataSource destination;
 653                 if(dbType.equals(DatabaseTypeEnum.MySQL)){
 654                         destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
 655                 } else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
 656                         destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
 657                 } else {
 658                         //TODO others
 659                         throw new RuntimeException("Unsupported DatabaseType");
 660                 }
 661                 return destination;
 662
 663         }
 664
 665
 666         /**
 667          * Accepts a string array and tries to find a method returning an ICdmDataSource with
 668          * the name of the given first string in the array
 669          *
 670          * @param args
 671          * @return
 672          */
 673         public static ICdmDataSource chooseDestination(String[] args) {
 674                 if(args == null) {
 675             return null;
 676         }
 677
 678                 if(args.length != 1) {
 679             return null;
 680         }
 681
 682                 String possibleDestination = args[0];
 683
 684                 Method[] methods = CdmDestinations.class.getMethods();
 685
 686                 for (Method method : methods){
 687                         if(method.getName().equals(possibleDestination)){
 688                                 try {
 689                                         return (ICdmDataSource) method.invoke(null, null);
 690                                 } catch (Exception e) {
 691                                         e.printStackTrace();
 692                                         throw new RuntimeException(e);
 693                                 }
 694                         }
 695                 }
 696                 return null;
 697         }
 698
 699 }
 700