StatsDB (jadex-platform-extension-relay 3.0.0-RC16 API)

java.lang.Object
- jadex.base.relay.StatsDB

```
public class StatsDB
extends java.lang.Object
```
Database connector for reading and writing statistics via JavaDB. Can be invoked as main for executing sql on the DB. For example use the following to show properties of platforms from a given IP: select * from relay.properties where exists (select * from relay.platforminfo where hostip='127.0.0.1' AND relay.properties.id=relay.platforminfo.id)

Field Summary

Fields
Modifier and Type	Field and Description
`protected java.sql.Connection`	`con` The db connection (if any).
`protected java.sql.PreparedStatement`	`deleteprops` The prepared delete properties statement.
`protected java.sql.PreparedStatement`	`getlatest` The prepared get latest entry query statement.
`protected java.sql.PreparedStatement`	`insert` The prepared insert statement for new platform entries (without dbid).
`protected java.sql.PreparedStatement`	`insert2` The prepared insert statement for remote platform entries (with dbid).
`protected java.sql.PreparedStatement`	`insertprops` The prepared insert properties statement.
`protected java.util.Map<java.lang.String,java.lang.Integer>`	`latest` The latest entries (cached for speed).
`protected java.lang.String`	`peerid` The peer id.
`protected java.sql.PreparedStatement`	`update` The prepared update statement for platform entries.

Constructor Summary

Constructors
Modifier Constructor and Description

protected StatsDB(java.lang.String peerid, java.sql.Connection con)
Create the db object.

Constructors
Modifier	Constructor and Description
`protected`	`StatsDB(java.lang.String peerid, java.sql.Connection con)` Create the db object.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`static StatsDB`	`createDB(java.lang.String peerid)` Create the db object.
`java.util.Iterator<PlatformInfo>`	`getAllPlatformInfos(boolean properties)` Get all saved platform infos for direct data export (sorted by id, oldest first).
`int`	`getLatestEntry(java.lang.String peerid)` Get the latest id for a peer.
`PlatformInfo[]`	`getPlatformInfos(int limit)` Get cumulated platform infos per ip to use for display (sorted by recency, newest first).
`PlatformInfo[]`	`getPlatformInfosForSync(java.lang.String peerid, int startid, int cnt)` Get platform infos for history synchronization
`protected static void`	`logResultSet(java.sql.ResultSet rs)` Print out the contents of a result set.
`static void`	`main(java.lang.String[] args)` Test the stats db.
`protected void`	`migrateFrom(StatsDB old)` Migrate from one database to another.
`protected static java.sql.Connection`	`openDerbyDB()` Create a derby db connection.
`protected static java.sql.Connection`	`openH2DB(java.lang.String peerid)` Create a derby db connection.
`protected static void`	`printPlatformInfos(java.util.Iterator<PlatformInfo> infos)` Print out the contents of a result set.
`protected static void`	`printPlatformInfos(PlatformInfo[] infos)` Print out the contents of a result set.
`protected static void`	`printResultSet(java.sql.ResultSet rs)` Print out the contents of a result set.
`void`	`save(PlatformInfo pi)` Save (insert or update) a platform info object.
`void`	`shutdown()` Close the database connection on exit.
`void`	`writePlatformInfos(java.io.OutputStream out, int limit)` Write platform infos as JSON to the provided output stream.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - peerid
```
protected java.lang.String peerid
```
    The peer id.
  - con
```
protected java.sql.Connection con
```
    The db connection (if any).
  - insert
```
protected java.sql.PreparedStatement insert
```
    The prepared insert statement for new platform entries (without dbid).
  - insert2
```
protected java.sql.PreparedStatement insert2
```
    The prepared insert statement for remote platform entries (with dbid).
  - update
```
protected java.sql.PreparedStatement update
```
    The prepared update statement for platform entries.
  - getlatest
```
protected java.sql.PreparedStatement getlatest
```
    The prepared get latest entry query statement.
  - deleteprops
```
protected java.sql.PreparedStatement deleteprops
```
    The prepared delete properties statement.
  - insertprops
```
protected java.sql.PreparedStatement insertprops
```
    The prepared insert properties statement.
  - latest
