dbfootballplayerstats

Documentation

Index

• func Delete(d *FootballPlayerStats) error
• func Insert(d *FootballPlayerStats) error
• func Save(s *FootballPlayerStats) error
• func Update(s *FootballPlayerStats) error
• type FootballPlayerStats
  • func ReadAll() ([]FootballPlayerStats, error)
  • func ReadByID(ID int64) (*FootballPlayerStats, error)
  • func ReadBySeasonWeekPlayer(seasonId, weekId, playerId int64) (*FootballPlayerStats, error)

Functions

func Delete

func Delete(d *FootballPlayerStats) error

Delete deletes a record from the database

func Insert

func Insert(d *FootballPlayerStats) error

Insert will create a new record in the database

func Save

func Save(s *FootballPlayerStats) error

func Update

func Update(s *FootballPlayerStats) error

Update will update a record in the database

Types

type FootballPlayerStats

type FootballPlayerStats struct {
	FootballPlayerStatsID int64               `db:"football_player_stats_id"`
	SeasonID              int64               `db:"season_id"`
	WeekID                database.NullInt64  `db:"week_id"`
	PlayerID              int64               `db:"player_id"`
	Started               database.NullInt64  `db:"started"`
	Played                database.NullInt64  `db:"played"`
	Inactive              database.NullInt64  `db:"inactive"`
	PassComp              database.NullInt64  `db:"pass_comp"`
	PassAttempts          database.NullInt64  `db:"pass_attempts"`
	PassYards             database.NullInt64  `db:"pass_yards"`
	PassInterceptions     database.NullInt64  `db:"pass_interceptions"`
	PassTDs               database.NullInt64  `db:"pass_tds"`
	PassTwoPts            database.NullInt64  `db:"pass_twopts"`
	Sacked                database.NullInt64  `db:"sacked"`
	SackedYardsLost       database.NullInt64  `db:"sacked_yards_lost"`
	RushAttempts          database.NullInt64  `db:"rush_attempts"`
	RushYards             database.NullInt64  `db:"rush_yards"`
	RushTDs               database.NullInt64  `db:"rush_tds"`
	RushTwoPts            database.NullInt64  `db:"rush_twopts"`
	RecTargets            database.NullInt64  `db:"rec_targets"`
	RecCatches            database.NullInt64  `db:"rec_catches"`
	RecYards              database.NullInt64  `db:"rec_yards"`
	RecTDs                database.NullInt64  `db:"rec_tds"`
	RecTwoPts             database.NullInt64  `db:"rec_twopts"`
	XPMade                database.NullInt64  `db:"xp_made"`
	XPAttempts            database.NullInt64  `db:"xp_attempts"`
	XPBlocked             database.NullInt64  `db:"xp_blocked"`
	FGMade                database.NullInt64  `db:"fg_made"`
	FGAttempts            database.NullInt64  `db:"fg_attempts"`
	FGBlocked             database.NullInt64  `db:"fg_blocked"`
	FG29Minus             database.NullInt64  `db:"fg_29_minus"`
	FG3039                database.NullInt64  `db:"fg_30_39"`
	FG4049                database.NullInt64  `db:"fg_40_49"`
	FG50Plus              database.NullInt64  `db:"fg_50_plus"`
	Fumbles               database.NullInt64  `db:"fumbles"`
	FumblesLost           database.NullInt64  `db:"fumbles_lost"`
	ExtraTDs              database.NullInt64  `db:"extra_tds"`
	TDDistances           database.NullString `db:"td_distances"`
	DefAssists            database.NullInt64  `db:"def_assists"`
	DefFumbleRecoveries   database.NullInt64  `db:"def_fumble_recoveries"`
	DefFumbleReturnYards  database.NullInt64  `db:"def_fumble_return_yards"`
	DefFumbleReturnForTDs database.NullInt64  `db:"def_fumble_return_for_tds"`
	DefFumbleForced       database.NullInt64  `db:"def_fumble_forced"`
	DefIntReturnYards     database.NullInt64  `db:"def_int_return_yards"`
	DefIntReturnForTDs    database.NullInt64  `db:"def_int_return_for_tds"`
	DefInt                database.NullInt64  `db:"def_int"`
	DefPassesDefensed     database.NullInt64  `db:"def_passes_defensed"`
	DefQBHurries          database.NullInt64  `db:"def_qb_hurries"`
	DefSackYardsLost      database.NullInt64  `db:"def_sack_yards_lost"`
	DefSacks              database.NullInt64  `db:"def_sacks"`
	DefSafeties           database.NullInt64  `db:"def_safeties"`
	DefTDDistances        database.NullString `db:"def_td_distances"`
	DefTackles            database.NullInt64  `db:"def_tackles"`
}

func ReadAll

func ReadAll() ([]FootballPlayerStats, error)

ReadAll reads all records in the database

func ReadByID

func ReadByID(ID int64) (*FootballPlayerStats, error)

ReadByID reads by id column

func ReadBySeasonWeekPlayer

func ReadBySeasonWeekPlayer(seasonId, weekId, playerId int64) (*FootballPlayerStats, error)

ReadBySeasonWeekPlayer reads by season_id, week_id, and player_id columns