models

Jun 28, 2023

Changes in this version

type JeppDB

+ func NewTestJeppDB() *JeppDB

Jun 28, 2023

Changes in this version

type JeppDB

+ func NewJeppDB(dbfile string) *JeppDB

+ func (db *JeppDB) CountClues() (int64, error)

+ func (db *JeppDB) GetCategories(limit int64) ([]Category, error)

+ func (db *JeppDB) GetCategoriesForGame(gameID int64) ([]Category, error)

+ func (db *JeppDB) GetCategory(categoryID int64) (*Category, error)

+ func (db *JeppDB) GetCategoryByName(categoryName string) (*Category, error)

+ func (db *JeppDB) GetCategoryClueCount(categoryID int64) (int64, error)

+ func (db *JeppDB) GetCategoryGameCount(categoryID int64) (int64, error)

+ func (db *JeppDB) GetClue(clueID int64) (*Clue, error)

+ func (db *JeppDB) GetClues(params CluesParams) ([]Clue, error)

+ func (db *JeppDB) GetGame(gameID int64) (*Game, error)

+ func (db *JeppDB) GetGames(limit int64) ([]Game, error)

+ func (db *JeppDB) GetGamesBySeason(seasonID int64) ([]Game, error)

+ func (db *JeppDB) GetRandomCategory() (*Category, error)

+ func (db *JeppDB) GetRandomCategoryMany(limit int64) ([]Category, error)

+ func (db *JeppDB) GetRandomClue() (*Clue, error)

+ func (db *JeppDB) GetRandomClueMany(limit int64) ([]Clue, error)

+ func (db *JeppDB) GetRandomGame() (*Game, error)

+ func (db *JeppDB) GetRandomGameMany(limit int64) ([]Game, error)

+ func (db *JeppDB) GetSeasons() ([]Season, error)

+ func (db *JeppDB) InsertCategory(name string) (*Category, error)

+ func (db *JeppDB) InsertClue(c *Clue) error

+ func (db *JeppDB) InsertGame(g *Game) error

+ func (db *JeppDB) InsertSeason(s *Season) error

+ func (db *JeppDB) UpdateCategory(c *Category) error

+ func (db *JeppDB) UpdateClue(c *Clue) error

Jun 25, 2023

Changes in this version

type Category

+ func (c *Category) Dump() []string

type Clue

+ func (c *Clue) Dump() []string

type Game

+ func (g *Game) Dump() []string

type Season

+ func (s *Season) Dump() []string

Jun 25, 2023

Changes in this version

type Category

+ func GetRandomCategoryMany(count int64) ([]Category, error)

type Clue

+ func GetRandomClueMany(count int64) ([]Clue, error)

type CluesParams

+ Limit int64

+ Page int64

type Game

+ func GetRandomGameMany(count int64) ([]Game, error)

Jun 23, 2023

Changes in this version

+ func CountClues() (int64, error)

Jun 23, 2023

Changes in this version

+ const CATEGORY_SCHEMA

+ const CLUE_SCHEMA

+ const GAME_SCHEMA

+ const SEASON_SCHEMA

+ const TIME_FORMAT

+ var RoundMap = map[string]Round

+ func GetCategoryClueCount(categoryID int64) (int64, error)

+ func GetCategoryGameCount(categoryID int64) (int64, error)

+ func GetCategoryID(s string) string

+ func GetDBHandle() *sqlx.DB

+ func GetSeasonURL(seasonID int64) string

+ func InsertClue(c *Clue) error

+ func InsertGame(g *Game) error

+ func InsertSeason(s *Season) error

+ func NumClues() (int64, error)

+ func ParseClueID(clueString string, gameId int64) int64

+ func UpdateCategory(c *Category) error

+ func UpdateClue(c *Clue) error

+ type Category struct

+ CategoryID int64

+ Name string

+ func GetCategories() ([]Category, error)

+ func GetCategoriesForGame(gameID int64) ([]Category, error)

+ func GetCategory(categoryID int64) (*Category, error)

+ func GetCategoryByName(categoryName string) (*Category, error)

+ func GetRandomCategory() (*Category, error)

+ func InsertCategory(name string) (*Category, error)

+ type Clue struct

+ Answer string

+ CategoryID int64

+ ClueID int64

+ GameID int64

+ Question string

+ func GetClue(clueID int64) (*Clue, error)

+ func GetClues(params CluesParams) ([]Clue, error)

+ func GetRandomClue() (*Clue, error)

+ func (c *Clue) String() string

+ type CluesParams struct

+ CategoryID int64

+ GameID int64

+ type Game struct

+ GameDate time.Time

+ GameID int64

+ SeasonID int64

+ ShowNum int64

+ TapedDate time.Time

+ func GetGame(gameID int64) (*Game, error)

+ func GetGames() ([]Game, error)

+ func GetGamesBySeason(seasonID int64) ([]Game, error)

+ func GetRandomGame() (*Game, error)

+ func (g Game) String() string

+ type JeppDB struct

+ Conn *sqlx.DB

+ type NavLinks struct

+ NextClue string

+ PrevClue string

+ type Option struct

+ OptionKey string

+ OptionVal string

+ Selected bool

+ type Options struct

+ CategoryOptions []Option

+ ClueID int64

+ Links NavLinks

+ type PaginationParams struct

+ Page int

+ PageSize int

+ type Round int

+ const DoubleJeopardy

+ const FinalJeopardy

+ const Jeopardy

+ type Season struct

+ EndDate time.Time

+ SeasonID int64

+ StartDate time.Time

+ func GetSeasons(params *PaginationParams) ([]*Season, error)

+ func (s Season) String() string