From 9c41b164fab7ef482995f2db0fb72ad8c4b6ac64 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 26 Feb 2019 18:12:46 +0100
Subject: [server] Implement fetching preset runscripts

---
 .../org/openslx/bwlp/sat/database/mappers/DbLecture.java    |  1 +
 .../org/openslx/bwlp/sat/database/mappers/DbRunScript.java  | 13 +++++++++++++
 2 files changed, 14 insertions(+)

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
index faa708ba..a51a168a 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
@@ -353,6 +353,7 @@ public class DbLecture {
 			lecture.setPresetLdapFilters(new ArrayList<Integer>());
 			DbLectureFilter.getSplitForLectureLdap(connection, lectureId,
 					lecture.ldapFilters, lecture.presetLdapFilters);
+			lecture.setPresetScriptIds(DbRunScript.getForEdit(connection, lectureId));
 			return lecture;
 		} catch (SQLException e) {
 			LOGGER.error("Query failed in DbLecture.getLectureDetails()", e);
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java
index 2037879d..20df4299 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java
@@ -86,6 +86,19 @@ public class DbRunScript {
 		}
 		return list;
 	}
+	
+	public static List<Integer> getForEdit(MysqlConnection connection, String lectureId) throws SQLException
+	{
+		MysqlStatement stmt = connection.prepareStatement("SELECT runscriptid FROM lecture_x_runscript"
+				+ " WHERE lectureid = :lectureid");
+		stmt.setString("lectureid", lectureId);
+		ResultSet rs = stmt.executeQuery();
+		List<Integer> result = new ArrayList<>();
+		while (rs.next()) {
+			result.add(rs.getInt("runscriptid"));
+		}
+		return result;
+	}
 
 	private static List<Integer> splitStringToInt(String input) {
 		if (input == null)
-- 
cgit v1.2.3-55-g7522