model

Documentation

Index

• Variables
• func NullTimeNow() null.Time
• func WrapTime(t time.Time) null.Time
• type Base
  • func (b *Base) Scan(value interface{}) error
  • func (b Base) Value() (driver.Value, error)
• type Game
  • func GetGame(id int64) (Game, error)
  • func SelectAllGames() ([]Game, error)
  • func SelectGames(ids []int64) ([]Game, error)
  • func (g *Game) Delete() error
  • func (g Game) LinkID() string
  • func (g *Game) Save() error
• type Member
  • func GetMember(id int64) (Member, error)
  • func GetMemberFromProvider(name string, id string) (Member, error)
  • func SearchMembers(search string) ([]Member, error)
  • func SelectAllMembers() ([]Member, error)
  • func SelectMembers(ids []int64) ([]Member, error)
  • func (m *Member) Delete() error
  • func (m *Member) DoesFollow(id int64) bool
  • func (m *Member) HasFollower(id int64) bool
  • func (m Member) LinkID() string
  • func (m *Member) Save() error
• type Model
• type Note
  • func GetNote(id int64) (Note, error)
  • func SelectAllNotes() ([]Note, error)
  • func SelectNotes(ids []int64) ([]Note, error)
  • func (n *Note) Delete() error
  • func (n Note) LinkID() string
  • func (n *Note) Save() error
• type Sport
• type Team
  • func GetTeam(id int64) (Team, error)
  • func GetTeamFull(id int64) (Team, error)
  • func SearchTeams(search string, sport string) ([]Team, error)
  • func SelectAllTeams() ([]Team, error)
  • func SelectTeams(ids []int64) ([]Team, error)
  • func (t *Team) Delete() error
  • func (t Team) LinkID() string
  • func (t *Team) Save() error
• type Venue
  • func GetVenue(id int64) (Venue, error)
  • func SearchVenues(search string) ([]Venue, error)
  • func SelectAllVenues() ([]Venue, error)
  • func SelectVenues(ids []int64) ([]Venue, error)
  • func (v *Venue) Delete() error
  • func (v Venue) LinkID() string
  • func (v *Venue) Save() error

Variables

var Sports = []Sport{"Baseball", "Basketball", "Cricket", "Field Hockey", "Football", "Ice Hockey", "Kickball", "Lacrosse", "Pickle Ball", "Rugby", "Soccer", "Softball", "Table Tennis", "Tennis", "Ultimate Frisbee", "Volleyball", "Water Polo"}

Sports supported sports

Functions

func NullTimeNow

func NullTimeNow() null.Time

NullTimeNow returns time.Now() as a nullable database value

func WrapTime

func WrapTime(t time.Time) null.Time

WrapTime wraps a time.Time value as a null.Time for database usage

Types

type Base

type Base struct {
	Model      `json:"-"`
	ID         int64     `json:"id,omitempty"`
	Created    null.Time `sql:" NOT NULL DEFAULT now()" json:"created,omitempty"`
	CreatedBy  int64     `sql:" NOT NULL DEFAULT 0" json:"createdby,omitempty"`
	Modified   null.Time `json:"modified,omitempty"`
	ModifiedBy int64     `sql:" NOT NULL DEFAULT 0" json:"modifiedby,omitempty"`
}

Base model that provides common fields

func (*Base) Scan

func (b *Base) Scan(value interface{}) error

Scan implements driver Scanner interface

func (Base) Value

func (b Base) Value() (driver.Value, error)

Value implements the driver Valuer interface

type Game

type Game struct {
	Base
	Sport     Sport         `json:"sport"`
	HomeTeam  Team          `json:"hometeam"`
	AwayTeam  Team          `json:"awayteam"`
	HomeScore int           `json:"homescore"`
	AwayScore int           `json:"awayscore"`
	Start     null.Time     `json:"start,omitempty"`
	Final     bool          `json:"final"`
	Venue     Venue         `json:"venue,omitempty"`
	Notes     pq.Int64Array `json:"-"`
	NoteCount int           `sql:"-" json:"notecount"`
}

Game data model

func GetGame

func GetGame(id int64) (Game, error)

GetGame returns game from data store

func SelectAllGames

func SelectAllGames() ([]Game, error)

SelectAllGames from data store

func SelectGames

func SelectGames(ids []int64) ([]Game, error)

SelectGames from data store where ID in slice

func (*Game) Delete

func (g *Game) Delete() error

Delete removes object from data store

func (Game) LinkID

func (g Game) LinkID() string

LinkID gets ID as a linkable string

func (*Game) Save

func (g *Game) Save() error

Save persists object to data store

type Member

