From e3fefe1c7093687265c883e2bf168f4bc63a0a74 Mon Sep 17 00:00:00 2001
From: Tobias Spitzer
Date: Thu, 17 Jul 2014 10:39:11 +0200
Subject: Es ist nun möglich ein Image als Vorlage definiert anzulegen und
 hochzuladen. Ebsenso ist es möglich eine Vorlage in ein bestehendes Image und
 andersrum zu tauschen

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

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index 98fc8ef7..ec768a40 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -487,7 +487,7 @@ 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, image_syncMode,image_filesize,image_path 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, image_isTemplate FROM bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"
 							+ id + "' and imageVersion = '" + version + "' ;");
 			while (data.next()) {
 				map.put("name", data.getString("image_name"));
@@ -499,6 +499,7 @@ public class SQL {
 				map.put("shareMode", data.getString("image_syncMode"));
 				map.put("filesize", data.getString("image_filesize"));
 				map.put("path", data.getString("image_path"));
+				map.put("template", data.getString("image_isTemplate"));
 			}
 			con.close();
 			return map;
@@ -750,4 +751,26 @@ public class SQL {
 		}
 		return -1;
 	}
+	
+	public List<String> getAllUniversities() {
+		List<String> list = new ArrayList<>();
+		try {
+			Connection con=getConnection();
+			Statement stm = con.createStatement();
+			ResultSet rs=stm
+					.executeQuery("SELECT name FROM bwLehrpool.m_institution;");
+			while (rs.next()) {
+				list.add(rs.getString("name"));
+			}
+			return list;
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			log.info(new Date() + " - Failed to getAllUniversities.");
+			e.printStackTrace();
+		}
+
+		return null;
+
+	}
 }
-- 
cgit v1.2.3-55-g7522