diff options
author | Simon Rettberg | 2019-02-26 18:12:46 +0100 |
---|---|---|
committer | Simon Rettberg | 2019-02-26 18:12:46 +0100 |
commit | 9c41b164fab7ef482995f2db0fb72ad8c4b6ac64 (patch) | |
tree | fb6785f4a8b529e3017b837d6c08ce772fe78e82 | |
parent | [client] properly enable custom sat field (diff) | |
download | tutor-module-9c41b164fab7ef482995f2db0fb72ad8c4b6ac64.tar.gz tutor-module-9c41b164fab7ef482995f2db0fb72ad8c4b6ac64.tar.xz tutor-module-9c41b164fab7ef482995f2db0fb72ad8c4b6ac64.zip |
[server] Implement fetching preset runscripts
-rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | 1 | ||||
-rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java | 13 |
2 files changed, 14 insertions, 0 deletions
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) |