diff options
| author | ralph isenmann | 2020-08-18 11:33:25 +0200 |
|---|---|---|
| committer | ralph isenmann | 2020-09-15 13:47:54 +0200 |
| commit | 020035e91913dc034f338c88fa09a3b0b41faa7c (patch) | |
| tree | a7fa40c1ba63cbc2dfe3ec3ba6279637bf2d6d01 /dozentenmodulserver/src | |
| parent | [client] handle dockerfile als metadata (diff) | |
| download | tutor-module-020035e91913dc034f338c88fa09a3b0b41faa7c.tar.gz tutor-module-020035e91913dc034f338c88fa09a3b0b41faa7c.tar.xz tutor-module-020035e91913dc034f338c88fa09a3b0b41faa7c.zip | |
[server] Modify sql Statement to receive metadata
Left Join on os_x_virt table because there is no combination of osid and virtid for docker.
Diffstat (limited to 'dozentenmodulserver/src')
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | 2 |
1 files changed, 1 insertions, 1 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 a57be8da..e0799c29 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 @@ -567,7 +567,7 @@ public class DbLecture { + " FROM lecture l " + " INNER JOIN imageversion i USING (imageversionid)" + " INNER JOIN imagebase b USING (imagebaseid)" - + " INNER JOIN os_x_virt o USING (osid, virtid)" + " WHERE l.lectureid = :lectureid"); + + " LEFT JOIN os_x_virt o USING (osid, virtid)" + " WHERE l.lectureid = :lectureid"); stmt.setString("lectureid", lectureId); ResultSet rs = stmt.executeQuery(); long now = Util.unixTime(); |