-\r
- long startInMillis = startDate.getTime();\r
- long endInMillis = endDate.getTime();\r
-\r
- sql = SQL_SELECT_NAME + feedids + SQL_FEED_ID + SQL_SELECT_COUNT + feedids + SQL_TYPE_PUB\r
- + SQL_SELECT_SUM\r
- + feedids + SQL_PUBLISH_LENGTH + SQL_SUBSCRIBER_URL\r
- + SQL_SUB_ID + SQL_DELIVERY_TIME + SQL_AVERAGE_DELAY + SQL_JOIN_RECORDS + feedids + ")" + subid + SQL_STATUS_204\r
- +" and e.event_time between " + startInMillis + " and " + endInMillis + SQL_GROUP_SUB_ID;\r
-\r
- return sql;\r
+ startInMillis = startDate.getTime();\r
+ endInMillis = endDate.getTime();\r
+ sql = SQL_SELECT_NAME + "?" + SQL_FEED_ID + SQL_SELECT_COUNT + "?" + SQL_TYPE_PUB + SQL_SELECT_SUM\r
+ + "?" + SQL_PUBLISH_LENGTH + SQL_SUBSCRIBER_URL + SQL_SUB_ID + SQL_DELIVERY_TIME + SQL_AVERAGE_DELAY\r
+ + SQL_JOIN_RECORDS + "?" + ") " + SQL_STATUS_204\r
+ + " and e.event_time between " + "?" + " and " + "?" + SQL_GROUP_SUB_ID;\r
+ compareType = "startAndEnd";\r
+ }\r
+ try (Connection conn = ProvDbUtils.getInstance().getConnection();\r
+ PreparedStatement ps = conn.prepareStatement(sql)) {\r
+ eventlogger.debug("SQL Query for Statistics resultset. " + sql);\r
+ intlogger.debug(sql);\r
+ ps.setString(1, feedids);\r
+ ps.setString(2, feedids);\r
+ ps.setString(3, feedids);\r
+ ps.setString(4, feedids);\r
+ if (compareType.equals(START)) {\r
+ ps.setLong(5, compareTime);\r
+ }\r
+ if (compareType.equals("startAndEnd")) {\r
+ ps.setLong(5, startInMillis);\r
+ ps.setLong(6, endInMillis);\r
+ }\r
+ rs = ps.executeQuery();\r
+ parseResult(outputType, out, resp, rs);\r