app-import/src/main/java/eu/etaxonomy/cdm/app/common/CdmImportSources.java

   1 // $Id$
   2 /**
   3 * Copyright (C) 2009 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 package eu.etaxonomy.cdm.app.common;
  11
  12 import java.net.URI;
  13 import java.net.URL;
  14
  15 import org.apache.log4j.Logger;
  16
  17 import eu.etaxonomy.cdm.app.tcs.TcsSources;
  18 import eu.etaxonomy.cdm.common.AccountStore;
  19 import eu.etaxonomy.cdm.io.common.Source;
  20
  21 /**
  22  * @author a.mueller
  23  * @date 21.04.2010
  24  *
  25  */
  26 public class CdmImportSources {
  27         @SuppressWarnings("unused")
  28         private static final Logger logger = Logger.getLogger(CdmImportSources.class);
  29
  30         public static Source ROTE_LISTE_DB(){
  31                 String dbms = Source.ORACLE;
  32                 String strServer = "xxx";
  33                 String strDB = "dbName";
  34                 int port = 1433;
  35                 String userName = "adam";
  36                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  37         }
  38
  39
  40         public static Source GLOBIS(){
  41                 String dbms = Source.SQL_SERVER_2005;
  42                 String strServer = "LENOVO-T61";
  43                 String strDB = "globis";
  44                 int port = 0001;
  45                 String userName = "user";
  46                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  47         }
  48
  49         public static Source GLOBIS_ODBC(){
  50                 String dbms = Source.ODDBC;
  51                 String strServer = "LENOVO-T61";
  52                 String strDB = "globis";
  53                 int port = 1433;
  54                 String userName = "sa";
  55                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  56         }
  57
  58         public static Source GLOBIS_MDB(){
  59                 String dbms = Source.ACCESS;
  60                 String strServer = null;
  61                 String strDB = "C:\\localCopy\\Data\\globis\\globis.mdb";
  62                 int port = -1;
  63                 String userName = "";
  64                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  65         }
  66
  67
  68         public static URI SYNTHESYS_SPECIMEN(){
  69                 //              tcsXmlTest.xml
  70                 URL url = new TcsSources().getClass().getResource("/specimen/SynthesysSpecimenExample.xls");
  71                 String sourceUrl = url.toString();
  72                 URI uri = URI.create(sourceUrl);
  73                 return uri;
  74         }
  75
  76         /**
  77          * Initializes the source.
  78          * @param dbms
  79          * @param strServer
  80          * @param strDB
  81          * @param port
  82          * @param userName
  83          * @param pwd
  84          * @return the source
  85          */
  86         private static Source makeSource(String dbms, String strServer, String strDB, int port, String userName, String pwd ){
  87                 //establish connection
  88                 Source source = null;
  89                 source = new Source(dbms, strServer, strDB);
  90                 source.setPort(port);
  91
  92                 pwd = AccountStore.readOrStorePassword(dbms, strServer, userName, pwd);
  93                 source.setUserAndPwd(userName, pwd);
  94                 // write pwd to account store
  95                 return source;
  96         }
  97 }