• xml creation in server is not used anymore - removed

2 files changed, 8 insertions, 232 deletions

diff --git a/dozentenmodulserver/src/main/java/server/ServerHandler.java b/dozentenmodulserver/src/main/java/server/ServerHandler.java
index 13e22499..23a987dc 100644
--- a/dozentenmodulserver/src/main/java/server/ServerHandler.java
+++ b/dozentenmodulserver/src/main/java/server/ServerHandler.java
@@ -29,7 +29,7 @@ import server.generated.Person;
 import com.mysql.jdbc.StringUtils;
 
 import sql.SQL;
-import util.XMLCreator;
+//import util.XMLCreator;
 
 public class ServerHandler implements Server.Iface {
 	static SQL sql = new SQL();
@@ -265,6 +265,7 @@ public class ServerHandler implements Server.Iface {
 				shortdesc, startDate, endDate, isActive, lectureID);
 		
 		
+		/*
 		XMLCreator xml = new XMLCreator(sql.getConnection(), name);
 		try {
 			xml.create(name);
@@ -276,9 +277,10 @@ public class ServerHandler implements Server.Iface {
 		} catch (TransformerException e) {
 			e.printStackTrace();
 		}
-		
+		*/
 		return false;
 	}
+	
 
 	@Override
 	public boolean startFileCopy(String filename) throws TException {
@@ -379,6 +381,8 @@ public class ServerHandler implements Server.Iface {
 		} catch (IOException e1) {
 			e1.printStackTrace();
 		}
+		
+		/*
 		XMLCreator xml = new XMLCreator(sql.getConnection(), newName);
 		try {
 			xml.create(newName);
@@ -387,6 +391,8 @@ public class ServerHandler implements Server.Iface {
 			e.printStackTrace();
 		}
 
+		*/
+
 		return false;
 	}
 
