Class TPSQueries

java.lang.Object

com.djrapitops.plan.storage.database.queries.objects.TPSQueries

public class TPSQueries
extends Object

Queries for TPS objects.

Method Summary

Modifier and Type	Method	Description
static Query<Long>	averageChunks(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageCPU(long after, long before, ServerUUID serverUUID)
static Query<Long>	averageEntities(long after, long before, ServerUUID serverUUID)
static Query<Long>	averageFreeDisk(long after, long before, ServerUUID serverUUID)
static Query<Long>	averageRAM(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageTPS(long after, long before, ServerUUID serverUUID)
static TPS	extractTPS(ResultSet set)
static Query<Optional<DateObj<Integer>>>	fetchAllTimePeakPlayerCount(ServerUUID serverUUID)
static Query<Optional<Long>>	fetchLastStoredTpsDate(ServerUUID serverUUID)
static Query<Optional<Long>>	fetchLatestServerStartTime(ServerUUID serverUUID, long dataGapThreshold)
static Query<Optional<TPS>>	fetchLatestTPSEntryForServer(ServerUUID serverUUID)
static Query<Optional<DateObj<Integer>>>	fetchPeakPlayerCount(ServerUUID serverUUID, long afterDate)
static Query<List<DateObj<Integer>>>	fetchPlayersOnlineOfServer(long after, long before, ServerUUID serverUUID)
static Query<List<TPSTable.Row>>	fetchRows(int currentId, int rowLimit)
static Query<Map<Integer, List<TPS>>>	fetchTPSDataOfAllServersBut(long after, long before, ServerUUID leaveOut)
static Query<List<TPS>>	fetchTPSDataOfServer(long after, long before, ServerUUID serverUUID)
static Query<List<TPS>>	fetchTPSDataOfServerInResolution(long after, long before, long resolution, ServerUUID serverUUID)
static Query<Map<Integer, List<TPS>>>	fetchTPSDataOfServers(long after, long before, Collection<ServerUUID> serverUUIDs)
static Query<List<DateObj<Integer>>>	fetchViewPreviewGraphData(ServerUUID serverUUID)
static Query<Long>	maxFreeDisk(long after, long before, ServerUUID serverUUID)
static Query<Long>	minFreeDisk(long after, long before, ServerUUID serverUUID)
static Query<Map<Integer,Long>>	occupiedTime(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Map<Integer,Long>>	uptime(long after, long before, List<ServerUUID> serverUUIDs)

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

fetchTPSDataOfServerInResolution

public static Query<List<TPS>> fetchTPSDataOfServerInResolution(long after,
 long before,
 long resolution,
 ServerUUID serverUUID)

extractTPS

public static TPS extractTPS(ResultSet set)
                      throws SQLException

Throws:

SQLException

fetchTPSDataOfServer

public static Query<List<TPS>> fetchTPSDataOfServer(long after,
 long before,
 ServerUUID serverUUID)

occupiedTime

public static Query<Map<Integer,Long>> occupiedTime(long after,
 long before,
 List<ServerUUID> serverUUIDs)

uptime

public static Query<Map<Integer,Long>> uptime(long after,
 long before,
 List<ServerUUID> serverUUIDs)

fetchViewPreviewGraphData

public static Query<List<DateObj<Integer>>> fetchViewPreviewGraphData(ServerUUID serverUUID)

fetchPlayersOnlineOfServer

public static Query<List<DateObj<Integer>>> fetchPlayersOnlineOfServer(long after,
 long before,
 ServerUUID serverUUID)

fetchTPSDataOfAllServersBut

public static Query<Map<Integer, List<TPS>>> fetchTPSDataOfAllServersBut(long after,
 long before,
 ServerUUID leaveOut)

fetchPeakPlayerCount

public static Query<Optional<DateObj<Integer>>> fetchPeakPlayerCount(ServerUUID serverUUID,
 long afterDate)

fetchAllTimePeakPlayerCount

public static Query<Optional<DateObj<Integer>>> fetchAllTimePeakPlayerCount(ServerUUID serverUUID)

fetchLatestTPSEntryForServer

public static Query<Optional<TPS>> fetchLatestTPSEntryForServer(ServerUUID serverUUID)

averageTPS

public static Query<Double> averageTPS(long after,
 long before,
 ServerUUID serverUUID)

averageCPU

public static Query<Double> averageCPU(long after,
 long before,
 ServerUUID serverUUID)

averageRAM

public static Query<Long> averageRAM(long after,
 long before,
 ServerUUID serverUUID)

averageChunks

public static Query<Long> averageChunks(long after,
 long before,
 ServerUUID serverUUID)

averageEntities

public static Query<Long> averageEntities(long after,
 long before,
 ServerUUID serverUUID)

maxFreeDisk

public static Query<Long> maxFreeDisk(long after,
 long before,
 ServerUUID serverUUID)

minFreeDisk

public static Query<Long> minFreeDisk(long after,
 long before,
 ServerUUID serverUUID)

averageFreeDisk

public static Query<Long> averageFreeDisk(long after,
 long before,
 ServerUUID serverUUID)

fetchLastStoredTpsDate

public static Query<Optional<Long>> fetchLastStoredTpsDate(ServerUUID serverUUID)

fetchTPSDataOfServers

public static Query<Map<Integer, List<TPS>>> fetchTPSDataOfServers(long after,
 long before,
 Collection<ServerUUID> serverUUIDs)

fetchLatestServerStartTime

public static Query<Optional<Long>> fetchLatestServerStartTime(ServerUUID serverUUID,
 long dataGapThreshold)

fetchRows

public static Query<List<TPSTable.Row>> fetchRows(int currentId,
 int rowLimit)