X-Git-Url: https://gerrit.onap.org/r/gitweb?p=dmaap%2Fdatarouter.git;a=blobdiff_plain;f=datarouter-prov%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fdmaap%2Fdatarouter%2Fprovisioning%2Fbeans%2FLogRecord.java;h=0d027033d8367663ca0eaaa919165aa32029c1b4;hp=70b8e6a05291935bc989feaa79499936d6f253d6;hb=68a9ca240970fceaf12bbe91b7bad8e1d98ecd93;hpb=ac12c63cc36197e569fba1c54e45b1b999384321 diff --git a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/LogRecord.java b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/LogRecord.java index 70b8e6a0..0d027033 100644 --- a/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/LogRecord.java +++ b/datarouter-prov/src/main/java/org/onap/dmaap/datarouter/provisioning/beans/LogRecord.java @@ -24,145 +24,152 @@ package org.onap.dmaap.datarouter.provisioning.beans; +import com.att.eelf.configuration.EELFLogger; +import com.att.eelf.configuration.EELFManager; import java.io.IOException; import java.io.OutputStream; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; -import java.sql.Statement; import java.sql.Types; import java.text.ParseException; import java.util.Iterator; - -import org.onap.dmaap.datarouter.provisioning.utils.DB; +import org.onap.dmaap.datarouter.provisioning.utils.ProvDbUtils; import org.onap.dmaap.datarouter.provisioning.utils.RLEBitSet; + /** - * The representation of a Log Record, as retrieved from the DB. Since this record format is only used - * to replicate between provisioning servers, it is very bare-bones; e.g. there are no field setters and only 1 getter. + * The representation of a Log Record, as retrieved from the DB. Since this record format is only used to replicate + * between provisioning servers, it is very bare-bones; e.g. there are no field setters and only 1 getter. * * @author Robert Eby * @version $Id: LogRecord.java,v 1.7 2014/03/12 19:45:41 eby Exp $ */ public class LogRecord extends BaseLogRecord { - /** - * Print all log records whose RECORD_IDs are in the bit set provided. - * - * @param os the {@link OutputStream} to print the records on - * @param bs the {@link RLEBitSet} listing the record IDs to print - * @throws IOException - */ - public static void printLogRecords(OutputStream os, RLEBitSet bs) throws IOException { - final String sql = "select * from LOG_RECORDS where RECORD_ID >= ? AND RECORD_ID <= ?"; - DB db = new DB(); - Connection conn = null; - try { - conn = db.getConnection(); - try(Statement stmt = conn.createStatement()) { - Iterator iter = bs.getRangeIterator(); - try(PreparedStatement ps = conn.prepareStatement(sql)) { - while (iter.hasNext()) { - Long[] n = iter.next(); - ps.setLong(1, n[0]); - ps.setLong(2, n[1]); - try(ResultSet rs = ps.executeQuery()) { - while (rs.next()) { - LogRecord lr = new LogRecord(rs); - os.write(lr.toString().getBytes()); - } - ps.clearParameters(); - } - } - } - } - } catch (SQLException e) { - e.printStackTrace(); - } finally { - if (conn != null) - db.release(conn); - } - } + private static EELFLogger intlogger = EELFManager.getInstance().getLogger("InternalLog"); private final String type; - private final String feedFileid; + private final String feedFileID; private final String remoteAddr; private final String user; private final int status; - private final int subid; - private final String fileid; + private final int subID; + private final String fileID; private final int result; private final int attempts; private final String reason; - private final long record_id; + private final long recordId; private final long clength2; + private final String fileName; - public LogRecord(ResultSet rs) throws SQLException { + /** + * LogRecord constructor. + * @param rs ResultSet from SQL statement + * @throws SQLException in case of SQL error + */ + private LogRecord(ResultSet rs) throws SQLException { super(rs); this.type = rs.getString("TYPE"); - this.feedFileid = rs.getString("FEED_FILEID"); + this.feedFileID = rs.getString("FEED_FILEID"); this.remoteAddr = rs.getString("REMOTE_ADDR"); this.user = rs.getString("USER"); this.status = rs.getInt("STATUS"); - this.subid = rs.getInt("DELIVERY_SUBID"); - this.fileid = rs.getString("DELIVERY_FILEID"); + this.subID = rs.getInt("DELIVERY_SUBID"); + this.fileID = rs.getString("DELIVERY_FILEID"); this.result = rs.getInt("RESULT"); this.attempts = rs.getInt("ATTEMPTS"); this.reason = rs.getString("REASON"); - this.record_id = rs.getLong("RECORD_ID"); + this.recordId = rs.getLong("RECORD_ID"); this.clength2 = rs.getLong("CONTENT_LENGTH_2"); + this.fileName = rs.getString("FILENAME"); } + /** + * LogRecord Constructor from string array. + * @param pp string array of LogRecord attributes + * @throws ParseException in case of parse error + */ public LogRecord(String[] pp) throws ParseException { super(pp); this.type = pp[8]; - this.feedFileid = pp[9]; + this.feedFileID = pp[9]; this.remoteAddr = pp[10]; this.user = pp[11]; this.status = Integer.parseInt(pp[12]); - this.subid = Integer.parseInt(pp[13]); - this.fileid = pp[14]; + this.subID = Integer.parseInt(pp[13]); + this.fileID = pp[14]; this.result = Integer.parseInt(pp[15]); this.attempts = Integer.parseInt(pp[16]); this.reason = pp[17]; - this.record_id = Long.parseLong(pp[18]); - this.clength2 = (pp.length == 20) ? Long.parseLong(pp[19]) : 0; + this.recordId = Long.parseLong(pp[18]); + this.clength2 = (pp.length == 21) ? Long.parseLong(pp[19]) : 0; + this.fileName = pp[20]; + } + + /** + * Print all log records whose RECORD_IDs are in the bit set provided. + * + * @param os the {@link OutputStream} to print the records on + * @param bs the {@link RLEBitSet} listing the record IDs to print + * @throws IOException in case of I/O error + */ + public static void printLogRecords(OutputStream os, RLEBitSet bs) throws IOException { + Iterator iter = bs.getRangeIterator(); + try (Connection conn = ProvDbUtils.getInstance().getConnection(); + PreparedStatement ps = conn.prepareStatement( + "select * from LOG_RECORDS where RECORD_ID >= ? AND RECORD_ID <= ?")) { + while (iter.hasNext()) { + Long[] nxt = iter.next(); + ps.setLong(1, nxt[0]); + ps.setLong(2, nxt[1]); + try (ResultSet rs = ps.executeQuery()) { + while (rs.next()) { + LogRecord lr = new LogRecord(rs); + os.write(lr.toString().getBytes()); + } + ps.clearParameters(); + } + } + } catch (SQLException e) { + intlogger.error("PROV0001 printLogRecords: " + e.getMessage(), e); + } } public long getRecordId() { - return record_id; + return recordId; } @Override public String toString() { return - sdf.format(getEventTime()) + "|" - + "LOG|" - + getPublishId() + "|" - + getFeedid() + "|" - + getRequestUri() + "|" - + getMethod() + "|" - + getContentType() + "|" - + getContentLength() + "|" - + type + "|" - + feedFileid + "|" - + remoteAddr + "|" - + user + "|" - + status + "|" - + subid + "|" - + fileid + "|" - + result + "|" - + attempts + "|" - + reason + "|" - + record_id + "|" - + clength2 - + "\n"; + sdf.format(getEventTime()) + "|" + + "LOG|" + + getPublishId() + "|" + + getFeedid() + "|" + + getRequestUri() + "|" + + getMethod() + "|" + + getContentType() + "|" + + getContentLength() + "|" + + type + "|" + + feedFileID + "|" + + remoteAddr + "|" + + user + "|" + + status + "|" + + subID + "|" + + fileID + "|" + + result + "|" + + attempts + "|" + + reason + "|" + + recordId + "|" + + clength2 + + "\n"; } @Override @@ -170,7 +177,7 @@ public class LogRecord extends BaseLogRecord { ps.setString(1, type); super.load(ps); // loads fields 2-8 if (type.equals("pub")) { - ps.setString(9, feedFileid); + ps.setString(9, feedFileID); ps.setString(10, remoteAddr); ps.setString(11, user); ps.setInt(12, status); @@ -179,34 +186,37 @@ public class LogRecord extends BaseLogRecord { ps.setNull(15, Types.INTEGER); ps.setNull(16, Types.INTEGER); ps.setNull(17, Types.VARCHAR); - ps.setLong(18, record_id); + ps.setLong(18, recordId); ps.setNull(19, Types.BIGINT); + ps.setString(20, fileName); } else if (type.equals("del")) { ps.setNull(9, Types.VARCHAR); ps.setNull(10, Types.VARCHAR); ps.setString(11, user); ps.setNull(12, Types.INTEGER); - ps.setInt(13, subid); - ps.setString(14, fileid); + ps.setInt(13, subID); + ps.setString(14, fileID); ps.setInt(15, result); ps.setNull(16, Types.INTEGER); ps.setNull(17, Types.VARCHAR); - ps.setLong(18, record_id); + ps.setLong(18, recordId); ps.setNull(19, Types.BIGINT); + ps.setString(20, fileName); } else if (type.equals("exp")) { ps.setNull(9, Types.VARCHAR); ps.setNull(10, Types.VARCHAR); ps.setNull(11, Types.VARCHAR); ps.setNull(12, Types.INTEGER); - ps.setInt(13, subid); - ps.setString(14, fileid); + ps.setInt(13, subID); + ps.setString(14, fileID); ps.setNull(15, Types.INTEGER); ps.setInt(16, attempts); ps.setString(17, reason); - ps.setLong(18, record_id); + ps.setLong(18, recordId); ps.setNull(19, Types.BIGINT); + ps.setString(20, fileName); } else if (type.equals("pbf")) { - ps.setString(9, feedFileid); + ps.setString(9, feedFileID); ps.setString(10, remoteAddr); ps.setString(11, user); ps.setNull(12, Types.INTEGER); @@ -215,24 +225,26 @@ public class LogRecord extends BaseLogRecord { ps.setNull(15, Types.INTEGER); ps.setNull(16, Types.INTEGER); ps.setNull(17, Types.VARCHAR); - ps.setLong(18, record_id); + ps.setLong(18, recordId); ps.setLong(19, clength2); + ps.setString(20, fileName); } else if (type.equals("dlx")) { ps.setNull(9, Types.VARCHAR); ps.setNull(10, Types.VARCHAR); ps.setNull(11, Types.VARCHAR); ps.setNull(12, Types.INTEGER); - ps.setInt(13, subid); + ps.setInt(13, subID); ps.setNull(14, Types.VARCHAR); ps.setNull(15, Types.INTEGER); ps.setNull(16, Types.INTEGER); ps.setNull(17, Types.VARCHAR); - ps.setLong(18, record_id); + ps.setLong(18, recordId); ps.setLong(19, clength2); + ps.setString(20, fileName); } } - public static void main(String[] a) throws IOException { - LogRecord.printLogRecords(System.out, new RLEBitSet(a[0])); + public static void main(String[] args) throws IOException { + LogRecord.printLogRecords(System.out, new RLEBitSet(args[0])); } }