diff --git a/dozentenmodulserver/src/main/java/util/XMLCreator.java b/dozentenmodulserver/src/main/java/util/XMLCreator.java
deleted file mode 100644
index 69d8c745..00000000
--- a/dozentenmodulserver/src/main/java/util/XMLCreator.java
+++ /dev/null
@@ -1,230 +0,0 @@
-package util;
-
-import java.io.File;
-import java.sql.Connection;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
-import java.text.DateFormat;
-import java.text.SimpleDateFormat;
-import java.util.Date;
-
-import javax.xml.parsers.DocumentBuilder;
-import javax.xml.parsers.DocumentBuilderFactory;
-import javax.xml.parsers.ParserConfigurationException;
-import javax.xml.transform.Transformer;
-import javax.xml.transform.TransformerException;
-import javax.xml.transform.TransformerFactory;
-import javax.xml.transform.dom.DOMSource;
-import javax.xml.transform.stream.StreamResult;
-
-import models.Configuration;
-
-import org.apache.log4j.Logger;
-import org.w3c.dom.Comment;
-import org.w3c.dom.Document;
-import org.w3c.dom.Element;
-
-import server.BinaryListener;
-import sql.SQL;
-
-public class XMLCreator {
-
-	/*
-	 * This class offers methods to create XML files for the (old) version of
-	 * managing VMware *.vmdks
-	 */
-
-	private Connection con = null;
-	private Statement st = null;
-	private ResultSet rs = null;
-	private String vmName;
-	private String filePath = Configuration.config.getAbsolute_path()+"prod/";
-	private String imageName;
-	private String xmlName;
-	private static Logger log = Logger.getLogger( BinaryListener.class );
-	
-
-	// phone param not existing
-	private String query = "SELECT m_VLData_imageInfo.image_path ,vorname, nachname, mail, shortdescription, description, m_operatingSystem.guestOS as os,m_VLData_lecture.admin_createTime as createtime ,m_VLData_lecture.admin_changeTime as time, m_VLData_lecture.name as lectureName, m_user.institution as userInstitution, m_user.loginName as loginName, m_VLData_lecture.isActive,  m_institution.name as institutionName "
-			+ "FROM bwLehrpool.m_VLData_lecture, bwLehrpool.m_VLData_imageInfo, bwLehrpool.m_user, bwLehrpool.m_operatingSystem, bwLehrpool.m_institution "
-			+ "WHERE m_user.userID = m_VLData_lecture.admin_owner "
-			+ "AND m_VLData_imageInfo.GUID_imageID = m_VLData_lecture.imageID "
-			+ "AND m_VLData_imageInfo.content_operatingSystem = m_operatingSystem.operatingSystemID "
-	//		+ "AND m_user.institution = m_institution.institutionID "
-			+ "AND m_VLData_lecture.name = ";
-
-	public XMLCreator(Connection con) {
-		this.con = con;
-	}
-
-	public XMLCreator(Connection con, String vmName) {
-		this.con = con;
-		this.vmName = vmName;
-	}
-
-	public boolean create() throws SQLException, ParserConfigurationException,
-			TransformerException {
-
-		 System.out.println("XML creator: "+query);
-
-		if (con == null || vmName == null) {
-			return false;
-		}
-		query += "'" + this.vmName + "';";
-
-		boolean success = startCreation();
-
-		if (success) {			
-			return true;
-		}
-		log.info(new Date() + " - Could not create XML-File '"+vmName+"'. Error in create(String vmName).");
-		return false;
-
-	}
-
-	// overload method for dynamic setting of param vmName instead of static
-	// context above
-	public boolean create(String vmName) throws SQLException,
-			ParserConfigurationException, TransformerException {
-		// System.out.println(query);
-
-		if (con == null || vmName == null) {
-			return false;
-		}
-		query += "'" + vmName + "';";
-
-		boolean success = startCreation();
-
-		if (success) {
-			return true;
-		}
-		log.info(new Date() + " - Could not create XML-File '"+vmName+"'. Error in create(String vmName).");
-		return false;
-	}
-
-	private boolean startCreation() throws SQLException,
-			ParserConfigurationException, TransformerException {
-		// get needed data from database
-		st = con.createStatement();
-		rs = st.executeQuery(query);
-		rs.next();
-
-		// factory
-		DocumentBuilderFactory docFactory = DocumentBuilderFactory
-				.newInstance();
-		DocumentBuilder docBuilder = docFactory.newDocumentBuilder();
-
-		// root elements - dynamic content
-		Document doc = docBuilder.newDocument();
-		Element rootElement = doc.createElement("settings");
-		doc.appendChild(rootElement);
-
-		Element entry = doc.createElement("eintrag");
-		rootElement.appendChild(entry);
-
-		Element prio = doc.createElement("priority");
-		entry.appendChild(prio);
-		prio.setAttribute("param", "0");
-
-		Comment fComment = doc.createComment("Diesen Abschnitt ergänzen");
-		entry.appendChild(fComment);
-
-		Element imgName = doc.createElement("image_name");
-		entry.appendChild(imgName);
-		imageName = rs.getString("image_path").substring(
-				rs.getString("image_path").lastIndexOf("/")+1); //+1 um das führende "/" los zu werden
-
-		imgName.setAttribute("param", imageName);
-
-		Element creator = doc.createElement("creator");
-		entry.appendChild(creator);
-		creator.setAttribute("param",
-				(rs.getString("vorname") + " " + rs.getString("nachname")));
-
-		Element email = doc.createElement("email");
-		entry.appendChild(email);
-		email.setAttribute("param", rs.getString("mail"));
-
-		// TODO check whether necessary
-		Element phone = doc.createElement("phone");
-		entry.appendChild(phone);
-		phone.setAttribute("param", "");
-
-		Element shortDesc = doc.createElement("short_description");
-		entry.appendChild(shortDesc);
-		shortDesc.setAttribute("param", rs.getString("lectureName"));
-
-		// TODO append latest change date and time
-		Element longDesc = doc.createElement("long_description");
-		entry.appendChild(longDesc);
-		longDesc.setAttribute("param", rs.getString("description")
-				+ "; last update: " + rs.getString("time"));
-
-		Element os = doc.createElement("os");
-		entry.appendChild(os);
-		os.setAttribute("param", rs.getString("os"));
-
-		Comment sComment = doc.createComment("Diesen Abschnitt ergänzen");
-		entry.appendChild(sComment);
-
-		// static content following - second part of xml descriptor
-
-		Element netwParam = doc.createElement("network");
-		entry.appendChild(netwParam);
-		netwParam.setAttribute("param", "nat");
-
-		Element netcParam = doc.createElement("netcard");
-		entry.appendChild(netcParam);
-		netcParam.setAttribute("param", "e1000");
-
-		Element vm = doc.createElement("virtualmachine");
-		entry.appendChild(vm);
-		vm.setAttribute("param", "vmware");
-
-		// TODO Fallunterscheidung
-		Element icon = doc.createElement("icon");
-		entry.appendChild(icon);
-		icon.setAttribute("param", "windows");
-
-		Element active = doc.createElement("active");
-		entry.appendChild(active);
-		
-		//set activity
-		if(rs.getString("isActive").equals("1")){
-			active.setAttribute("param", "true");
-		} else if(rs.getString("isActive").equals("0")){
-			active.setAttribute("param", "false");
-		}
-
-		Element pools = doc.createElement("pools");
-		entry.appendChild(pools);
-		pools.setAttribute("param", "default");
-
-		Element enable3d = doc.createElement("enable3d");
-		entry.appendChild(enable3d);
-		enable3d.setAttribute("param", "true");
-
-		// write virtual document to file
-		TransformerFactory transformerFactory = TransformerFactory
-				.newInstance();
-		Transformer transformer = transformerFactory.newTransformer();
-		DOMSource source = new DOMSource(doc);
-		
-		//Set XML-filename
-		xmlName=rs.getString("createtime").substring(0, rs.getString("createtime").length() - 2).replace("-", "").replace(" ", "").replace(":", "") + "_" + rs.getString("institutionName") + "_" + rs.getString("loginName") + "_" + rs.getString("lectureName") + ".xml";
-		
-		//Write file
-		StreamResult result = new StreamResult(new File(filePath+ xmlName)); // see filepath at top of class
-		
-		transformer.transform(source, result);
-
-		// cleanup
-		rs.close();
-		st.close();
-
-		// return
-		log.info(new Date() + " -  XML-File '"+xmlName+"' successfully created.");
-		return true;
-	}
-}