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 org.apache.log4j.Logger;
  13
  14 import eu.etaxonomy.cdm.common.AccountStore;
  15 import eu.etaxonomy.cdm.database.CdmDataSource;
  16 import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
  17 import eu.etaxonomy.cdm.database.ICdmDataSource;
  18
  19 public class CdmDestinations {
  20         @SuppressWarnings("unused")
  21         private static Logger logger = Logger.getLogger(CdmDestinations.class);
  22
  23         public static ICdmDataSource cdm_1_1(){
  24                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  25                 String cdmServer = "192.168.2.10";
  26                 String cdmDB = "cdm_1_1"; // values: "cdm_1_1"  "cdm_build"
  27                 String cdmUserName = "edit";
  28                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  29         }
  30
  31
  32         public static ICdmDataSource cdm_build(){
  33                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  34                 String cdmServer = "192.168.2.10";
  35                 String cdmDB = "cdm_build"; // values: "cdm_1_1"  "cdm_build"
  36                 String cdmUserName = "edit";
  37                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  38         }
  39
  40         /**
  41          * Intended to be used for imports
  42          */
  43         public static ICdmDataSource cdm_import(){
  44                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  45                 String cdmServer = "192.168.2.10";
  46                 String cdmDB = "cdm_import";
  47                 String cdmUserName = "edit";
  48                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  49         }
  50
  51         public static ICdmDataSource cdm_test(){
  52                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  53                 String cdmServer = "192.168.2.10";
  54                 String cdmDB = "cdm_test"; // values: "cdm_1_1"  "cdm_build"
  55                 String cdmUserName = "edit";
  56                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  57         }
  58
  59
  60         public static ICdmDataSource cdm_test_anahit(){
  61                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  62                 String cdmServer = "192.168.2.10";
  63                 String cdmDB = "cdm_test_anahit";
  64                 String cdmUserName = "edit";
  65                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  66         }
  67
  68         public static ICdmDataSource cdm_test_anahit2(){
  69                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  70                 String cdmServer = "192.168.2.10";
  71                 String cdmDB = "cdm_test_anahit2";
  72                 String cdmUserName = "edit";
  73                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  74         }
  75
  76         public static ICdmDataSource cdm_test_jaxb(){
  77                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  78                 String cdmServer = "192.168.2.10";
  79                 String cdmDB = "cdm_test_jaxb";
  80                 String cdmUserName = "edit";
  81                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  82         }
  83
  84         public static ICdmDataSource cdm_test_jaxb2(){
  85                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  86                 String cdmServer = "192.168.2.10";
  87                 String cdmDB = "cdm_test_jaxb2";
  88                 String cdmUserName = "edit";
  89                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  90         }
  91
  92         public static ICdmDataSource cdm_test_andreas_diptera(){
  93                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
  94                 String cdmServer = "192.168.2.10";
  95                 String cdmDB = "cdm_test_andreas_diptera";
  96                 String cdmUserName = "edit";
  97                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
  98         }
  99
 100         public static ICdmDataSource cdm_test_andreas_palmae(){
 101                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 102                 String cdmServer = "192.168.2.10";
 103                 String cdmDB = "cdm_test_andreas_palmae";
 104                 String cdmUserName = "edit";
 105                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 106         }
 107
 108         public static ICdmDataSource cdm_test_andreas_cichorieae(){
 109                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 110                 String cdmServer = "192.168.2.10";
 111                 String cdmDB = "cdm_test_andreas_cichorieae";
 112                 String cdmUserName = "edit";
 113                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 114         }
 115
 116         public static ICdmDataSource cdm_test_andreasM(){
 117                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 118                 String cdmServer = "192.168.2.10";
 119                 String cdmDB = "cdm_test_andreasM";
 120                 String cdmUserName = "edit";
 121                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 122         }
 123
 124         public static ICdmDataSource cdm_test_andreasM2(){
 125                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 126                 String cdmServer = "192.168.2.10";
 127                 String cdmDB = "cdm_test_andreasM2";
 128                 String cdmUserName = "edit";
 129                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 130         }
 131
 132         public static ICdmDataSource cdm_test_andreasM3(){
 133                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 134                 String cdmServer = "192.168.2.10";
 135                 String cdmDB = "cdm_test_andreasM3";
 136                 String cdmUserName = "edit";
 137                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 138         }
 139
 140
 141         public static ICdmDataSource cdm_editor2(){
 142                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 143                 String cdmServer = "192.168.2.10";
 144                 String cdmDB = "cdm_editor_test2";
 145                 String cdmUserName = "edit";
 146                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 147         }
 148
 149                 public static ICdmDataSource cdm_portal(){
 150                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 151                 String cdmServer = "192.168.2.10";
 152                 String cdmDB = "cdm_portal";
 153                 String cdmUserName = "edit";
 154                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 155         }
 156
 157         public static ICdmDataSource cdm_portal_test(){
 158                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 159                 String cdmServer = "192.168.2.10";
 160                 String cdmDB = "cdm_portal_test";
 161                 String cdmUserName = "edit";
 162                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 163         }
 164
 165         public static ICdmDataSource cdm_test_patricia(){
 166                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 167                 String cdmServer = "192.168.2.10";
 168                 String cdmDB = "cdm_test_patricia";
 169                 String cdmUserName = "edit";
 170                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 171         }
 172
 173         public static ICdmDataSource cdm_test_niels1(){
 174                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 175                 String cdmServer = "192.168.2.10";
 176                 String cdmDB = "cdm_test_niels1";
 177                 String cdmUserName = "edit";
 178                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 179         }
 180
 181         public static ICdmDataSource cdm_test_niels2(){
 182                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 183                 String cdmServer = "192.168.2.10";
 184                 String cdmDB = "cdm_test_niels2";
 185                 String cdmUserName = "edit";
 186                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 187         }
 188
 189         //
 190         public static ICdmDataSource cdm_test_andreasK1(){
 191                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 192                 String cdmServer = "192.168.2.10";
 193                 String cdmDB = "cdm_test_andreasK1";
 194                 String cdmUserName = "edit";
 195                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 196         }
 197
 198         public static ICdmDataSource cdm_test_andreasK2(){
 199                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 200                 String cdmServer = "192.168.2.10";
 201                 String cdmDB = "cdm_test_andreasK2";
 202                 String cdmUserName = "edit";
 203                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 204         }
 205
 206
 207         public static ICdmDataSource cdm_pesi_erms(){
 208                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 209                 String cdmServer = "192.168.2.10";
 210                 String cdmDB = "cdm_pesi_erms";
 211                 String cdmUserName = "edit";
 212                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 213         }
 214
 215         public static ICdmDataSource cdm_portal_test_localhost(){
 216                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 217                 String cdmServer = "127.0.0.1";
 218                 String cdmDB = "cdm_portal_test";
 219                 String cdmUserName = "edit";
 220                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 221         }
 222
 223         public static ICdmDataSource cdm_portal_test_localhost2(){
 224                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 225                 String cdmServer = "127.0.0.1";
 226                 String cdmDB = "cdm_portal_test2";
 227                 String cdmUserName = "edit";
 228                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 229         }
 230
 231         public static ICdmDataSource cdm_local_cichorieae(){
 232                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 233                 String cdmServer = "127.0.0.1";
 234                 String cdmDB = "cdm_edit_cichorieae";
 235                 String cdmUserName = "edit";
 236                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 237         }
 238
 239         public static ICdmDataSource cdm_local_dipera(){
 240                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 241                 String cdmServer = "127.0.0.1";
 242                 String cdmDB = "cdm_edit_diptera";
 243                 String cdmUserName = "edit";
 244                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 245         }
 246
 247         public static ICdmDataSource cdm_local_palmae(){
 248                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 249                 String cdmServer = "127.0.0.1";
 250                 String cdmDB = "cdm_edit_palmae";
 251                 String cdmUserName = "edit";
 252                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 253         }
 254
 255
 256         public static ICdmDataSource NULL(){
 257                 return null;
 258         }
 259
 260         public static ICdmDataSource localH2(){
 261                 return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
 262         }
 263
 264         public static ICdmDataSource localH2(String database, String username, String filePath){
 265                 return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
 266         }
 267
 268         public static ICdmDataSource localH2Salvador(){
 269                 return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
 270         }
 271
 272         public static ICdmDataSource localH2Diptera(){
 273                 return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");
 274         }
 275
 276
 277         public static ICdmDataSource localH2Cichorieae(){
 278                 return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
 279         }
 280
 281         public static ICdmDataSource localH2Palmae(){
 282                 return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
 283         }
 284
 285         public static ICdmDataSource localH2_viola(){
 286                 return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");
 287         }
 288
 289         public static ICdmDataSource localH2_LIAS(){
 290                 return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");
 291         }
 292
 293         public static ICdmDataSource localH2_Erythroneura(){
 294                 return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");
 295         }
 296
 297         public static ICdmDataSource localH2_Cicad(){
 298                 return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");
 299         }
 300
 301         public static ICdmDataSource localH2_ValRosandraFRIDAKey(){
 302                 return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");
 303         }
 304
 305         public static ICdmDataSource localH2_FreshwaterAquaticInsects(){
 306                 return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");
 307         }
 308
 309         public static ICdmDataSource cdm_portal_test_pollux(){
 310                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 311                 String cdmServer = "192.168.2.11";
 312                 String cdmDB = "cdm_portal_test";
 313                 String cdmUserName = "edit";
 314                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 315         }
 316
 317         public static ICdmDataSource cdm_edit_cichorieae(){
 318                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 319                 String cdmServer = "192.168.2.10";
 320                 String cdmDB = "cdm_edit_cichorieae";
 321                 String cdmUserName = "edit";
 322                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 323         }
 324
 325         public static ICdmDataSource cdm_v1_cichorieae(){
 326                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 327                 String cdmServer = "192.168.2.10";
 328                 String cdmDB = "cdm_v1_cichorieae";
 329                 String cdmUserName = "edit";
 330                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 331         }
 332
 333         public static ICdmDataSource cdm_edit_diptera(){
 334                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 335                 String cdmServer = "192.168.2.10";
 336                 String cdmDB = "cdm_edit_diptera";
 337                 String cdmUserName = "edit";
 338                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 339         }
 340
 341         public static ICdmDataSource cdm_edit_diptera_177(){
 342                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 343                 String cdmServer = "87.106.88.177";
 344                 String cdmDB = "cdm_edit_diptera";
 345                 String cdmUserName = "edit";
 346                 return makeDestination(cdmServer, cdmDB, 80, cdmUserName, null);
 347         }
 348
 349         public static ICdmDataSource cdm_v1_diptera(){
 350                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 351                 String cdmServer = "192.168.2.10";
 352                 String cdmDB = "cdm_v1_diptera";
 353                 String cdmUserName = "edit";
 354                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 355         }
 356
 357         public static ICdmDataSource cdm_edit_palmae(){
 358                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 359                 String cdmServer = "192.168.2.10";
 360                 String cdmDB = "cdm_edit_palmae";
 361                 String cdmUserName = "edit";
 362                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 363         }
 364
 365         public static ICdmDataSource cdm_edit_diptera_preview_B(){
 366                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 367                 String cdmServer = "127.0.0.1";
 368                 String cdmDB = "cdm_edit_diptera_b";
 369                 String cdmUserName = "edit";
 370                 int port = 13306;
 371                 return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);
 372         }
 373
 374         public static ICdmDataSource cdm_edit_cichorieae_preview_B(){
 375                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 376                 String cdmServer = "127.0.0.1";
 377                 String cdmDB = "cdm_edit_cichorieae_b";
 378                 String cdmUserName = "edit";
 379                 int port = 13306;
 380                 return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);
 381         }
 382
 383         public static ICdmDataSource cdm_edit_palmae_preview_A(){
 384                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 385                 String cdmServer = "127.0.0.1";
 386                 String cdmDB = "cdm_edit_palmae_a";
 387                 String cdmUserName = "edit";
 388                 int port = 13306;
 389                 return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);
 390         }
 391
 392         public static ICdmDataSource cdm_edit_palmae_preview_B(){
 393                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 394                 String cdmServer = "127.0.0.1";
 395                 String cdmDB = "cdm_edit_palmae_b";
 396                 String cdmUserName = "edit";
 397                 int port = 13306;
 398                 return makeDestination(cdmServer, cdmDB, port, cdmUserName, null);
 399         }
 400
 401         public static ICdmDataSource cdm_v1_palmae(){
 402                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 403                 String cdmServer = "192.168.2.10";
 404                 String cdmDB = "cdm_v1_palmae";
 405                 String cdmUserName = "edit";
 406                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 407         }
 408
 409         public static ICdmDataSource cdm_edit_salvador(){
 410                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 411                 String cdmServer = "192.168.2.10";
 412                 String cdmDB = "cdm_edit_salvador";
 413                 String cdmUserName = "edit";
 414                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 415         }
 416
 417         public static ICdmDataSource cdm_import_cichorieae() {
 418                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 419                 String cdmServer = "192.168.2.10";
 420                 String cdmDB = "cdm_import_cichorieae";
 421                 String cdmUserName = "edit";
 422                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 423         }
 424
 425         public static ICdmDataSource cdm_import_diptera() {
 426                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 427                 String cdmServer = "192.168.2.10";
 428                 String cdmDB = "cdm_import_diptera";
 429                 String cdmUserName = "edit";
 430                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 431         }
 432
 433         public static ICdmDataSource cdm_import_palmae() {
 434                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 435                 String cdmServer = "192.168.2.10";
 436                 String cdmDB = "cdm_import_palmae";
 437                 String cdmUserName = "edit";
 438                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 439         }
 440
 441         public static ICdmDataSource cdm_import_salvador() {
 442                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 443                 String cdmServer = "192.168.2.10";
 444                 String cdmDB = "cdm_import_salvador";
 445                 String cdmUserName = "edit";
 446                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 447         }
 448
 449         public static ICdmDataSource cdm_salvador_production() {
 450                 DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
 451                 String cdmServer = "192.168.2.10";
 452                 String cdmDB = "salvador_cdm";
 453                 String cdmUserName = "salvador";
 454                 return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 455         }
 456
 457
 458 //      public static ICdmDataSource LAPTOP_HP(){
 459 //              DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
 460 //              String cdmServer = "LAPTOPHP";
 461 //              String cdmDB = "cdmTest";
 462 //              String cdmUserName = "edit";
 463 //              return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
 464 //      }
 465
 466
 467         /**
 468          * initializes source
 469          * @return true, if connection establisehd
 470          */
 471         private static ICdmDataSource makeDestination(String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
 472                 //establish connection
 473                 pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
 474                 //TODO not MySQL
 475                 ICdmDataSource destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
 476                 return destination;
 477
 478         }
 479
 480 }
 481