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.InvocationTargetException;
  13 import java.lang.reflect.Method;
  14
  15 import org.apache.log4j.Logger;
  16
  17 import eu.etaxonomy.cdm.common.AccountStore;
  18 import eu.etaxonomy.cdm.database.CdmDataSource;
  19 import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
  20 import eu.etaxonomy.cdm.database.ICdmDataSource;
  21
  22 public class CdmDestinations {
  23         @SuppressWarnings("unused")
  24         private static Logger logger = Logger.getLogger(CdmDestinations.class);
  25
  26         /**
  27          * Intended to be used for imports
  28          */
  29         public static ICdmDataSource import_a(){
  30                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  31                 String cdmServer = "localhost";
  32                 String cdmDB = "import_a";
  33                 String cdmUserName = "root";
  34                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  35         }
  36
  37         public static ICdmDataSource cdm_test_alex(){
  38                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  39                 String cdmServer = "192.168.2.10";
  40                 String cdmDB = "cdm_production_palmae";
  41                 String cdmUserName = "edit";
  42                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  43         }
  44
  45
  46         public static ICdmDataSource cdm_test_useSummary(){
  47                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  48                 String cdmServer = "localhost";
  49                 String cdmDB = "palmae_2011_07_17";
  50                 String cdmUserName = "root";
  51                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  52         }
  53
  54         public static ICdmDataSource cdm_test_local_mysql(){
  55                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  56                 String cdmServer = "127.0.0.1";
  57                 String cdmDB = "cdm_test";
  58                 String cdmUserName = "edit";
  59                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  60         }
  61
  62
  63         public static ICdmDataSource cdm_test_local_mysql_moose(){
  64                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  65                 String cdmServer = "127.0.0.1";
  66                 String cdmDB = "moose";
  67                 String cdmUserName = "root";
  68                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  69         }
  70
  71         public static ICdmDataSource cdm_test_local_mysql_standardliste(){
  72                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  73                 String cdmServer = "127.0.0.1";
  74                 String cdmDB = "standardliste";
  75                 String cdmUserName = "root";
  76                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  77         }
  78
  79         public static ICdmDataSource cdm_test_local_mysql_standardliste2(){
  80                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  81                 String cdmServer = "127.0.0.1";
  82                 String cdmDB = "standardliste2";
  83                 String cdmUserName = "root";
  84                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  85         }
  86
  87         public static ICdmDataSource cdm_test_local_mysql_dwca(){
  88                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  89                 String cdmServer = "127.0.0.1";
  90                 String cdmDB = "dwca";
  91                 String cdmUserName = "edit";
  92                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
  93         }
  94
  95
  96         public static ICdmDataSource cdm_test_local_mysql_fdac(){
  97                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  98                 String cdmServer = "127.0.0.1";
  99                 String cdmDB = "fdac";
 100                 String cdmUserName = "edit";
 101                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 102         }
 103
 104         public static ICdmDataSource cdm_test_local_mysql_test(){
 105                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 106                 String cdmServer = "127.0.0.1";
 107                 String cdmDB = "test";
 108                 String cdmUserName = "root";
 109                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 110         }
 111
 112         public static ICdmDataSource cdm_corvidae_dev(){
 113                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 114                 String cdmServer = "160.45.63.201";
 115                 String cdmDB = "cdm_corvidae";
 116                 String cdmUserName = "edit";
 117                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 118         }
 119
 120         public static ICdmDataSource cdm_ildis_dev(){
 121                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 122                 String cdmServer = "160.45.63.201";
 123                 String cdmDB = "cdm_edit_ildis";
 124                 String cdmUserName = "edit";
 125                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 126         }
 127
 128 //
 129 //      public static ICdmDataSource cdm_ildis_production(){
 130 //              DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 131 //              String cdmServer = "160.45.63.171";
 132 //              String cdmDB = "cdm_edit_ildis";
 133 //              String cdmUserName = "edit";
 134 //              return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 135 //      }
 136
 137
 138         public static ICdmDataSource cdm_redlist_moose_dev(){
 139                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 140                 String cdmServer = "160.45.63.201";
 141                 String cdmDB = "cdm_mt_moose";
 142                 String cdmUserName = "edit";
 143                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 144         }
 145
 146         public static ICdmDataSource cdm_redlist_standardlist_dev(){
 147                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 148                 String cdmServer = "160.45.63.201";
 149                 String cdmDB = "cdm_mt_standardliste";
 150                 String cdmUserName = "edit";
 151                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 152         }
 153
 154         public static ICdmDataSource cdm_cyprus_dev(){
 155                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 156                 String cdmServer = "160.45.63.201";
 157                 String cdmDB = "cdm_cyprus";
 158                 String cdmUserName = "edit";
 159                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 160         }
 161
 162         public static ICdmDataSource cdm_cyprus_production(){
 163                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 164                 String cdmServer = "160.45.63.171";
 165                 String cdmDB = "cdm_production_cyprus";
 166                 String cdmUserName = "edit";
 167                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 168         }
 169
 170         public static ICdmDataSource cdm_cyprus_production_tunnel(){
 171                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 172                 String cdmServer = "127.0.0.1";
 173                 int port = 13306;
 174                 String cdmDB = "cdm_production_cyprus";
 175                 String cdmUserName = "edit";
 176                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 177         }
 178
 179         public static ICdmDataSource cdm_cyprus_dev_tunnel(){
 180                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 181                 String cdmServer = "127.0.0.1";
 182                 int port = 13306;
 183                 String cdmDB = "cdm_cyprus";
 184                 String cdmUserName = "edit";
 185                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 186         }
 187
 188         public static ICdmDataSource cdm_campanulaceae_production(){
 189                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 190                 String cdmServer = "160.45.63.171";
 191                 String cdmDB = "cdm_production_campanulaceae";
 192                 String cdmUserName = "edit";
 193                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 194         }
 195
 196         public static ICdmDataSource cdm_flora_malesiana_preview(){
 197                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 198                 String cdmServer = "160.45.63.201";
 199                 String cdmDB = "cdm_edit_flora_malesiana";
 200                 String cdmUserName = "edit";
 201                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 202         }
 203
 204         public static ICdmDataSource cdm_flora_malesiana_production(){
 205                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 206                 String cdmServer = "160.45.63.171";
 207                 String cdmDB = "cdm_production_flora_malesiana";
 208                 String cdmUserName = "edit";
 209                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 210         }
 211
 212         public static ICdmDataSource cdm_flora_central_africa_preview(){
 213                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 214                 String cdmServer = "160.45.63.201";
 215                 String cdmDB = "cdm_edit_flora_central_africa";
 216                 String cdmUserName = "edit";
 217                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 218         }
 219
 220         public static ICdmDataSource cdm_flora_central_africa_production(){
 221                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 222                 String cdmServer = "160.45.63.171";
 223                 String cdmDB = "cdm_production_flora_central_africa";
 224                 String cdmUserName = "edit";
 225                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 226         }
 227
 228         public static ICdmDataSource cdm_pesi_euroMed(){
 229                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 230                 String cdmServer = "192.168.2.10";
 231                 String cdmDB = "cdm_pesi_euroMed";
 232                 String cdmUserName = "edit";
 233                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 234         }
 235
 236         public static ICdmDataSource cdm_pesi_all(){
 237                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 238                 String cdmServer = "192.168.2.10";
 239                 String cdmDB = "cdm_pesi_all";
 240                 String cdmUserName = "edit";
 241                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 242         }
 243
 244         public static ICdmDataSource cdm_portal_test_localhost(){
 245                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 246                 String cdmServer = "127.0.0.1";
 247                 String cdmDB = "cdm_portal_test";
 248                 String cdmUserName = "edit";
 249                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 250         }
 251
 252         public static ICdmDataSource cdm_portal_test_localhost2(){
 253                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 254                 String cdmServer = "127.0.0.1";
 255                 String cdmDB = "cdm_portal_test2";
 256                 String cdmUserName = "edit";
 257                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 258         }
 259
 260         public static ICdmDataSource cdm_local_cichorieae(){
 261                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 262                 String cdmServer = "127.0.0.1";
 263                 String cdmDB = "cdm_edit_cichorieae";
 264                 String cdmUserName = "edit";
 265                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 266         }
 267
 268         public static ICdmDataSource cdm_local_dipera(){
 269                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 270                 String cdmServer = "127.0.0.1";
 271                 String cdmDB = "cdm_edit_diptera";
 272                 String cdmUserName = "edit";
 273                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 274         }
 275
 276         public static ICdmDataSource cdm_local_palmae(){
 277                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 278                 String cdmServer = "127.0.0.1";
 279                 String cdmDB = "cdm_edit_palmae";
 280                 String cdmUserName = "edit";
 281                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 282         }
 283
 284         public static ICdmDataSource cdm_globis_dev(){
 285                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 286                 String cdmServer = "160.45.63.201";
 287                 String cdmDB = "cdm_edit_globis";
 288                 String cdmUserName = "edit";
 289                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 290         }
 291
 292         public static ICdmDataSource cdm_local_globis(){
 293                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 294                 String cdmServer = "127.0.0.1";
 295                 String cdmDB = "cdm_globis";
 296                 String cdmUserName = "edit";
 297                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 298         }
 299
 300         public static ICdmDataSource cdm_local_postgres_CdmTest(){
 301                 DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 302                 String cdmServer = "127.0.0.1";
 303                 String cdmDB = "CdmTest";
 304                 String cdmUserName = "edit";
 305                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 306         }
 307
 308         public static ICdmDataSource cdm_local_tdwg2010(){
 309                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 310                 String cdmServer = "127.0.0.1";
 311                 String cdmDB = "cdm_tdwg2010";
 312                 String cdmUserName = "edit";
 313                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 314         }
 315
 316
 317         public static ICdmDataSource NULL(){
 318                 return null;
 319         }
 320
 321
 322         public static ICdmDataSource localH2(){
 323                 return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
 324         }
 325
 326         public static ICdmDataSource localH2(String database, String username, String filePath){
 327                 return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
 328         }
 329
 330         public static ICdmDataSource localH2Salvador(){
 331                 return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
 332         }
 333
 334         public static ICdmDataSource localH2Diptera(){
 335                 return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");
 336         }
 337
 338
 339         public static ICdmDataSource localH2Cichorieae(){
 340                 return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
 341         }
 342
 343         public static ICdmDataSource localH2Palmae(){
 344                 return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
 345         }
 346
 347         public static ICdmDataSource localH2EuroMed(){
 348                 return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
 349         }
 350
 351         public static ICdmDataSource localH2Erms(){
 352                 return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
 353         }
 354
 355         public static ICdmDataSource localH2_viola(){
 356                 return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");
 357         }
 358
 359         public static ICdmDataSource localH2_LIAS(){
 360                 return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");
 361         }
 362
 363         public static ICdmDataSource localH2_Erythroneura(){
 364                 return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");
 365         }
 366
 367         public static ICdmDataSource localH2_Cicad(){
 368                 return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");
 369         }
 370
 371         public static ICdmDataSource localH2_ValRosandraFRIDAKey(){
 372                 return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");
 373         }
 374
 375         public static ICdmDataSource localH2_FreshwaterAquaticInsects(){
 376                 return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");
 377         }
 378
 379         public static ICdmDataSource cdm_algaterra_preview(){
 380                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 381                 String cdmServer = "160.45.63.201";
 382                 String cdmDB = "cdm_edit_algaterra";
 383                 String cdmUserName = "edit";
 384                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 385         }
 386
 387         public static ICdmDataSource cdm_algaterra_production(){
 388                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 389                 String cdmServer = "160.45.63.171";
 390                 String cdmDB = "cdm_production_algaterra";
 391                 String cdmUserName = "edit";
 392                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 393         }
 394
 395         public static ICdmDataSource cdm_edit_cichorieae_local_PG(){
 396                 DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
 397                 String cdmServer = "127.0.0.1";
 398                 String cdmDB = "cdm_edit_cichorieae_a";
 399                 String cdmUserName = "edit";
 400                 int port = 15432;
 401                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 402         }
 403
 404         public static ICdmDataSource cdm_cichorieae_preview(){
 405                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 406                 String cdmServer = "160.45.63.201";
 407                 String cdmDB = "cdm_edit_cichorieae";
 408                 String cdmUserName = "edit";
 409                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 410         }
 411
 412         public static ICdmDataSource cdm_production_cichorieae(){
 413                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 414                 String cdmServer = "160.45.63.171";
 415 //              String cdmServer = "127.0.0.1";
 416                 String cdmDB = "cdm_production_cichorieae";
 417                 String cdmUserName = "edit";
 418                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 419         }
 420
 421         public static ICdmDataSource cdm_production_palmae(){
 422                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 423                 String cdmServer = "160.45.63.171";
 424                 String cdmDB = "cdm_production_palmae";
 425                 String cdmUserName = "edit";
 426                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 427         }
 428
 429
 430         public static ICdmDataSource cdm_production_diptera(){
 431                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 432                 String cdmServer = "160.45.63.171";
 433                 String cdmDB = "cdm_production_diptera";
 434                 String cdmUserName = "edit";
 435                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 436         }
 437
 438         public static ICdmDataSource local_cdm_edit_cichorieae_a(){
 439                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 440                 String cdmServer = "127.0.0.1";
 441                 String cdmDB = "cdm_edit_cichorieae_a";
 442                 String cdmUserName = "edit";
 443                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 444         }
 445
 446         public static ICdmDataSource cdm_edit_palmae_a(){
 447                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 448                 String cdmServer = "192.168.2.10";
 449                 String cdmDB = "cdm_edit_palmae_a";
 450                 String cdmUserName = "edit";
 451                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 452         }
 453
 454         public static ICdmDataSource cdm_edit_cichorieae_preview(){
 455                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 456                 String cdmServer = "127.0.0.1";
 457                 String cdmDB = "cdm_edit_cichorieae";
 458                 String cdmUserName = "edit";
 459                 int port = 13306;
 460                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 461         }
 462
 463         public static ICdmDataSource cdm_edit_cichorieae_preview_direct(){
 464                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 465                 String cdmServer = "160.45.63.201";
 466                 String cdmDB = "cdm_edit_cichorieae";
 467                 String cdmUserName = "edit";
 468                 int port = 3306;
 469                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 470         }
 471
 472         public static ICdmDataSource cdm_edit_cichorieae_integration(){
 473                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 474                 String cdmServer = "127.0.0.1";
 475                 String cdmDB = "cdm_integration_cichorieae";
 476                 String cdmUserName = "edit";
 477                 int port = 13306;
 478                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 479         }
 480
 481         public static ICdmDataSource cdm_edit_palmae_preview(){
 482                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 483                 String cdmServer = "127.0.0.1";
 484                 String cdmDB = "cdm_edit_palmae";
 485                 String cdmUserName = "edit";
 486                 int port = 13306;
 487                 return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
 488         }
 489
 490         public static ICdmDataSource cdm_edit_salvador(){
 491                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 492                 String cdmServer = "192.168.2.10";
 493                 String cdmDB = "cdm_edit_salvador";
 494                 String cdmUserName = "edit";
 495                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 496         }
 497
 498         public static ICdmDataSource cdm_import_salvador() {
 499                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 500                 String cdmServer = "192.168.2.10";
 501                 String cdmDB = "cdm_import_salvador";
 502                 String cdmUserName = "edit";
 503                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 504         }
 505
 506         public static ICdmDataSource cdm_salvador_production() {
 507                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 508                 String cdmServer = "192.168.2.10";
 509                 String cdmDB = "salvador_cdm";
 510                 String cdmUserName = "salvador";
 511                 return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 512         }
 513
 514         /**
 515      * patricia
 516      */
 517     public static ICdmDataSource mon_cdm() {
 518         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 519         String cdmServer = "localhost";
 520         String cdmDB = "cdm_local";
 521         String cdmUserName = "root";
 522         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 523     }
 524
 525    public static ICdmDataSource proibiosphere_local() {
 526         DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 527         String cdmServer = "localhost";
 528         String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
 529         String cdmUserName = "root";
 530         return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
 531     }
 532
 533 //      public static ICdmDataSource LAPTOP_HP(){
 534 //              DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
 535 //              String cdmServer = "LAPTOPHP";
 536 //              String cdmDB = "cdmTest";
 537 //              String cdmUserName = "edit";
 538 //              return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 539 //      }
 540
 541
 542
 543
 544         /**
 545          * initializes source
 546          * TODO only supports MySQL and PostgreSQL
 547          *
 548          * @param dbType
 549          * @param cdmServer
 550          * @param cdmDB
 551          * @param port
 552          * @param cdmUserName
 553          * @param pwd
 554          * @return
 555          */
 556         public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
 557                 //establish connection
 558                 pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
 559                 ICdmDataSource destination;
 560                 if(dbType.equals(DatabaseTypeEnum.MySQL)){
 561                         destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
 562                 } else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
 563                         destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
 564                 } else {
 565                         //TODO others
 566                         throw new RuntimeException("Unsupported DatabaseType");
 567                 }
 568                 return destination;
 569
 570         }
 571
 572
 573         /**
 574          * Accepts a string array and tries to find a method returning an ICdmDataSource with
 575          * the name of the given first string in the array
 576          *
 577          * @param args
 578          * @return
 579          */
 580         public static ICdmDataSource chooseDestination(String[] args) {
 581                 if(args == null)
 582                         return null;
 583
 584                 if(args.length != 1)
 585                         return null;
 586
 587                 String possibleDestination = args[0];
 588
 589                 Method[] methods = CdmDestinations.class.getMethods();
 590
 591                 for (Method method : methods){
 592                         if(method.getName().equals(possibleDestination)){
 593                                 try {
 594                                         return (ICdmDataSource) method.invoke(null, null);
 595                                 } catch (IllegalArgumentException e) {
 596                                         // TODO Auto-generated catch block
 597                                         e.printStackTrace();
 598                                 } catch (IllegalAccessException e) {
 599                                         // TODO Auto-generated catch block
 600                                         e.printStackTrace();
 601                                 } catch (InvocationTargetException e) {
 602                                         // TODO Auto-generated catch block
 603                                         e.printStackTrace();
 604                                 }
 605                         }
 606                 }
 607                 return null;
 608         }
 609
 610 }
 611