sqlc

package
v0.2.1 Latest Latest
Warning

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

Go to latest
Published: Jan 17, 2024 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActiveServer

type ActiveServer struct {
	Timestamp    pgtype.Timestamptz `db:"timestamp"`
	Address      string             `db:"address"`
	Protocols    []byte             `db:"protocols"`
	Name         string             `db:"name"`
	Gametype     string             `db:"gametype"`
	Passworded   bool               `db:"passworded"`
	Map          string             `db:"map"`
	MapSha256sum *string            `db:"map_sha256sum"`
	MapSize      *int32             `db:"map_size"`
	Version      string             `db:"version"`
	MaxClients   int16              `db:"max_clients"`
	MaxPlayers   int16              `db:"max_players"`
	ScoreKind    string             `db:"score_kind"`
}

type ActiveServerClient

type ActiveServerClient struct {
	ID        int64  `db:"id"`
	Address   string `db:"address"`
	Name      string `db:"name"`
	Clan      string `db:"clan"`
	CountryID int16  `db:"country_id"`
	Score     int32  `db:"score"`
	IsPlayer  bool   `db:"is_player"`
	Team      *int16 `db:"team"`
}

type AddFlagMappingParams

type AddFlagMappingParams struct {
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	FlagID    int16  `db:"flag_id"`
	Emoji     string `db:"emoji"`
}

type AddFlagParams

type AddFlagParams struct {
	FlagID int16  `db:"flag_id"`
	Abbr   string `db:"abbr"`
	Emoji  string `db:"emoji"`
}

type AddGuildChannelParams

type AddGuildChannelParams struct {
	ChannelID int64 `db:"channel_id"`
	GuildID   int64 `db:"guild_id"`
	Running   bool  `db:"running"`
}

type AddGuildParams

type AddGuildParams struct {
	GuildID     int64  `db:"guild_id"`
	Description string `db:"description"`
}

type AddPrevActiveServerClientParams

type AddPrevActiveServerClientParams struct {
	MessageID int64  `db:"message_id"`
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Name      string `db:"name"`
	Clan      string `db:"clan"`
	Team      *int16 `db:"team"`
	CountryID int16  `db:"country_id"`
	Score     int32  `db:"score"`
	IsPlayer  bool   `db:"is_player"`
	FlagAbbr  string `db:"flag_abbr"`
	FlagEmoji string `db:"flag_emoji"`
}

type AddPrevActiveServerParams

type AddPrevActiveServerParams struct {
	MessageID    int64              `db:"message_id"`
	GuildID      int64              `db:"guild_id"`
	ChannelID    int64              `db:"channel_id"`
	Timestamp    pgtype.Timestamptz `db:"timestamp"`
	Address      string             `db:"address"`
	Protocols    []byte             `db:"protocols"`
	Name         string             `db:"name"`
	Gametype     string             `db:"gametype"`
	Passworded   bool               `db:"passworded"`
	Map          string             `db:"map"`
	MapSha256sum *string            `db:"map_sha256sum"`
	MapSize      *int32             `db:"map_size"`
	Version      string             `db:"version"`
	MaxClients   int16              `db:"max_clients"`
	MaxPlayers   int16              `db:"max_players"`
	ScoreKind    string             `db:"score_kind"`
}

type AddTrackingParams

type AddTrackingParams struct {
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Address   string `db:"address"`
	MessageID int64  `db:"message_id"`
}

type Channel

type Channel struct {
	ChannelID int64 `db:"channel_id"`
	GuildID   int64 `db:"guild_id"`
	Running   bool  `db:"running"`
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Flag

type Flag struct {
	FlagID int16  `db:"flag_id"`
	Abbr   string `db:"abbr"`
	Emoji  string `db:"emoji"`
}

type FlagMapping

type FlagMapping struct {
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	FlagID    int16  `db:"flag_id"`
	Emoji     string `db:"emoji"`
}

type GetChannelParams

type GetChannelParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
}

type GetFlagMappingParams

type GetFlagMappingParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	FlagID    int16 `db:"flag_id"`
}

type GetFlagMappingRow

type GetFlagMappingRow struct {
	FlagID int16  `db:"flag_id"`
	Emoji  string `db:"emoji"`
	Abbr   string `db:"abbr"`
}

type GetMessageTargetNotificationsParams

type GetMessageTargetNotificationsParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
}

type GetMessageTargetNotificationsRow

