diff options
Diffstat (limited to 'dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java')
-rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 18 |
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; + } + } + } |