diff options
| author | Simon Rettberg | 2015-09-05 19:42:54 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-05 19:42:54 +0200 |
| commit | 3a7b32ff9f679cfbff21dff88fdc7839e011f583 (patch) | |
| tree | df31e907a7d3bde55e1105e208969a7ed9bed467 /dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | |
| parent | [server] Sanitize permissions when saving/checking (diff) | |
| download | tutor-module-3a7b32ff9f679cfbff21dff88fdc7839e011f583.tar.gz tutor-module-3a7b32ff9f679cfbff21dff88fdc7839e011f583.tar.xz tutor-module-3a7b32ff9f679cfbff21dff88fdc7839e011f583.zip | |
[server] Fix delete old lectures query
Diffstat (limited to 'dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | 2 |
1 files changed, 1 insertions, 1 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 e5e7fe4f..97c79f5e 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 @@ -477,7 +477,7 @@ public class DbLecture { public static void deleteOld(int minAgeDays) throws SQLException { try (MysqlConnection connection = Database.getConnection()) { - MysqlStatement stmt = connection.prepareStatement("DELETE FROM lecture WHERE enddate < :cutoff"); + MysqlStatement stmt = connection.prepareStatement("DELETE FROM lecture WHERE endtime < :cutoff"); stmt.setLong("cutoff", Util.unixTime() - TimeUnit.DAYS.toSeconds(minAgeDays)); stmt.executeUpdate(); connection.commit(); |