From 99538bd2cc35d2580dabdb4b16d68c5cce108e4d Mon Sep 17 00:00:00 2001
From: unknown
Date: Tue, 11 Mar 2014 10:21:56 +0100
Subject: Es ist nun möglich die Metadaten eines Images über das Dozentenmodul
 zu updaten

---
 Dozentenmodulserver/src/sql/SQL.java | 44 +++++++++++++++++++++++++++++++++++-
 1 file changed, 43 insertions(+), 1 deletion(-)

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index 9f9ba352..2e81116a 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -171,7 +171,7 @@ public class SQL {
 		{
 			internet_bol=1;
 		}
-		else if(license==true)
+		if(license==true)
 		{
 			license_bol=1;
 		}
@@ -272,4 +272,46 @@ public class SQL {
 		}
 		return null;
 	}
+	
+	public ResultSet getImageData(Connection con,String name){
+		try {
+			Statement stm=con.createStatement();
+			System.out.println("Test");
+			return stm.executeQuery("SELECT image_name,cond_hasInternetRestriction,cond_hasLicenseRestriction, cond_minCPUs, cond_minRAM FROM bwLehrpool.m_VLData_imageInfo where image_name like '"+name+"';");
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		return null;
+	}
+	
+	public int UpdateImageData(Connection con,String name,String newName,boolean license, boolean internet, long cpu, long ram){
+		try {
+			DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
+			Statement stm=con.createStatement();
+			ResultSet rs=getImageIDandVersion(con, name);
+			rs.next();
+			System.out.println(rs.getString("GUID_imageID")+"Version"+rs.getString("imageVersion"));
+			int newVersion=rs.getInt("imageVersion")+1;
+			int internet_bol=0;
+			int license_bol=0;
+			if(internet==true)
+			{
+				internet_bol=1;
+			}
+			if(license==true)
+			{
+				license_bol=1;
+			}
+			System.out.println(internet_bol);
+			System.out.println(license_bol);
+			stm.executeUpdate("UPDATE `bwLehrpool`.`m_VLData_imageInfo` SET `imageVersion` = '"+newVersion+"',`image_name` = '"+newName+"',`image_update_time` = '"+formatter.format(new Date())+"',`rec_change_time` = '"+formatter.format(new Date())+"',`cond_hasLicenseRestriction` = '"+license_bol+"',`cond_hasInternetRestriction` = '"+internet_bol+"',`cond_minRAM` = '"+ram+"',`cond_minCPUs` = '"+cpu+"' WHERE `GUID_imageID` = '"+rs.getString("GUID_imageID")+"' AND `imageVersion` = '"+rs.getString("imageVersion")+"';");
+			con.commit();
+			return 0;
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		return -1;
+	}
 }
-- 
cgit v1.2.3-55-g7522