summaryrefslogtreecommitdiffstats
path: root/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
diff options
context:
space:
mode:
authorSimon Rettberg2015-09-10 18:51:20 +0200
committerSimon Rettberg2015-09-10 18:51:20 +0200
commit80af9ff6befbbe4204eab259c72c40df5cd5e5a1 (patch)
treef1c731d05841a6d2457db68b412f297d72edae76 /dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
parent[client] LectureDetails: moved fields around to keep the same order as in Ima... (diff)
downloadtutor-module-80af9ff6befbbe4204eab259c72c40df5cd5e5a1.tar.gz
tutor-module-80af9ff6befbbe4204eab259c72c40df5cd5e5a1.tar.xz
tutor-module-80af9ff6befbbe4204eab259c72c40df5cd5e5a1.zip
[server] Schema changes, distinct delete flag for images
Diffstat (limited to 'dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java')
-rw-r--r--dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java17
1 files changed, 17 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 b93e1464..0e6b4ec1 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
@@ -511,4 +511,21 @@ public class DbLecture {
}
}
+ public static void unlinkFromImageVersion(String imageVersionId) throws SQLException {
+ try (MysqlConnection connection = Database.getConnection()) {
+ unlinkFromImageVersion(connection, imageVersionId);
+ connection.commit();
+ } catch (SQLException e) {
+ LOGGER.error("Query failed in DbLecture.unlinkFromImageVersion()", e);
+ throw e;
+ }
+ }
+
+ protected static void unlinkFromImageVersion(MysqlConnection connection, String imageVersionId)
+ throws SQLException {
+ MysqlStatement stmt = connection.prepareStatement("UPDATE lecture SET imageversionid = NULL"
+ + " WHERE imageversionid = :imageversionid");
+ stmt.setString("imageversionid", imageVersionId);
+ }
+
}