storage

package

Go to main page

Versions in this module

v0

v0.3.2

Nov 27, 2022

v0.1.5

Jan 10, 2023

Changes in this version

+ func EventsToCSV(e []*PostgresGameEvent) string

+ func GamesToCSV(g []*PostgresGame) string

+ func UsersGamesToCSV(ug []*PostgresUserGame) string

+ func UsersToCSV(u []*PostgresUser) string

type PostgresGuild

+ func (g *PostgresGuild) ToCSV() string

type PsqlInterface

+ func (psqlInterface *PsqlInterface) GetGamesEventsForGuild(guildID uint64) ([]*PostgresGameEvent, error)

+ func (psqlInterface *PsqlInterface) GetGamesForGuild(guildID uint64) ([]*PostgresGame, error)

+ func (psqlInterface *PsqlInterface) GetGuildForDownload(guildID uint64) (*PostgresGuild, error)

+ func (psqlInterface *PsqlInterface) GetUsersForGuild(guildID uint64) ([]*PostgresUser, error)

+ func (psqlInterface *PsqlInterface) GetUsersGamesForGuild(guildID uint64) ([]*PostgresUserGame, error)

v0.1.4

Nov 27, 2022

v0.1.3

Nov 27, 2022

v0.1.2

Nov 27, 2022

v0.1.1

Nov 27, 2022

Changes in this version

+ const SecsIn12Hrs

+ const SecsInADay

+ const TopGGID

+ var DiscussCode = fmt.Sprintf("%d", game.DISCUSS)

+ var TasksCode = fmt.Sprintf("%d", game.TASKS)

+ func CanRevertTransfer(origin, dest *PostgresGuild) error

+ func CanTransfer(origin, dest *PostgresGuild) error

+ func ConstructPsqlConnectURL(addr, username, password string) string

+ type GameStatistics struct

+ Events []SimpleEvent

+ GameDuration time.Duration

+ NumDeaths int

+ NumDisconnects int

+ NumMeetings int

+ NumVotedOff int

+ WinType game.GameResult

+ func StatsFromGameAndEvents(pgame *PostgresGame, events []*PostgresGameEvent) GameStatistics

+ func (stats *GameStatistics) FormatDurationAndWin() string

+ func (stats *GameStatistics) ToDiscordEmbed(combinedID string, sett *settings.GuildSettings) *discordgo.MessageEmbed

+ func (stats *GameStatistics) ToString() string

+ type Int16ModeCount struct

+ Count int64

+ Mode int16

+ type PgxIface interface

+ Begin func(context.Context) (pgx.Tx, error)

+ Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error)

+ Ping func(context.Context) error

+ Prepare func(context.Context, string, string) (*pgconn.StatementDescription, error)

+ Query func(context.Context, string, ...interface{}) (pgx.Rows, error)

+ QueryRow func(context.Context, string, ...interface{}) pgx.Row

+ type PostgresBestTeammatePlayerRanking struct

+ Count int64

+ TeammateID uint64

+ UserID uint64

+ WinCount int64

+ WinRate float64

+ type PostgresGame struct

+ ConnectCode string

+ EndTime int32

+ GameID int64

+ GuildID uint64

+ StartTime int32

+ WinType int16

+ type PostgresGameEvent struct

+ EventID uint64

+ EventTime int32

+ EventType int16

+ GameID int64

+ Payload string

+ UserID *uint64

+ type PostgresGuild struct

+ GuildID uint64

+ GuildName string

+ InheritsFrom *uint64

+ Premium int16

+ TransferredTo *uint64

+ TxTimeUnix *int32

+ type PostgresOtherPlayerRanking struct

+ Count int64

+ Percent float64

+ UserID uint64

+ type PostgresPlayerRanking struct

+ Count int64

+ UserID uint64

+ WinCount int64

+ WinRate float64

+ type PostgresUser struct

+ Opt bool

+ UserID uint64

+ VoteTimeUnix *int32

+ type PostgresUserActionRanking struct

+ Count int64

+ TotalAction int64

+ UserID uint64

+ WinRate float64

+ type PostgresUserGame struct

+ GameID int64

+ GuildID uint64

+ PlayerColor int16

+ PlayerName string

+ PlayerRole int16

+ PlayerWon bool

+ UserID uint64

+ type PostgresUserMostFrequentFirstTargetRanking struct

+ Count int64

+ DeathRate float64

+ TotalDeath int64

+ UserID uint64

+ type PostgresUserMostFrequentKilledByanking struct

+ DeathRate float64

+ Encounter int64

+ TeammateID uint64

+ TotalDeath int64

+ UserID uint64

+ type PostgresWorstTeammatePlayerRanking struct

+ Count int64

+ LooseCount int64

+ LooseRate float64

+ TeammateID uint64

+ UserID uint64

+ type PsqlInterface struct

+ Pool *pgxpool.Pool

+ func (psqlInterface *PsqlInterface) AddEvent(event *PostgresGameEvent) error

+ func (psqlInterface *PsqlInterface) AddGoldSubServer(origin, dest string) error

+ func (psqlInterface *PsqlInterface) AddInitialGame(game *PostgresGame) (uint64, error)

+ func (psqlInterface *PsqlInterface) BestTeammateByRole(userID, guildID string, role int16, leaderboardMin int) []*PostgresBestTeammatePlayerRanking

+ func (psqlInterface *PsqlInterface) BestTeammateForServerByRole(guildID string, role int16, leaderboardMin int) []*PostgresBestTeammatePlayerRanking

