db

package
v0.0.0-...-425883a Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Mar 6, 2025 License: Apache-2.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func ComputeSha256FromByteArray 

func ComputeSha256FromByteArray(arr []byte) string

Types

type Action 

type Action struct {
	TeamNumber  string `gorm:"primaryKey"`
	MatchNumber int32  `gorm:"primaryKey"`
	SetNumber   int32  `gorm:"primaryKey"`
	CompLevel   string `gorm:"primaryKey"`
	CompType    string `gorm:"primaryKey"`
	CompCode    string `gorm:"primaryKey"`
	// This contains a serialized scouting.webserver.requests.ActionType flatbuffer.
	CompletedAction []byte
	Timestamp       int64 `gorm:"primaryKey"`
	CollectedBy     string
}

type Database 

type Database struct {
	*gorm.DB
}

func NewDatabase 

func NewDatabase(user string, password string, port int) (*Database, error)

Opens a database at the specified port on localhost. We currently don't support connecting to databases on other hosts.

func (*Database) AddAction 

func (database *Database) AddAction(a Action) error

func (*Database) AddDriverRanking 

func (database *Database) AddDriverRanking(data DriverRankingData) error

func (*Database) AddDriverRanking2025 

func (database *Database) AddDriverRanking2025(data DriverRanking2025) error

func (*Database) AddHumanRanking2025 

func (database *Database) AddHumanRanking2025(data HumanRanking2025) error

func (*Database) AddNotes 

func (database *Database) AddNotes(data NotesData) error

func (*Database) AddNotes2025 

func (database *Database) AddNotes2025(data NotesData2025) error

func (*Database) AddOrUpdateRankings 

func (database *Database) AddOrUpdateRankings(r Ranking) error

func (*Database) AddParsedDriverRanking 

func (database *Database) AddParsedDriverRanking(data ParsedDriverRankingData) error

func (*Database) AddPitImage 

func (database *Database) AddPitImage(p PitImage) error

func (*Database) AddToMatch2025 

func (database *Database) AddToMatch2025(m TeamMatch2025) error

func (*Database) AddToShift 

func (database *Database) AddToShift(sh Shift) error

func (*Database) AddToStats2025 

func (database *Database) AddToStats2025(s Stats2025) error

func (*Database) Delete 

func (database *Database) Delete() error

func (*Database) DeleteFromActions2025 

func (database *Database) DeleteFromActions2025(compCode_ string, compLevel_ string, matchNumber_ int32, setNumber_ int32, teamNumber_ string) error

func (*Database) DeleteFromNotesData2025 

func (database *Database) DeleteFromNotesData2025(compCode_ string, compLevel_ string, matchNumber_ int32, setNumber_ int32, teamNumber_ string) error

func (*Database) DeleteFromStats2025 

func (database *Database) DeleteFromStats2025(compCode_ string, compLevel_ string, matchNumber_ int32, setNumber_ int32, teamNumber_ string) error

func (*Database) QueryActions 

func (database *Database) QueryActions(teamNumber_ string) ([]Action, error)

func (*Database) QueryAllShifts 

func (database *Database) QueryAllShifts(matchNumber_ int) ([]Shift, error)

func (*Database) QueryDriverRanking 

func (database *Database) QueryDriverRanking(MatchNumber int) ([]DriverRankingData, error)

func (*Database) QueryDriverRanking2025 

func (database *Database) QueryDriverRanking2025(CompCode string) ([]DriverRanking2025, error)

func (*Database) QueryHumanRanking2025 

func (database *Database) QueryHumanRanking2025(CompCode string) ([]HumanRanking2025, error)

func (*Database) QueryNotes 

func (database *Database) QueryNotes(TeamNumber string) ([]string, error)

func (*Database) QueryNotes2025 

func (database *Database) QueryNotes2025(CompCode string, TeamNumber string) ([]string, error)

func (*Database) QueryPitImageByChecksum 

func (database *Database) QueryPitImageByChecksum(checksum_ string) (PitImage, error)

func (*Database) QueryPitImages 

func (database *Database) QueryPitImages(teamNumber_ string) ([]RequestedPitImage, error)

func (*Database) QueryRankings 

func (database *Database) QueryRankings(TeamNumber string) ([]Ranking, error)

func (*Database) QueryStats2025 

func (database *Database) QueryStats2025(CompCode string) ([]Stats2025, error)

func (*Database) ReturnActions 

func (database *Database) ReturnActions() ([]Action, error)

func (*Database) ReturnAllDriverRankings 

func (database *Database) ReturnAllDriverRankings() ([]DriverRankingData, error)

func (*Database) ReturnAllNotes 

func (database *Database) ReturnAllNotes() ([]NotesData, error)

func (*Database) ReturnAllNotes2025 

func (database *Database) ReturnAllNotes2025(CompCode string) ([]NotesData2025, error)

func (*Database) ReturnAllParsedDriverRankings 

func (database *Database) ReturnAllParsedDriverRankings() ([]ParsedDriverRankingData, error)

func (*Database) ReturnAllShifts 

func (database *Database) ReturnAllShifts() ([]Shift, error)

func (*Database) ReturnMatches2025 

func (database *Database) ReturnMatches2025(compCode_ string) ([]TeamMatch2025, error)

