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