pgmodel

package
v0.0.0-...-9b2646f Latest Latest
Warning

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

 Go to latest Published: Dec 15, 2024 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

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 DeleteKVEntryParams 

type DeleteKVEntryParams struct {
	Key     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
	Consumed        bool
	ConsumedGuildID sql.NullString
}

type GetCustomCommandByNameParams 

type GetCustomCommandByNameParams struct {
	Name    string
	GuildID string
}

type GetCustomCommandParams 

type GetCustomCommandParams struct {
	ID      string
	GuildID string
}

type GetEntitlementParams 

type GetEntitlementParams struct {
	ID     string
	UserID sql.NullString
}

type GetKVEntryParams 

type GetKVEntryParams struct {
	Key     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 IncreaseKVEntryParams 

type IncreaseKVEntryParams struct {
	Key       string
	GuildID   string
	Value     string
	ExpiresAt sql.NullTime
	CreatedAt time.Time
	UpdatedAt time.Time
}

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
	ThreadName     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 KvEntry 

type KvEntry struct {
	Key       string
	GuildID   string
	Value     string
	ExpiresAt sql.NullTime
	CreatedAt time.Time
	UpdatedAt time.Time
}

type MessageActionSet 

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

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) CountKVEntries 

func (q *Queries) CountKVEntries(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) DeleteKVEntry 

func (q *Queries) DeleteKVEntry(ctx context.Context, arg DeleteKVEntryParams) (KvEntry, 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) GetEntitlement 

func (q *Queries) GetEntitlement(ctx context.Context, arg GetEntitlementParams) (Entitlement, 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) GetKVEntry 

func (q *Queries) GetKVEntry(ctx context.Context, arg GetKVEntryParams) (KvEntry, 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) IncreaseKVEntry 

func (q *Queries) IncreaseKVEntry(ctx context.Context, arg IncreaseKVEntryParams) (KvEntry, 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) SearchKVEntries 

func (q *Queries) SearchKVEntries(ctx context.Context, arg SearchKVEntriesParams) ([]KvEntry, 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) SetKVEntry 

func (q *Queries) SetKVEntry(ctx context.Context, arg SetKVEntryParams) 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) UpdateEntitlementConsumedGuildID 

func (q *Queries) UpdateEntitlementConsumedGuildID(ctx context.Context, arg UpdateEntitlementConsumedGuildIDParams) (Entitlement, 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
	ThreadName     sql.NullString
}

type SearchKVEntriesParams 

type SearchKVEntriesParams struct {
	Key     string
	GuildID string
}

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 SetKVEntryParams 

type SetKVEntryParams struct {
	Key       string
	GuildID   string
	Value     string
	ExpiresAt sql.NullTime
	CreatedAt time.Time
	UpdatedAt time.Time
}

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 UpdateEntitlementConsumedGuildIDParams 

type UpdateEntitlementConsumedGuildIDParams struct {
	ID              string
	ConsumedGuildID sql.NullString
}

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
	ThreadName     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
	Consumed  bool
}

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
}

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.