cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/common/BerlinModelSources.java

   1
   2 /**
   3 * Copyright (C) 2007 EDIT
   4 * European Distributed Institute of Taxonomy
   5 * http://www.e-taxonomy.eu
   6 *
   7 * The contents of this file are subject to the Mozilla Public License Version 1.1
   8 * See LICENSE.TXT at the top of this package for the full license terms.
   9 */
  10
  11 package eu.etaxonomy.cdm.app.common;
  12
  13 import org.apache.log4j.Logger;
  14
  15 import eu.etaxonomy.cdm.common.AccountStore;
  16 import eu.etaxonomy.cdm.io.common.Source;
  17
  18
  19 public class BerlinModelSources {
  20         @SuppressWarnings("unused")
  21         private static final Logger logger = Logger.getLogger(BerlinModelSources.class);
  22
  23         public static Source EDIT_Diptera(){
  24                 //      BerlinModel - EDIT_Diptera
  25                 String dbms = Source.SQL_SERVER_2008;
  26                 String strServer = "BGBM42";
  27                 String strDB = "EDIT_Diptera";
  28                 int port = 1433;
  29                 String userName = "webUser";
  30                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  31         }
  32
  33         public static Source euroMed_local(){
  34                 //      BerlinModel - Euro+Med
  35                 String dbms = Source.SQL_SERVER_2005;
  36                 String strServer = "LENOVO-T61";
  37                 String strDB = "euroMed";
  38                 int port = 1433;
  39                 String userName = "webUser";
  40                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  41         }
  42
  43         public static Source euroMed(){
  44                 //      BerlinModel - Euro+Med
  45                 String dbms = Source.SQL_SERVER_2005;
  46                 String strServer = "BGBM42";
  47                 String strDB = "EuroPlusMed_00_Edit";
  48                 int port = 1247;
  49                 String userName = "webUser";
  50                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  51         }
  52
  53         public static Source PESI_ERMS(){
  54                 //      BerlinModel - Pesi-ERMS
  55                 String dbms = Source.SQL_SERVER_2005;
  56                 String strServer = "SQL2000Intern\\SQL2005";
  57                 String strDB = "BM_ERMS";
  58                 int port = 1433;
  59                 String userName = "WebUser";
  60                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  61         }
  62
  63         /**
  64          * Initializes the source.
  65          * @param dbms
  66          * @param strServer
  67          * @param strDB
  68          * @param port
  69          * @param userName
  70          * @param pwd
  71          * @return the source
  72          */
  73         private static Source makeSource(String dbms, String strServer, String strDB, int port, String userName, String pwd ){
  74                 //establish connection
  75                 Source source = null;
  76                 source = new Source(dbms, strServer, strDB);
  77                 source.setPort(port);
  78
  79                 pwd = AccountStore.readOrStorePassword(dbms, strServer, userName, pwd);
  80                 source.setUserAndPwd(userName, pwd);
  81                 // write pwd to account store
  82                 return source;
  83         }
  84
  85 }