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

Class LargeStoreQueries

java.lang.Object

com.djrapitops.plan.storage.database.queries.LargeStoreQueries

public class LargeStoreQueries
extends Object

Static method class for large storage queries.

Method Summary

Modifier and Type	Method	Description
static Executable	insertAccessLog(List<AccessLogTable.Row> rows)
static Executable	insertBaseUsers(Collection<BaseUser> ofUsers)	Execute a big batch of user information insert statements.
static Executable	insertJoinAddresses(List<JoinAddressTable.Row> rows)
static Transaction	insertKillsWithOldSessionIds(List<KillsTable.Row> rows)
static Executable	insertPing(List<PingTable.Row> rows)
static Executable	insertPluginVersions(List<PluginVersionTable.Row> rows)
static Executable	insertPreferences(List<WebUserPreferencesTable.Row> rows)
static Executable	insertSessionsWithOldIds(List<SessionsTable.Row> rows)
static Executable	insertTps(List<TPSTable.Row> rows)
static Executable	insertUserInfo(List<UserInfoTable.Row> rows)
static Executable	insertWorlds(List<WorldTable.Row> rows)
static Transaction	insertWorldTimesWithOldSessionIds(List<WorldTimesTable.Row> rows)
static Executable	mergeBaseUsers(List<BaseUser> existingUsers, LookupTable<UUID> playerLookupTable)
static Executable	storeAllGeoInformation(Map<UUID,List<GeoInfo>> ofUsers)	Execute a big batch of GeoInfo insert statements.
static Executable	storeAllNicknameData(Map<ServerUUID,Map<UUID,List<Nickname>>> ofServersAndUsers)	Execute a big batch of nickname insert statements.
static Executable	storeAllPingData(Map<UUID,List<Ping>> ofUsers)
static Executable	storeAllPlanServerInformation(Collection<Server> servers)	Execute a big batch of server information insert statements.
static Executable	storeAllPlanWebUsers(Collection<User> users)
static Executable	storeAllPreferences(Map<String,String> preferencesByUsername)
static Executable	storeAllSessionsWithKillAndWorldData(Collection<FinishedSession> sessions)
static Executable	storeAllSessionsWithoutKillOrWorldData(Collection<FinishedSession> sessions)
static Executable	storeAllTPSData(Map<ServerUUID,List<TPS>> ofServers)	Execute a big batch of TPS insert statements.
static Executable	storeAllWorldNames(Map<ServerUUID,Collection<String>> ofServers)	Execute a big batch of world name insert statements.
static Executable	storeGroupNames(List<String> groups)
static Executable	storeGroupPermissionIdRelations(Map<Integer,List<Integer>> groupPermissions)
static Executable	storeGroupPermissionRelations(Map<String,List<String>> groupPermissions)
static Executable	storePermissions(List<String> permissions)
static Executable	storePerServerUserInformation(Map<ServerUUID,List<UserInfo>> ofServers)	Execute a big batch of Per server UserInfo insert statements.
static Executable	storeUsers(List<SecurityTable.Row> rows)
static Executable	upsertAllowlistBounces(List<AllowlistBounceTable.Row> rows, DBType dbType)
static Executable	upsertGeoInfo(List<GeoInfoTable.Row> rows, DBType dbType)
static Executable	upsertNicknames(List<NicknamesTable.Row> rows, DBType dbType)

Methods inherited from class java.lang.Object

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

Method Details

storeAllGeoInformation

public static Executable storeAllGeoInformation(Map<UUID,List<GeoInfo>> ofUsers)

Execute a big batch of GeoInfo insert statements.

Parameters:

ofUsers - Map: Player UUID - List of GeoInfo

Returns:

Executable, use inside a Transaction

storeAllNicknameData

public static Executable storeAllNicknameData(Map<ServerUUID,Map<UUID,List<Nickname>>> ofServersAndUsers)

Execute a big batch of nickname insert statements.

Parameters:

ofServersAndUsers - Multimap: Server UUID - (Player UUID - List of nicknames)

Returns:

Executable, use inside a Transaction

storeAllPlanWebUsers

