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

1 files changed, 24 insertions, 1 deletions

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;

+

+	}

 }