1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
|
/*******************************************************************************
* ============LICENSE_START==================================================
* * org.onap.dmaap
* * ===========================================================================
* * Copyright © 2017 AT&T Intellectual Property. All rights reserved.
* * ===========================================================================
* * Licensed under the Apache License, Version 2.0 (the "License");
* * you may not use this file except in compliance with the License.
* * You may obtain a copy of the License at
* *
* * http://www.apache.org/licenses/LICENSE-2.0
* *
* * Unless required by applicable law or agreed to in writing, software
* * distributed under the License is distributed on an "AS IS" BASIS,
* * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* * See the License for the specific language governing permissions and
* * limitations under the License.
* * ============LICENSE_END====================================================
* *
* * ECOMP is a trademark and service mark of AT&T Intellectual Property.
* *
******************************************************************************/
package org.onap.dmaap.datarouter.reports;
import com.att.eelf.configuration.EELFLogger;
import com.att.eelf.configuration.EELFManager;
import java.io.FileNotFoundException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.util.TreeSet;
import org.onap.dmaap.datarouter.provisioning.utils.ProvDbUtils;
/**
* Generate a traffic volume report. The report is a .csv file containing the following columns:
* <table>
* <tr><td>date</td><td>the date for this record</td></tr>
* <tr><td>feedid</td><td>the Feed ID for this record</td></tr>
* <tr><td>filespublished</td><td>the number of files published on this feed and date</td></tr>
* <tr><td>bytespublished</td><td>the number of bytes published on this feed and date</td></tr>
* <tr><td>filesdelivered</td><td>the number of files delivered on this feed and date</td></tr>
* <tr><td>bytesdelivered</td><td>the number of bytes delivered on this feed and date</td></tr>
* <tr><td>filesexpired</td><td>the number of files expired on this feed and date</td></tr>
* <tr><td>bytesexpired</td><td>the number of bytes expired on this feed and date</td></tr>
* </table>
*
* @author Robert P. Eby
* @version $Id: VolumeReport.java,v 1.3 2014/02/28 15:11:13 eby Exp $
*/
public class VolumeReport extends ReportBase {
private EELFLogger loggerVolumeReport= EELFManager.getInstance().getLogger("ReportLog");
private class Counters {
int filespublished, filesdelivered, filesexpired;
long bytespublished, bytesdelivered, bytesexpired;
@Override
public String toString() {
return String.format("%d,%d,%d,%d,%d,%d",
filespublished, bytespublished, filesdelivered,
bytesdelivered, filesexpired, bytesexpired);
}
}
@Override
public void run() {
Map<String, Counters> map = new HashMap<>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
long start = System.currentTimeMillis();
try (Connection conn = ProvDbUtils.getInstance().getConnection()) {
// We need to run this SELECT in stages, because otherwise we run out of memory!
final long stepsize = 6000000L;
boolean goAgain = true;
for (long i = 0; goAgain; i += stepsize) {
try (PreparedStatement ps = conn.prepareStatement(
"select EVENT_TIME, TYPE, FEEDID, CONTENT_LENGTH, RESULT from LOG_RECORDS "
+ "where EVENT_TIME >= ? and EVENT_TIME <= ? LIMIT ?, ?")) {
ps.setLong(1, from);
ps.setLong(2, to);
ps.setLong(3, i);
ps.setLong(4, stepsize);
try (ResultSet rs = ps.executeQuery()) {
goAgain = false;
while (rs.next()) {
goAgain = true;
long etime = rs.getLong("EVENT_TIME");
String type = rs.getString("TYPE");
int feed = rs.getInt("FEEDID");
long clen = rs.getLong("CONTENT_LENGTH");
String key = sdf.format(new Date(etime)) + ":" + feed;
Counters c = map.get(key);
if (c == null) {
c = new Counters();
map.put(key, c);
}
if (type.equalsIgnoreCase("pub")) {
c.filespublished++;
c.bytespublished += clen;
} else if (type.equalsIgnoreCase("del")) {
// Only count successful deliveries
int statusCode = rs.getInt("RESULT");
if (statusCode >= 200 && statusCode < 300) {
c.filesdelivered++;
c.bytesdelivered += clen;
}
} else if (type.equalsIgnoreCase("exp")) {
c.filesexpired++;
c.bytesexpired += clen;
}
}
}
} catch (SQLException sqlException) {
loggerVolumeReport.error("SqlException", sqlException);
}
}
} catch (SQLException e) {
loggerVolumeReport.error("SQLException: " + e.getMessage());
}
logger.debug("Query time: " + (System.currentTimeMillis() - start) + " ms");
try (PrintWriter os = new PrintWriter(outfile)) {
os.println("date,feedid,filespublished,bytespublished,filesdelivered,bytesdelivered,filesexpired,bytesexpired");
for(String key :new TreeSet<String>(map.keySet()))
{
Counters c = map.get(key);
String[] p = key.split(":");
os.println(String.format("%s,%s,%s", p[0], p[1], c.toString()));
}
}
catch (FileNotFoundException e) {
System.err.println("File cannot be written: " + outfile);
}
}
}
|
