[server] Implement fetching preset runscripts

1 files changed, 13 insertions, 0 deletions

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)