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

Class UserInfoQueries

java.lang.Object

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

public class UserInfoQueries
extends Object

Queries for UserInfo objects.

Method Summary

Modifier and Type	Method	Description
static Set<Integer>	extractUserIds(ResultSet set)
static Set<Integer>	extractUserIds(ResultSet set, String column)
static Query<Map<ServerUUID,List<UserInfo>>>	fetchAllUserInformation()	Query database for user information.
static Query<Map<UUID,Long>>	fetchRegisterDates(long after, long before, ServerUUID serverUUID)
static Query<Set<UserInfo>>	fetchUserInformationOfUser(UUID playerUUID)	Query database for User information of a specific player.
static Query<Set<Integer>>	getUserIdsForBooleanGroup(String column, boolean value)
static Query<Set<Integer>>	userIdsOfBanned()
static Query<Set<Integer>>	userIdsOfNonOperators()
static Query<Set<Integer>>	userIdsOfNotBanned()
static Query<Set<Integer>>	userIdsOfOperators()
static Query<Set<Integer>>	userIdsOfRegisteredBetween(long after, long before, List<ServerUUID> serverUUIDs)

Methods inherited from class java.lang.Object

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

Method Details

fetchAllUserInformation

public static Query<Map<ServerUUID,List<UserInfo>>> fetchAllUserInformation()

Query database for user information.

The user information does not contain player names.

Returns:

Map: Server UUID - List of user information

fetchUserInformationOfUser

public static Query<Set<UserInfo>> fetchUserInformationOfUser(UUID playerUUID)

Query database for User information of a specific player.

Parameters:

playerUUID - UUID of the player.

Returns:

List of UserInfo objects, one for each server where the player has played.

fetchRegisterDates

public static Query<Map<UUID,Long>> fetchRegisterDates(long after,
 long before,
 ServerUUID serverUUID)

userIdsOfOperators

public static Query<Set<Integer>> userIdsOfOperators()

getUserIdsForBooleanGroup

public static Query<Set<Integer>> getUserIdsForBooleanGroup(String column,
 boolean value)

extractUserIds

public static Set<Integer> extractUserIds(ResultSet set)
                                   throws SQLException

Throws:

SQLException

extractUserIds

public static Set<Integer> extractUserIds(ResultSet set,
 String column)
                                   throws SQLException

Throws:

SQLException

userIdsOfNonOperators

public static Query<Set<Integer>> userIdsOfNonOperators()

userIdsOfBanned

public static Query<Set<Integer>> userIdsOfBanned()

userIdsOfNotBanned

public static Query<Set<Integer>> userIdsOfNotBanned()

userIdsOfRegisteredBetween

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