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<Long>	averageChunks(long after, long before, List<ServerUUID> serverUUIDs, @Nullable OnlineActivityType onlineActivityType)
static Query<Long>	averageChunksPerPlayer(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	averageCPU(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageCPU(long after, long before, List<ServerUUID> serverUUIDs, OnlineActivityType onlineActivityType)
static Query<Double>	averageCpuPerPlayer(long after, long before, List<ServerUUID> serverUUIDs, double averageWhenIdle)
static Query<Long>	averageEntities(long after, long before, ServerUUID serverUUID)
static Query<Long>	averageEntities(long after, long before, List<ServerUUID> serverUUIDs, OnlineActivityType onlineActivityType)
static Query<Double>	averageEntitiesPerChunk(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	averageFreeDisk(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageMSPT(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageMSPT(long after, long before, List<ServerUUID> serverUUIDs, OnlineActivityType onlineActivityType)
static Query<Double>	averageMsptImpactPerChunk(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	averageMsptImpactPerPlayer(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	averageMsptJitter(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageMsptJitter(long after, long before, List<ServerUUID> serverUUIDs, OnlineActivityType onlineActivityType)
static Query<Double>	averageMSPTWhenLowTps(long after, long before, List<ServerUUID> serverUUIDs, double lowTpsThreshold)
static Query<Double>	averagePlayersOnline(long after, long before, ServerUUID serverUUID)
static Query<Double>	averagePlayersOnline(long after, long before, List<ServerUUID> serverUUIDs, OnlineActivityType onlineActivityType)
static Query<Long>	averageRAM(long after, long before, ServerUUID serverUUID)
static Query<Long>	averageRAM(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	averageTPS(long after, long before, ServerUUID serverUUID)
static Query<Double>	averageTPS(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	downtime(long after, long before, List<ServerUUID> serverUUIDs)
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>>>	fetchNetworkPeakPlayerCount(long afterDate, long beforeDate, boolean onlyOneProxy)
static Query<Optional<DateObj<Integer>>>	fetchPeakPlayerCount(ServerUUID serverUUID, long afterDate, long beforeDate)
static Query<Optional<DateObj<Integer>>>	fetchPeakPlayerCount(List<ServerUUID> serverUUIDs, long afterDate, long beforeDate)
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<Integer>	lowTpsSpikes(double threshold, long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	max95thMSPT(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	max95thMSPTWhenLowTps(long after, long before, List<ServerUUID> serverUUIDs, double lowTpsThreshold)
static Query<Long>	maxFreeDisk(long after, long before, ServerUUID serverUUID)
static Query<Long>	maxFreeDisk(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Double>	maxMsptJitter(long after, long before, ServerUUID serverUUID)
static Query<Double>	maxMsptJitter(long after, long before, List<ServerUUID> serverUUIDs, OnlineActivityType onlineActivityType)
static Query<Long>	minFreeDisk(long after, long before, ServerUUID serverUUID)
static Query<Long>	minFreeDisk(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	occupiedTime(long after, long before, List<ServerUUID> serverUUIDs)
static Query<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<Long> occupiedTime(long after,
 long before,
 List<ServerUUID> serverUUIDs)

uptime

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

downtime

public static Query<Long> downtime(long after,
 long before,
 List<ServerUUID> serverUUIDs)

lowTpsSpikes

public static Query<Integer> lowTpsSpikes(double threshold,
 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,
 long beforeDate)

fetchPeakPlayerCount

public static Query<Optional<DateObj<Integer>>> fetchPeakPlayerCount(List<ServerUUID> serverUUIDs,
 long afterDate,
 long beforeDate)

fetchNetworkPeakPlayerCount

public static Query<Optional<DateObj<Integer>>> fetchNetworkPeakPlayerCount(long afterDate,
 long beforeDate,
 boolean onlyOneProxy)

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)

averageTPS

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

averagePlayersOnline

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

averagePlayersOnline

public static Query<Double> averagePlayersOnline(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 OnlineActivityType onlineActivityType)

averageCPU

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

averageCPU

public static Query<Double> averageCPU(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 OnlineActivityType onlineActivityType)

averageMsptJitter

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

averageMsptJitter

public static Query<Double> averageMsptJitter(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 OnlineActivityType onlineActivityType)

maxMsptJitter

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

maxMsptJitter

public static Query<Double> maxMsptJitter(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 OnlineActivityType onlineActivityType)

averageCpuPerPlayer

public static Query<Double> averageCpuPerPlayer(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 double averageWhenIdle)

averageRAM

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

averageRAM

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

averageChunks

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

averageChunks

public static Query<Long> averageChunks(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 @Nullable OnlineActivityType onlineActivityType)

averageChunksPerPlayer

public static Query<Long> averageChunksPerPlayer(long after,
 long before,
 List<ServerUUID> serverUUIDs)

averageEntities

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

averageEntities

public static Query<Long> averageEntities(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 OnlineActivityType onlineActivityType)

averageEntitiesPerChunk

public static Query<Double> averageEntitiesPerChunk(long after,
 long before,
 List<ServerUUID> serverUUIDs)

averageMSPT

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

averageMSPT

public static Query<Double> averageMSPT(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 OnlineActivityType onlineActivityType)

averageMSPTWhenLowTps

public static Query<Double> averageMSPTWhenLowTps(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 double lowTpsThreshold)

max95thMSPTWhenLowTps

public static Query<Double> max95thMSPTWhenLowTps(long after,
 long before,
 List<ServerUUID> serverUUIDs,
 double lowTpsThreshold)

max95thMSPT

public static Query<Double> max95thMSPT(long after,
 long before,
 List<ServerUUID> serverUUIDs)

averageMsptImpactPerPlayer

public static Query<Double> averageMsptImpactPerPlayer(long after,
 long before,
 List<ServerUUID> serverUUIDs)

averageMsptImpactPerChunk

public static Query<Double> averageMsptImpactPerChunk(long after,
 long before,
 List<ServerUUID> serverUUIDs)

maxFreeDisk

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

maxFreeDisk

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

minFreeDisk

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

minFreeDisk

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

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)