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