```
protected java.util.Map<java.lang.String,java.lang.Integer> latest
```
    The latest entries (cached for speed).
- Constructor Detail
  - StatsDB
```
protected StatsDB(java.lang.String peerid,
                  java.sql.Connection con)
```
    Create the db object.
- Method Detail
  - createDB
```
public static StatsDB createDB(java.lang.String peerid)
```
    Create the db object.
    
    Returns:
    
    null, if creation fails.
  - openDerbyDB
```
protected static java.sql.Connection openDerbyDB()
                                          throws java.lang.Exception
```
    Create a derby db connection.
    
    Throws:
    
    java.lang.Exception
  - openH2DB
```
protected static java.sql.Connection openH2DB(java.lang.String peerid)
                                       throws java.lang.Exception
```
    Create a derby db connection.
    
    Throws:
    
    java.lang.Exception
  - save
```
public void save(PlatformInfo pi)
```
    Save (insert or update) a platform info object.
    
    Parameters:
    
    pi - The platform info.
  - getAllPlatformInfos
```
public java.util.Iterator<PlatformInfo> getAllPlatformInfos(boolean properties)
```
    Get all saved platform infos for direct data export (sorted by id, oldest first).
    
    Returns:
    
    All stored platform infos.
  - getPlatformInfosForSync
```
public PlatformInfo[] getPlatformInfosForSync(java.lang.String peerid,
                                              int startid,
                                              int cnt)
```
    Get platform infos for history synchronization
    
    Parameters:
    
    peerid - The peer id;
    
    startid - Start id;
    
    cnt - The number of entries to retrieve;
    
    Returns:
    
    Up to cnt platform infos (less means no more available).
  - getPlatformInfos
```
public PlatformInfo[] getPlatformInfos(int limit)
```
    Get cumulated platform infos per ip to use for display (sorted by recency, newest first).
    
    Parameters:
    
    limit - Limit the number of results (-1 for no limit);
    
    Returns:
    
    Up to limit platform infos.
  - writePlatformInfos
```
public void writePlatformInfos(java.io.OutputStream out,
                               int limit)
```
    Write platform infos as JSON to the provided output stream. Cumulated per ip/platform to use for display (sorted by recency, newest first).
    
    Parameters:
    
    limit - Limit the number of results (-1 for no limit);
  - getLatestEntry
```
public int getLatestEntry(java.lang.String peerid)
```
    Get the latest id for a peer. Only considers completed (immutable platform infos), i.e., that have a disconnection time set.
    
    Returns:
    
    The latest id or 0 if no entry for that peer or -1 in case of db error.
  - shutdown
```
public void shutdown()
```
    Close the database connection on exit.
  - migrateFrom
```
protected void migrateFrom(StatsDB old)
```
    Migrate from one database to another.
  - main
```
public static void main(java.lang.String[] args)
                 throws java.lang.Exception
```
    Test the stats db.
    
    Parameters:
    
    args - Ignored.
    
    Throws:
    
    java.lang.Exception - on database problems.
  - printPlatformInfos
```
protected static void printPlatformInfos(PlatformInfo[] infos)
```
    Print out the contents of a result set.
  - printPlatformInfos
```
protected static void printPlatformInfos(java.util.Iterator<PlatformInfo> infos)
```
    Print out the contents of a result set.
  - printResultSet
```
protected static void printResultSet(java.sql.ResultSet rs)
                              throws java.lang.Exception
```
    Print out the contents of a result set.
    
    Throws:
    
    java.lang.Exception
  - logResultSet
```
protected static void logResultSet(java.sql.ResultSet rs)
                            throws java.lang.Exception
```
    Print out the contents of a result set.
    
    Throws:
    
    java.lang.Exception

Class StatsDB

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

peerid

con

insert

insert2

update

getlatest

deleteprops

insertprops

latest

Constructor Detail

StatsDB

Method Detail

createDB

openDerbyDB

openH2DB

save

getAllPlatformInfos

getPlatformInfosForSync

getPlatformInfos

writePlatformInfos

getLatestEntry

shutdown

migrateFrom

main

printPlatformInfos

printPlatformInfos

printResultSet

logResultSet