diff options
| author | Simon Rettberg | 2015-09-03 14:30:34 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-03 14:30:34 +0200 |
| commit | f31c979821a65309868b89591b1d9158ce1aa3e6 (patch) | |
| tree | 22a8fd48b56d8a4cc680a251db7a77dc2d53af87 /dozentenmodulserver/src/main/java | |
| parent | Merge branch 'v1.1' of git.openslx.org:openslx-ng/tutor-module into v1.1 (diff) | |
| download | tutor-module-f31c979821a65309868b89591b1d9158ce1aa3e6.tar.gz tutor-module-f31c979821a65309868b89591b1d9158ce1aa3e6.tar.xz tutor-module-f31c979821a65309868b89591b1d9158ce1aa3e6.zip | |
[server] Update usage stats of lectures
Diffstat (limited to 'dozentenmodulserver/src/main/java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | 8 |
1 files changed, 8 insertions, 0 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 74b2cad3..5f4bfaac 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 @@ -436,6 +436,7 @@ public class DbLecture { public static VmMetaData getClientLaunchData(String lectureId) throws SQLException, TNotFoundException { try (MysqlConnection connection = Database.getConnection()) { + // Get required data about lecture and used image MysqlStatement stmt = connection.prepareStatement("SELECT" + " l.displayname AS lecturename, l.starttime, l.endtime, l.isenabled," + " o.virtoskeyword, i.filepath, i.virtualizerconfig" @@ -460,6 +461,13 @@ public class DbLecture { meta.setOs(rs.getString("virtoskeyword")); } meta.addHddTemplate("%VM_DISK_PATH%"); + // Everything worked so far, update statistics counters + MysqlStatement upStmt = connection.prepareStatement("UPDATE" + + " lecture SET lastused = UNIX_TIMESTAMP(), usecount = usecount + 1" + + " WHERE lectureid = :lectureid"); + upStmt.setString("lectureid", lectureId); + upStmt.executeUpdate(); + connection.commit(); return meta; } catch (SQLException e) { LOGGER.error("Query failed in DbLecture.getClientLaunchData()", e); |