database

type ConnectionInfo ¶

type ConnectionInfo struct {
	Server   string
	Port     int
	Database string
	Username string
	Password string
}

func (c *ConnectionInfo) String() string

type Database ¶

type Database struct {
	ConnectionInfo

	Connection    *sql.DB
	Subscriptions *SubscriptionTable
	Videos        *VideosTable
	Version       *VersionTable
	Download      *DownloadTable
	Log           *LogTable
}

Database : A connection to the SoftTube database

func NewDatabase(server string, port int, database, username, password string) *Database

func (d *Database) Close()

func (d *Database) Open() error

type Download ¶

type Download struct {
	ID string
}

Download : Represents a download request

type DownloadTable ¶

type DownloadTable struct {
	*Table
}

DownloadTable : VideosTable in the SoftTube database

func (d DownloadTable) Delete(id string) error

func (d DownloadTable) GetAll() ([]Download, error)

func (d DownloadTable) Insert(id string) error

type Log ¶

type Log struct {
	ID      int
	Message string
	Type    LogType
}

Log : Represents a SoftTube log entry

type LogTable ¶

type LogTable struct {
	*Table
}

LogTable : The version table in the database

func (l *LogTable) GetLatest() ([]Log, error)

func (l *LogTable) Insert(logType LogType, logMessage string) error

type LogType ¶

type LogType int

type Subscription ¶

type Subscription struct {
	ID          string
	Name        string
	Frequency   int
	LastChecked sql.NullTime
	NextUpdate  sql.NullInt32
}

Subscription : Represents a YouTube subscription in SoftTube

func (s Subscription) NeedsUpdate() bool

type SubscriptionTable ¶

type SubscriptionTable struct {
	*Table
}

SubscriptionTable : SubscriptionTable in the SoftTube database

func (s SubscriptionTable) Get(id string) (Subscription, error)

func (s SubscriptionTable) GetAll() ([]Subscription, error)

func (s SubscriptionTable) UpdateLastChecked(subscription *Subscription, interval int) error

type Table ¶

type Table struct {
	*Database
}

type Version ¶

type Version struct {
	Major    int
	Minor    int
	Revision int
}

Version : Represents the SoftTube database version

type VersionTable ¶

type VersionTable struct {
	*Table
}

VersionTable : The version table in the database

func (v VersionTable) Get() (Version, error)

type Video ¶

type Video struct {
	ID               string
	SubscriptionID   string
	SubscriptionName string
	Title            string
	Added            time.Time
	Published        time.Time
	Duration         sql.NullString
	Status           VideoStatusType
	Saved            bool
}

Video : Represents a YouTube video in SoftTube

type VideoStatusType ¶

type VideoStatusType int

type VideosTable ¶

type VideosTable struct {
	*Table
}

VideosTable : VideosTable in the SoftTube database

func (v VideosTable) Delete(id string) error

func (v VideosTable) Exists(videoID string) (bool, error)

func (v VideosTable) Get(id string) (Video, error)

func (v VideosTable) GetStatus(videoID string) (int, error)

func (v VideosTable) GetVideos(failed, savedView bool) ([]Video, error)

func (v VideosTable) Insert(
	id string, subscriptionID string, title string, duration string, published time.Time,
) error

func (v VideosTable) Search(text string) ([]Video, error)

func (v VideosTable) UpdateDuration(videoID string, duration string) error

func (v VideosTable) UpdateSave(id string, saved bool) error

func (v VideosTable) UpdateStatus(id string, status VideoStatusType) error