db

type AddPlaylistItemParams struct {
	PlaylistID  int64
	MediaPath   string
	TrackNumber sql.NullInt64
}

type Captions struct {
	MediaPath string          `json:"media_path"`
	Time      sql.NullFloat64 `json:"time"`
	Text      sql.NullString  `json:"text"`
}

type CaptionsFts struct {
	MediaPath string `json:"media_path"`
	Text      string `json:"text"`
}

type ColumnDef struct {
	Table  string
	Column string
	Schema string
}

type CustomKeywords struct {
	Category string `json:"category"`
	Keyword  string `json:"keyword"`
}

type DBTX interface {
	ExecContext(context.Context, string, ...any) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...any) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...any) *sql.Row
}

type DeletePlaylistParams struct {
	TimeDeleted sql.NullInt64
	ID          int64
}

type GetAllCaptionsOrderedParams struct {
	VideoOnly int64
	AudioOnly int64
	ImageOnly int64
	TextOnly  int64
	Limit     int64
}

type GetAllCaptionsOrderedRow struct {
	MediaPath string          `json:"media_path"`
	Time      sql.NullFloat64 `json:"time"`
	Text      sql.NullString  `json:"text"`
	Title     sql.NullString  `json:"title"`
	MediaType sql.NullString  `json:"media_type"`
	Size      sql.NullInt64   `json:"size"`
	Duration  sql.NullInt64   `json:"duration"`
}

type GetAllCaptionsRow struct {
	MediaPath string          `json:"media_path"`
	Time      sql.NullFloat64 `json:"time"`
	Text      sql.NullString  `json:"text"`
	Title     sql.NullString  `json:"title"`
	MediaType sql.NullString  `json:"media_type"`
	Size      sql.NullInt64   `json:"size"`
	Duration  sql.NullInt64   `json:"duration"`
}

type GetAllMediaMetadataRow struct {
	Path         string
	Size         sql.NullInt64
	TimeModified sql.NullInt64
	TimeDeleted  sql.NullInt64
}

type GetCategoryStatsRow struct {
	Category string
	Count    int64
}

type GetGenreStatsRow struct {
	Genre sql.NullString
	Count int64
}

type GetLanguageStatsRow struct {
	Language sql.NullString
	Count    int64
}

type GetMediaByDurationParams struct {
	MinDuration int64
	MaxDuration int64
	Limit       int64
}

type GetMediaByPathParams struct {
	PathPattern string
	Limit       int64
}

type GetMediaByPathPrefixParams struct {
	PathPrefix string
	PathNot    string
	Limit      int64
}

type GetMediaByPlayCountParams struct {
	MinPlayCount int64
	MaxPlayCount int64
	Limit        int64
}

type GetMediaBySizeParams struct {
	MinSize int64
	MaxSize int64
	Limit   int64
}

type GetMediaByTypeParams struct {
	VideoOnly bool
	AudioOnly bool
	ImageOnly bool
	Limit     int64
}

type GetPlaylistItemsRow struct {
	Media
	TrackNumber sql.NullInt64 `json:"track_number"`
	TimeAdded   sql.NullInt64 `json:"time_added"`
}

type GetRatingStatsRow struct {
	Rating int64
	Count  int64
}

type GetSiblingMediaParams struct {
	PathPattern string
	PathExclude string
	Limit       int64
}

type GetStatsByTypeRow struct {
	MediaType     sql.NullString
	Count         int64
	TotalSize     sql.NullInt64
	TotalDuration sql.NullInt64
}

type GetStatsRow struct {
	TotalCount           int64
	TotalSize            sql.NullInt64
	TotalDuration        sql.NullInt64
	WatchedCount         int64
	UnwatchedCount       int64
	TotalWatchedDuration sql.NullInt64
}

type GetUsedCategoriesRow struct {
	Categories sql.NullString
	Count      int64
}

type History struct {
	ID         int64         `json:"id"`
	MediaPath  string        `json:"media_path"`
	TimePlayed sql.NullInt64 `json:"time_played"`
	Playhead   sql.NullInt64 `json:"playhead"`
	Done       sql.NullInt64 `json:"done"`
}

type IndexDef struct {
	Name string
	SQL  string
}

type InsertCaptionParams struct {
	MediaPath string
	Time      sql.NullFloat64
	Text      sql.NullString
}

type InsertHistoryParams struct {
	MediaPath  string
	TimePlayed sql.NullInt64
	Playhead   sql.NullInt64
	Done       sql.NullInt64
}

type InsertPlaylistParams struct {
	Path            sql.NullString
	Title           sql.NullString
	ExtractorKey    sql.NullString
	ExtractorConfig sql.NullString
}

type MaintenanceConfig struct {
	// RefreshInterval is the minimum time between automatic refreshes
	// Default: 72 hours
	RefreshInterval time.Duration
}

type MaintenanceStatus struct {
	FolderStatsLastRefresh time.Time
	FTSLastRebuild         time.Time
}

type MarkDeletedParams struct {
	TimeDeleted sql.NullInt64
	Path        string
}

