[server] Implemente setImageVersionExpiry

1 files changed, 13 insertions, 0 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 34ecce5c..320f6cc5 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
@@ -999,4 +999,17 @@ public class DbImage {
 		}
 	}
 
+	public static void setExpireDate(String imageVersionId, long expireTime) throws SQLException {
+		try (MysqlConnection connection = Database.getConnection()) {
+			MysqlStatement stmt = connection.prepareStatement("UPDATE imageversionid SET expiretime = :expiretime"
+					+ " WHERE imageversionid = :imageversionid");
+			stmt.setString("imageversionid", imageVersionId);
+			stmt.setLong("expiretime", expireTime);
+			stmt.executeUpdate();
+		} catch (SQLException e) {
+			LOGGER.error("Query failed in DbImage.setExpireDate()", e);
+			throw e;
+		}
+	}
+
 }