database

Documentation

Index

• type Db
  • func NewDb(c config.Config) (Db, error)
  • func (d Db) DeleteSubscribedChannel(channelId, guildId string) (changed bool, err error)
  • func (d Db) SubscribedChannels(guildIds []string) ([]SubscribedChannel, error)
  • func (d Db) UpdateSubscribedChannel(channelId, guildId, notificationType, launchMentions string) (changed bool, err error)
• type SubscribedChannel

Types

type Db

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

Db represents a connection to the database and provides methods for interacting with it.

func NewDb

func NewDb(c config.Config) (Db, error)

NewDb creates a new Db.

func (Db) DeleteSubscribedChannel

func (d Db) DeleteSubscribedChannel(channelId, guildId string) (changed bool, err error)

func (Db) SubscribedChannels

func (d Db) SubscribedChannels(guildIds []string) ([]SubscribedChannel, error)

SubscribedChannels returns a slice of SubscribedChannels that are exist in the given guild ids.

func (Db) UpdateSubscribedChannel

func (d Db) UpdateSubscribedChannel(channelId, guildId, notificationType, launchMentions string) (changed bool, err error)

UpdateSubscribedChannel sets the notification type and launch mentions for a given channel ID. guildId is required to ensure that the channel exists in that guild.

type SubscribedChannel

type SubscribedChannel struct {
	Id               string         `db:"channel_id"`
	GuildId          string         `db:"guild_id"`
	Name             string         `db:"channel_name"`
	NotificationType string         `db:"notification_type"`
	LaunchMentions   sql.NullString `db:"launch_mentions"`
}

SubscribedChannel represents a subscribed channel from the database.