storage

type ChannelCount struct {
	Channel string `json:"channel"`
	Count   int    `json:"count"`
}

type DB struct {
	*db.DB
}

type DailyCount struct {
	Date  string `json:"date"`
	Count int    `json:"count"`
}

type ListFilters struct {
	Channel  string
	Language string
	Topic    string
	Status   string
}

type TopicCount struct {
	Topic string `json:"topic"`
	Count int    `json:"count"`
}

type Video struct {
	ID                  uuid.UUID       `json:"id"`
	UserID              int             `json:"user_id"`
	KarakeepBookmarkID  string          `json:"karakeep_bookmark_id,omitempty"`
	YouTubeID           string          `json:"youtube_id"`
	Title               string          `json:"title"`
	Channel             string          `json:"channel"`
	DurationSeconds     int             `json:"duration_seconds,omitempty"`
	Language            string          `json:"language,omitempty"`
	Transcript          string          `json:"transcript,omitempty"`
	Summary             string          `json:"summary,omitempty"`
	DetailLevel         string          `json:"detail_level"`
	SummaryProvider     string          `json:"summary_provider,omitempty"`
	SummaryModel        string          `json:"summary_model,omitempty"`
	SummaryInputTokens  int             `json:"summary_input_tokens,omitempty"`
	SummaryOutputTokens int             `json:"summary_output_tokens,omitempty"`
	Metadata            json.RawMessage `json:"metadata"`
	Status              string          `json:"status"`
	ErrorMessage        string          `json:"error_message,omitempty"`
	CreatedAt           time.Time       `json:"created_at"`
	UpdatedAt           time.Time       `json:"updated_at"`
}

type VideoMatch struct {
	ID         uuid.UUID       `json:"id"`
	YouTubeID  string          `json:"youtube_id"`
	Title      string          `json:"title"`
	Channel    string          `json:"channel"`
	Summary    string          `json:"summary"`
	Metadata   json.RawMessage `json:"metadata"`
	Similarity float64         `json:"similarity"`
	CreatedAt  time.Time       `json:"created_at"`
}

type VideoStats struct {
	TotalCount           int            `json:"total_count"`
	TotalDurationSeconds int64          `json:"total_duration_seconds"`
	ByStatus             map[string]int `json:"by_status"`
	ByChannel            []ChannelCount `json:"by_channel"`
	TopTopics            []TopicCount   `json:"top_topics"`
	DailyActivity        []DailyCount   `json:"daily_activity"`
}