diff options
author | Simon Rettberg | 2015-09-10 18:51:20 +0200 |
---|---|---|
committer | Simon Rettberg | 2015-09-10 18:51:20 +0200 |
commit | 80af9ff6befbbe4204eab259c72c40df5cd5e5a1 (patch) | |
tree | f1c731d05841a6d2457db68b412f297d72edae76 /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) | |
download | tutor-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.java | 17 |
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); + } + } |