mlb

type Game struct {
	GameID   int    `db:"game_id"`
	Season   int    `db:"season"`
	GameType string `db:"game_type"`
	HomeTeam int    `db:"home_team"`
	AwayTeam int    `db:"away_team"`
}

type GlUpload struct {
	Data       json.RawMessage `db:"data"`
	Checksum   *string         `db:"checksum"`
	UploadType string          `db:"upload_type"`
	UploadTime time.Time       `db:"upload_time"`
}

type PGXDB interface {
	Exec(ctx context.Context, sql string, arguments ...interface{}) (pgconn.CommandTag, error)
	Query(ctx context.Context, sql string, args ...interface{}) (pgx.Rows, error)
	QueryRow(ctx context.Context, sql string, args ...interface{}) pgx.Row
	SendBatch(ctx context.Context, b *pgx.Batch) pgx.BatchResults
}

type Pitch struct {
	Season     int       `db:"season"`
	GameID     int       `db:"game_id"`
	PlayID     uuid.UUID `db:"play_id"`
	PitcherID  int       `db:"pitcher_id"`
	PitchHand  string    `db:"pitch_hand"`
	BatterID   int       `db:"batter_id"`
	BatSide    string    `db:"bat_side"`
	PfxX       []float64 `db:"pfx_x"`
	PfxY       []float64 `db:"pfx_y"`
	PfxZ       []float64 `db:"pfx_z"`
	PitchType  *string   `db:"pitch_type"`
	PlateXyzt  []float64 `db:"plate_xyzt"`
	CommitXyzt []float64 `db:"commit_xyzt"`
}

type PitchSpatial struct {
	GameID int       `db:"game_id"`
	PlayID uuid.UUID `db:"play_id"`
	T      float64   `db:"t"`
	Xyz    []float64 `db:"xyz"`
	M      string    `db:"m"`
	MXyz   int64     `db:"m_xyz"`
	MX     int       `db:"m_x"`
	MY     int       `db:"m_y"`
	MZ     int       `db:"m_z"`
	L01    int8      `db:"l01"`
	L02    int8      `db:"l02"`
	L03    int8      `db:"l03"`
	L04    int8      `db:"l04"`
	L05    int8      `db:"l05"`
	L06    int8      `db:"l06"`
	L07    int8      `db:"l07"`
	L08    int8      `db:"l08"`
	L09    int8      `db:"l09"`
	L10    int8      `db:"l10"`
	L11    int8      `db:"l11"`
	L12    int8      `db:"l12"`
	L13    int8      `db:"l13"`
	L14    int8      `db:"l14"`
	L15    int8      `db:"l15"`
	L16    int8      `db:"l16"`
	Tag    *string   `db:"tag"`
}

type Play struct {
	GameID         int            `db:"game_id"`
	PlayID         uuid.UUID      `db:"play_id"`
	VenueID        int            `db:"venue_id"`
	GameIdx        int            `db:"game_idx"`
	AtBatIdx       int            `db:"at_bat_idx"`
	PlayIdx        int            `db:"play_idx"`
	StartTime      *time.Time     `db:"start_time"`
	EndTime        *time.Time     `db:"end_time"`
	Inning         int            `db:"inning"`
	Matchup        []int          `db:"matchup"`
	PreScore       []int          `db:"pre_score"`
	Score          []int          `db:"score"`
	PreRunner      RunnerMap      `db:"pre_runner"`
	Runner         RunnerMap      `db:"runner"`
	PreCount       []int          `db:"pre_count"`
	Count          []int          `db:"count"`
	PlayType       PlayType       `db:"play_type"`
	PlayResultType PlayResultType `db:"play_result_type"`
}

type PlayResultType int

type PlayType int

type Player struct {
	PlayerID  int    `db:"player_id"`
	NameFirst string `db:"name_first"`
	NameLast  string `db:"name_last"`
}

type RunnerMap struct {
	Plate []int `db:"plate"`
	Base1 []int `db:"base1"`
	Base2 []int `db:"base2"`
	Base3 []int `db:"base3"`
	Out   []int `db:"out"`
	Score []int `db:"score"`
	// contains filtered or unexported fields
}