+ func (psqlInterface *PsqlInterface) Close()

+ func (psqlInterface *PsqlInterface) ColorRankingForPlayerOnServer(userID, guildID string) []*Int16ModeCount

+ func (psqlInterface *PsqlInterface) DeleteAllGamesForServer(guildID string) error

+ func (psqlInterface *PsqlInterface) DeleteAllGamesForUser(userID string) error

+ func (psqlInterface *PsqlInterface) EnsureGuildExists(guildID uint64, guildName string) (*PostgresGuild, error)

+ func (psqlInterface *PsqlInterface) EnsureUserExists(userID uint64) (*PostgresUser, error)

+ func (psqlInterface *PsqlInterface) GetGame(guildID, connectCode, matchID string) (*PostgresGame, error)

+ func (psqlInterface *PsqlInterface) GetGameEvents(matchID string) ([]*PostgresGameEvent, error)

+ func (psqlInterface *PsqlInterface) GetGuildOrUserPremiumStatus(official bool, dbl *dbl.Client, guildID, userID string) (premium.Tier, int, error)

+ func (psqlInterface *PsqlInterface) GetUserByString(userID string) (*PostgresUser, error)

+ func (psqlInterface *PsqlInterface) Init(addr string) error

+ func (psqlInterface *PsqlInterface) LoadAndExecFromFile(filepath string) error

+ func (psqlInterface *PsqlInterface) NamesRankingForPlayerOnServer(userID, guildID string) []*StringModeCount

+ func (psqlInterface *PsqlInterface) NumGamesAsRole(userID string, role int16) int64

+ func (psqlInterface *PsqlInterface) NumGamesAsRoleOnServer(userID, guildID string, role int16) int64

+ func (psqlInterface *PsqlInterface) NumGamesPlayedByUser(userID string) int64

+ func (psqlInterface *PsqlInterface) NumGamesPlayedByUserOnServer(userID, guildID string) int64

+ func (psqlInterface *PsqlInterface) NumGamesPlayedOnGuild(guildID string) int64

+ func (psqlInterface *PsqlInterface) NumGamesWonAsRoleOnServer(guildID string, role game.GameRole) int64

+ func (psqlInterface *PsqlInterface) NumGuildsPlayedInByUser(userID string) int64

+ func (psqlInterface *PsqlInterface) NumWins(userID string) int64

+ func (psqlInterface *PsqlInterface) NumWinsAsRole(userID string, role int16) int64

+ func (psqlInterface *PsqlInterface) NumWinsAsRoleOnServer(userID, guildID string, role int16) int64

+ func (psqlInterface *PsqlInterface) NumWinsOnServer(userID, guildID string) int64

+ func (psqlInterface *PsqlInterface) OptUserByString(userID string, opt bool) error

+ func (psqlInterface *PsqlInterface) OtherPlayersRankingForPlayerOnServer(userID, guildID string) []*PostgresOtherPlayerRanking

+ func (psqlInterface *PsqlInterface) RevertPremiumTransfer(original, transferred string) error

+ func (psqlInterface *PsqlInterface) TotalGamesRankingForServer(guildID uint64) []*Uint64ModeCount

+ func (psqlInterface *PsqlInterface) TotalWinRankingForServer(guildID uint64) []*PostgresPlayerRanking

+ func (psqlInterface *PsqlInterface) TotalWinRankingForServerByRole(guildID uint64, role int16) []*PostgresPlayerRanking

+ func (psqlInterface *PsqlInterface) TransferPremium(origin, dest string) error

+ func (psqlInterface *PsqlInterface) UpdateGameAndPlayers(gameID int64, winType int16, endTime int64, players []*PostgresUserGame) error

+ func (psqlInterface *PsqlInterface) UserFrequentFirstTarget(userID, guildID string, action string, leaderboardSize int) []*PostgresUserMostFrequentFirstTargetRanking

+ func (psqlInterface *PsqlInterface) UserMostFrequentFirstTargetForServer(guildID string, action string, leaderboardSize int) []*PostgresUserMostFrequentFirstTargetRanking

+ func (psqlInterface *PsqlInterface) UserMostFrequentKilledBy(userID, guildID string) []*PostgresUserMostFrequentKilledByanking

+ func (psqlInterface *PsqlInterface) UserMostFrequentKilledByServer(guildID string) []*PostgresUserMostFrequentKilledByanking

+ func (psqlInterface *PsqlInterface) UserWinByActionAndRole(userdID, guildID string, action string, role int16) []*PostgresUserActionRanking

+ func (psqlInterface *PsqlInterface) WorstTeammateByRole(userID, guildID string, role int16, leaderboardMin int) []*PostgresWorstTeammatePlayerRanking

+ func (psqlInterface *PsqlInterface) WorstTeammateForServerByRole(guildID string, role int16, leaderboardMin int) []*PostgresWorstTeammatePlayerRanking

+ type PsqlParameters struct

+ Addr string

+ Password string

+ Username string

+ type SimpleEvent struct

+ Data string

+ EventTimeOffset time.Duration

+ EventType SimpleEventType

+ type SimpleEventType int

+ const Discuss

+ const PlayerDeath

+ const PlayerDisconnect

+ const Tasks

+ type StringModeCount struct

+ Count int64

+ Mode string

+ type Uint64ModeCount struct

+ Count int64

+ Mode uint64

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL