db

type APIToken struct {
	Token     string
	CreatedAt time.Time
	User      User
}

type Artist struct {
	ID            int
	Name          string
	Aliases       []ArtistAlias
	ReleaseGroups []RoledReleaseGroup
	Added         time.Time
	AddedBy       User
	Bio           sql.NullString
	Tags          []string
}

type ArtistAlias struct {
	Alias   string
	Added   time.Time
	AddedBy User
}

type BlogEntry struct {
	ID       int
	Author   User
	Title    string
	PostedAt time.Time
	Content  string
	Tags     []string
}

type BoilingDB interface {
	Close() error

	SignUpUser(username, password, email string) error
	LoginAndGetUser(username, password string) (*User, error)
	GetUser(id int) (*User, error)
	UpdateUserDeltaUpDown(id, deltaUp, deltaDown int) error
	UpdateUserSetLastAccess(id int, lastAccess time.Time) error
	UpdateUserSetLastLogin(id int, lastLogin time.Time) error
	UpdateUserAddPrivileges(id int, privileges []int) error
	PopulateUserPrivileges(u *User) error

	GetPasskeyForUser(id int) (*Passkey, error)
	GetAllPasskeysForUser(id int) ([]Passkey, error)
	GenerateNewPasskeyForUser(id int) (string, error)

	InsertTokenForUser(u User) (*APIToken, error)
	GetToken(token string) (*APIToken, error)

	InsertBlogEntry(post *BlogEntry) error
	GetBlogEntry(id int) (*BlogEntry, error)
	UpdateBlogEntry(post BlogEntry) error
	DeleteBlogEntry(id int) error
	GetBlogEntries(limit, offset int) ([]BlogEntry, error)

	AutocompleteArtists(s string) ([]Artist, error)
	AutocompleteArtistTags(s string) ([]string, error)
	GetArtist(id int) (*Artist, error)
	PopulateReleaseGroups(artist *Artist) error
	InsertArtist(artist *Artist) error

	GetAllPrivileges() (map[int]string, error)

	GetAllFormats() (map[int]Format, error)

	GetAllMedia() (map[int]string, error)

	GetAllReleaseGroupRoles() (map[int]string, error)

	GetAllLeechTypes() (map[int]string, error)

	GetAllReleaseProperties() (map[int]string, error)
	AddReleaseProperty(key string) error

	AutocompleteRecordLabels(s string) ([]RecordLabel, error)
	GetRecordLabel(id int) (*RecordLabel, error)
	InsertRecordLabel(label *RecordLabel) error

	AutocompleteReleaseTags(s string) ([]string, error)
	InsertRelease(release *Release) error
	SetReleaseProperty(id int, k, v string) error
	GetRelease(id int) (*Release, error)
	DeleteRelease(id int) error
	PopulateTorrents(release *Release) error

	AutocompleteReleaseGroups(s string) ([]ReleaseGroup, error)
	AutocompleteReleaseGroupTags(s string) ([]string, error)
	GetAllReleaseGroupTypes() (map[int]string, error)
	GetReleaseGroup(id int) (*ReleaseGroup, error)
	InsertReleaseGroup(group *ReleaseGroup) error
	PopulateReleases(group *ReleaseGroup) error
	SearchReleaseGroups(q *Query, offset, limit int) ([]ReleaseGroup, error)
}

type Boolean interface {
	// contains filtered or unexported methods
}

type ColumnSelector interface {
	// contains filtered or unexported methods
}

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

type Format struct {
	Format   string
	Encoding string
}

type Passkey struct {
	Uid       int
	Passkey   string
	CreatedAt time.Time
	Valid     bool
}

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

type RecordLabel struct {
	ID          int
	Name        string
	Description sql.NullString
	Founded     pq.NullTime
	Added       time.Time
	AddedBy     User
}

type Release struct {
	ID              int
	ReleaseGroup    ReleaseGroup
	Edition         sql.NullString
	Medium          int
	ReleaseDate     time.Time
	CatalogueNumber sql.NullString
	RecordLabel     RecordLabel
	Torrents        []Torrent
	Added           time.Time
	AddedBy         User
	Original        bool
	Tags            []string

	// Properties lists "official" properties of releases, for example
	// "LossyMasterApproved", to be set by trusted users or staff.
	Properties map[string]string
}

type ReleaseGroup struct {
	ID          int
	Name        string // Album title
	Artists     []RoledArtist
	ReleaseDate time.Time
	Added       time.Time
	AddedBy     User
	Type        int       // Album/EP
	Releases    []Release // individual releases
	Tags        []string
}

type RoledArtist struct {
	Role   int
	Artist Artist
}

type RoledReleaseGroup struct {
	Role         int
	ReleaseGroup ReleaseGroup
}

type Sorter interface {
	// contains filtered or unexported methods
}

type Torrent struct {
	ID         int
	Uploaded   time.Time
	UploadedBy User
	InfoHash   [20]byte

	Format      int
	Size        int64
	Description string

	Leechers int
	Seeders  int
	Snatches int

	FileList []string

	Properties map[string]string
	LeechType  string
}

type User struct {
	ID           int
	Username     string
	Email        string
	PasswordHash string
	Bio          sql.NullString
	Enabled      bool
	CanLogin     bool
	JoinedAt     time.Time
	LastLogin    pq.NullTime
	LastAccess   pq.NullTime
	Uploaded     int64
	Downloaded   int64
	Privileges   []int
}