postgres

package
v0.0.0-...-349f490 Latest Latest
Warning

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

Go to latest
Published: May 2, 2024 License: MIT Imports: 14 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func BuildConnectionDSN

func BuildConnectionDSN() string

Types

type CustomBot

type CustomBot struct {
	ID                      string
	GuildID                 string
	ApplicationID           string
	Token                   string
	PublicKey               string
	UserID                  string
	UserName                string
	UserDiscriminator       string
	UserAvatar              sql.NullString
	HandledFirstInteraction bool
	CreatedAt               time.Time
	TokenInvalid            bool
	GatewayStatus           string
	GatewayActivityType     sql.NullInt16
	GatewayActivityName     sql.NullString
	GatewayActivityState    sql.NullString
	GatewayActivityUrl      sql.NullString
}

type CustomCommand

type CustomCommand struct {
	ID                 string
	GuildID            string
	Name               string
	Description        string
	Enabled            bool
	Parameters         json.RawMessage
	Actions            json.RawMessage
	CreatedAt          time.Time
	UpdatedAt          time.Time
	DeployedAt         sql.NullTime
	DerivedPermissions pqtype.NullRawMessage
	LastUsedAt         time.Time
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteCustomCommandParams

type DeleteCustomCommandParams struct {
	ID      string
	GuildID string
}

type DeleteSavedMessageForCreatorParams

type DeleteSavedMessageForCreatorParams struct {
	ID        string
	CreatorID string
}

type DeleteSavedMessageForGuildParams

type DeleteSavedMessageForGuildParams struct {
	ID      string
	GuildID sql.NullString
}

type DeleteScheduledMessageParams

type DeleteScheduledMessageParams struct {
	ID      string
	GuildID string
}
type EmbedLink struct {
	ID             string
	Url            string
	ThemeColor     sql.NullString
	OgTitle        sql.NullString
	OgSiteName     sql.NullString
	OgDescription  sql.NullString
	OgImage        sql.NullString
	OeType         sql.NullString
	OeAuthorName   sql.NullString
	OeAuthorUrl    sql.NullString
	OeProviderName sql.NullString
	OeProviderUrl  sql.NullString
	TwCard         sql.NullString
	ExpiresAt      sql.NullTime
	CreatedAt      time.Time
}

type Entitlement

type Entitlement struct {
	ID        string
	UserID    sql.NullString
	GuildID   sql.NullString
	UpdatedAt time.Time
	Deleted   bool
	SkuID     string
	StartsAt  sql.NullTime
	EndsAt    sql.NullTime
}

type GetCustomCommandByNameParams

type GetCustomCommandByNameParams struct {
	Name    string
	GuildID string
}

type GetCustomCommandParams

type GetCustomCommandParams struct {
	ID      string
	GuildID string
}

type GetMessageActionSetParams

type GetMessageActionSetParams struct {
	MessageID string
	SetID     string
}

type GetSavedMessageForGuildParams

type GetSavedMessageForGuildParams struct {
	GuildID sql.NullString
	ID      string
}

type GetScheduledMessageParams

type GetScheduledMessageParams struct {
	ID      string
	GuildID string
}

type Image

type Image struct {
	ID              string
	UserID          string
	GuildID         sql.NullString
	FileHash        string
	FileName        string
	FileSize        int32
	FileContentType string
	S3Key           string
}

type InsertCustomCommandParams

type InsertCustomCommandParams struct {
	ID                 string
	GuildID            string
	Name               string
	Description        string
	Parameters         json.RawMessage
	Actions            json.RawMessage
	DerivedPermissions pqtype.NullRawMessage
	CreatedAt          time.Time
	UpdatedAt          time.Time
}

type InsertEmbedLinkParams

type InsertEmbedLinkParams struct {
	ID             string
	Url            string
	ThemeColor     sql.NullString
	OgTitle        sql.NullString
	OgSiteName     sql.NullString
	OgDescription  sql.NullString
	OgImage        sql.NullString
	OeType         sql.NullString
	OeAuthorName   sql.NullString
	OeAuthorUrl    sql.NullString
	OeProviderName sql.NullString
	OeProviderUrl  sql.NullString
	TwCard         sql.NullString
	ExpiresAt      sql.NullTime
	CreatedAt      time.Time
}

type InsertImageParams

type InsertImageParams struct {
	ID              string
	GuildID         sql.NullString
	UserID          string
	FileHash        string
	FileName        string
	FileContentType string
	FileSize        int32
	S3Key           string
}

type InsertMessageActionSetParams

type InsertMessageActionSetParams struct {
	ID                 string
	MessageID          string
	SetID              string
	Actions            json.RawMessage
	DerivedPermissions pqtype.NullRawMessage
	Ephemeral          bool
}

type InsertSavedMessageParams

type InsertSavedMessageParams struct {
	ID          string
	CreatorID   string
	GuildID     sql.NullString
	UpdatedAt   time.Time
	Name        string
	Description sql.NullString
	Data        json.RawMessage
}

type InsertScheduledMessageParams

type InsertScheduledMessageParams struct {
	ID             string
	CreatorID      string
	GuildID        string
	ChannelID      string
	MessageID      sql.NullString
	SavedMessageID string
	Name           string
	Description    sql.NullString
	CronExpression sql.NullString
	CronTimezone   sql.NullString
	StartAt        time.Time
	EndAt          sql.NullTime
	NextAt         time.Time
	OnlyOnce       bool
	Enabled        bool
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type InsertSessionParams

type InsertSessionParams struct {
	TokenHash   string
	UserID      string
	GuildIds    []string
	AccessToken string
	CreatedAt   time.Time
	ExpiresAt   time.Time
}

type InsertSharedMessageParams

type InsertSharedMessageParams struct {
	ID        string
	CreatedAt time.Time
	ExpiresAt time.Time
	Data      json.RawMessage
}

type MessageActionSet

type MessageActionSet struct {
	ID                 string
	MessageID          string
	SetID              string
	Actions            json.RawMessage
	DerivedPermissions pqtype.NullRawMessage
	LastUsedAt         time.Time
	Ephemeral          bool
}

type PostgresStore

type PostgresStore struct {
	Q *Queries
	// contains filtered or unexported fields
}

func NewPostgresStore

func NewPostgresStore() *PostgresStore

func (*PostgresStore) GetMigrater

func (pgs *PostgresStore) GetMigrater() (*PostgresStoreMigrater, error)

type PostgresStoreMigrater

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

func (*PostgresStoreMigrater) Close

func (mig *PostgresStoreMigrater) Close() error

func (*PostgresStoreMigrater) Down

func (mig *PostgresStoreMigrater) Down() error

func (*PostgresStoreMigrater) Force

func (mig *PostgresStoreMigrater) Force(version int) error

func (*PostgresStoreMigrater) List

func (mig *PostgresStoreMigrater) List() ([]string, error)

func (*PostgresStoreMigrater) SetLogger

func (mig *PostgresStoreMigrater) SetLogger(logger migrate.Logger)

func (*PostgresStoreMigrater) To

func (mig *PostgresStoreMigrater) To(version uint) error

func (*PostgresStoreMigrater) Up

func (mig *PostgresStoreMigrater) Up() error

func (*PostgresStoreMigrater) Version

func (mig *PostgresStoreMigrater) Version() (uint, bool, error)

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CountCustomCommands

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

func (*Queries) DeleteCustomBot

func (q *Queries) DeleteCustomBot(ctx context.Context, guildID string) (CustomBot, error)

func (*Queries) DeleteCustomCommand

func (q *Queries) DeleteCustomCommand(ctx context.Context, arg DeleteCustomCommandParams) (CustomCommand, error)

func (*Queries) DeleteExpiredSharedMessages

func (q *Queries) DeleteExpiredSharedMessages(ctx context.Context, expiresAt time.Time) error

func (*Queries) DeleteMessageActionSetsForMessage

func (q *Queries) DeleteMessageActionSetsForMessage(ctx context.Context, messageID string) error

func (*Queries) DeleteSavedMessageForCreator

func (q *Queries) DeleteSavedMessageForCreator(ctx context.Context, arg DeleteSavedMessageForCreatorParams) error

func (*Queries) DeleteSavedMessageForGuild

func (q *Queries) DeleteSavedMessageForGuild(ctx context.Context, arg DeleteSavedMessageForGuildParams) error

func (*Queries) DeleteScheduledMessage

func (q *Queries) DeleteScheduledMessage(ctx context.Context, arg DeleteScheduledMessageParams) error

func (*Queries) DeleteSession

func (q *Queries) DeleteSession(ctx context.Context, tokenHash string) error

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, id string) error

func (*Queries) GetActiveEntitlementsForGuild

func (q *Queries) GetActiveEntitlementsForGuild(ctx context.Context, guildID sql.NullString) ([]Entitlement, error)

func (*Queries) GetActiveEntitlementsForUser

func (q *Queries) GetActiveEntitlementsForUser(ctx context.Context, userID sql.NullString) ([]Entitlement, error)

func (*Queries) GetCustomBot

func (q *Queries) GetCustomBot(ctx context.Context, id string) (CustomBot, error)

func (*Queries) GetCustomBotByGuildID

func (q *Queries) GetCustomBotByGuildID(ctx context.Context, guildID string) (CustomBot, error)

func (*Queries) GetCustomBots

func (q *Queries) GetCustomBots(ctx context.Context) ([]CustomBot, error)

func (*Queries) GetCustomCommand

func (q *Queries) GetCustomCommand(ctx context.Context, arg GetCustomCommandParams) (CustomCommand, error)

func (*Queries) GetCustomCommandByName

func (q *Queries) GetCustomCommandByName(ctx context.Context, arg GetCustomCommandByNameParams) (CustomCommand, error)

func (*Queries) GetCustomCommands

func (q *Queries) GetCustomCommands(ctx context.Context, guildID string) ([]CustomCommand, error)

func (*Queries) GetDueScheduledMessages

func (q *Queries) GetDueScheduledMessages(ctx context.Context, nextAt time.Time) ([]ScheduledMessage, error)
func (q *Queries) GetEmbedLink(ctx context.Context, id string) (EmbedLink, error)

func (*Queries) GetEntitlements

func (q *Queries) GetEntitlements(ctx context.Context) ([]Entitlement, error)

func (*Queries) GetImage

func (q *Queries) GetImage(ctx context.Context, id string) (Image, error)

func (*Queries) GetMessageActionSet

func (q *Queries) GetMessageActionSet(ctx context.Context, arg GetMessageActionSetParams) (MessageActionSet, error)

func (*Queries) GetMessageActionSets

func (q *Queries) GetMessageActionSets(ctx context.Context, messageID string) ([]MessageActionSet, error)

func (*Queries) GetSavedMessageForGuild

func (q *Queries) GetSavedMessageForGuild(ctx context.Context, arg GetSavedMessageForGuildParams) (SavedMessage, error)

func (*Queries) GetSavedMessagesForCreator

func (q *Queries) GetSavedMessagesForCreator(ctx context.Context, creatorID string) ([]SavedMessage, error)

func (*Queries) GetSavedMessagesForGuild

func (q *Queries) GetSavedMessagesForGuild(ctx context.Context, guildID sql.NullString) ([]SavedMessage, error)

func (*Queries) GetScheduledMessage

func (q *Queries) GetScheduledMessage(ctx context.Context, arg GetScheduledMessageParams) (ScheduledMessage, error)

func (*Queries) GetScheduledMessages

func (q *Queries) GetScheduledMessages(ctx context.Context, guildID string) ([]ScheduledMessage, error)

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, tokenHash string) (Session, error)

