From 13a778fcb35093cb50dc8f14664f7ffeb4574493 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Wed, 9 Jan 2019 11:49:40 +0100 Subject: [server] Get runscripts for lecture: Fix query --- .../openslx/bwlp/sat/database/mappers/DbRunScript.java | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 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 172ef691..26b2c2e2 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 @@ -43,13 +43,14 @@ public class DbRunScript { int osId) { List retval = null; try { - MysqlStatement stmt = connection.prepareStatement("SELECT s.content, s.extension, s.visibility, s.passcreds" - + " FROM presetrunscript s" - + " INNER JOIN lecture_x_runscript lxr ON " - + " ((lxr.lectureid = :lectureid AND lxr.runscriptid = s.runscriptid) OR (s.isglobal))" - + " INNER JOIN presetrunscript_x_operatingsystem pxo ON " - + " (pxo.runscriptid = s.runscriptid AND pxo.osid = :osid)" - + " ORDER BY s.scriptname ASC"); + MysqlStatement stmt = connection.prepareStatement("SELECT us.content, us.extension, us.visibility, us.passcreds" + + " FROM (SELECT s.scriptname, s.content, s.extension, s.visibility, s.passcreds, s.runscriptid" + + " FROM presetrunscript s" + + " INNER JOIN lecture_x_runscript lxr ON (lxr.lectureid = :lectureid AND lxr.runscriptid = s.runscriptid)" + + " UNION SELECT t.scriptname, t.content, t.extension, t.visibility, t.passcreds, t.runscriptid" + + " FROM presetrunscript t WHERE t.isglobal" + + " ) us INNER JOIN presetrunscript_x_operatingsystem pxo ON (pxo.runscriptid = us.runscriptid AND pxo.osid = :osid)" + + " ORDER BY us.scriptname ASC"); stmt.setString("lectureid", lectureId); stmt.setInt("osid", osId); ResultSet rs = stmt.executeQuery(); -- cgit v1.2.3-55-g7522