mysql

package
v0.0.0-...-d931726 Latest Latest
Warning

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

Go to latest
Published: Aug 28, 2024 License: MIT Imports: 19 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type MysqlMiddleware

type MysqlMiddleware struct {
	Db *sql.DB
	// contains filtered or unexported fields
}

MysqlMiddleware implements the Database interface for MariaDB or MysqlMiddleware.

func New

func New() *MysqlMiddleware

func (*MysqlMiddleware) AddBackup

func (m *MysqlMiddleware) AddBackup(guildID, fileID string) error

func (*MysqlMiddleware) AddGuildLogEntry

func (m *MysqlMiddleware) AddGuildLogEntry(e models.GuildLogEntry) (err error)

func (*MysqlMiddleware) AddKarmaBlockList

func (m *MysqlMiddleware) AddKarmaBlockList(guildID, userID string) (err error)

func (*MysqlMiddleware) AddOrUpdateKarmaRule

func (m *MysqlMiddleware) AddOrUpdateKarmaRule(rule models.KarmaRule) (err error)

func (*MysqlMiddleware) AddReport

func (m *MysqlMiddleware) AddReport(rep models.Report) error

func (*MysqlMiddleware) AddRoleSelects

func (m *MysqlMiddleware) AddRoleSelects(v []models.RoleSelect) error

func (*MysqlMiddleware) AddTag

func (m *MysqlMiddleware) AddTag(tag tag.Tag) error

func (*MysqlMiddleware) AddToAntiraidJoinList

func (m *MysqlMiddleware) AddToAntiraidJoinList(guildID, userID, userTag string, accountCreated time.Time) (err error)

func (*MysqlMiddleware) AddUnbanRequest

func (m *MysqlMiddleware) AddUnbanRequest(r models.UnbanRequest) (err error)

func (*MysqlMiddleware) AddUpdateVote

func (m *MysqlMiddleware) AddUpdateVote(vote vote.Vote) error

func (*MysqlMiddleware) AddVerificationQueue

func (m *MysqlMiddleware) AddVerificationQueue(e models.VerificationQueueEntry) (err error)

func (*MysqlMiddleware) CheckKarmaRule

func (m *MysqlMiddleware) CheckKarmaRule(guildID, checksum string) (ok bool, err error)

func (*MysqlMiddleware) CleanupExpiredRefreshTokens

func (m *MysqlMiddleware) CleanupExpiredRefreshTokens() (n int64, err error)

func (*MysqlMiddleware) Close

func (m *MysqlMiddleware) Close()

func (*MysqlMiddleware) Connect

func (m *MysqlMiddleware) Connect(credentials ...interface{}) (err error)

func (*MysqlMiddleware) DeleteAPIToken

func (m *MysqlMiddleware) DeleteAPIToken(userID string) error

func (*MysqlMiddleware) DeleteBackup

func (m *MysqlMiddleware) DeleteBackup(guildID, fileID string) error

func (*MysqlMiddleware) DeleteBirthday

func (m *MysqlMiddleware) DeleteBirthday(guildID, userID string) (err error)

func (*MysqlMiddleware) DeleteLockChan

func (m *MysqlMiddleware) DeleteLockChan(chanID string) error

func (*MysqlMiddleware) DeleteLogEntries

func (m *MysqlMiddleware) DeleteLogEntries(guildID string) (err error)

func (*MysqlMiddleware) DeleteLogEntry

func (m *MysqlMiddleware) DeleteLogEntry(guildID string, id snowflake.ID) (err error)

func (*MysqlMiddleware) DeleteReport

func (m *MysqlMiddleware) DeleteReport(id snowflake.ID) error

func (*MysqlMiddleware) DeleteTag

func (m *MysqlMiddleware) DeleteTag(id snowflake.ID) error

func (*MysqlMiddleware) DeleteTwitchNotify

func (m *MysqlMiddleware) DeleteTwitchNotify(twitchUserID, guildID string) error

func (*MysqlMiddleware) DeleteVote

func (m *MysqlMiddleware) DeleteVote(voteID string) error

func (*MysqlMiddleware) EditTag

func (m *MysqlMiddleware) EditTag(tag tag.Tag) error

