(no commit message)

diff --git a/.gitattributes b/.gitattributes
index 4a91b9910eeea6f007c44fb573081e86143ffa9b..590173f79da47731bbfbf7d1ac6baab04832c01e 100644 (file)
--- a/.gitattributes
+++ b/.gitattributes
@@ -524,6 +524,9 @@ eclipse-updateSite/index.html -text
 eclipse-updateSite/plugins/eu.etaxonomy.cdmLibrary_0.4.7.6.jar -text
 eclipse-updateSite/site.xml -text
 imports/pom.xml -text
+imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelImportActivator.java -text
+imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelSources.java -text
+imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/CdmDestinations.java -text
 libraryTesterApplication/.classpath -text
 libraryTesterApplication/.project -text
 libraryTesterApplication/cdmResources/applicationContext.xml -text

diff --git a/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelImportActivator.java b/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelImportActivator.java
new file mode 100644 (file)
index 0000000..45d82a6
--- /dev/null
+++ b/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelImportActivator.java
@@ -0,0 +1,55 @@
+package eu.etaxonomy.cdm.io.berlinModel;\r
+\r
+import org.apache.log4j.Logger;\r
+\r
+import eu.etaxonomy.cdm.api.application.CdmApplicationController;\r
+import eu.etaxonomy.cdm.database.ICdmDataSource;\r
+import eu.etaxonomy.cdm.database.CdmPersistentDataSource.HBM2DDL;\r
+import eu.etaxonomy.cdm.io.berlinModel.BerlinModelImport;\r
+import eu.etaxonomy.cdm.io.berlinModel.BerlinModelSources;\r
+import eu.etaxonomy.cdm.io.source.Source;\r
+\r
+\r
+/**\r
+ * @author a.mueller\r
+ *\r
+ */\r
+public class BerlinModelImportActivator {\r
+       private static Logger logger = Logger.getLogger(BerlinModelImportActivator.class);\r
+\r
+       //database validation status (create, update, validate ...)\r
+       static HBM2DDL hbm2dll = HBM2DDL.CREATE;\r
+       static final Source berlinModelSource = BerlinModelSources.editWP6();\r
+       static final ICdmDataSource cdmDestination = CdmDestinations.cdm_1_1();\r
+       \r
+       /**\r
+        * @param args\r
+        */\r
+       public static void main(String[] args) {\r
+               System.out.println("Start import cichorieae from BerlinModel ("+ berlinModelSource.getDatabase() + ") ...");\r
+               CdmApplicationController cdmApp;\r
+               \r
+               //make BerlinModel Source\r
+               Source source = berlinModelSource;\r
+               ICdmDataSource destination = cdmDestination;\r
+               \r
+               BerlinModelImportConfigurator bmImportConfigurator = BerlinModelImportConfigurator.NewInstance(source,  destination);\r
+               bmImportConfigurator.setDoNameStatus(false);\r
+//             bmImportConfigurator.setDoTaxa(false);\r
+               bmImportConfigurator.setDoFacts(false);\r
+//             bmImportConfigurator.setDoRelNames(false);\r
+               bmImportConfigurator.setHbm2dll(HBM2DDL.CREATE);\r
+               \r
+               // invoke import\r
+               BerlinModelImport bmImport = new BerlinModelImport();\r
+               bmImport.doImport(bmImportConfigurator);\r
+\r
+               System.out.println("End import from BerlinModel ("+ source.getDatabase() + ")...");\r
+       }\r
+       \r
+       \r
+\r
+       \r
+       \r
+\r
+}\r

