storage

package
v0.0.0-...-b16daea Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jun 18, 2021 License: MIT Imports: 23 Imported by: 0

Documentation

Index

Constants

View Source 
const DefaultLeaderboardMin = 3
View Source 
const DefaultLeaderboardSize = 3
View Source 
const NoExpiryCode = -9999 // dumb, but no one would ever have expired premium for 9999 days
View Source 
const SecsInADay = 86400
View Source 
const SubDays = 31 // use 31 because there shouldn't ever be a gap; whenever a renewal happens on the 31st day, that should be valid

Variables

View Source 
var DiscussCode = fmt.Sprintf("%d", game.DISCUSS)
View Source 
var TasksCode = fmt.Sprintf("%d", game.TASKS)

Functions

func ConstructPsqlConnectURL 

func ConstructPsqlConnectURL(addr, username, password string) string

Types

type GameStatistics 

type GameStatistics struct {
	GameDuration time.Duration
	WinType      game.GameResult

	NumMeetings    int
	NumDeaths      int
	NumVotedOff    int
	NumDisconnects int
	Events         []SimpleEvent
}

func StatsFromGameAndEvents 

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

func (*GameStatistics) FormatDurationAndWin 

func (stats *GameStatistics) FormatDurationAndWin() string

TODO localize

func (*GameStatistics) ToDiscordEmbed 

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

func (*GameStatistics) ToString 

func (stats *GameStatistics) ToString() string

type GuildSettings 

type GuildSettings struct {
	AdminUserIDs             []string        `json:"adminIDs"`
	PermissionRoleIDs        []string        `json:"permissionRoleIDs"`
	CommandPrefix            string          `json:"commandPrefix"`
	Language                 string          `json:"language"`
	VoiceRules               game.VoiceRules `json:"voiceRules"`
	MapVersion               string          `json:"mapVersion"`
	Delays                   game.GameDelays `json:"delays"`
	DeleteGameSummaryMinutes int             `json:"deleteGameSummary"`

	UnmuteDeadDuringTasks bool   `json:"unmuteDeadDuringTasks"`
	AutoRefresh           bool   `json:"autoRefresh"`
	MatchSummaryChannelID string `json:"matchSummaryChannelID"`
	LeaderboardMention    bool   `json:"leaderboardMention"`
	LeaderboardSize       int    `json:"leaderboardSize"`
	LeaderboardMin        int    `json:"leaderboardMin"`
	MuteSpectator         bool   `json:"muteSpectator"`
	DisplayRoomCode       string `json:"displayRoomCode"`
	// contains filtered or unexported fields
}

func MakeGuildSettings 

func MakeGuildSettings() *GuildSettings

func (*GuildSettings) GetAdminUserIDs 

func (gs *GuildSettings) GetAdminUserIDs() []string

func (*GuildSettings) GetAutoRefresh 

func (gs *GuildSettings) GetAutoRefresh() bool

func (*GuildSettings) GetCommandPrefix 

func (gs *GuildSettings) GetCommandPrefix() string

func (*GuildSettings) GetDelay 

func (gs *GuildSettings) GetDelay(oldPhase, newPhase game.Phase) int

func (*GuildSettings) GetDeleteGameSummaryMinutes 

func (gs *GuildSettings) GetDeleteGameSummaryMinutes() int

func (*GuildSettings) GetDisplayRoomCode 

func (gs *GuildSettings) GetDisplayRoomCode() string

func (*GuildSettings) GetLanguage 

func (gs *GuildSettings) GetLanguage() string

func (*GuildSettings) GetLeaderboardMention 

func (gs *GuildSettings) GetLeaderboardMention() bool

func (*GuildSettings) GetLeaderboardMin 

func (gs *GuildSettings) GetLeaderboardMin() int

func (*GuildSettings) GetLeaderboardSize 

func (gs *GuildSettings) GetLeaderboardSize() int

func (*GuildSettings) GetMapVersion 

func (gs *GuildSettings) GetMapVersion() string

func (*GuildSettings) GetMatchSummaryChannelID 

func (gs *GuildSettings) GetMatchSummaryChannelID() string

func (*GuildSettings) GetMuteSpectator 