type GetMessageTargetNotificationsRow struct {
	UserID    int64 `db:"user_id"`
	Threshold int16 `db:"threshold"`
}

type GetPlayerCountNotificationParams

type GetPlayerCountNotificationParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
	UserID    int64 `db:"user_id"`
}

type GetPrevActiveServerClientsRow

type GetPrevActiveServerClientsRow struct {
	MessageID int64  `db:"message_id"`
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Name      string `db:"name"`
	Clan      string `db:"clan"`
	Team      *int16 `db:"team"`
	CountryID int16  `db:"country_id"`
	Score     int32  `db:"score"`
	IsPlayer  bool   `db:"is_player"`
	FlagAbbr  string `db:"flag_abbr"`
	FlagEmoji string `db:"flag_emoji"`
}

type Guild

type Guild struct {
	GuildID     int64  `db:"guild_id"`
	Description string `db:"description"`
}

type InsertActiveServerClientsParams

type InsertActiveServerClientsParams struct {
	Address   string `db:"address"`
	Name      string `db:"name"`
	Clan      string `db:"clan"`
	CountryID int16  `db:"country_id"`
	Score     int32  `db:"score"`
	IsPlayer  bool   `db:"is_player"`
	Team      *int16 `db:"team"`
}

type InsertActiveServersParams

type InsertActiveServersParams struct {
	Timestamp    pgtype.Timestamptz `db:"timestamp"`
	Address      string             `db:"address"`
	Protocols    []byte             `db:"protocols"`
	Name         string             `db:"name"`
	Gametype     string             `db:"gametype"`
	Passworded   bool               `db:"passworded"`
	Map          string             `db:"map"`
	MapSha256sum *string            `db:"map_sha256sum"`
	MapSize      *int32             `db:"map_size"`
	Version      string             `db:"version"`
	MaxClients   int16              `db:"max_clients"`
	MaxPlayers   int16              `db:"max_players"`
	ScoreKind    string             `db:"score_kind"`
}

type ListAllTrackingsRow

type ListAllTrackingsRow struct {
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Address   string `db:"address"`
	MessageID int64  `db:"message_id"`
}

type ListChannelTrackingsParams

type ListChannelTrackingsParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
}

type ListChannelTrackingsRow

type ListChannelTrackingsRow struct {
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Address   string `db:"address"`
	MessageID int64  `db:"message_id"`
}

type ListFlagMappingsParams

type ListFlagMappingsParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
}

type ListFlagMappingsRow

type ListFlagMappingsRow struct {
	FlagID int16  `db:"flag_id"`
	Emoji  string `db:"emoji"`
	Abbr   string `db:"abbr"`
}

type ListGuildChannelsRow

type ListGuildChannelsRow struct {
	ChannelID int64 `db:"channel_id"`
	Running   bool  `db:"running"`
}

type ListTrackedServerClientsRow

type ListTrackedServerClientsRow struct {
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	MessageID int64  `db:"message_id"`
	Name      string `db:"name"`
	Clan      string `db:"clan"`
	CountryID int16  `db:"country_id"`
	Score     int32  `db:"score"`
	IsPlayer  bool   `db:"is_player"`
	Team      *int16 `db:"team"`
	Abbr      string `db:"abbr"`
	FlagEmoji string `db:"flag_emoji"`
}

type ListTrackedServersRow

type ListTrackedServersRow struct {
	GuildID      int64              `db:"guild_id"`
	ChannelID    int64              `db:"channel_id"`
	MessageID    int64              `db:"message_id"`
	Timestamp    pgtype.Timestamptz `db:"timestamp"`
	Address      string             `db:"address"`
	Protocols    []byte             `db:"protocols"`
	Name         string             `db:"name"`
	Gametype     string             `db:"gametype"`
	Passworded   bool               `db:"passworded"`
	Map          string             `db:"map"`
	MapSha256sum *string            `db:"map_sha256sum"`
	MapSize      *int32             `db:"map_size"`
	Version      string             `db:"version"`
	MaxClients   int16              `db:"max_clients"`
	MaxPlayers   int16              `db:"max_players"`
	ScoreKind    string             `db:"score_kind"`
}

type PlayerCountNotification

type PlayerCountNotification struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
	UserID    int64 `db:"user_id"`
	Threshold int16 `db:"threshold"`
}

type PrevActiveServer

