public static void duration() {
connectDb();
String sql = "select min(time), max(time), count(*) from " + tablename + ";";
try {
ResultSet rs = query.executeQuery(sql);
rs.next();
int numCols = rs.getMetaData().getColumnCount();
String minTime = rs.getString(1);
String maxTime = rs.getString(2);
String numPackets = rs.getString(3);
System.out.println(
"Experiment "
+ tablename
+ "\n\tfrom: "
+ minTime
+ "\n\tto: "
+ maxTime
+ "\n\tpackets: "
+ numPackets);
} catch (SQLException e) {
System.out.println("SQL Exception: " + e);
System.exit(1);
}
}
public static void clearTable() {
connectDb();
String sql = "delete from " + tablename + ";";
try {
query.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("SQL Exception: " + e);
System.exit(1);
}
System.out.println("Table Cleared Successfully");
}
public static void createTable() {
connectDb();
String dataField = "";
for (int i = 0; i < AM_HEADER_LENGTH + TOSH_DATA_LENGTH + CRC_LENGTH; i++) {
dataField = dataField + ", " + "b" + Integer.toString(i) + " smallint";
}
String sql =
"create table "
+ tablename
+ " (time timestamp without time zone, packetid serial"
+ dataField;
sql += ", primary key (packetid) );";
try {
query.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("SQL Exception: " + e);
System.exit(1);
}
System.out.println("Initialise Table Successfully");
}
static void listen() {
if (doLogging == true) {
// first we connect to the database first
connectDb();
}
PacketSource reader = BuildSource.makePacketSource(source);
if (reader == null) {
System.out.println("Cannot connect to destination.");
System.out.println("Did you forget to do network@ip:port? Destination maybe wrong or busy");
}
try {
reader.open(PrintStreamMessenger.err);
for (; ; ) {
byte[] packet = reader.readPacket();
if (doLogging == true) logPacket(packet);
if (doDisplay == true) PrettyPrint.print(packet);
System.out.println();
}
} catch (IOException e) {
System.err.println("Error on " + reader.getName() + ": " + e);
}
}