[server] RPC: Add "scan for orphaned files" function

This function can either just scan, or scan and delete for files on the
vmstore that don't have a matching entry in the database. This can
happen if you restore an older backup after having uploaded new VMs.

References #3321

1 files changed, 18 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 ca4c3e3c..6b672c86 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
@@ -1067,4 +1067,22 @@ public class DbImage {
 		}
 	}
 
+	/**
+	 * Get all known file names of images, regardless of whether they are working/valid.
+	 */
+	public static Set<String> getAllFilenames() throws SQLException {
+		try (MysqlConnection connection = Database.getConnection()) {
+			MysqlStatement stmt = connection.prepareStatement("SELECT filepath FROM imageversion");
+			ResultSet rs = stmt.executeQuery();
+			Set<String> result = new HashSet<>();
+			while (rs.next()) {
+				result.add(rs.getString("filepath"));
+			}
+			return result;
+		} catch (SQLException e) {
+			LOGGER.error("Query failed in DbImage.getAllFilenames()", e);
+			throw e;
+		}
+	}
+
 }