func (*Queries) GetSessionsForUser

func (q *Queries) GetSessionsForUser(ctx context.Context, userID string) ([]Session, error)

func (*Queries) GetSharedMessage

func (q *Queries) GetSharedMessage(ctx context.Context, id string) (SharedMessage, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id string) (User, error)

func (*Queries) InsertCustomCommand

func (q *Queries) InsertCustomCommand(ctx context.Context, arg InsertCustomCommandParams) (CustomCommand, error)
func (q *Queries) InsertEmbedLink(ctx context.Context, arg InsertEmbedLinkParams) (EmbedLink, error)

func (*Queries) InsertImage

func (q *Queries) InsertImage(ctx context.Context, arg InsertImageParams) (Image, error)

func (*Queries) InsertMessageActionSet

func (q *Queries) InsertMessageActionSet(ctx context.Context, arg InsertMessageActionSetParams) (MessageActionSet, error)

func (*Queries) InsertSavedMessage

func (q *Queries) InsertSavedMessage(ctx context.Context, arg InsertSavedMessageParams) (SavedMessage, error)

func (*Queries) InsertScheduledMessage

func (q *Queries) InsertScheduledMessage(ctx context.Context, arg InsertScheduledMessageParams) (ScheduledMessage, error)

func (*Queries) InsertSession

func (q *Queries) InsertSession(ctx context.Context, arg InsertSessionParams) (Session, error)

func (*Queries) InsertSharedMessage

func (q *Queries) InsertSharedMessage(ctx context.Context, arg InsertSharedMessageParams) (SharedMessage, error)

func (*Queries) SetCustomBotHandledFirstInteraction

func (q *Queries) SetCustomBotHandledFirstInteraction(ctx context.Context, id string) error

func (*Queries) SetCustomCommandsDeployedAt

func (q *Queries) SetCustomCommandsDeployedAt(ctx context.Context, arg SetCustomCommandsDeployedAtParams) (CustomCommand, error)

func (*Queries) UpdateCustomBotPresence

func (q *Queries) UpdateCustomBotPresence(ctx context.Context, arg UpdateCustomBotPresenceParams) (CustomBot, error)

func (*Queries) UpdateCustomBotTokenInvalid

func (q *Queries) UpdateCustomBotTokenInvalid(ctx context.Context, arg UpdateCustomBotTokenInvalidParams) (CustomBot, error)

func (*Queries) UpdateCustomBotUser

func (q *Queries) UpdateCustomBotUser(ctx context.Context, arg UpdateCustomBotUserParams) (CustomBot, error)

func (*Queries) UpdateCustomCommand

