public void processHostData() {
try {
PreparedStatement pstmt = sqlConnection.prepareStatement(Queries.getSqlInsertHostInfo());
AggregationOutput aggregationOutput =
mongoTask.getAggregatedOutput("host", Queries.getHostInfoQuery());
for (DBObject obj : aggregationOutput.results()) {
String hostname = (String) obj.get("hostname");
Double cpuUsage = Double.parseDouble(obj.get("cpuusage").toString());
Double cpuMax = Double.parseDouble(obj.get("cpumax").toString());
Double cpuPercent = Double.parseDouble(obj.get("cpupercentage").toString());
Double memUsage = Double.parseDouble(obj.get("memusage").toString());
Double memMax = Double.parseDouble(obj.get("memmax").toString());
Double memPercent = Double.parseDouble(obj.get("mempercentage").toString());
Double upTime = Double.parseDouble(obj.get("uptime").toString());
Double tx = Double.parseDouble(obj.get("tx").toString());
Double rx = Double.parseDouble(obj.get("rx").toString());
pstmt.setTimestamp(1, new java.sql.Timestamp(timeStamp.getTime()));
pstmt.setString(2, hostname);
pstmt.setDouble(3, cpuUsage);
pstmt.setDouble(4, cpuMax);
pstmt.setDouble(5, cpuPercent);
pstmt.setDouble(6, memUsage);
pstmt.setDouble(7, memMax);
pstmt.setDouble(8, memPercent);
pstmt.setDouble(9, upTime);
pstmt.setDouble(10, tx);
pstmt.setDouble(11, rx);
pstmt.addBatch();
}
pstmt.executeBatch();
} catch (SQLException s) {
s.printStackTrace();
}
}
