db

Documentation

Index

• func DSNFromOptions(opts Options) string
• func GetAllTeams(db *gorm.DB, year int) int
• func GetName(db *gorm.DB, teamID int) string
• func Migrate(db *gorm.DB)
• func NewDB(opts Options) *gorm.DB
• type Game
  • func GetGames(db *gorm.DB, year int) []Game
• type Options
• type Team
  • func GetTeamsInASeason(db *gorm.DB, year int) []Team
• type Week
  • func GetWeeks(db *gorm.DB, year int) []Week
• type Year
  • func GetYear(db *gorm.DB, year int) Year

Functions

func DSNFromOptions

func DSNFromOptions(opts Options) string

func GetAllTeams

func GetAllTeams(db *gorm.DB, year int) int

func GetName

func GetName(db *gorm.DB, teamID int) string

func Migrate

func Migrate(db *gorm.DB)

func NewDB

func NewDB(opts Options) *gorm.DB

Types

type Game

type Game struct {
	gorm.Model

	HomeID     int
	Home       Team
	HomePoints int
	AwayID     int
	Away       Team
	AwayPoints int

	Completed bool
	Tie       bool

	Date time.Time

	WeekID int
	Week   Week
	YearID int
	Year   Year
}

func GetGames

func GetGames(db *gorm.DB, year int) []Game

type Options

type Options struct {
	User     string
	Password string
	Host     string
	Port     int
	Database string
	Args     string
}

type Team

type Team struct {
	gorm.Model

	Name     string
	Nickname string
}

func GetTeamsInASeason

func GetTeamsInASeason(db *gorm.DB, year int) []Team

type Week

type Week struct {
	gorm.Model

	Week int

	YearID int
	Year   Year
}

func GetWeeks

func GetWeeks(db *gorm.DB, year int) []Week

type Year

type Year struct {
	gorm.Model
	Year int `gorm:"index:unqiue,"`
}

func GetYear

func GetYear(db *gorm.DB, year int) Year