changes for vernacular names import
[cdmlib-apps.git] / cdm-pesi / src / main / java / eu / etaxonomy / cdm / app / pesi / PesiDestinations.java
index a44aa56aaf7ba2c7a46a58a4256e6f38111a41a7..1969929dc9b17874891d7034e5b530442c62a15e 100644 (file)
@@ -24,39 +24,59 @@ public class PesiDestinations {
        @SuppressWarnings("unused")\r
        private static final Logger logger = Logger.getLogger(PesiDestinations.class);\r
        \r
-       public static Source pesi_test_local_PESI_V10(){\r
+       public static Source pesi_test_local_CDM_EM2PESI(){\r
                //      CDM - PESI\r
                String dbms = Source.SQL_SERVER_2008;\r
-               String strServer = "C206\\MSSQLSERVER2";\r
-               String strDB = "PESI_V10";\r
+               String strServer = "localhost";\r
+               String strDB = "CDM_EM2PESI";\r
                int port = 1433;\r
-               String userName = "sa";\r
-               String pwd = "bewell";\r
-               return makeSource(dbms, strServer, strDB, port, userName, pwd);\r
+               String userName =  "pesiexport";// "pesiexport3";\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        \r
-       public static Source pesi_test_local_CDM_DWH_FaEu(){\r
+       public static Source pesi_test_local_CDM_EM2PESI_tmp(){\r
                //      CDM - PESI\r
                String dbms = Source.SQL_SERVER_2008;\r
-               String strServer = "C206\\MSSQLSERVER2";\r
-               String strDB = "CDM_DWH_FaEu";\r
+               String strServer = "localhost";\r
+               String strDB = "CDMTMP_EM2PESI";\r
+               int port = 1433;\r
+               String userName = "pesiexport";\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r
+       public static Source pesi_test_local_CDM_FE2PESI(){\r
+               //      CDM - PESI\r
+               String dbms = Source.SQL_SERVER_2008;\r
+               String strServer = "pesiimport3"; //192.168.1.223\r
+               String strDB = "CDM_FE2PESI";\r
+               int port = 1433;\r
+               String userName = "pesiExportFaunaEu";\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+\r
+       \r
+       public static Source pesi_test_local_CDM_IF2PESI(){\r
+               //      CDM - PESI\r
+               String dbms = Source.SQL_SERVER_2008;\r
+               String strServer = "pesiimport3"; //192.168.1.223\r
+               String strDB = "CDMTMP_IF2PESI";\r
                int port = 1433;\r
-               String userName = "sa";\r
-               String pwd = "bewell";\r
-               return makeSource(dbms, strServer, strDB, port, userName, pwd);\r
+               String userName = "pesiExportFaunaEu";\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        \r
-       public static Source pesi_test_local_PESI_V11(){\r
+       public static Source pesi_test_local_CDM_ERMS2PESI(){\r
                //      CDM - PESI\r
                String dbms = Source.SQL_SERVER_2008;\r
-               String strServer = "C206\\MSSQLSERVER2";\r
-               String strDB = "PESI_V11_LOCAL";\r
+               String strServer = "pesiimport3";\r
+               String strDB = "CDM_ERMS2PESI";\r
                int port = 1433;\r
-               String userName = "sa";\r
-               String pwd = "bewell";\r
-               return makeSource(dbms, strServer, strDB, port, userName, pwd);\r
+               String userName = "pesiexport";\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        \r
+\r
+       \r
        public static Source pesi_test_bgbm42_CDM_DWH_FaEu(){\r
                //      CDM - PESI\r
                String dbms = Source.SQL_SERVER_2008;\r
@@ -64,8 +84,7 @@ public class PesiDestinations {
                String strDB = "CDM_DWH_FaEu";\r
                int port = 1433;\r
                String userName = "WebUser";\r
-               String pwd = "";\r
-               return makeSource(dbms, strServer, strDB, port, userName, pwd);\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        \r
        public static Source pesi_test_bgbm42_PESI_V11(){\r
@@ -75,8 +94,7 @@ public class PesiDestinations {
                String strDB = "PESI_v11";\r
                int port = 1433;\r
                String userName = "WebUser";\r
-               String pwd = "";\r
-               return makeSource(dbms, strServer, strDB, port, userName, pwd);\r
+               return makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        \r
        /**\r