func (gs *GuildSettings) GetMuteSpectator() bool

func (*GuildSettings) GetPermissionRoleIDs 

func (gs *GuildSettings) GetPermissionRoleIDs() []string

func (*GuildSettings) GetUnmuteDeadDuringTasks 

func (gs *GuildSettings) GetUnmuteDeadDuringTasks() bool

func (*GuildSettings) GetVoiceRule 

func (gs *GuildSettings) GetVoiceRule(isMute bool, phase game.Phase, alive string) bool

func (*GuildSettings) GetVoiceState 

func (gs *GuildSettings) GetVoiceState(alive bool, tracked bool, phase game.Phase) (bool, bool)

func (*GuildSettings) HasAdminPerms 

func (gs *GuildSettings) HasAdminPerms(user *discordgo.User) bool

func (*GuildSettings) HasRolePerms 

func (gs *GuildSettings) HasRolePerms(mem *discordgo.Member) bool

func (*GuildSettings) LocalizeMessage 

func (gs *GuildSettings) LocalizeMessage(args ...interface{}) string

func (*GuildSettings) SetAdminUserIDs 

func (gs *GuildSettings) SetAdminUserIDs(ids []string)

func (*GuildSettings) SetAutoRefresh 

func (gs *GuildSettings) SetAutoRefresh(n bool)

func (*GuildSettings) SetCommandPrefix 

func (gs *GuildSettings) SetCommandPrefix(p string)

func (*GuildSettings) SetDelay 

func (gs *GuildSettings) SetDelay(oldPhase, newPhase game.Phase, v int)

func (*GuildSettings) SetDeleteGameSummaryMinutes 

func (gs *GuildSettings) SetDeleteGameSummaryMinutes(num int)

func (*GuildSettings) SetDisplayRoomCode 

func (gs *GuildSettings) SetDisplayRoomCode(r string)

func (*GuildSettings) SetLanguage 

func (gs *GuildSettings) SetLanguage(l string)

func (*GuildSettings) SetLeaderboardMention 

func (gs *GuildSettings) SetLeaderboardMention(v bool)

func (*GuildSettings) SetLeaderboardMin 

func (gs *GuildSettings) SetLeaderboardMin(v int)

func (*GuildSettings) SetLeaderboardSize 

func (gs *GuildSettings) SetLeaderboardSize(v int)

func (*GuildSettings) SetMapVersion 

func (gs *GuildSettings) SetMapVersion(n string)

func (*GuildSettings) SetMatchSummaryChannelID 

func (gs *GuildSettings) SetMatchSummaryChannelID(id string)

func (*GuildSettings) SetMuteSpectator 

func (gs *GuildSettings) SetMuteSpectator(behavior bool)

func (*GuildSettings) SetPermissionRoleIDs 

func (gs *GuildSettings) SetPermissionRoleIDs(ids []string)

func (*GuildSettings) SetUnmuteDeadDuringTasks 

func (gs *GuildSettings) SetUnmuteDeadDuringTasks(v bool)

func (*GuildSettings) SetVoiceRule 

func (gs *GuildSettings) SetVoiceRule(isMute bool, phase game.Phase, alive string, val bool)

type HashedID 

type HashedID string

func HashGuildID 

func HashGuildID(guildID string) HashedID

type Int16ModeCount 

type Int16ModeCount struct {
	Count int64 `db:"count"`
	Mode  int16 `db:"mode"`
}

type PostgresBestTeammatePlayerRanking 

type PostgresBestTeammatePlayerRanking struct {
	UserID     uint64  `db:"user_id"`
	TeammateID uint64  `db:"teammate_id"`
	WinCount   int64   `db:"win"`
	Count      int64   `db:"total"`
	WinRate    float64 `db:"win_rate"`
}

type PostgresGame 

type PostgresGame struct {
	GameID      int64  `db:"game_id"`
	GuildID     uint64 `db:"guild_id"`
	ConnectCode string `db:"connect_code"`
	StartTime   int32  `db:"start_time"`
	WinType     int16  `db:"win_type"`
	EndTime     int32  `db:"end_time"`
}

type PostgresGameEvent 

