From 5d24cdec4d239f473ee2359493ab47d1ef3273dd Mon Sep 17 00:00:00 2001
From: Tobias Spitzer
Date: Fri, 23 May 2014 11:31:42 +0200
Subject: Freigabe Mechanismus implementiert, nun sollte die notwendige
 Grundlage für die Syncronisation vorhanden sein.

---
 Dozentenmodulserver/src/sql/SQL.java | 19 ++++++++++---------
 1 file changed, 10 insertions(+), 9 deletions(-)

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index 9a746093..98fc8ef7 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -231,7 +231,7 @@ public class SQL {
 
 	public boolean setImageData(String pk_person, boolean license,
 			boolean internet, long cpu, long ram, String imagename,
-			String imagePath, boolean isTemplate, long filesize) {
+			String imagePath, boolean isTemplate, long filesize, String shareMode) {
 
 		DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
 
@@ -249,7 +249,7 @@ public class SQL {
 			Statement stm = con.createStatement();
 			
 			String uid = UUID.randomUUID().toString();
-			stm.executeUpdate("INSERT INTO `bwLehrpool`.`m_VLData_imageInfo`(`GUID_imageID`,`imageVersion`,`image_name`,`image_path`,`image_lastCall`,`image_create_time`,`image_update_time`,`image_owner`,`image_change_by`,`rec_create_time`,`rec_change_time`,`rec_owner`,`rec_change_by`,`content_operatingSystem`,`status_isCompressed`,`status_isSecure`,`status_isOptimzed`,`status_isValid`,`status_isReady`,`status_isDeleted`,`status_isLastOfficialVersion`,`cond_hasLicenseRestriction`,`cond_hasInternetRestriction`,`cond_minRAM`,`cond_minCPUs`,`image_isTemplate`,`image_filesize`)VALUES('"
+			stm.executeUpdate("INSERT INTO `bwLehrpool`.`m_VLData_imageInfo`(`GUID_imageID`,`imageVersion`,`image_name`,`image_path`,`image_lastCall`,`image_create_time`,`image_update_time`,`image_owner`,`image_change_by`,`rec_create_time`,`rec_change_time`,`rec_owner`,`rec_change_by`,`content_operatingSystem`,`status_isCompressed`,`status_isSecure`,`status_isOptimzed`,`status_isValid`,`status_isReady`,`status_isDeleted`,`status_isLastOfficialVersion`,`cond_hasLicenseRestriction`,`cond_hasInternetRestriction`,`cond_minRAM`,`cond_minCPUs`,`image_isTemplate`,`image_filesize`,`image_syncMode`)VALUES('"
 					+ uid // GUID_imageID
 					+ "',1,'" // imageVersion
 					+ imagename // image_name
@@ -277,6 +277,7 @@ public class SQL {
 					+ "','" + cpu // cond_minCPUs
 					+ "','" + isTemplate //image_isTemplate
 					+ "','" + filesize //image_filesize
+					+ "','" + shareMode //shareMode
 					+ "');");
 			con.commit();
 			con.close();
@@ -486,20 +487,18 @@ public class SQL {
 			Connection con=getConnection();
 			Statement stm = con.createStatement();
 			ResultSet data=stm
-					.executeQuery("SELECT image_name,cond_hasInternetRestriction,cond_hasLicenseRestriction, cond_minCPUs, cond_minRAM FROM bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"
+					.executeQuery("SELECT image_name,cond_hasInternetRestriction,cond_hasLicenseRestriction, cond_minCPUs, cond_minRAM, image_syncMode,image_filesize,image_path FROM bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"
 							+ id + "' and imageVersion = '" + version + "' ;");
 			while (data.next()) {
-				System.out.println(data
-						.getString("cond_hasInternetRestriction")
-						+ data.getString("cond_hasLicenseRestriction")
-						+ data.getString("cond_minCPUs")
-						+ data.getString("cond_minRAM"));
 				map.put("name", data.getString("image_name"));
 				map.put("internet",
 						data.getString("cond_hasInternetRestriction"));
 				map.put("license", data.getString("cond_hasLicenseRestriction"));
 				map.put("cpu", data.getString("cond_minCPUs"));
 				map.put("ram", data.getString("cond_minRAM"));
+				map.put("shareMode", data.getString("image_syncMode"));
+				map.put("filesize", data.getString("image_filesize"));
+				map.put("path", data.getString("image_path"));
 			}
 			con.close();
 			return map;
@@ -513,7 +512,7 @@ public class SQL {
 
 	public int UpdateImageData(String name, String newName,String image_path,
 			boolean license, boolean internet, long cpu, long ram, String id,
-			String version, boolean isTemplate, long filesize) {
+			String version, boolean isTemplate, long filesize, String shareMode) {
 		try {
 			Connection con=getConnection();
 			DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
@@ -552,6 +551,8 @@ public class SQL {
 					+ isTemplate
 					+ "',`image_filesize` = '"
 					+ filesize
+					+ "',`image_syncMode` = '"
+					+ shareMode
 					+ "' WHERE `GUID_imageID` = '"
 					+ id
 					+ "' AND `imageVersion` = '" + version + "';");
-- 
cgit v1.2.3-55-g7522