model

type Album struct {
	ID          int
	SpotifyID   string
	Name        string
	TrackAmount int
	Popularity  int
	CoverID     string
	CoverURL    string
	UpdatedAt   time.Time

	// Non db fields
	Artists []Artist
}

type AlbumArtist struct {
	ID       int
	AlbumID  int
	ArtistID int
}

type AlbumUser struct {
	ID        int
	UserID    int
	AlbumID   int
	DeletedAt time.Time
}

type Artist struct {
	ID         int
	SpotifyID  string
	Name       string
	Followers  int
	Popularity int
	CoverID    string
	CoverURL   string
	UpdatedAt  time.Time
}

type Directory struct {
	ID       int
	UserID   int
	Name     string
	ParentID int

	// Non db fields
	Playlists []Playlist
}

type DirectoryPlaylist struct {
	ID          int
	DirectoryID int
	PlaylistID  int
}

type Generator struct {
	ID              int
	UserID          int
	Name            string
	Description     string
	PlaylistID      int
	Interval        time.Duration
	SpotifyOutdated bool
	Params          GeneratorParams
	UpdatedAt       time.Time
	CreatedAt       time.Time

	// Non db fields
	User   User
	Tracks []Track
}

type GeneratorParams struct {
	TrackAmount         int   `json:"track_amount"`
	ExcludedPlaylistIDs []int `json:"excluded_playlist_ids"`
	ExcludedTrackIDs    []int `json:"excluded_track_ids"`

	Preset GeneratorPreset `json:"preset"`

	ParamsTop    *GeneratorPresetTopParams    `json:"params_top,omitzero"`
	ParamsOldTop *GeneratorPresetOldTopParams `json:"params_old_top,omitzero"`
}

type GeneratorPreset string

type GeneratorPresetOldTopParams struct {
	PeakWindow   GeneratorWindow `json:"peak_window"`
	RecentWindow GeneratorWindow `json:"recent_window"`
}

type GeneratorPresetTopParams struct {
	Window GeneratorWindow `json:"window"`
}

type GeneratorTrack struct {
	ID          int
	GeneratorID int
	TrackID     int
}

type GeneratorWindow struct {
	Start            time.Time     `json:"start"`
	End              time.Time     `json:"end"`
	MinPlays         int           `json:"min_plays"`
	BurstInterval    time.Duration `json:"burst_interval"`
	DynamicReference time.Time     `json:"dynamic_reference"`
}

type History struct {
	ID         int
	UserID     int
	TrackID    int
	PlayedAt   time.Time
	Skipped    *bool
	AlbumID    int
	ArtistID   int
	PlaylistID int
	ShowID     int

	// Non db fields
	Track     Track
	PlayCount int
}

type HistoryFilter struct {
	UserID           int
	Limit            int
	Offset           int
	Start            time.Time
	End              time.Time
	Skipped          *bool
	PlayCountSkipped *bool
}

type Link struct {
	ID                int
	SourceDirectoryID int
	SourcePlaylistID  int
	TargetDirectoryID int
	TargetPlaylistID  int
}

type Playlist struct {
	ID            int
	SpotifyID     string
	OwnerID       int
	Name          string
	Description   string
	Public        *bool
	TrackAmount   int
	Collaborative *bool
	CoverID       string
	CoverURL      string
	SnapshotID    string
	UpdatedAt     time.Time

	// Non db fields
	Owner       User
	Duplicates  []Track
	Unplayables []Track
}

type PlaylistTrack struct {
	ID         int
	PlaylistID int
	TrackID    int
	CreatedAt  time.Time
	DeletedAt  time.Time
}

type PlaylistUser struct {
	ID         int
	UserID     int
	PlaylistID int
	DeletedAt  time.Time
}

type Show struct {
	ID            int
	SpotifyID     string
	Name          string
	EpisodeAmount int
	CoverID       string
	CoverURL      string
	UpdatedAt     time.Time
}

type ShowUser struct {
	ID        int
	UserID    int
	ShowID    int
	DeletedAt time.Time
}

type Task struct {
	// Task result
	ID       int // ID of the task result
	UserID   int // ID of the user that started the task
	RunAt    time.Time
	Result   TaskResult
	Message  string
	Error    error
	Duration time.Duration

	// Task fields
	UID       string // Identifier of the task
	Name      string
	Active    bool
	Recurring bool
}

type TaskFilter struct {
	UserID    int
	TaskUID   string
	Result    *TaskResult
	Recurring *bool
	Limit     int
	Offset    int
}

type TaskResult string

type Track struct {
	ID         int       `json:"id"`
	SpotifyID  string    `json:"spotify_id"`
	Name       string    `json:"name"`
	Popularity int       `json:"popularity"`
	DurationMs int       `json:"duration_ms"`
	UpdatedAt  time.Time `json:"updated_at"`

	// Non db fields
	Artists   []Artist
	Playlist  Playlist
	CreatedAt time.Time
	DeletedAt time.Time
}

type TrackArtist struct {
	ID       int
	TrackID  int
	ArtistID int
}

type TrackFilter struct {
	UserID     int
	PlaylistID int
	Limit      int
	Offset     int
}

type User struct {
	ID          int
	UID         string
	Name        string
	DisplayName string
	Email       string
}