func (q *Queries) UpdateCustomCommand(ctx context.Context, arg UpdateCustomCommandParams) (CustomCommand, error)

func (*Queries) UpdateSavedMessageForCreator

func (q *Queries) UpdateSavedMessageForCreator(ctx context.Context, arg UpdateSavedMessageForCreatorParams) (SavedMessage, error)

func (*Queries) UpdateSavedMessageForGuild

func (q *Queries) UpdateSavedMessageForGuild(ctx context.Context, arg UpdateSavedMessageForGuildParams) (SavedMessage, error)

func (*Queries) UpdateScheduledMessage

func (q *Queries) UpdateScheduledMessage(ctx context.Context, arg UpdateScheduledMessageParams) (ScheduledMessage, error)

func (*Queries) UpdateScheduledMessageEnabled

func (q *Queries) UpdateScheduledMessageEnabled(ctx context.Context, arg UpdateScheduledMessageEnabledParams) (ScheduledMessage, error)

func (*Queries) UpdateScheduledMessageNextAt

func (q *Queries) UpdateScheduledMessageNextAt(ctx context.Context, arg UpdateScheduledMessageNextAtParams) (ScheduledMessage, error)

func (*Queries) UpsertCustomBot

func (q *Queries) UpsertCustomBot(ctx context.Context, arg UpsertCustomBotParams) (CustomBot, error)

func (*Queries) UpsertEntitlement

func (q *Queries) UpsertEntitlement(ctx context.Context, arg UpsertEntitlementParams) (Entitlement, error)

func (*Queries) UpsertUser

func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)

func (*Queries) WithTx

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

type SavedMessage

type SavedMessage struct {
	ID          string
	CreatorID   string
	GuildID     sql.NullString
	UpdatedAt   time.Time
	Name        string
	Description sql.NullString
	Data        json.RawMessage
}

type ScheduledMessage

type ScheduledMessage struct {
	ID             string
	CreatorID      string
	GuildID        string
	ChannelID      string
	MessageID      sql.NullString
	SavedMessageID string
	Name           string
	Description    sql.NullString
	CronExpression sql.NullString
	OnlyOnce       bool
	StartAt        time.Time
	EndAt          sql.NullTime
	NextAt         time.Time
	Enabled        bool
	CreatedAt      time.Time
	UpdatedAt      time.Time
	CronTimezone   sql.NullString
}