type PostgresGameEvent struct {
	EventID   uint64  `db:"event_id"`
	UserID    *uint64 `db:"user_id"`
	GameID    int64   `db:"game_id"`
	EventTime int32   `db:"event_time"`
	EventType int16   `db:"event_type"`
	Payload   string  `db:"payload"`
}

type PostgresGuild 

type PostgresGuild struct {
	GuildID    uint64 `db:"guild_id"`
	GuildName  string `db:"guild_name"`
	Premium    int16  `db:"premium"`
	TxTimeUnix *int32 `db:"tx_time_unix"`
}

type PostgresOtherPlayerRanking 

type PostgresOtherPlayerRanking struct {
	UserID  uint64  `db:"user_id"`
	Count   int64   `db:"count"`
	Percent float64 `db:"percent"`
}

type PostgresPlayerRanking 

type PostgresPlayerRanking struct {
	UserID   uint64  `db:"user_id"`
	WinCount int64   `db:"win"`
	Count    int64   `db:"total"`
	WinRate  float64 `db:"win_rate"`
}

type PostgresUser 

type PostgresUser struct {
	UserID uint64 `db:"user_id"`
	Opt    bool   `db:"opt"`
}

type PostgresUserActionRanking 

type PostgresUserActionRanking struct {
	UserID      uint64  `db:"user_id"`
	TotalAction int64   `db:"total_action"`
	Count       int64   `db:"total"`
	WinRate     float64 `db:"win_rate"`
}

type PostgresUserGame 

type PostgresUserGame struct {
	UserID      uint64 `db:"user_id"`
	GuildID     uint64 `db:"guild_id"`
	GameID      int64  `db:"game_id"`
	PlayerName  string `db:"player_name"`
	PlayerColor int16  `db:"player_color"`
	PlayerRole  int16  `db:"player_role"`
	PlayerWon   bool   `db:"player_won"`
}

type PostgresUserMostFrequentFirstTargetRanking 

type PostgresUserMostFrequentFirstTargetRanking struct {
	UserID     uint64  `db:"user_id"`
	TotalDeath int64   `db:"total_death"`
	Count      int64   `db:"total"`
	DeathRate  float64 `db:"death_rate"`
}

type PostgresUserMostFrequentKilledByanking 

type PostgresUserMostFrequentKilledByanking struct {
	UserID     uint64  `db:"user_id"`
	TeammateID uint64  `db:"teammate_id"`
	TotalDeath int64   `db:"total_death"`
	Encounter  int64   `db:"encounter"`
	DeathRate  float64 `db:"death_rate"`
}

type PostgresWorstTeammatePlayerRanking 

type PostgresWorstTeammatePlayerRanking struct {
	UserID     uint64  `db:"user_id"`
	TeammateID uint64  `db:"teammate_id"`
	LooseCount int64   `db:"loose"`
	Count      int64   `db:"total"`
	LooseRate  float64 `db:"loose_rate"`
}

type PsqlInterface 

type PsqlInterface struct {
	Pool *pgxpool.Pool
}

func (*PsqlInterface) AddEvent 

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

func (*PsqlInterface) AddInitialGame 

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

func (*PsqlInterface) BestTeammateByRole 

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

func (*PsqlInterface) BestTeammateForServerByRole 

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

func (*PsqlInterface) Close 

func (psqlInterface *PsqlInterface) Close()

func (*PsqlInterface) ColorRankingForPlayerOnServer 

func (psqlInterface *PsqlInterface) ColorRankingForPlayerOnServer(userID, guildID string) []*Int16ModeCount
func (psqlInterface *PsqlInterface) ColorRankingForPlayer(userID string) []*Int16ModeCount {
	r := []*Int16ModeCount{}
	err := pgxscan.Select(context.Background(), psqlInterface.Pool, &r, "SELECT count(*),mode() within GROUP (ORDER BY player_color) AS mode FROM users_games WHERE user_id=$1 GROUP BY player_color ORDER BY count desc;", userID)

	if err != nil {
		log.Println(err)
	}
	return r
}

func (*PsqlInterface) DeleteAllGamesForServer 

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

func (*PsqlInterface) DeleteAllGamesForUser 

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