type PrevActiveServer struct {
	MessageID    int64              `db:"message_id"`
	GuildID      int64              `db:"guild_id"`
	ChannelID    int64              `db:"channel_id"`
	Timestamp    pgtype.Timestamptz `db:"timestamp"`
	Address      string             `db:"address"`
	Protocols    []byte             `db:"protocols"`
	Name         string             `db:"name"`
	Gametype     string             `db:"gametype"`
	Passworded   bool               `db:"passworded"`
	Map          string             `db:"map"`
	MapSha256sum *string            `db:"map_sha256sum"`
	MapSize      *int32             `db:"map_size"`
	Version      string             `db:"version"`
	MaxClients   int16              `db:"max_clients"`
	MaxPlayers   int16              `db:"max_players"`
	ScoreKind    string             `db:"score_kind"`
}

type PrevActiveServerClient

type PrevActiveServerClient struct {
	ID        int64  `db:"id"`
	MessageID int64  `db:"message_id"`
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Name      string `db:"name"`
	Clan      string `db:"clan"`
	CountryID int16  `db:"country_id"`
	Score     int32  `db:"score"`
	IsPlayer  bool   `db:"is_player"`
	Team      *int16 `db:"team"`
	FlagAbbr  string `db:"flag_abbr"`
	FlagEmoji string `db:"flag_emoji"`
}

type PrevMessageMention

