Class SessionQueries

java.lang.Object

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

public class SessionQueries
extends Object

Queries for FinishedSession objects.

Method Summary

Modifier and Type	Method	Description
static Query<Long>	activePlaytime(long after, long before)
static Query<Long>	activePlaytime(long after, long before, ServerUUID serverUUID)
static Query<Long>	afkTime(long after, long before)
static Query<Long>	afkTime(long after, long before, ServerUUID serverUUID)
static Query<Long>	afkTime(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	afkTime(long after, long before, UUID playerUUID, List<ServerUUID> serverUUIDs)
static Query<Double>	afkTimePercentage(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	averageAfkPerPlayer(long after, long before)	Fetch average Afk per ALL players.
static Query<Long>	averageAfkPerPlayer(long after, long before, ServerUUID serverUUID)
static Query<Long>	averagePlaytimePerDay(long after, long before, long timeZoneOffset)
static Query<Long>	averagePlaytimePerDay(long after, long before, long timeZoneOffset, ServerUUID serverUUID)
static Query<Long>	averagePlaytimePerDay(long after, long before, long timeZoneOffset, List<ServerUUID> serverUUIDs)
static Query<Long>	averagePlaytimePerDay(long after, long before, long timeZoneOffset, UUID playerUUID, List<ServerUUID> serverUUIDs)
static Query<Long>	averagePlaytimePerPlayer(long after, long before)	Fetch average playtime per ALL players.
static Query<Long>	averagePlaytimePerPlayer(long after, long before, ServerUUID serverUUID)
static Query<Long>	averagePlaytimePerPlayer(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	earliestSessionStart()
static Query<List<FinishedSession>>	fetchAllSessions()	Query the database for Session data with kill, death or world data.
static Query<List<FinishedSession>>	fetchLatestSessionsOfServer(ServerUUID serverUUID, int limit)
static Query<List<SessionsTable.Row>>	fetchRows(int currentId, int rowLimit)
static Query<List<FinishedSession>>	fetchServerSessionsWithoutKillOrWorldData(long after, long before, ServerUUID serverUUID)
static Query<Map<ServerUUID, List<FinishedSession>>>	fetchSessionsOfPlayer(UUID playerUUID)	Query the database for Session data of a player with kill and world data.
static Query<Map<UUID,Long>>	lastSeen(ServerUUID serverUUID)
static Query<Long>	lastSeen(UUID playerUUID)
static Query<Long>	lastSeen(UUID playerUUID, ServerUUID serverUUID)
static Query<List<PlayerIdentifier>>	playersOnlineOn(long date)
static Query<List<PlayerIdentifier>>	playersOnlineOn(long date, ServerUUID serverUUID)
static Query<Long>	playtime(long after, long before)
static Query<Long>	playtime(long after, long before, ServerUUID serverUUID)
static Query<Long>	playtime(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	playtime(long after, long before, UUID playerUUID, List<ServerUUID> serverUUIDs)
static Query<PlaytimeAndCount>	playtimeAndCount(long after, long before, List<ServerUUID> serverUUIDs)
static Query<PlaytimeAndCount>	playtimeAndCount(long after, long before, UUID playerUUID, List<ServerUUID> serverUUIDs)
static Query<Map<ServerUUID, Long>>	playtimeOfPlayer(long after, long before, UUID playerUUID)
static Query<NavigableMap<Long,Long>>	playtimePerDay(long after, long before, long timeZoneOffset)	Query playtime for each day within range across the whole network.
static Query<NavigableMap<Long,Long>>	playtimePerDay(long after, long before, long timeZoneOffset, ServerUUID serverUUID)	Query playtime for each day within range on a server.
static Query<Map<String,Long>>	playtimePerServer(long after, long before)
static Query<Long>	sessionCount(long after, long before)
static Query<Long>	sessionCount(long after, long before, ServerUUID serverUUID)
static Query<Long>	sessionCount(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Long>	sessionCount(long after, long before, UUID playerUUID, List<ServerUUID> serverUUIDs)
static Query<NavigableMap<Long,Integer>>	sessionCountPerDay(long after, long before, long timeZoneOffset)	Query session count for each day within range across the whole network.
static Query<NavigableMap<Long,Integer>>	sessionCountPerDay(long after, long before, long timeZoneOffset, ServerUUID serverUUID)	Query session count for each day within range on a server.
static Query<List<FinishedSession>>	sessionsOfPlayer(UUID playerUUID, long after, long before, List<ServerUUID> serverUUIDs)
static Query<List<FinishedSession>>	sessionsOfServers(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Map<String,Long>>	summaryOfPlayers(Set<Integer> userIds, List<ServerUUID> serverUUIDs, long after, long before)
static Query<Set<Integer>>	userIdsOfLastSeenBetween(long after, long before, List<ServerUUID> serverUUIDs)
static Query<Set<Integer>>	userIdsOfPlayedBetween(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

fetchAllSessions

public static Query<List<FinishedSession>> fetchAllSessions()

Query the database for Session data with kill, death or world data.

Returns:

List of sessions

fetchSessionsOfPlayer

public static Query<Map<ServerUUID, List<FinishedSession>>> fetchSessionsOfPlayer(UUID playerUUID)

Query the database for Session data of a player with kill and world data.

Parameters:

playerUUID - UUID of the Player.

Returns:

Map: Server UUID - List of sessions on the server.

fetchServerSessionsWithoutKillOrWorldData

public static Query<List<FinishedSession>> fetchServerSessionsWithoutKillOrWorldData(long after,
 long before,
 ServerUUID serverUUID)

fetchLatestSessionsOfServer

public static Query<List<FinishedSession>> fetchLatestSessionsOfServer(ServerUUID serverUUID,
 int limit)

sessionCount

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

sessionCount

public static Query<Long> sessionCount(long after,
 long before)

sessionCount

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

sessionCount

public static Query<Long> sessionCount(long after,
 long before,
 UUID playerUUID,
 List<ServerUUID> serverUUIDs)

sessionCountPerDay

public static Query<NavigableMap<Long,Integer>> sessionCountPerDay(long after,
 long before,
 long timeZoneOffset,
 ServerUUID serverUUID)

Query session count for each day within range on a server.

Parameters:

after - After epoch ms

before - Before epoch ms

timeZoneOffset - Offset in ms to determine start of day.

serverUUID - UUID of the Plan server.

Returns:

Map - Epoch ms (Start of day at 0 AM, no offset) : Session count of that day

sessionCountPerDay

public static Query<NavigableMap<Long,Integer>> sessionCountPerDay(long after,
 long before,
 long timeZoneOffset)

Query session count for each day within range across the whole network.

Parameters:

after - After epoch ms

before - Before epoch ms

timeZoneOffset - Offset in ms to determine start of day.

Returns:

Map - Epoch ms (Start of day at 0 AM, no offset) : Session count of that day

playtime

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

playtime

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

playtime

public static Query<Long> playtime(long after,
 long before,
 UUID playerUUID,
 List<ServerUUID> serverUUIDs)

playtimeAndCount

public static Query<PlaytimeAndCount> playtimeAndCount(long after,
 long before,
 List<ServerUUID> serverUUIDs)

playtimeAndCount

public static Query<PlaytimeAndCount> playtimeAndCount(long after,
 long before,
 UUID playerUUID,
 List<ServerUUID> serverUUIDs)

playtimeOfPlayer

public static Query<Map<ServerUUID, Long>> playtimeOfPlayer(long after,
 long before,
 UUID playerUUID)

playtime

public static Query<Long> playtime(long after,
 long before)

playtimePerDay

public static Query<NavigableMap<Long,Long>> playtimePerDay(long after,
 long before,
 long timeZoneOffset,
 ServerUUID serverUUID)

Query playtime for each day within range on a server.

Parameters:

after - After epoch ms

before - Before epoch ms

timeZoneOffset - Offset in ms to determine start of day.

serverUUID - UUID of the Plan server.

Returns:

Map - Epoch ms (Start of day at 0 AM, no offset) : Playtime of that day

playtimePerDay

public static Query<NavigableMap<Long,Long>> playtimePerDay(long after,
 long before,
 long timeZoneOffset)

Query playtime for each day within range across the whole network.

Parameters:

after - After epoch ms

before - Before epoch ms

timeZoneOffset - Offset in ms to determine start of day.

Returns:

Map - Epoch ms (Start of day at 0 AM, no offset) : Playtime of that day

averagePlaytimePerDay

public static Query<Long> averagePlaytimePerDay(long after,
 long before,
 long timeZoneOffset)

averagePlaytimePerDay

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

averagePlaytimePerDay

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

averagePlaytimePerDay

public static Query<Long> averagePlaytimePerDay(long after,
 long before,
 long timeZoneOffset,
 UUID playerUUID,
 List<ServerUUID> serverUUIDs)

averagePlaytimePerPlayer

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

averagePlaytimePerPlayer

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

averagePlaytimePerPlayer

public static Query<Long> averagePlaytimePerPlayer(long after,
 long before)

Fetch average playtime per ALL players.

Parameters:

after - After epoch ms

before - Before epoch ms

Returns:

Average ms played / player, calculated with grouped sums from sessions table.

averageAfkPerPlayer

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

averageAfkPerPlayer

public static Query<Long> averageAfkPerPlayer(long after,
 long before)

Fetch average Afk per ALL players.

Parameters:

after - After epoch ms

before - Before epoch ms

Returns:

Average ms afk / player, calculated with grouped sums from sessions table.

afkTime

public static Query<Long> afkTime(long after,
 long before,
 UUID playerUUID,
 List<ServerUUID> serverUUIDs)

afkTime

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

afkTime

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

afkTimePercentage

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

afkTime

public static Query<Long> afkTime(long after,
 long before)

playtimePerServer

public static Query<Map<String,Long>> playtimePerServer(long after,
 long before)

lastSeen

public static Query<Long> lastSeen(UUID playerUUID)

lastSeen

public static Query<Long> lastSeen(UUID playerUUID,
 ServerUUID serverUUID)

activePlaytime

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

activePlaytime

public static Query<Long> activePlaytime(long after,
 long before)

userIdsOfPlayedBetween

public static Query<Set<Integer>> userIdsOfPlayedBetween(long after,
 long before,
 List<ServerUUID> serverUUIDs)

summaryOfPlayers

public static Query<Map<String,Long>> summaryOfPlayers(Set<Integer> userIds,
 List<ServerUUID> serverUUIDs,
 long after,
 long before)

earliestSessionStart

public static Query<Long> earliestSessionStart()

lastSeen

public static Query<Map<UUID,Long>> lastSeen(ServerUUID serverUUID)

fetchRows

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

playersOnlineOn

public static Query<List<PlayerIdentifier>> playersOnlineOn(long date)

playersOnlineOn

public static Query<List<PlayerIdentifier>> playersOnlineOn(long date,
 ServerUUID serverUUID)

userIdsOfLastSeenBetween

public static Query<Set<Integer>> userIdsOfLastSeenBetween(long after,
 long before,
 List<ServerUUID> serverUUIDs)

sessionsOfPlayer

public static Query<List<FinishedSession>> sessionsOfPlayer(UUID playerUUID,
 long after,
 long before,
 List<ServerUUID> serverUUIDs)

sessionsOfServers

public static Query<List<FinishedSession>> sessionsOfServers(long after,
 long before,
 List<ServerUUID> serverUUIDs)