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.berlinModelImport.SourceBase;
  18 import eu.etaxonomy.cdm.app.tcs.TcsSources;
  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 extends SourceBase{
  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         public static Source GLOBIS_MDB_20120928(){
  68                 String dbms = Source.ACCESS;
  69                 String strServer = null;
  70                 String strDB = "C:\\localCopy\\Data\\globis\\globis.20120928.mdb";
  71                 int port = -1;
  72                 String userName = "";
  73                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  74         }
  75
  76         public static Source GLOBIS_MDB_20140113(){
  77                 String dbms = Source.ACCESS;
  78                 String strServer = null;
  79                 String strDB = "C:\\localCopy\\Data\\globis\\globis_20140113.mdb";
  80                 int port = -1;
  81                 String userName = "";
  82                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  83         }
  84
  85         //Problem MS Access ODBC Driver does not work on PESIIMPORT 3
  86         @Deprecated
  87         public static Source GLOBIS_MDB_20140113_PESIIMPORT(){
  88                 String dbms = Source.ACCESS;
  89                 String strServer = null;
  90                 String strDB = "\\\\PESIIMPORT3\\globis\\globis_20140113.mdb";
  91                 int port = -1;
  92                 String userName = "";
  93                 return  makeSource(dbms, strServer, strDB, port, userName, null);
  94         }
  95
  96         public static Source GLOBIS_MDB_20140113_PESIIMPORT_SQLSERVER(){
  97                 String dbms = Source.SQL_SERVER_2008;
  98                 String strServer = "PESIIMPORT3";
  99                 String strDB = "globis_orig_20140113";
 100                 int port = 1433;
 101                 String userName = "pesiexport";
 102                 return  makeSource(dbms, strServer, strDB, port, userName, null);
 103         }
 104
 105         public static URI SYNTHESYS_SPECIMEN(){
 106                 //              tcsXmlTest.xml
 107                 URL url = new TcsSources().getClass().getResource("/specimen/SynthesysSpecimenExample.xls");
 108                 String sourceUrl = url.toString();
 109                 URI uri = URI.create(sourceUrl);
 110                 return uri;
 111         }
 112
 113
 114
 115
 116 }