type PrevMessageMention struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
	UserID    int64 `db:"user_id"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddFlag

func (q *Queries) AddFlag(ctx context.Context, arg AddFlagParams) error

func (*Queries) AddFlagMapping

func (q *Queries) AddFlagMapping(ctx context.Context, arg AddFlagMappingParams) error

func (*Queries) AddGuild

func (q *Queries) AddGuild(ctx context.Context, arg AddGuildParams) error

func (*Queries) AddGuildChannel

func (q *Queries) AddGuildChannel(ctx context.Context, arg AddGuildChannelParams) error

func (*Queries) AddPrevActiveServer

func (q *Queries) AddPrevActiveServer(ctx context.Context, arg AddPrevActiveServerParams) error

func (*Queries) AddPrevActiveServerClient

func (q *Queries) AddPrevActiveServerClient(ctx context.Context, arg AddPrevActiveServerClientParams) error

func (*Queries) AddTracking

func (q *Queries) AddTracking(ctx context.Context, arg AddTrackingParams) error

func (*Queries) DeleteActiveServerClients

func (q *Queries) DeleteActiveServerClients(ctx context.Context) error

func (*Queries) DeleteActiveServers

func (q *Queries) DeleteActiveServers(ctx context.Context) error

func (*Queries) ExistsServer

func (q *Queries) ExistsServer(ctx context.Context, address string) ([]string, error)

func (*Queries) GetChannel

func (q *Queries) GetChannel(ctx context.Context, arg GetChannelParams) ([]bool, error)

func (*Queries) GetFlag

func (q *Queries) GetFlag(ctx context.Context, flagID int16) ([]Flag, error)

func (*Queries) GetFlagByAbbr

func (q *Queries) GetFlagByAbbr(ctx context.Context, abbr string) ([]Flag, error)

func (*Queries) GetFlagMapping

func (q *Queries) GetFlagMapping(ctx context.Context, arg GetFlagMappingParams) ([]GetFlagMappingRow, error)

func (*Queries) GetGuild

func (q *Queries) GetGuild(ctx context.Context, guildID int64) ([]Guild, error)

func (*Queries) GetPlayerCountNotification

func (q *Queries) GetPlayerCountNotification(ctx context.Context, arg GetPlayerCountNotificationParams) ([]PlayerCountNotification, error)

func (*Queries) GetPrevActiveServerClients

func (q *Queries) GetPrevActiveServerClients(ctx context.Context, messageID int64) ([]GetPrevActiveServerClientsRow, error)

func (*Queries) InsertActiveServerClients

func (q *Queries) InsertActiveServerClients(ctx context.Context, arg InsertActiveServerClientsParams) error

func (*Queries) InsertActiveServers

func (q *Queries) InsertActiveServers(ctx context.Context, arg InsertActiveServersParams) error

func (*Queries) ListAllTrackings

func (q *Queries) ListAllTrackings(ctx context.Context) ([]ListAllTrackingsRow, error)

func (*Queries) ListChannelTrackings

func (q *Queries) ListChannelTrackings(ctx context.Context, arg ListChannelTrackingsParams) ([]ListChannelTrackingsRow, error)

func (*Queries) ListFlagMappings

func (q *Queries) ListFlagMappings(ctx context.Context, arg ListFlagMappingsParams) ([]ListFlagMappingsRow, error)

func (*Queries) ListFlags

func (q *Queries) ListFlags(ctx context.Context) ([]Flag, error)

func (*Queries) ListGuildChannels

func (q *Queries) ListGuildChannels(ctx context.Context, guildID int64) ([]ListGuildChannelsRow, error)

func (*Queries) ListGuilds

func (q *Queries) ListGuilds(ctx context.Context) ([]Guild, error)

func (*Queries) ListPlayerCountNotifications

func (q *Queries) ListPlayerCountNotifications(ctx context.Context) ([]PlayerCountNotification, error)

func (*Queries) ListPrevActiveServers

func (q *Queries) ListPrevActiveServers(ctx context.Context) ([]PrevActiveServer, error)

func (*Queries) ListPreviousMessageMentions

func (q *Queries) ListPreviousMessageMentions(ctx context.Context) ([]PrevMessageMention, error)

func (*Queries) ListTrackedServerClients

func (q *Queries) ListTrackedServerClients(ctx context.Context) ([]ListTrackedServerClientsRow, error)

func (*Queries) ListTrackedServers

func (q *Queries) ListTrackedServers(ctx context.Context) ([]ListTrackedServersRow, error)

func (*Queries) RemoveFlagMapping

func (q *Queries) RemoveFlagMapping(ctx context.Context, arg RemoveFlagMappingParams) error

func (*Queries) RemoveGuild

func (q *Queries) RemoveGuild(ctx context.Context, guildID int64) error

func (*Queries) RemoveGuildChannel

func (q *Queries) RemoveGuildChannel(ctx context.Context, arg RemoveGuildChannelParams) error

func (*Queries) RemoveMessageMentions

func (q *Queries) RemoveMessageMentions(ctx context.Context, arg RemoveMessageMentionsParams) error

func (*Queries) RemovePlayerCountNotification

func (q *Queries) RemovePlayerCountNotification(ctx context.Context, arg RemovePlayerCountNotificationParams) error

func (*Queries) RemovePlayerCountNotifications

func (q *Queries) RemovePlayerCountNotifications(ctx context.Context) error

func (*Queries) RemovePrevActiveServer

func (q *Queries) RemovePrevActiveServer(ctx context.Context, messageID int64) error

func (*Queries) RemovePrevActiveServerClient

func (q *Queries) RemovePrevActiveServerClient(ctx context.Context, messageID int64) error

func (*Queries) RemoveTrackingByMessageId

func (q *Queries) RemoveTrackingByMessageId(ctx context.Context, arg RemoveTrackingByMessageIdParams) error

func (*Queries) SetPlayerCountNotification

func (q *Queries) SetPlayerCountNotification(ctx context.Context, arg SetPlayerCountNotificationParams) error

func (*Queries) StartChannel

func (q *Queries) StartChannel(ctx context.Context, arg StartChannelParams) error

func (*Queries) StopChannel

func (q *Queries) StopChannel(ctx context.Context, arg StopChannelParams) error

func (*Queries) WithTx

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type RemoveFlagMappingParams

type RemoveFlagMappingParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	FlagID    int16 `db:"flag_id"`
}

type RemoveGuildChannelParams

type RemoveGuildChannelParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
}

type RemoveMessageMentionsParams

type RemoveMessageMentionsParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
}

type RemovePlayerCountNotificationParams

type RemovePlayerCountNotificationParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
	UserID    int64 `db:"user_id"`
	Threshold int16 `db:"threshold"`
}

type RemoveTrackingByMessageIdParams

type RemoveTrackingByMessageIdParams struct {
	GuildID   int64 `db:"guild_id"`
	MessageID int64 `db:"message_id"`
}

type SetPlayerCountNotificationParams

type SetPlayerCountNotificationParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
	MessageID int64 `db:"message_id"`
	UserID    int64 `db:"user_id"`
	Threshold int16 `db:"threshold"`
}

type StartChannelParams

type StartChannelParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
}

type StopChannelParams

type StopChannelParams struct {
	GuildID   int64 `db:"guild_id"`
	ChannelID int64 `db:"channel_id"`
}

type Tracking

type Tracking struct {
	ID        *int64 `db:"id"`
	MessageID int64  `db:"message_id"`
	GuildID   int64  `db:"guild_id"`
	ChannelID int64  `db:"channel_id"`
	Address   string `db:"address"`
}

Jump to

Keyboard shortcuts

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