func (*MysqlMiddleware) ExpireReports

func (m *MysqlMiddleware) ExpireReports(ids ...string) (err error)

func (*MysqlMiddleware) FlushAntiraidJoinList

func (m *MysqlMiddleware) FlushAntiraidJoinList(guildID string) (err error)

func (*MysqlMiddleware) FlushGuildData

func (m *MysqlMiddleware) FlushGuildData(guildID string) (err error)

func (*MysqlMiddleware) FlushUserData

func (m *MysqlMiddleware) FlushUserData(userID string) (res map[string]int, err error)

func (*MysqlMiddleware) FlushVerificationQueue

func (m *MysqlMiddleware) FlushVerificationQueue(guildID string) (err error)

func (*MysqlMiddleware) GetAPIToken

func (m *MysqlMiddleware) GetAPIToken(userID string) (t models.APITokenEntry, err error)

func (*MysqlMiddleware) GetAllTwitchNotifies

func (m *MysqlMiddleware) GetAllTwitchNotifies(twitchUserID string) ([]twitchnotify.DBEntry, error)

func (*MysqlMiddleware) GetAntiraidBurst

func (m *MysqlMiddleware) GetAntiraidBurst(guildID string) (burst int, err error)

func (*MysqlMiddleware) GetAntiraidJoinList

func (m *MysqlMiddleware) GetAntiraidJoinList(guildID string) (res []models.JoinLogEntry, err error)

func (*MysqlMiddleware) GetAntiraidRegeneration

func (m *MysqlMiddleware) GetAntiraidRegeneration(guildID string) (limit int, err error)

func (*MysqlMiddleware) GetAntiraidState

func (m *MysqlMiddleware) GetAntiraidState(guildID string) (state bool, err error)

func (*MysqlMiddleware) GetAntiraidVerification

func (m *MysqlMiddleware) GetAntiraidVerification(guildID string) (state bool, err error)

func (*MysqlMiddleware) GetBackups

func (m *MysqlMiddleware) GetBackups(guildID string) ([]backupmodels.Entry, error)

func (*MysqlMiddleware) GetBirthdays

func (m *MysqlMiddleware) GetBirthdays(guildID string) (bd []models.Birthday, err error)

func (*MysqlMiddleware) GetExpiredReports

func (m *MysqlMiddleware) GetExpiredReports() (results []models.Report, err error)

func (*MysqlMiddleware) GetGuildAPI

func (m *MysqlMiddleware) GetGuildAPI(guildID string) (settings models.GuildAPISettings, err error)

func (*MysqlMiddleware) GetGuildAutoRole

func (m *MysqlMiddleware) GetGuildAutoRole(guildID string) ([]string, error)

func (*MysqlMiddleware) GetGuildAutoVC

func (m *MysqlMiddleware) GetGuildAutoVC(guildID string) ([]string, error)

func (*MysqlMiddleware) GetGuildBackup

func (m *MysqlMiddleware) GetGuildBackup(guildID string) (bool, error)

func (*MysqlMiddleware) GetGuildBirthdayChan

func (m *MysqlMiddleware) GetGuildBirthdayChan(guildID string) (chanID string, err error)

func (*MysqlMiddleware) GetGuildCodeExecEnabled

func (m *MysqlMiddleware) GetGuildCodeExecEnabled(guildID string) (bool, error)

func (*MysqlMiddleware) GetGuildColorReaction

func (m *MysqlMiddleware) GetGuildColorReaction(guildID string) (enabled bool, err error)

func (*MysqlMiddleware) GetGuildGhostpingMsg

