models

type Account struct {
	// Internal account identifier. This should not be exposed externally.
	AccountID int32 `db:"account_id"`
	// External account identifier. This can be exposed externally and used in URLs.
	Username string `db:"username"`
	// A bcrypt hash of the user's password.
	PasswordHash string `db:"password_hash"`
	FullName     string `db:"full_name"`
	Email        string `db:"email"`
}

type Contest struct {
	ContestID int32 `db:"contest_id"`
	// Full name of the contest.
	Title string `db:"title"`
	// Short name of the contest, for use in e.g. URLs.
	ShortName string `db:"short_name"`
	// A host name for the contest. Web requests to this hostname will resolve to this contest.
	HostName        sql.NullString `db:"host_name"`
	StartTime       sql.NullTime   `db:"start_time"`
	FlexibleEndTime sql.NullTime   `db:"selection_window_end_time"`
	Duration        time.Duration  `db:"duration"`
	// Whether the scoreboard should be hidden for contestants during the contest.
	HiddenScoreboard bool `db:"hidden_scoreboard"`
	Problems         []*ContestProblem
}

type ContestProblem struct {
	ContestID int32 `db:"contest_id"`
	ProblemID int32 `db:"problem_id"`
	Problem   *Problem
	Label     string
}

type Evaluation struct {
	Score       int32   `db:"score"`
	TimeUsageMS int32   `db:"time_usage_ms"`
	Verdict     Verdict `db:"verdict"`
}

type HTMLString string

type IncludedFiles struct {
	LanguageId     string         `db:"language_id"`
	InclusionFiles types.JSONText `db:"inclusion_files"`
}

type License string

type NilableStoredFile struct {
	Hash sql.NullString `db:"hash"`
	URL  []byte         `db:"url"`
}

type OutputValidator struct {
	ValidatorLanguageID sql.NullString     `db:"language_id"`
	ValidatorSourceZIP  *NilableStoredFile `db:"validator_source_zip"`
}

type Problem struct {
	// The numeric problem ID. This should not be exposed externally.
	ProblemID int32 `db:"problem_id"`
	// The short name of the problem. This is suitable to use in e.g. URLs or as externally-visible identifiers.
	ShortName      string `db:"short_name"`
	Statements     []*ProblemStatement
	Author         string          `db:"author"`
	License        License         `db:"license"`
	CurrentVersion *ProblemVersion `db:"problem_version"`
	Source         string          `db:"source"`
	StatementFiles []*ProblemStatementFile
	PublicFrom     *time.Time `db:"public_from"`
}

type ProblemList []*Problem

type ProblemMap map[int32]*Problem

type ProblemStatement struct {
	ProblemID int32 `db:"problem_id"`
	// The tag of the language that the statement is written in.
	Language string `db:"language"`
	// The title of the statement.
	Title string `db:"title"`
	// The HTML template of the statement.
	HTML string `db:"html"`
}

type ProblemStatementFile struct {
	ProblemID int32 `db:"problem_id"`
	// The tag of the language that the statement is written in.
	Path       string      `db:"file_path"`
	Attachment bool        `db:"attachment"`
	Content    *StoredFile `db:"content"`
}

type ProblemVersion struct {
	ProblemVersionID int32            `db:"problem_version_id"`
	ProblemID        int32            `db:"problem_id"`
	TimeLimMS        int32            `db:"time_limit_ms"`
	MemLimKB         int32            `db:"memory_limit_kb"`
	OutputValidator  *OutputValidator `db:"validator"`
	TestGroups       TestGroupList
	IncludedFiles    []*IncludedFiles
}

type StatementList []*ProblemStatement

type Status string

type StoredFile struct {
	// Hash is a hash of the binary data of the stored file.
	Hash string
	// URL is a descriptor of how to retrieve the file, understood by the filestore service.
	URL []byte
}

type Submission struct {
	// SubmissionID The numeric ID of the submission. This may exposed externally.
	SubmissionID int32 `db:"submission_id"`
	// The ID of the author of the submission.
	AccountID int32    `db:"account_id"`
	Account   *Account `db:"account"`
	// The ID of the problem the submission was for.
	ProblemID int32 `db:"problem_id"`
	// The tag of the langauge the submission was made in.
	Language string
	// The creation date of the submission.
	Created time.Time `db:"date_created"`
	// The files the submission consists of.
	Files      []*SubmissionFile
	CurrentRun *SubmissionRun `db:"submission_run"`
}

type SubmissionFile struct {
	SubmissionID int32 `db:"submission_id"`
	// The path that the file should be placed at, relative to the compilation working directory.
	Path     string `db:"file_path"`
	Contents string `db:"file_contents"`
}

type SubmissionRun struct {
	SubmissionID     int32 `db:"submission_id"`
	SubmissionRunID  int32 `db:"submission_run_id"`
	ProblemVersionID int32 `db:"problem_version_id"`
	Evaluation
	// The current judge workflow status of this run.
	Status       Status
	CompileError sql.NullString `db:"compile_error"`
	Created      time.Time      `db:"date_created"`

	GroupRuns TestGroupRunList `db:"group_runs"`
}

type Team struct {
	TeamID    int32          `db:"team_id"`
	ContestID int32          `db:"contest_id"`
	TeamName  sql.NullString `db:"team_name"`
	StartTime sql.NullTime   `db:"start_time"`
	Members   TeamMemberList
}

type TeamList []*Team

type TeamMember struct {
	TeamID    int32   `db:"team_id"`
	AccountID int32   `db:"account_id"`
	Account   Account `db:"account"`
}

type TeamMemberList []*TeamMember

type TestCase struct {
	TestGroupID int32 `db:"problem_testgroup_id"`
	TestCaseID  int32 `db:"problem_testcase_id"`
	// A user-visible name for the test case.
	Name       string      `db:"testcase_name"`
	InputFile  *StoredFile `db:"input_file"`
	OutputFile *StoredFile `db:"output_file"`
}

type TestCaseRun struct {
	SubmissionRunID int32 `db:"submission_run_id"`
	TestCaseID      int32 `db:"problem_testcase_id"`
	Evaluation
	Created time.Time `db:"date_created"`
}

type TestGroup struct {
	TestGroupID      int32 `db:"problem_testgroup_id"`
	ProblemVersionID int32 `db:"problem_version_id"`
	// A user-visible name for the test group.
	Name string `db:"testgroup_name"`
	// Whether the tests in the group should be displayed to users.
	PublicVisibility bool `db:"public_visibility"`
	// The score that should be awarded if the test group is passed.
	Score int32 `db:"score"`
	// The flags that should be provided to output validators when evaluating the group.
	OutputValidatorFlags string `db:"output_validator_flags"`
	Tests                []*TestCase
}

type TestGroupList []*TestGroup

type TestGroupMap map[int32]*TestGroup

type TestGroupRun struct {
	SubmissionRunID int32  `db:"submission_run_id"`
	TestGroupID     int32  `db:"problem_testgroup_id" json:"problem_testgroup_id"`
	TestGroupName   string `json:"testgroup_name"`
	Evaluation
	Created time.Time `db:"date_created"`
}

type TestGroupRunList []*TestGroupRun

type Verdict string