diff options
| author | Simon Rettberg | 2015-10-29 16:16:46 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2015-10-29 16:16:46 +0100 |
| commit | 1d9e5d2e9fb830a5d45fe1ecdae1feb0fe122e7d (patch) | |
| tree | d4384f7ee9013650578d61a9c5284df643e02558 /dozentenmodulserver | |
| parent | [client] Make MapHelper null safe and do lectureCache refresh with QuickTimer... (diff) | |
| download | tutor-module-1d9e5d2e9fb830a5d45fe1ecdae1feb0fe122e7d.tar.gz tutor-module-1d9e5d2e9fb830a5d45fe1ecdae1feb0fe122e7d.tar.xz tutor-module-1d9e5d2e9fb830a5d45fe1ecdae1feb0fe122e7d.zip | |
[server] unlinkLecture: Actually execute query; deleteImgVersion: only unlink lectures, don't delete them (as it was planned!)
Diffstat (limited to 'dozentenmodulserver')
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 4 | ||||
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | 1 |
2 files changed, 3 insertions, 2 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java index ace8df01..55fa02b2 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java @@ -640,9 +640,9 @@ public class DbImage { public static void deleteVersionPermanently(LocalImageVersion image) throws SQLException { try (MysqlConnection connection = Database.getConnection()) { - DbLecture.deletePermanently(connection, image); // Unlink any linked lectures DbLecture.unlinkFromImageVersion(connection, image.imageVersionId); + //DbLecture.deletePermanently(connection, image); // Unlink latest version field from image base MysqlStatement unlinkStmt = connection.prepareStatement("UPDATE imagebase SET latestversionid = NULL" + " WHERE latestversionid = :imageversionid"); @@ -654,7 +654,7 @@ public class DbImage { stmt.executeUpdate(); connection.commit(); } catch (SQLException e) { - LOGGER.error("Query failed in DbImage.deleteVersionPermanently()", e); + LOGGER.error("Query failed in DbImage.deleteVersionPermanently(2)", e); throw e; } } 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 1436aa36..0ed62770 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 @@ -532,6 +532,7 @@ public class DbLecture { MysqlStatement stmt = connection.prepareStatement("UPDATE lecture SET imageversionid = NULL" + " WHERE imageversionid = :imageversionid"); stmt.setString("imageversionid", imageVersionId); + stmt.executeUpdate(); } } |