Versions in this module Expand all Collapse all v1 v1.1.3 Dec 24, 2018 v1.1.2 Dec 2, 2018 v1.1.1 Nov 29, 2016 Changes in this version + func AddCategory(db *sql.DB, category *Category) (err error) + func AddFlag(db *sql.DB, flag *Flag) (err error) + func AddScore(db *sql.DB, score *Score) (err error) + func AddSession(db *sql.DB, s *Session) (err error) + func AddTask(db *sql.DB, t *Task) (err error) + func AddTeam(db *sql.DB, t *Team) (err error) + func CleanDatabase(db *sql.DB) (err error) + func GetSessionCount(db *sql.DB) (count int, err error) + func GetSessionTeam(db *sql.DB, session string) (teamID int, err error) + func GetSolvedBy(db *sql.DB, taskID int) (teamIDs []int, err error) + func GetSolvedCount(db *sql.DB, taskID int) (count int, err error) + func GetTeamIDByToken(db *sql.DB, token string) (teamID int, err error) + func InitDatabase(path string) (db *sql.DB, err error) + func IsSolved(db *sql.DB, teamID, taskID int) (solved bool, err error) + func OpenDatabase(path string) (db *sql.DB, err error) + func SetOpened(db *sql.DB, taskID int, opened bool) (err error) + func UpdateTask(db *sql.DB, t *Task) (err error) + type Category struct + ID int + Name string + func GetCategories(db *sql.DB) (categories []Category, err error) + type Flag struct + Flag string + ID int + Solved bool + TaskID int + TeamID int + Timestamp time.Time + func GetFlags(db *sql.DB) (flags []Flag, err error) + type Score struct + ID int + Score int + TeamID int + Timestamp time.Time + func GetLastScore(db *sql.DB, teamID int) (s Score, err error) + type Session struct + ID int + Session string + TeamID int + Timestamp time.Time + type Task struct + Author string + CategoryID int + Desc string + DescEn string + Flag string + ForceClosed bool + ID int + Level int + MaxSharePrice int + MinSharePrice int + Name string + NameEn string + Opened bool + OpenedTime time.Time + Price int + Shared bool + Tags string + func GetTask(db *sql.DB, taskID int) (t Task, err error) + func GetTasks(db *sql.DB) (tasks []Task, err error) + type Team struct + Desc string + Email string + ID int + Name string + Test bool + Token string + func GetTeams(db *sql.DB) (teams []Team, err error)