func (*PsqlInterface) EnsureGuildExists 

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

func (*PsqlInterface) EnsureUserExists 

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

func (*PsqlInterface) GetGame 

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

func (*PsqlInterface) GetGameEvents 

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

func (*PsqlInterface) GetGuild 

func (psqlInterface *PsqlInterface) GetGuild(guildID uint64) (*PostgresGuild, error)

func (*PsqlInterface) GetGuildPremiumStatus 

func (psqlInterface *PsqlInterface) GetGuildPremiumStatus(guildID string) (premium.Tier, int)

func (*PsqlInterface) GetUser 

func (psqlInterface *PsqlInterface) GetUser(userID uint64) (*PostgresUser, error)

func (*PsqlInterface) GetUserByString 

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

func (*PsqlInterface) Init 

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

func (*PsqlInterface) LoadAndExecFromFile 

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

func (*PsqlInterface) NamesRankingForPlayerOnServer 

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

func (*PsqlInterface) NumGamesAsRole 

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

func (*PsqlInterface) NumGamesAsRoleOnServer 

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

func (*PsqlInterface) NumGamesPlayedByUser 

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

func (*PsqlInterface) NumGamesPlayedByUserOnServer 

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

func (*PsqlInterface) NumGamesPlayedOnGuild 

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

func (*PsqlInterface) NumGamesWonAsRoleOnServer 

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

func (*PsqlInterface) NumGuildsPlayedInByUser 

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

func (*PsqlInterface) NumWins 

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

func (*PsqlInterface) NumWinsAsRole 

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

func (*PsqlInterface) NumWinsAsRoleOnServer 

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

func (*PsqlInterface) NumWinsOnServer 

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

func (*PsqlInterface) OptUserByString 

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

func (*PsqlInterface) OtherPlayersRankingForPlayerOnServer 

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

func (*PsqlInterface) TotalGamesRankingForServer 

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

func (*PsqlInterface) TotalWinRankingForServer 

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

func (*PsqlInterface) TotalWinRankingForServerByRole 

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

func (*PsqlInterface) UpdateGameAndPlayers 

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

make sure to call the relevant "ensure" methods before this one...

func (*PsqlInterface) UserFrequentFirstTarget 

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

func (*PsqlInterface) UserMostFrequentFirstTargetForServer 

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

func (*PsqlInterface) UserMostFrequentKilledBy 

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

func (*PsqlInterface) UserMostFrequentKilledByServer 

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

func (*PsqlInterface) UserWinByActionAndRole 

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

func (*PsqlInterface) WorstTeammateByRole 

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

func (*PsqlInterface) WorstTeammateForServerByRole 

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

type PsqlParameters 

type PsqlParameters struct {
	Addr     string
	Username string
	Password string
}

type RedisParameters 

type RedisParameters struct {
	Addr     string
	Username string
	Password string
}

type SimpleEvent 

type SimpleEvent struct {
	EventType       SimpleEventType
	EventTimeOffset time.Duration
	Data            string
}

type SimpleEventType 

type SimpleEventType int
const (
	Tasks SimpleEventType = iota
	Discuss
	PlayerDeath
	PlayerDisconnect
)

type StorageInterface 

type StorageInterface struct {
	// contains filtered or unexported fields
}

func (*StorageInterface) Close 

func (storageInterface *StorageInterface) Close() error

func (*StorageInterface) DeleteGuildSettings 

func (storageInterface *StorageInterface) DeleteGuildSettings(guildID string) error

func (*StorageInterface) GetGuildSettings 

func (storageInterface *StorageInterface) GetGuildSettings(guildID string) *GuildSettings

func (*StorageInterface) Init 

func (storageInterface *StorageInterface) Init(params interface{}) error

func (*StorageInterface) SetGuildSettings 

func (storageInterface *StorageInterface) SetGuildSettings(guildID string, guildSettings *GuildSettings) error

type StringModeCount 

type StringModeCount struct {
	Count int64  `db:"count"`
	Mode  string `db:"mode"`
}

type Uint64ModeCount 

type Uint64ModeCount struct {
	Count int64  `db:"count"`
	Mode  uint64 `db:"mode"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.