func (m *MysqlMiddleware) GetGuildGhostpingMsg(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildInviteBlock

func (m *MysqlMiddleware) GetGuildInviteBlock(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildJdoodleKey

func (m *MysqlMiddleware) GetGuildJdoodleKey(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildJoinMsg

func (m *MysqlMiddleware) GetGuildJoinMsg(guildID string) (string, string, error)

func (*MysqlMiddleware) GetGuildLeaveMsg

func (m *MysqlMiddleware) GetGuildLeaveMsg(guildID string) (string, string, error)

func (*MysqlMiddleware) GetGuildLogDisable

func (m *MysqlMiddleware) GetGuildLogDisable(guildID string) (bool, error)

func (*MysqlMiddleware) GetGuildLogEntries

func (m *MysqlMiddleware) GetGuildLogEntries(
	guildID string,
	offset, limit int,
	severity models.GuildLogSeverity,
	ascending bool,
) (res []models.GuildLogEntry, err error)

func (*MysqlMiddleware) GetGuildLogEntriesCount

func (m *MysqlMiddleware) GetGuildLogEntriesCount(guildID string, severity models.GuildLogSeverity) (n int, err error)

func (*MysqlMiddleware) GetGuildModLog

func (m *MysqlMiddleware) GetGuildModLog(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildModNot

func (m *MysqlMiddleware) GetGuildModNot(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildNotifyRole

func (m *MysqlMiddleware) GetGuildNotifyRole(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildPermissions

func (m *MysqlMiddleware) GetGuildPermissions(guildID string) (map[string]permissions.PermissionArray, error)

func (*MysqlMiddleware) GetGuildPrefix

func (m *MysqlMiddleware) GetGuildPrefix(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildTags

func (m *MysqlMiddleware) GetGuildTags(guildID string) ([]tag.Tag, error)

func (*MysqlMiddleware) GetGuildUnbanRequests

func (m *MysqlMiddleware) GetGuildUnbanRequests(guildID string, limit, offset int) (r []models.UnbanRequest, err error)

func (*MysqlMiddleware) GetGuildUnbanRequestsCount

func (m *MysqlMiddleware) GetGuildUnbanRequestsCount(guildID string, state *models.UnbanRequestState) (n int, err error)

func (*MysqlMiddleware) GetGuildUserUnbanRequests

func (m *MysqlMiddleware) GetGuildUserUnbanRequests(userID, guildID string) (r []models.UnbanRequest, err error)

func (*MysqlMiddleware) GetGuildVerificationRequired

func (m *MysqlMiddleware) GetGuildVerificationRequired(guildID string) (bool, error)

func (*MysqlMiddleware) GetGuildVoiceLog

func (m *MysqlMiddleware) GetGuildVoiceLog(guildID string) (string, error)

func (*MysqlMiddleware) GetGuildVoiceLogIgnores

func (m *MysqlMiddleware) GetGuildVoiceLogIgnores(guildID string) (res []string, err error)

func (*MysqlMiddleware) GetGuilds

func (m *MysqlMiddleware) GetGuilds() ([]string, error)

func (*MysqlMiddleware) GetKarma

func (m *MysqlMiddleware) GetKarma(userID, guildID string) (i int, err error)

func (*MysqlMiddleware) GetKarmaBlockList

func (m *MysqlMiddleware) GetKarmaBlockList(guildID string) (list []string, err error)

func (*MysqlMiddleware) GetKarmaEmotes

func (m *MysqlMiddleware) GetKarmaEmotes(guildID string) (emotesInc, emotesDec string, err error)

func (*MysqlMiddleware) GetKarmaGuild

func (m *MysqlMiddleware) GetKarmaGuild(guildID string, limit int) ([]models.GuildKarma, error)

func (*MysqlMiddleware) GetKarmaPenalty

func (m *MysqlMiddleware) GetKarmaPenalty(guildID string) (state bool, err error)

func (*MysqlMiddleware) GetKarmaRules

func (m *MysqlMiddleware) GetKarmaRules(guildID string) (res []models.KarmaRule, err error)

func (*MysqlMiddleware) GetKarmaState

func (m *MysqlMiddleware) GetKarmaState(guildID string) (state bool, err error)

func (*MysqlMiddleware) GetKarmaSum

func (m *MysqlMiddleware) GetKarmaSum(userID string) (i int, err error)

func (*MysqlMiddleware) GetKarmaTokens

func (m *MysqlMiddleware) GetKarmaTokens(guildID string) (tokens int, err error)

func (*MysqlMiddleware) GetLockChan

func (m *MysqlMiddleware) GetLockChan(chanID string) (guildID, executorID, permissions string, err error)

func (*MysqlMiddleware) GetLockChannels

func (m *MysqlMiddleware) GetLockChannels(guildID string) (chanIDs []string, err error)

func (*MysqlMiddleware) GetReport

func (m *MysqlMiddleware) GetReport(id snowflake.ID) (models.Report, error)

func (*MysqlMiddleware) GetReportsFiltered

func (m *MysqlMiddleware) GetReportsFiltered(guildID, memberID string, repType models.ReportType, offset, limit int) ([]models.Report, error)

func (*MysqlMiddleware) GetReportsFilteredCount

func (m *MysqlMiddleware) GetReportsFilteredCount(guildID, memberID string, repType int) (count int, err error)

func (*MysqlMiddleware) GetReportsGuild

func (m *MysqlMiddleware) GetReportsGuild(guildID string, offset, limit int) ([]models.Report, error)

func (*MysqlMiddleware) GetReportsGuildCount

func (m *MysqlMiddleware) GetReportsGuildCount(guildID string) (count int, err error)

func (*MysqlMiddleware) GetRoleSelects

func (m *MysqlMiddleware) GetRoleSelects() ([]models.RoleSelect, error)

func (*MysqlMiddleware) GetSetting

func (m *MysqlMiddleware) GetSetting(setting string) (string, error)

func (*MysqlMiddleware) GetStarboardConfig

func (m *MysqlMiddleware) GetStarboardConfig(guildID string) (config models.StarboardConfig, err error)

func (*MysqlMiddleware) GetStarboardEntries

func (m *MysqlMiddleware) GetStarboardEntries(
	guildID string,
	sortBy models.StarboardSortBy,
	limit, offset int,
) (res []models.StarboardEntry, err error)

func (*MysqlMiddleware) GetStarboardEntriesCount

func (m *MysqlMiddleware) GetStarboardEntriesCount(guildID string) (n int, err error)

func (*MysqlMiddleware) GetStarboardEntry

func (m *MysqlMiddleware) GetStarboardEntry(messageID string) (e models.StarboardEntry, err error)

func (*MysqlMiddleware) GetTagByID

func (m *MysqlMiddleware) GetTagByID(id snowflake.ID) (tag.Tag, error)

func (*MysqlMiddleware) GetTagByIdent

func (m *MysqlMiddleware) GetTagByIdent(ident string, guildID string) (tag.Tag, error)

func (*MysqlMiddleware) GetTwitchNotify

func (m *MysqlMiddleware) GetTwitchNotify(twitchUserID, guildID string) (twitchnotify.DBEntry, error)

func (*MysqlMiddleware) GetUnbanRequest

func (m *MysqlMiddleware) GetUnbanRequest(id string) (r models.UnbanRequest, err error)

func (*MysqlMiddleware) GetUserByRefreshToken

func (m *MysqlMiddleware) GetUserByRefreshToken(token string) (userID string, expires time.Time, err error)

func (*MysqlMiddleware) GetUserOTAEnabled

func (m *MysqlMiddleware) GetUserOTAEnabled(userID string) (enabled bool, err error)

func (*MysqlMiddleware) GetUserStarboardOptout

func (m *MysqlMiddleware) GetUserStarboardOptout(userID string) (enabled bool, err error)

func (*MysqlMiddleware) GetUserVerified

func (m *MysqlMiddleware) GetUserVerified(userID string) (enabled bool, err error)

func (*MysqlMiddleware) GetVerificationQueue

func (m *MysqlMiddleware) GetVerificationQueue(guildID, userID string) (res []models.VerificationQueueEntry, err error)

func (*MysqlMiddleware) GetVotes

func (m *MysqlMiddleware) GetVotes() (map[string]vote.Vote, error)

func (*MysqlMiddleware) IsGuildVoiceLogIgnored

func (m *MysqlMiddleware) IsGuildVoiceLogIgnored(guildID, channelID string) (ok bool, err error)

func (*MysqlMiddleware) IsKarmaBlockListed

func (m *MysqlMiddleware) IsKarmaBlockListed(guildID, userID string) (ok bool, err error)

func (*MysqlMiddleware) Migrate

func (m *MysqlMiddleware) Migrate() (err error)

func (*MysqlMiddleware) RemoveAntiraidJoinList

func (m *MysqlMiddleware) RemoveAntiraidJoinList(guildID, userID string) (err error)

func (*MysqlMiddleware) RemoveGuildVoiceLogIgnore

func (m *MysqlMiddleware) RemoveGuildVoiceLogIgnore(guildID, channelID string) (err error)

func (*MysqlMiddleware) RemoveKarmaBlockList

func (m *MysqlMiddleware) RemoveKarmaBlockList(guildID, userID string) (err error)

func (*MysqlMiddleware) RemoveKarmaRule

func (m *MysqlMiddleware) RemoveKarmaRule(guildID string, id snowflake.ID) (err error)

func (*MysqlMiddleware) RemoveRoleSelect

func (m *MysqlMiddleware) RemoveRoleSelect(guildID, channelID, messageID string) error

func (*MysqlMiddleware) RemoveStarboardEntry

func (m *MysqlMiddleware) RemoveStarboardEntry(msgID string) (err error)

func (*MysqlMiddleware) RemoveVerificationQueue

func (m *MysqlMiddleware) RemoveVerificationQueue(guildID, userID string) (ok bool, err error)

func (*MysqlMiddleware) RevokeUserRefreshToken

func (m *MysqlMiddleware) RevokeUserRefreshToken(userID string) (err error)

func (*MysqlMiddleware) SetAPIToken

func (m *MysqlMiddleware) SetAPIToken(token models.APITokenEntry) (err error)

func (*MysqlMiddleware) SetAntiraidBurst

func (m *MysqlMiddleware) SetAntiraidBurst(guildID string, burst int) (err error)

func (*MysqlMiddleware) SetAntiraidRegeneration

func (m *MysqlMiddleware) SetAntiraidRegeneration(guildID string, limit int) (err error)

func (*MysqlMiddleware) SetAntiraidState

func (m *MysqlMiddleware) SetAntiraidState(guildID string, state bool) (err error)

func (*MysqlMiddleware) SetAntiraidVerification

func (m *MysqlMiddleware) SetAntiraidVerification(guildID string, state bool) (err error)

func (*MysqlMiddleware) SetBirthday

func (m *MysqlMiddleware) SetBirthday(bd models.Birthday) (err error)

func (*MysqlMiddleware) SetGuildAPI

func (m *MysqlMiddleware) SetGuildAPI(guildID string, settings models.GuildAPISettings) (err error)

func (*MysqlMiddleware) SetGuildAutoRole

func (m *MysqlMiddleware) SetGuildAutoRole(guildID string, autoRoleIDs []string) error

func (*MysqlMiddleware) SetGuildAutoVC

func (m *MysqlMiddleware) SetGuildAutoVC(guildID string, autoVCIDs []string) error

func (*MysqlMiddleware) SetGuildBackup

func (m *MysqlMiddleware) SetGuildBackup(guildID string, enabled bool) error

func (*MysqlMiddleware) SetGuildBirthdayChan

func (m *MysqlMiddleware) SetGuildBirthdayChan(guildID string, chanID string) (err error)

func (*MysqlMiddleware) SetGuildCodeExecEnabled

func (m *MysqlMiddleware) SetGuildCodeExecEnabled(guildID string, enabled bool) error

func (*MysqlMiddleware) SetGuildColorReaction

func (m *MysqlMiddleware) SetGuildColorReaction(guildID string, enabled bool) error

func (*MysqlMiddleware) SetGuildGhostpingMsg

func (m *MysqlMiddleware) SetGuildGhostpingMsg(guildID, msg string) error

func (*MysqlMiddleware) SetGuildInviteBlock

func (m *MysqlMiddleware) SetGuildInviteBlock(guildID string, data string) error

func (*MysqlMiddleware) SetGuildJdoodleKey

func (m *MysqlMiddleware) SetGuildJdoodleKey(guildID, key string) error

func (*MysqlMiddleware) SetGuildJoinMsg

func (m *MysqlMiddleware) SetGuildJoinMsg(guildID string, msg string, channelID string) error

func (*MysqlMiddleware) SetGuildLeaveMsg

func (m *MysqlMiddleware) SetGuildLeaveMsg(guildID string, channelID string, msg string) error

func (*MysqlMiddleware) SetGuildLogDisable

func (m *MysqlMiddleware) SetGuildLogDisable(guildID string, enabled bool) error

func (*MysqlMiddleware) SetGuildModLog

func (m *MysqlMiddleware) SetGuildModLog(guildID, chanID string) error

func (*MysqlMiddleware) SetGuildModNot

func (m *MysqlMiddleware) SetGuildModNot(guildID, chanID string) error

func (*MysqlMiddleware) SetGuildNotifyRole

func (m *MysqlMiddleware) SetGuildNotifyRole(guildID, roleID string) error

func (*MysqlMiddleware) SetGuildPrefix

func (m *MysqlMiddleware) SetGuildPrefix(guildID, newPrefix string) error

func (*MysqlMiddleware) SetGuildRolePermission

func (m *MysqlMiddleware) SetGuildRolePermission(guildID, roleID string, p permissions.PermissionArray) error

func (*MysqlMiddleware) SetGuildVerificationRequired

func (m *MysqlMiddleware) SetGuildVerificationRequired(guildID string, enable bool) error

func (*MysqlMiddleware) SetGuildVoiceLog

func (m *MysqlMiddleware) SetGuildVoiceLog(guildID, chanID string) error

func (*MysqlMiddleware) SetGuildVoiceLogIngore

func (m *MysqlMiddleware) SetGuildVoiceLogIngore(guildID, channelID string) (err error)

func (*MysqlMiddleware) SetKarma

func (m *MysqlMiddleware) SetKarma(userID, guildID string, val int) (err error)

func (*MysqlMiddleware) SetKarmaEmotes

func (m *MysqlMiddleware) SetKarmaEmotes(guildID, emotesInc, emotesDec string) (err error)

func (*MysqlMiddleware) SetKarmaPenalty

func (m *MysqlMiddleware) SetKarmaPenalty(guildID string, state bool) (err error)

func (*MysqlMiddleware) SetKarmaState

func (m *MysqlMiddleware) SetKarmaState(guildID string, state bool) (err error)

func (*MysqlMiddleware) SetKarmaTokens

func (m *MysqlMiddleware) SetKarmaTokens(guildID string, tokens int) (err error)

func (*MysqlMiddleware) SetLockChan

func (m *MysqlMiddleware) SetLockChan(chanID, guildID, executorID, permissions string) error

func (*MysqlMiddleware) SetSetting

func (m *MysqlMiddleware) SetSetting(setting, value string) error

func (*MysqlMiddleware) SetStarboardConfig

func (m *MysqlMiddleware) SetStarboardConfig(config models.StarboardConfig) (err error)

func (*MysqlMiddleware) SetStarboardEntry

func (m *MysqlMiddleware) SetStarboardEntry(e models.StarboardEntry) (err error)

func (*MysqlMiddleware) SetTwitchNotify

func (m *MysqlMiddleware) SetTwitchNotify(twitchNotify twitchnotify.DBEntry) error

func (*MysqlMiddleware) SetUserOTAEnabled

func (m *MysqlMiddleware) SetUserOTAEnabled(userID string, enabled bool) error

func (*MysqlMiddleware) SetUserRefreshToken

func (m *MysqlMiddleware) SetUserRefreshToken(userID, token string, expires time.Time) (err error)

func (*MysqlMiddleware) SetUserStarboardOptout

func (m *MysqlMiddleware) SetUserStarboardOptout(userID string, enabled bool) error

func (*MysqlMiddleware) SetUserVerified

func (m *MysqlMiddleware) SetUserVerified(userID string, enabled bool) error

func (*MysqlMiddleware) Status

func (m *MysqlMiddleware) Status() error

func (*MysqlMiddleware) UpdateKarma

func (m *MysqlMiddleware) UpdateKarma(userID, guildID string, diff int) (err error)

func (*MysqlMiddleware) UpdateUnbanRequest

func (m *MysqlMiddleware) UpdateUnbanRequest(r models.UnbanRequest) (err error)

Jump to

Keyboard shortcuts

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