public static Executable storeAllPlanWebUsers(Collection<User> users)

storeAllPlanServerInformation

public static Executable storeAllPlanServerInformation(Collection<Server> servers)

Execute a big batch of server information insert statements.

Parameters:

servers - Collection of Plan Servers.

Returns:

Executable, use inside a Transaction

storeAllTPSData

public static Executable storeAllTPSData(Map<ServerUUID,List<TPS>> ofServers)

Execute a big batch of TPS insert statements.

Parameters:

ofServers - Map: Server UUID - List of TPS data

Returns:

Executable, use inside a Transaction

storePerServerUserInformation

public static Executable storePerServerUserInformation(Map<ServerUUID,List<UserInfo>> ofServers)

Execute a big batch of Per server UserInfo insert statements.

Parameters:

ofServers - Map: Server UUID - List of user information

Returns:

Executable, use inside a Transaction

storeAllWorldNames

public static Executable storeAllWorldNames(Map<ServerUUID,Collection<String>> ofServers)

Execute a big batch of world name insert statements.

Parameters:

ofServers - Map: Server UUID - Collection of world names

Returns:

Executable, use inside a Transaction

insertBaseUsers

public static Executable insertBaseUsers(Collection<BaseUser> ofUsers)

Execute a big batch of user information insert statements.

Parameters:

ofUsers - Collection of BaseUsers

Returns:

Executable, use inside a Transaction

storeAllSessionsWithoutKillOrWorldData

public static Executable storeAllSessionsWithoutKillOrWorldData(Collection<FinishedSession> sessions)

storeAllSessionsWithKillAndWorldData

public static Executable storeAllSessionsWithKillAndWorldData(Collection<FinishedSession> sessions)

storeAllPingData

public static Executable storeAllPingData(Map<UUID,List<Ping>> ofUsers)

storeGroupNames

public static Executable storeGroupNames(List<String> groups)

storePermissions

public static Executable storePermissions(List<String> permissions)

storeGroupPermissionRelations

public static Executable storeGroupPermissionRelations(Map<String,List<String>> groupPermissions)

storeGroupPermissionIdRelations

public static Executable storeGroupPermissionIdRelations(Map<Integer,List<Integer>> groupPermissions)

storeAllPreferences

public static Executable storeAllPreferences(Map<String,String> preferencesByUsername)

mergeBaseUsers

public static Executable mergeBaseUsers(List<BaseUser> existingUsers,
 LookupTable<UUID> playerLookupTable)

insertUserInfo

public static Executable insertUserInfo(List<UserInfoTable.Row> rows)

insertJoinAddresses

public static Executable insertJoinAddresses(List<JoinAddressTable.Row> rows)

insertPing

public static Executable insertPing(List<PingTable.Row> rows)

insertTps

public static Executable insertTps(List<TPSTable.Row> rows)

insertPluginVersions

public static Executable insertPluginVersions(List<PluginVersionTable.Row> rows)

insertSessionsWithOldIds

public static Executable insertSessionsWithOldIds(List<SessionsTable.Row> rows)

insertWorldTimesWithOldSessionIds

public static Transaction insertWorldTimesWithOldSessionIds(List<WorldTimesTable.Row> rows)

insertWorlds

public static Executable insertWorlds(List<WorldTable.Row> rows)

insertKillsWithOldSessionIds

public static Transaction insertKillsWithOldSessionIds(List<KillsTable.Row> rows)

insertAccessLog

public static Executable insertAccessLog(List<AccessLogTable.Row> rows)

upsertGeoInfo

public static Executable upsertGeoInfo(List<GeoInfoTable.Row> rows,
 DBType dbType)

upsertNicknames

public static Executable upsertNicknames(List<NicknamesTable.Row> rows,
 DBType dbType)

upsertAllowlistBounces

public static Executable upsertAllowlistBounces(List<AllowlistBounceTable.Row> rows,
 DBType dbType)

storeUsers

public static Executable storeUsers(List<SecurityTable.Row> rows)

insertPreferences

public static Executable insertPreferences(List<WebUserPreferencesTable.Row> rows)