[server] Schema changes, distinct delete flag for images

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);
+	}
+
 }