showstorage

Documentation

Index

• func SetupTable(db *sqlx.DB)
• func Update(db *sqlx.DB, show *Show) (sql.Result, error)
• type Show
  • func Find(db *sqlx.DB, name string) (*Show, error)

Functions

func SetupTable

func SetupTable(db *sqlx.DB)

SetupTable creates the shows table if it does not exist.

func Update

func Update(db *sqlx.DB, show *Show) (sql.Result, error)

Update stores new data in the database.

Types

type Show

type Show struct {
	Name         string `db:"name"`
	LatestSeason int    `db:"latest_season"`
	NextEpisode  int    `db:"next_episode"`
	Path         string `dB:"path"`
}

Show stores a TV Show name, path to the files, and the next season and episode number.

func Find

func Find(db *sqlx.DB, name string) (*Show, error)

Find looks up a show by name.