Class SessionQueries

java.lang.Object
com.djrapitops.plan.storage.database.queries.objects.SessionQueries

public class SessionQueries extends Object
Queries for FinishedSession objects.
  • 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)
    • fetchSessionsOfPlayerWithoutExtraData

      public static Query<List<FinishedSession>> fetchSessionsOfPlayerWithoutExtraData(UUID playerUUID, long after, long before)
      Fetch sessions of a player that overlap the given time range, without kill, world time or other extra data.

      Only start, end, afk time, server and join address are filled in. Intended for placeholders that need playtime within a window, so they don't need to load every session of the player with all extra data.

      Parameters:
      playerUUID - UUID of the player.
      after - Sessions that ended at or after this epoch ms are included.
      before - Sessions that started at or before this epoch ms are included.
      Returns:
      List of sessions, most recent first.
    • fetchLatestSessionOfPlayerWithoutExtraData

      public static Query<Optional<FinishedSession>> fetchLatestSessionOfPlayerWithoutExtraData(UUID playerUUID)
      Fetch the most recently started session of a player, without kill, world time or other extra data.
      Parameters:
      playerUUID - UUID of the player.
      Returns:
      The latest session with start, end, afk time, server and join address, or empty if none is stored.