@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
url = "jdbc:mysql://mysql2.gigahost.dk:3306/fixwin_";
String db = req.getHeader("sql_db");
url = url + db;
try {
conn = DriverManager.getConnection(url, user, pass);
statement = conn.createStatement();
JSONArray teams = new JSONArray();
Map<Integer, Boolean> teamIDs = new HashMap<>();
ResultSet streaksResult =
statement.executeQuery("SELECT * FROM " + streaksTable + " where active = 1");
while (streaksResult.next()) {
teamIDs.put(streaksResult.getInt("teamId"), streaksResult.getInt("pending") == 1);
}
for (Map.Entry<Integer, Boolean> entry : teamIDs.entrySet()) {
int id = entry.getKey();
ResultSet teamsResult =
statement.executeQuery("SELECT * FROM " + teamsTable + " where id = " + id);
while (teamsResult.next()) {
JSONObject team = new JSONObject();
team.put("name", teamsResult.getString("name"));
team.put("league", teamsResult.getString("leagueShortName"));
team.put("nextGameTime", Integer.parseInt(teamsResult.getString("nextGameTimestamp")));
team.put("handled", entry.getValue());
teams.put(team);
}
}
resp.setCharacterEncoding("utf-8");
resp.getWriter().write(teams.toString());
} catch (SQLException | JSONException e) {
e.printStackTrace();
resp.getWriter().write(e.getMessage());
}
}
