db

Documentation

Index

• func InitDB(path string) (*sql.DB, error)
• func MutateAddTag(db *sql.DB, tag string, guild_id string, channel_id string, message_id string) error
• func MutateAwardCount(db *sql.DB, guild_id string, earner_id string, award_name string, ...) error
• func MutateRemoveTagByName(db *sql.DB, guild_id string, tag string) error
• func QueryListTags(db *sql.DB, guild_id string, page int) ([]string, error)
• func QuerySearchTags(db *sql.DB, query string, guild_id string) ([]string, error)
• func RunMigrations(db *sql.DB) error
• type AwardKV
  • func QueryAwardCounts(db *sql.DB, guild_id string, earner_id string) (AwardKV, error)
• type AwardOperation
• type LeaderboardEntry
  • func QueryLeaderboard(db *sql.DB, guild_id string) ([]LeaderboardEntry, error)
• type TagQueryResult
  • func QueryTagByName(db *sql.DB, name string, guild_id string) (TagQueryResult, error)

Functions

func InitDB

func InitDB(path string) (*sql.DB, error)

func MutateAddTag

func MutateAddTag(db *sql.DB, tag string, guild_id string, channel_id string, message_id string) error

func MutateAwardCount

func MutateAwardCount(db *sql.DB, guild_id string, earner_id string, award_name string, op AwardOperation) error

func MutateRemoveTagByName

func MutateRemoveTagByName(db *sql.DB, guild_id string, tag string) error

func QueryListTags

func QueryListTags(db *sql.DB, guild_id string, page int) ([]string, error)

func QuerySearchTags

func QuerySearchTags(db *sql.DB, query string, guild_id string) ([]string, error)

func RunMigrations

func RunMigrations(db *sql.DB) error

Types

type AwardKV

type AwardKV map[string]int

func QueryAwardCounts

func QueryAwardCounts(db *sql.DB, guild_id string, earner_id string) (AwardKV, error)

type AwardOperation

type AwardOperation int

const (
	AwardIncrement AwardOperation = iota
	AwardDecrement
)

type LeaderboardEntry

type LeaderboardEntry struct {
	AwardName string
	EarnerId  string
	Count     int
}

func QueryLeaderboard

func QueryLeaderboard(db *sql.DB, guild_id string) ([]LeaderboardEntry, error)

type TagQueryResult

type TagQueryResult struct {
	Name      string
	GuildID   string
	ChannelID string
	MessageID string
}

func QueryTagByName

func QueryTagByName(db *sql.DB, name string, guild_id string) (TagQueryResult, error)