type Media struct {
	Path            string          `json:"path"`
	PathTokenized   sql.NullString  `json:"path_tokenized"`
	Title           sql.NullString  `json:"title"`
	Duration        sql.NullInt64   `json:"duration"`
	Size            sql.NullInt64   `json:"size"`
	TimeCreated     sql.NullInt64   `json:"time_created"`
	TimeModified    sql.NullInt64   `json:"time_modified"`
	TimeDeleted     sql.NullInt64   `json:"time_deleted"`
	TimeFirstPlayed sql.NullInt64   `json:"time_first_played"`
	TimeLastPlayed  sql.NullInt64   `json:"time_last_played"`
	PlayCount       sql.NullInt64   `json:"play_count"`
	Playhead        sql.NullInt64   `json:"playhead"`
	MediaType       sql.NullString  `json:"media_type"`
	Width           sql.NullInt64   `json:"width"`
	Height          sql.NullInt64   `json:"height"`
	Fps             sql.NullFloat64 `json:"fps"`
	VideoCodecs     sql.NullString  `json:"video_codecs"`
	AudioCodecs     sql.NullString  `json:"audio_codecs"`
	SubtitleCodecs  sql.NullString  `json:"subtitle_codecs"`
	VideoCount      sql.NullInt64   `json:"video_count"`
	AudioCount      sql.NullInt64   `json:"audio_count"`
	SubtitleCount   sql.NullInt64   `json:"subtitle_count"`
	Album           sql.NullString  `json:"album"`
	Artist          sql.NullString  `json:"artist"`
	Genre           sql.NullString  `json:"genre"`
	Categories      sql.NullString  `json:"categories"`
	Description     sql.NullString  `json:"description"`
	Language        sql.NullString  `json:"language"`
	TimeDownloaded  sql.NullInt64   `json:"time_downloaded"`
	Score           sql.NullFloat64 `json:"score"`

	// Hash and processing status
	Fasthash  sql.NullString `json:"fasthash"`
	Sha256    sql.NullString `json:"sha256"`
	IsDeduped sql.NullInt64  `json:"is_deduped"`
}

type MediaFts struct {
	Path          string `json:"path"`
	PathTokenized string `json:"path_tokenized"`
	Title         string `json:"title"`
	Description   string `json:"description"`
}

type PlaylistItems struct {
	PlaylistID  int64         `json:"playlist_id"`
	MediaPath   string        `json:"media_path"`
	TrackNumber sql.NullInt64 `json:"track_number"`
	TimeAdded   sql.NullInt64 `json:"time_added"`
}

type Playlists struct {
	ID              int64          `json:"id"`
	Path            sql.NullString `json:"path"`
	Title           sql.NullString `json:"title"`
	ExtractorKey    sql.NullString `json:"extractor_key"`
	ExtractorConfig sql.NullString `json:"extractor_config"`
	TimeDeleted     sql.NullInt64  `json:"time_deleted"`
}

type Queries struct {
	// contains filtered or unexported fields
}

type RemovePlaylistItemParams struct {
	PlaylistID int64
	MediaPath  string
}

type SearchCaptionsParams struct {
	Query     string
	VideoOnly bool
	AudioOnly bool
	ImageOnly bool
	TextOnly  bool
	Limit     int64
}

type SearchCaptionsRow struct {
	MediaPath string
	Time      sql.NullFloat64
	Text      sql.NullString
	Title     sql.NullString
	MediaType sql.NullString
	Size      sql.NullInt64
	Duration  sql.NullInt64
	Rank      float64
}

type SearchMediaFTSParams struct {
	Query string
	Limit int64
}

type SearchMediaFTSResult struct {
	Media Media
	Rank  float64
}

type UpdateMediaCategoriesParams struct {
	Categories sql.NullString
	Path       string
}

type UpdatePathParams struct {
	NewPath string
	OldPath string
}

type UpdatePlayHistoryParams struct {
	TimeLastPlayed  sql.NullInt64
	TimeFirstPlayed sql.NullInt64
	Playhead        sql.NullInt64
	Path            string
}

type UpsertMediaParams struct {
	Path           string
	PathTokenized  sql.NullString
	Title          sql.NullString
	Duration       sql.NullInt64
	Size           sql.NullInt64
	TimeCreated    sql.NullInt64
	TimeModified   sql.NullInt64
	MediaType      sql.NullString
	Width          sql.NullInt64
	Height         sql.NullInt64
	Fps            sql.NullFloat64
	VideoCodecs    sql.NullString
	AudioCodecs    sql.NullString
	SubtitleCodecs sql.NullString
	VideoCount     sql.NullInt64
	AudioCount     sql.NullInt64
	SubtitleCount  sql.NullInt64
	Album          sql.NullString
	Artist         sql.NullString
	Genre          sql.NullString
	Categories     sql.NullString
	Description    sql.NullString
	Language       sql.NullString
	TimeDownloaded sql.NullInt64
	Score          sql.NullFloat64
	Fasthash       sql.NullString
	Sha256         sql.NullString
	IsDeduped      sql.NullInt64
}