dbsportlevel

Documentation

Index

• Constants
• func Delete(d *SportLevel) error
• func Insert(d *SportLevel) error
• func Save(s *SportLevel) error
• func Update(s *SportLevel) error
• type SportLevel
  • func ReadAll() ([]SportLevel, error)
  • func ReadByID(ID int64) (*SportLevel, error)
• type SportLevelFull
  • func ReadAllFull(orderBy string) ([]SportLevelFull, error)
  • func ReadByIDFull(ID int64) (*SportLevelFull, error)

Constants

const AMATEUR_GOLF = 5

const COLLEGE_BASKETBALL = 3

const COLLEGE_FOOTBALL = 2

const LEVEL_AMATEUR = "amateur"

const LEVEL_PRO = "pro"

const PRO_FOOTBALL = 1

const PRO_GOLF = 4

Functions

func Delete

func Delete(d *SportLevel) error

Delete deletes a record from the database

func Insert

func Insert(d *SportLevel) error

Insert will create a new record in the database

func Save

func Save(s *SportLevel) error

func Update

func Update(s *SportLevel) error

Update will update a record in the database

Types

type SportLevel

type SportLevel struct {
	SportLevelID int64  `db:"sport_level_id"`
	SportID      int64  `db:"sport_id"`
	Level        string `db:"level"`
	CurrentYear  int64  `db:"current_year"`
}

func ReadAll

func ReadAll() ([]SportLevel, error)

ReadAll reads all records in the database

func ReadByID

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

ReadByID reads by id column

type SportLevelFull

type SportLevelFull struct {
	SportLevelID int64  `db:"sport_level_id"`
	SportID      int64  `db:"sport_id"`
	SportLevel   string `db:"level"`
	SportName    string `db:"name"`
}

func ReadAllFull

func ReadAllFull(orderBy string) ([]SportLevelFull, error)

ReadAllFull reads all records in the database, including the sport name

func ReadByIDFull

func ReadByIDFull(ID int64) (*SportLevelFull, error)

ReadByIDFull reads by id column and also includes sport table info