type Member struct {
	Base
	Handle        string        `sql:" NOT NULL UNIQUE"`
	Email         string        `sql:" NOT NULL UNIQUE"`
	FirstName     string        `json:"firstname"`
	LastName      string        `json:"lastname"`
	Provider      string        `json:"-"`
	ProviderID    string        `json:"-"`
	Enabled       bool          `json:"-"`
	LastActive    null.Time     `json:"-"`
	Teams         pq.Int64Array `json:"-"`
	TeamCount     int           `sql:"-" json:"teamCount"`
	Follows       pq.Int64Array `json:"-"`
	FollowCount   int           `sql:"-" json:"followCount"`
	Followers     pq.Int64Array `json:"-"`
	FollowerCount int           `sql:"-" json:"followerCount"`
}

Member data model

func GetMember

func GetMember(id int64) (Member, error)

GetMember returns member from data store

func GetMemberFromProvider

func GetMemberFromProvider(name string, id string) (Member, error)

GetMemberFromProvider returns a member from data store based on provider name and userID

func SearchMembers

func SearchMembers(search string) ([]Member, error)

SearchMembers finds members that match a search string

func SelectAllMembers

func SelectAllMembers() ([]Member, error)

SelectAllMembers from data store

func SelectMembers

func SelectMembers(ids []int64) ([]Member, error)

SelectMembers from data store where ID in slice

func (*Member) Delete

func (m *Member) Delete() error

Delete removes object from data store

func (*Member) DoesFollow

func (m *Member) DoesFollow(id int64) bool

DoesFollow shows if Member follows id

func (*Member) HasFollower

func (m *Member) HasFollower(id int64) bool

HasFollower shows if id is a follower of Member

func (Member) LinkID

func (m Member) LinkID() string

LinkID gets ID as a linkable string

func (*Member) Save

func (m *Member) Save() error

Save persists object to data store

type Model

type Model interface {
	Save() error
	Delete() error
	LinkID() string
}

Model data store operations

type Note

type Note struct {
	Base
	Message string `json:"message,omitempty"`
}

Note data model

func GetNote

func GetNote(id int64) (Note, error)

GetNote returns note from data store

func SelectAllNotes

func SelectAllNotes() ([]Note, error)

SelectAllNotes from data store

func SelectNotes

func SelectNotes(ids []int64) ([]Note, error)

SelectNotes from data store where ID in slice

func (*Note) Delete

func (n *Note) Delete() error

Delete removes object from data store

func (Note) LinkID

func (n Note) LinkID() string

LinkID gets ID as a linkable string

func (*Note) Save

func (n *Note) Save() error

Save persists object to data store

type Sport

type Sport string

Sport name

type Team

type Team struct {
	Base
	Name      string        `json:"name"`
	Sport     Sport         `json:"sport,omitempty"`
	Venue     Venue         `json:"venue,omitempty"`
	Mascot    string        `json:"mascot,omitempty"`
	Games     pq.Int64Array `json:"-"`
	GameCount int           `sql:"-" json:"gameCount"`
}

Team data model

func GetTeam

func GetTeam(id int64) (Team, error)

GetTeam returns team from data store

func GetTeamFull

func GetTeamFull(id int64) (Team, error)

GetTeamFull returns team from data store with nested structs populated

func SearchTeams

func SearchTeams(search string, sport string) ([]Team, error)

SearchTeams finds teams that match a search string and sport

func SelectAllTeams

func SelectAllTeams() ([]Team, error)

SelectAllTeams from data store

func SelectTeams

func SelectTeams(ids []int64) ([]Team, error)

SelectTeams from data store where ID in slice

func (*Team) Delete

func (t *Team) Delete() error

Delete removes object from data store

func (Team) LinkID

func (t Team) LinkID() string

LinkID gets ID as a linkable string

func (*Team) Save

func (t *Team) Save() error

Save persists object to data store

type Venue

type Venue struct {
	Base
	Name        string `json:"name,omitempty"`
	Address     string `json:"address,omitempty"`
	Coordinates string `json:"coordinates,omitempty"`
}

Venue data model

func GetVenue

func GetVenue(id int64) (Venue, error)

GetVenue returns venue from data store

func SearchVenues

func SearchVenues(search string) ([]Venue, error)

SearchVenues finds venues that match a search string

func SelectAllVenues

func SelectAllVenues() ([]Venue, error)

SelectAllVenues from data store

func SelectVenues

func SelectVenues(ids []int64) ([]Venue, error)

SelectVenues from data store where ID in slice

func (*Venue) Delete

func (v *Venue) Delete() error

Delete removes object from data store

func (Venue) LinkID

func (v Venue) LinkID() string

LinkID gets ID as a linkable string

func (*Venue) Save

func (v *Venue) Save() error

Save persists object to data store