models

type Category struct {
	ID       int           `db:"id" json:"id"`
	Name     string        `db:"name" json:"name"`
	ParentID sql.NullInt64 `db:"parent_id" json:"parentId"`
}

type Channel struct {
	ID          int            `db:"id" json:"id"`
	Title       string         `db:"title" json:"title"`
	Description string         `db:"description" json:"description"`
	Keywords    sql.NullString `db:"keywords" json:"-"`
	Image       string         `db:"image" json:"image"`
	URL         string         `db:"url" json:"url"`
	Website     sql.NullString `db:"website" json:"website"`
	NumPodcasts int            `db:"num_podcasts" json:"numPodcasts"`
	Podcasts    []*Podcast     `db:"-" json:"-"`
	Categories  []string       `db:"-" json:"-"`
}

type ChannelDetail struct {
	Channel    *Channel   `json:"channel"`
	Categories []Category `json:"categories"`
	Podcasts   []Podcast  `json:"podcasts"`
	Related    []Channel  `json:"relatedChannels"`
	Page       *Paginator `json:"page"`
}

type OPML struct {
	XMLName  xml.Name   `xml:"opml"`
	Version  string     `xml:"version,attr"`
	Title    string     `xml:"head>title"`
	Outlines []*Outline `xml:"body>outline"`
}

type Outline struct {
	XMLName xml.Name `xml:"outline"`
	Type    string   `xml:"type,attr"`
	Title   string   `xml:"title,attr"`
	Text    string   `xml:"text,attr"`
	URL     string   `xml:"xmlUrl,attr"`
	HTMLURL string   `xml:"htmlUrl,attr,omitempty"`
}

type Paginator struct {
	NumRows     int `json:"numRows"`
	NumPages    int `json:"numPages"`
	CurrentPage int `json:"page"`
	PageSize    int `json:"pageSize"`
	Offset      int `json:"-"`
}

type Play struct {
	PodcastID int       `db:"podcast_id" json:"podcastId"`
	CreatedAt time.Time `db:"created_at" json:"createdAt"`
}

type Podcast struct {
	ID           int       `db:"id" json:"id"`
	ChannelID    int       `db:"channel_id" json:"channelId"`
	GUID         string    `db:"guid" json:"-"`
	Name         string    `db:"name" json:"name"`
	Image        string    `db:"image" json:"image"`
	Title        string    `db:"title" json:"title"`
	Source       string    `db:"source" json:"source"`
	Description  string    `db:"description" json:"description"`
	EnclosureURL string    `db:"enclosure_url" json:"enclosureUrl"`
	PubDate      time.Time `db:"pub_date" json:"pubDate"`
	CreatedAt    time.Time `db:"created_at" json:"-"`
}

type PodcastList struct {
	Podcasts []Podcast  `json:"podcasts"`
	Page     *Paginator `json:"page"`
}

type SearchResult struct {
	Channels []Channel    `json:"channels"`
	Podcasts *PodcastList `json:"podcasts"`
}

type User struct {
	ID            int       `db:"id" json:"id"`
	Name          string    `db:"name" json:"name"`
	Email         string    `db:"email" json:"email"`
	Password      string    `db:"password" json:"-"`
	CreatedAt     time.Time `db:"created_at" json:"-"`
	Bookmarks     []int     `db:"-" json:"bookmarks"`
	Subscriptions []int     `db:"-" json:"subscriptions"`
	Plays         []Play    `db:"-" json:"plays"`
}