func (*Database) ReturnPitImages 

func (database *Database) ReturnPitImages() ([]PitImage, error)

func (*Database) ReturnRankings 

func (database *Database) ReturnRankings() ([]Ranking, error)

func (*Database) ReturnStats2025 

func (database *Database) ReturnStats2025() ([]Stats2025, error)

func (*Database) ReturnStats2025ForTeam 

func (database *Database) ReturnStats2025ForTeam(compCode string, teamNumber string, matchNumber int32, setNumber int32, compLevel string, compType string) ([]Stats2025, error)

func (*Database) SetDebugLogLevel 

func (database *Database) SetDebugLogLevel()

type DriverRanking2025 

type DriverRanking2025 struct {
	// Each Driver Ranking data is the ranking for one team
	ID          uint `gorm:"primaryKey"`
	CompCode    string
	MatchNumber int32
	TeamNumber  string
	Score       int32
}

type DriverRankingData 

type DriverRankingData struct {
	ID          uint `gorm:"primaryKey"`
	MatchNumber int32
	Rank1       string
	Rank2       string
	Rank3       string
}

type HumanRanking2025 

type HumanRanking2025 struct {
	// Each Human Ranking data is the ranking for one team
	ID          uint `gorm:"primaryKey"`
	CompCode    string
	MatchNumber int32
	TeamNumber  string
	Score       int32
}

type NotesData 

type NotesData struct {
	ID             uint `gorm:"primaryKey"`
	TeamNumber     string
	MatchNumber    int32
	SetNumber      int32
	CompLevel      string
	Notes          string
	GoodDriving    bool
	BadDriving     bool
	SolidPlacing   bool
	SketchyPlacing bool
	GoodDefense    bool
	BadDefense     bool
	EasilyDefended bool
	NoShow         bool
}

type NotesData2025 

type NotesData2025 struct {
	ID                   uint `gorm:"primaryKey"`
	CompCode             string
	TeamNumber           string
	MatchNumber          int32
	SetNumber            int32
	CompLevel            string
	Notes                string
	GoodDriving          bool
	BadDriving           bool
	CoralGroundIntake    bool
	CoralHpIntake        bool
	AlgaeGroundIntake    bool
	SolidAlgaeShooting   bool
	SketchyAlgaeShooting bool
	SolidCoralShooting   bool
	SketchyCoralShooting bool
	ShuffleCoral         bool
	ReefIntake           bool
	Penalties            bool
	GoodDefense          bool
	BadDefense           bool
	EasilyDefended       bool
	NoShow               bool
}

type ParsedDriverRankingData 

type ParsedDriverRankingData struct {
	TeamNumber string `gorm:"primaryKey"`

	// The score of the team. A difference of 100 in two team's scores
	// indicates that one team will outperform the other in 90% of the
	// matches.
	Score float32
}

type PitImage 

type PitImage struct {
	TeamNumber string `gorm:"primaryKey"`
	CheckSum   string `gorm:"primaryKey"`
	ImagePath  string
	ImageData  []byte
}

type Ranking 

type Ranking struct {
	TeamNumber         string `gorm:"primaryKey"`
	Losses, Wins, Ties int32
	Rank, Dq           int32
}

type RequestedPitImage 

type RequestedPitImage struct {
	TeamNumber string
	CheckSum   string `gorm:"primaryKey"`
	ImagePath  string
}

type Shift 

type Shift struct {
	MatchNumber                                                      int32 `gorm:"primaryKey"`
	R1scouter, R2scouter, R3scouter, B1scouter, B2scouter, B3scouter string
}

type Stats2025 

type Stats2025 struct {
	CompCode                           string `gorm:"primaryKey"`
	TeamNumber                         string `gorm:"primaryKey"`
	MatchNumber                        int32  `gorm:"primaryKey"`
	SetNumber                          int32  `gorm:"primaryKey"`
	CompLevel                          string `gorm:"primaryKey"`
	CompType                           string `gorm:"primaryKey"`
	StartingQuadrant                   int32
	L1Auto, L2Auto, L3Auto, L4Auto     int32
	NetAuto, ProcessorAuto             int32
	CoralDroppedAuto, AlgaeDroppedAuto int32
	CoralMissedAuto, AlgaeMissedAuto   int32
	MobilityAuto                       bool
	//teleop
	L1Teleop, L2Teleop, L3Teleop, L4Teleop   int32
	ProcessorTeleop, NetTeleop               int32
	CoralDroppedTeleop, AlgaeDroppedTeleop   int32
	CoralMissedTeleop, AlgaeMissedTeleop     int32
	Penalties                                int32
	AvgCycle                                 int64
	RobotDied                                bool
	Park, ShallowCage, DeepCage, BuddieClimb bool
	NoShow                                   bool
	CollectedBy                              string
}

type TeamMatch2025 

type TeamMatch2025 struct {
	MatchNumber      int32  `gorm:"primaryKey"`
	CompCode         string `gorm:"primaryKey"`
	SetNumber        int32  `gorm:"primaryKey"`
	CompLevel        string `gorm:"primaryKey"`
	Alliance         string `gorm:"primaryKey"` // "R" or "B"
	AlliancePosition int32  `gorm:"primaryKey"` // 1, 2, or 3
	TeamNumber       string
}

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.