type Session

type Session struct {
	TokenHash   string
	UserID      string
	GuildIds    []string
	AccessToken string
	CreatedAt   time.Time
	ExpiresAt   time.Time
}

type SetCustomCommandsDeployedAtParams

type SetCustomCommandsDeployedAtParams struct {
	GuildID    string
	DeployedAt sql.NullTime
}

type SharedMessage

type SharedMessage struct {
	ID        string
	CreatedAt time.Time
	ExpiresAt time.Time
	Data      json.RawMessage
}

type UpdateCustomBotPresenceParams

type UpdateCustomBotPresenceParams struct {
	GuildID              string
	GatewayStatus        string
	GatewayActivityType  sql.NullInt16
	GatewayActivityName  sql.NullString
	GatewayActivityState sql.NullString
	GatewayActivityUrl   sql.NullString
}

type UpdateCustomBotTokenInvalidParams

type UpdateCustomBotTokenInvalidParams struct {
	GuildID      string
	TokenInvalid bool
}

type UpdateCustomBotUserParams

type UpdateCustomBotUserParams struct {
	GuildID           string
	UserName          string
	UserDiscriminator string
	UserAvatar        sql.NullString
}

type UpdateCustomCommandParams

type UpdateCustomCommandParams struct {
	ID                 string
	GuildID            string
	Name               string
	Description        string
	Enabled            bool
	Actions            json.RawMessage
	Parameters         json.RawMessage
	DerivedPermissions pqtype.NullRawMessage
	UpdatedAt          time.Time
}

type UpdateSavedMessageForCreatorParams

type UpdateSavedMessageForCreatorParams struct {
	ID          string
	CreatorID   string
	UpdatedAt   time.Time
	Name        string
	Description sql.NullString
	Data        json.RawMessage
}

type UpdateSavedMessageForGuildParams

type UpdateSavedMessageForGuildParams struct {
	ID          string
	GuildID     sql.NullString
	UpdatedAt   time.Time
	Name        string
	Description sql.NullString
	Data        json.RawMessage
}

type UpdateScheduledMessageEnabledParams

type UpdateScheduledMessageEnabledParams struct {
	ID        string
	GuildID   string
	Enabled   bool
	UpdatedAt time.Time
}

type UpdateScheduledMessageNextAtParams

type UpdateScheduledMessageNextAtParams struct {
	ID        string
	GuildID   string
	NextAt    time.Time
	UpdatedAt time.Time
}

type UpdateScheduledMessageParams

type UpdateScheduledMessageParams struct {
	ID             string
	GuildID        string
	ChannelID      string
	MessageID      sql.NullString
	SavedMessageID string
	Name           string
	Description    sql.NullString
	CronExpression sql.NullString
	NextAt         time.Time
	StartAt        time.Time
	EndAt          sql.NullTime
	OnlyOnce       bool
	Enabled        bool
	UpdatedAt      time.Time
	CronTimezone   sql.NullString
}

type UpsertCustomBotParams

type UpsertCustomBotParams struct {
	ID                string
	GuildID           string
	ApplicationID     string
	UserID            string
	UserName          string
	UserDiscriminator string
	UserAvatar        sql.NullString
	Token             string
	PublicKey         string
	CreatedAt         time.Time
}

type UpsertEntitlementParams

type UpsertEntitlementParams struct {
	ID        string
	UserID    sql.NullString
	GuildID   sql.NullString
	UpdatedAt time.Time
	Deleted   bool
	SkuID     string
	StartsAt  sql.NullTime
	EndsAt    sql.NullTime
}

type UpsertUserParams

type UpsertUserParams struct {
	ID            string
	Name          string
	Discriminator string
	Avatar        sql.NullString
}

type User

type User struct {
	ID            string
	Name          string
	Discriminator string
	Avatar        sql.NullString
	IsTester      bool
}

Directories

Path Synopsis

Jump to

Keyboard shortcuts

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