db

Documentation

Index

• type Handler
  • func (d *Handler) AddTeam(guildID, name, channel string) error
  • func (d *Handler) CacheSchedule(s *schedule.Schedule) (err error)
  • func (d *Handler) CachedSchedule(s *schedule.Schedule) (err error)
  • func (d *Handler) ExecJSON(query string, v interface{}) error
  • func (d *Handler) GetName(channelID string) (string, error)
  • func (d *Handler) SpreadsheetID(teamID int) (id string, err error)

Types

type Handler

type Handler struct {
	*sqlx.DB
}

Handler makes grabbing and updating config easier

func (*Handler) AddTeam

func (d *Handler) AddTeam(guildID, name, channel string) error

AddTeam adds a team to the database

func (*Handler) CacheSchedule

func (d *Handler) CacheSchedule(s *schedule.Schedule) (err error)

CacheSchedule adds a new schedule to the cache, or updates an existing cache for the schedule.

func (*Handler) CachedSchedule

func (d *Handler) CachedSchedule(s *schedule.Schedule) (err error)

CachedSchedule returns a cached schedule

func (*Handler) ExecJSON

func (d *Handler) ExecJSON(query string, v interface{}) error

ExecJSON runs a query with a JSON representation of v.

func (*Handler) GetName

func (d *Handler) GetName(channelID string) (string, error)

GetName returns the name of a team in a given channel

func (*Handler) SpreadsheetID

func (d *Handler) SpreadsheetID(teamID int) (id string, err error)

SpreadsheetID returns the spreadsheet ID for the team with the given ID.