diff --git a/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelSources.java b/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelSources.java
new file mode 100644 (file)
index 0000000..2ef3dca
--- /dev/null
+++ b/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/BerlinModelSources.java
@@ -0,0 +1,56 @@
+package eu.etaxonomy.cdm.io.berlinModel;\r
+\r
+import java.io.BufferedReader;\r
+import java.io.IOException;\r
+\r
+import org.apache.log4j.Logger;\r
+\r
+import eu.etaxonomy.cdm.common.CdmUtils;\r
+import eu.etaxonomy.cdm.io.source.Source;\r
+\r
+public class BerlinModelSources {\r
+       private static Logger logger = Logger.getLogger(BerlinModelSources.class);\r
+       \r
+       public static Source euroMed(){\r
+               //      BerlinModel - Euro+Med\r
+               String dbms = "SQLServer";\r
+               String strServer = "BGBM111";\r
+               String strDB = "EuroPlusMed_00_Edit";\r
+               int port = 1247;\r
+               String userName = "webUser";\r
+               return  makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r
+       public static Source editWP6(){\r
+               //      BerlinModel - EditWp6\r
+               String dbms = "SQLServer";\r
+               String strServer = "BGBM111";\r
+               String strDB = "EditWP6";\r
+               int port = 1247;\r
+               String userName = "webUser";\r
+               return  makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+\r
+\r
+       \r
+       /**\r
+        * initializes source\r
+        * @return true, if connection establisehd\r
+        */\r
+       private static Source makeSource(String dbms, String strServer, String strDB, int port, String userName, String pwd ){\r
+               //establish connection\r
+               try {\r
+                       Source source = new Source(dbms, strServer, strDB);\r
+                       source.setPort(port);\r
+                       if (pwd == null){\r
+                               pwd = CdmUtils.readInputLine("Please insert password for " + CdmUtils.Nz(userName) + ": ");\r
+                       }\r
+                       source.setUserAndPwd(userName, pwd);\r
+                       return source;\r
+               } catch (Exception e) {\r
+                       logger.error(e);\r
+                       return null;\r
+               }\r
+       }\r
+\r
+}\r

diff --git a/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/CdmDestinations.java b/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/CdmDestinations.java
new file mode 100644 (file)
index 0000000..5f66098
--- /dev/null
+++ b/imports/src/main/java/eu/etaxonomy/cdm/io/berlinModel/CdmDestinations.java
@@ -0,0 +1,68 @@
+package eu.etaxonomy.cdm.io.berlinModel;\r
+\r
+import org.apache.log4j.Logger;\r
+\r
+import eu.etaxonomy.cdm.common.CdmUtils;\r
+import eu.etaxonomy.cdm.database.CdmDataSource;\r
+import eu.etaxonomy.cdm.database.DatabaseTypeEnum;\r
+import eu.etaxonomy.cdm.database.ICdmDataSource;\r
+\r
+public class CdmDestinations {\r
+       private static Logger logger = Logger.getLogger(CdmDestinations.class);\r
+       \r
+       public static ICdmDataSource cdm_1_1(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_1_1"; // values: "cdm_1_1"  "cdm_build"\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       \r
+       public static ICdmDataSource cdm_build(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_1_1"; // values: "cdm_1_1"  "cdm_build"\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+\r
+       \r
+       public static ICdmDataSource cdm_test(){\r
+               DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;\r
+               String cdmServer = "192.168.2.10";\r
+               String cdmDB = "cdm_1_1"; // values: "cdm_1_1"  "cdm_build"\r
+               String cdmUserName = "edit";\r
+               return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+       }\r
+       \r
+       \r
+//     public static ICdmDataSource LAPTOP_HP(){\r
+//             DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;\r
+//             String cdmServer = "LAPTOPHP";\r
+//             String cdmDB = "cdmTest"; \r
+//             String cdmUserName = "edit";\r
+//             return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);\r
+//     }\r
+       \r
+       \r
+       /**\r
+        * initializes source\r
+        * @return true, if connection establisehd\r
+        */\r
+       private static ICdmDataSource makeDestination(String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){\r
+               //establish connection\r
+               try {\r
+                       if (pwd == null){\r
+                               pwd = CdmUtils.readInputLine("Please insert password for " + CdmUtils.Nz(cdmUserName) + ": ");\r
+                       }\r
+                       //TODO not MySQL\r
+                       ICdmDataSource destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);\r
+                       return destination;\r
+               } catch (Exception e) {\r
+                       logger.error(e);\r
+                       return null;\r
+               }\r
+       }\r
+\r
+}\r