@Override
protected void get() throws RequestException {
int year = Integer.parseInt(getUrlParameter("year"));
int month = Integer.parseInt(getUrlParameter("month"));
String sql =
"SELECT empire_id, rank, total_stars, total_colonies, total_buildings,"
+ " total_ships, total_population"
+ " FROM empire_rank_histories"
+ " WHERE date >= ?"
+ " AND date < ?"
+ " ORDER BY rank, date DESC";
try (SqlStmt stmt = DB.prepare(sql)) {
stmt.setDateTime(1, new DateTime(year, month, 1, 0, 0, DateTimeZone.UTC));
stmt.setDateTime(2, new DateTime(year, month, 1, 0, 0, DateTimeZone.UTC).plusMonths(1));
SqlResult res = stmt.select();
int lastRank = 0;
Messages.EmpireRanks.Builder empire_ranks_pb = Messages.EmpireRanks.newBuilder();
empire_ranks_pb.setDate(
new DateTime(year, month, 1, 0, 0, DateTimeZone.UTC).getMillis() / 1000);
while (res.next()) {
int rank = res.getInt(2);
if (rank == lastRank) {
continue;
}
lastRank = rank;
Messages.EmpireRank.Builder empire_rank_pb = Messages.EmpireRank.newBuilder();
empire_rank_pb.setEmpireKey(Integer.toString(res.getInt(1)));
empire_rank_pb.setRank(rank);
empire_rank_pb.setTotalStars(res.getInt(3));
empire_rank_pb.setTotalColonies(res.getInt(4));
empire_rank_pb.setTotalBuildings(res.getInt(5));
empire_rank_pb.setTotalShips(res.getInt(6));
empire_rank_pb.setTotalPopulation(res.getInt(7));
empire_ranks_pb.addRanks(empire_rank_pb);
}
setResponseBody(empire_ranks_pb.build());
} catch (Exception e) {
throw new RequestException(e);
}
}
