diff options
| author | Simon Rettberg | 2015-09-09 11:36:26 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-09 11:36:26 +0200 |
| commit | d8ca4aa29ae120b0b56ef231d7e13e63bf54892b (patch) | |
| tree | 85d3f3e19f04b02f0fccd411571eb5e498753754 /dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | |
| parent | [client] Tweak caching strategies for meta data (diff) | |
| download | tutor-module-d8ca4aa29ae120b0b56ef231d7e13e63bf54892b.tar.gz tutor-module-d8ca4aa29ae120b0b56ef231d7e13e63bf54892b.tar.xz tutor-module-d8ca4aa29ae120b0b56ef231d7e13e63bf54892b.zip | |
[server] Debug code for mail gen
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 | 14 |
1 files changed, 13 insertions, 1 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 8cb8bb9e..bbbb8c8d 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 @@ -767,13 +767,25 @@ public class DbImage { */ private static boolean setLatestVersion(MysqlConnection connection, String imageBaseId, LocalImageVersion latest) throws SQLException { + // Debug + MysqlStatement ds = connection.prepareStatement("SELECT latestversionid FROM imagebase WHERE imagebaseid = :imagebaseid"); + ds.setString("imagebaseid", imageBaseId); + ResultSet drs = ds.executeQuery(); + if (drs.next()) { + LOGGER.debug("set latest on " + imageBaseId + ": from " + drs.getString("latestversionid") + + " to " + (latest == null ? null : latest.imageVersionId)); + } else { + LOGGER.debug("set latest: could not determine old latest for " + imageBaseId); + } // Update latestversionid reference in imagebase table MysqlStatement latestStmt = connection.prepareStatement("UPDATE imagebase SET latestversionid = :newversionid" + " WHERE imagebaseid = :imagebaseid"); latestStmt.setString("newversionid", latest == null ? null : latest.imageVersionId); latestStmt.setString("imagebaseid", imageBaseId); // If nothing changed (because the deleted version was not the latest), bail out - if (latestStmt.executeUpdate() == 0) + int updateCount = latestStmt.executeUpdate(); + LOGGER.debug(updateCount + " rows affected"); + if (updateCount == 0) return false; // It there is no valid version, bail out as a shortcut - queries below wouldn't do anything if (latest == null) |