database

Dec 26, 2024

Changes in this version

+ func ApiTokenQuery() *goqu.SelectDataset

+ func FeaturingArtistsQuery(table, idColName string) *goqu.SelectDataset

+ func InvalidFilter(err error) error

+ func InvalidSort(err error) error

+ func PlaylistQuery() *goqu.SelectDataset

+ func UserQuery() *goqu.SelectDataset

+ func UserSettingsQuery() *goqu.SelectDataset

type Album

+ ArtistOtherName sql.NullString

+ FeaturingArtists FeaturingArtists

+ OtherName sql.NullString

+ Tags sql.NullString

type AlbumChanges

+ OtherName types.Change[sql.NullString]

+ type ApiToken struct

+ Created int64

+ Id string

+ Name string

+ Updated int64

+ UserId string

type Artist

+ Created int64

+ OtherName sql.NullString

+ Tags sql.NullString

+ Updated int64

type ArtistChanges

+ Created types.Change[int64]

+ OtherName types.Change[sql.NullString]

+ type ArtistSearch struct

+ Id string

+ Name string

type CreateAlbumParams

+ OtherName sql.NullString

+ type CreateApiTokenParams struct

+ Created int64

+ Id string

+ Name string

+ Updated int64

+ UserId string

type CreateArtistParams

+ Created int64

+ OtherName sql.NullString

+ Updated int64

type CreatePlaylistParams

+ Created int64

+ Id string

+ Picture sql.NullString

+ Updated int64

+ type CreateTaglistParams struct

+ Created int64

+ Filter string

+ Name string

+ OwnerId string

+ Updated int64

type CreateTrackParams

+ OtherName sql.NullString

+ type CreateUserParams struct

+ Created int64

+ Id string

+ Password string

+ Role string

+ Updated int64

+ Username string

type Database

+ func (db *Database) AddFeaturingArtistToAlbum(ctx context.Context, albumId, artistId string) error

+ func (db *Database) AddFeaturingArtistToTrack(ctx context.Context, trackId, artistId string) error

+ func (db *Database) AddItemToPlaylist(ctx context.Context, playlistId, trackId string) error

+ func (db *Database) AddTagToAlbum(ctx context.Context, tagSlug, albumId string) error

+ func (db *Database) AddTagToArtist(ctx context.Context, tagSlug, artistId string) error

+ func (db *Database) CreateApiToken(ctx context.Context, params CreateApiTokenParams) (ApiToken, error)

+ func (db *Database) CreateTaglist(ctx context.Context, params CreateTaglistParams) (Taglist, error)

+ func (db *Database) GetAllApiTokensForUser(ctx context.Context, userId string) ([]ApiToken, error)

+ func (db *Database) GetApiTokenById(ctx context.Context, id string) (ApiToken, error)

+ func (db *Database) GetPagedTracks(ctx context.Context, opts FetchOption) ([]Track, types.Page, error)

+ func (db *Database) GetTaglistById(ctx context.Context, id string) (Taglist, error)

+ func (db *Database) GetTaglistByUser(ctx context.Context, userId string) ([]Taglist, error)

+ func (db *Database) GetUserSettingsById(ctx context.Context, id string) (UserSettings, error)

+ func (db *Database) InitializeSearch() error

+ func (db *Database) RefillSearchTables(ctx context.Context) error

+ func (db *Database) RemoveAllAlbumFeaturingArtists(ctx context.Context, albumId string) error

+ func (db *Database) RemoveAllTagsFromAlbum(ctx context.Context, albumId string) error

+ func (db *Database) RemoveAllTagsFromArtist(ctx context.Context, artistId string) error

+ func (db *Database) RemoveAllTrackFeaturingArtists(ctx context.Context, trackId string) error

+ func (db *Database) RemoveApiToken(ctx context.Context, id string) error

+ func (db *Database) RemovePlaylistItem(ctx context.Context, playlistId, trackId string) error

+ func (db *Database) RemoveTaglist(ctx context.Context, id string) error

+ func (db *Database) SearchAlbums(searchQuery string) ([]Album, error)

+ func (db *Database) SearchArtists(searchQuery string) ([]Artist, error)

+ func (db *Database) SearchTracks(searchQuery string) ([]Track, error)

+ func (db *Database) UpdateTaglist(ctx context.Context, id string, changes TaglistChanges) error

+ func (db *Database) UpdateUserSettings(ctx context.Context, settings UserSettings) error

+ type FeaturingArtist struct

+ Id string

+ Name string

+ OtherName *string

+ type FeaturingArtists []FeaturingArtist

+ func (s FeaturingArtists) Value() (driver.Value, error)

+ func (v *FeaturingArtists) Scan(value any) error

+ type FetchOption struct

+ Filter string

+ Page int

+ PerPage int

+ Sort string

type Playlist

+ Created string

+ Picture sql.NullString

+ Updated string

+ type Taglist struct

+ Created int64

+ Filter string

+ Id string

+ Name string

+ OwnerId string

+ Updated int64

+ type TaglistChanges struct

+ Created types.Change[int64]

+ Filter types.Change[string]

+ Name types.Change[string]

type Track

+ AlbumOtherName sql.NullString

+ ArtistOtherName sql.NullString

+ FeaturingArtists FeaturingArtists

+ OtherName sql.NullString

type TrackChanges

+ OtherName types.Change[sql.NullString]

+ type TrackSearch struct

+ Album string

+ Artist string

+ Id string

+ Name string

+ Tags string

type User

+ Created int64

+ DisplayName sql.NullString

+ QuickPlaylist sql.NullString

+ Role string

+ Updated int64

+ func (u User) ToUserSettings() UserSettings

type UserChanges

+ Created types.Change[int64]

+ type UserSettings struct

+ DisplayName sql.NullString

+ Id string

+ QuickPlaylist sql.NullString

Nov 26, 2024

Changes in this version

type Database

+ func (db *Database) UpdateUser(ctx context.Context, id string, changes UserChanges) error

+ type UserChanges struct

+ Password types.Change[string]

+ Username types.Change[string]

Oct 20, 2024

Changes in this version

+ var ErrItemAlreadyExists = errors.New("database: item already exists")

+ func AlbumQuery() *goqu.SelectDataset

+ func ArtistQuery() *goqu.SelectDataset

+ func TagQuery() *goqu.SelectDataset

type Album

+ Available bool

+ Created int64

+ Updated int64

+ Year sql.NullInt64

type AlbumChanges

+ Created types.Change[int64]

+ Year types.Change[sql.NullInt64]

type AlbumResolverAdapter

+ func (*AlbumResolverAdapter) DefaultSort() string

+ func (*AlbumResolverAdapter) MapSortName(name string) (types.Name, error)

type CreateAlbumParams

+ Available bool

+ Created int64

+ Id string

+ Updated int64

+ Year sql.NullInt64

type CreateArtistParams

+ Id string

type CreateTrackParams

+ Available bool

+ Created int64

+ ExportName string

+ Id string

+ MobileFilename string

+ Number sql.NullInt64

+ OriginalFilename string

+ Updated int64

+ Year sql.NullInt64

type Database

+ NewRawConn *sqlx.DB

+ func (db *Database) AddItemsToPlaylistRaw(ctx context.Context, playlistId string, trackIds []string) error

+ func (db *Database) Get(dest any, s ToSQL) error

+ func (db *Database) GetPlaylistTracks(ctx context.Context, playlistId string) ([]Track, error)

+ func (db *Database) GetTagBySlug(ctx context.Context, slug string) (Tag, error)

+ func (db *Database) RemoveAlbum(ctx context.Context, id string) error

+ func (db *Database) RemoveAlbumTracks(ctx context.Context, albumId string) error

+ func (db *Database) RemoveAllTagsFromTrack(ctx context.Context, trackId string) error

+ func (db *Database) RemoveTrack(ctx context.Context, id string) error

+ func (db *Database) RunMigrateDown() error

+ func (db *Database) RunMigrateUp() error

+ func (db *Database) Select(dest any, s ToSQL) error

type Tag

+ Slug string

type Track

+ AlbumCoverArt sql.NullString

+ Created int64

+ ExportName string

+ MobileFilename string

+ OriginalFilename string

+ Updated int64

+ Year sql.NullInt64

type TrackChanges

+ AlbumId types.Change[string]

+ Created types.Change[int64]

+ ExportName types.Change[string]

+ MobileFilename types.Change[string]

+ OriginalFilename types.Change[string]

+ Year types.Change[sql.NullInt64]

Aug 18, 2024

Changes in this version

type Track

+ Available bool

Aug 16, 2024

Changes in this version

+ var ErrInvalidSort = errors.New("Invalid sort")

type TrackResolverAdapter

+ func (a *TrackResolverAdapter) DefaultSort() string

+ func (a *TrackResolverAdapter) MapSortName(name string) (types.Name, error)

Aug 15, 2024

Changes in this version

+ var ErrInvalidFilter = errors.New("Invalid filter")

+ var ErrItemNotFound = errors.New("database: item not found")

Aug 6, 2024

Changes in this version

type Album

+ ArtistName string

Jul 31, 2024

Changes in this version

+ func RunMigrateUp(db *Database) error

Jul 20, 2024

Changes in this version

+ func TrackQuery() *goqu.SelectDataset

+ type Scan interface

+ Scan func(dest ...any) error

type Track

+ Genres string

+ Tags string

+ func ScanTrack(scanner Scan) (Track, error)

Jul 9, 2024

Changes in this version

type Database

+ func (db *Database) GetAllUsers(ctx context.Context) ([]User, error)

Jun 18, 2024

Changes in this version

type AlbumChanges

+ ArtistId types.Change[string]

Jun 16, 2024

Changes in this version

+ func FullParseFilter(adapter filter.ResolverAdapter, filterStr string) (exp.Expression, error)

+ func TrackMapNameToId(typ string, name string) string

+ type AlbumResolverAdapter struct

+ func (a *AlbumResolverAdapter) GetDefaultSort() string

+ func (a *AlbumResolverAdapter) MapName(name string) (filter.Name, error)

+ func (a *AlbumResolverAdapter) MapNameToId(typ, name string) (string, error)

+ func (a *AlbumResolverAdapter) ResolveFunctionCall(resolver *filter.Resolver, name string, args []ast.Expr) (filter.FilterExpr, error)

+ func (a *AlbumResolverAdapter) ResolveTable(typ string) (filter.Table, error)

type Database

+ func (db *Database) AddGenreToTrack(ctx context.Context, genreId, trackId string) error

+ func (db *Database) CreateGenre(ctx context.Context, name string) (Genre, error)

+ func (db *Database) GetAllGenres(ctx context.Context) ([]Genre, error)

+ func (db *Database) GetGenreByName(ctx context.Context, name string) (Genre, error)

+ func (db *Database) GetTrackByNameAndAlbum(ctx context.Context, name string, albumId string) (Track, error)

+ func (db *Database) GetTrackGenres(ctx context.Context, trackId string) ([]Genre, error)

+ func (db *Database) Invalidate()

+ func (db *Database) RemoveGenreFromTrack(ctx context.Context, genreId, trackId string) error

+ type Genre struct

+ DisplayName string

+ Id string

+ Name string

type Tag

+ DisplayName string

+ type TrackResolverAdapter struct

+ func (a *TrackResolverAdapter) GetDefaultSort() string

+ func (a *TrackResolverAdapter) MapName(name string) (filter.Name, error)

+ func (a *TrackResolverAdapter) MapNameToId(typ, name string) (string, error)

+ func (a *TrackResolverAdapter) ResolveFunctionCall(resolver *filter.Resolver, name string, args []ast.Expr) (filter.FilterExpr, error)

+ func (a *TrackResolverAdapter) ResolveTable(typ string) (filter.Table, error)

Jun 5, 2024

Changes in this version

+ type Config struct

+ OwnerId string

+ type Connection interface

+ Exec func(query string, args ...any) (sql.Result, error)

+ Query func(query string, args ...any) (*sql.Rows, error)

+ QueryRow func(query string, args ...any) *sql.Row

+ type CreatePlaylistParams struct

+ Name string

+ OwnerId string

type Database

+ Conn Connection

+ RawConn *sql.DB

+ func Open(workDir types.WorkDir) (*Database, error)

+ func (db *Database) AddItemsToPlaylist(ctx context.Context, playlistId string, trackIds []string) error

+ func (db *Database) Begin() (*Database, *sql.Tx, error)

+ func (db *Database) CreateConfig(ctx context.Context, ownerId string) (Config, error)

+ func (db *Database) CreatePlaylist(ctx context.Context, params CreatePlaylistParams) (Playlist, error)

+ func (db *Database) CreateUser(ctx context.Context, username, password string) (User, error)

+ func (db *Database) DeleteItemsFromPlaylist(ctx context.Context, playlistId string, trackIndices []int) error

+ func (db *Database) GetAlbumByName(ctx context.Context, name string) (Album, error)

+ func (db *Database) GetConfig(ctx context.Context) (*Config, error)

+ func (db *Database) GetPlaylistById(ctx context.Context, id string) (Playlist, error)

+ func (db *Database) GetPlaylistItems(ctx context.Context, playlistId string) ([]PlaylistItem, error)

+ func (db *Database) GetPlaylistsByUser(ctx context.Context, userId string) ([]Playlist, error)

+ func (db *Database) GetTrackByName(ctx context.Context, name string) (Track, error)

+ func (db *Database) GetUserById(ctx context.Context, id string) (User, error)

+ func (db *Database) GetUserByUsername(ctx context.Context, username string) (User, error)

+ func (db *Database) MovePlaylistItem(ctx context.Context, playlistId string, trackId string, toIndex int) error

+ type Playlist struct

+ Id string

+ Name string

+ OwnerId string

+ type PlaylistItem struct

+ ItemIndex int

+ PlaylistId string

+ TrackId string

+ type User struct

+ Id string

+ Password string

+ Username string

Mar 17, 2024

Changes in this version

type Database

+ func (db *Database) GetAllTags(ctx context.Context) ([]Tag, error)

type TrackChanges

+ CoverArt types.Change[sql.NullString]

Mar 2, 2024

Changes in this version

type CreateTrackParams

+ Duration int

type Database

+ func (db *Database) AddTagToTrack(ctx context.Context, tagId, trackId string) error

+ func (db *Database) CreateTag(ctx context.Context, name string) (Tag, error)

+ func (db *Database) GetArtistByName(ctx context.Context, name string) (Artist, error)

+ func (db *Database) GetTagByName(ctx context.Context, name string) (Tag, error)

+ func (db *Database) GetTrackTags(ctx context.Context, trackId string) ([]Tag, error)

+ func (db *Database) RemoveTagFromTrack(ctx context.Context, tagId, trackId string) error

+ type Tag struct

+ Id string

+ Name string

type Track

+ Duration int

type TrackChanges

+ ArtistId types.Change[string]

+ Duration types.Change[int]

Mar 1, 2024

Changes in this version

+ type AlbumChanges struct

+ Available bool

+ CoverArt types.Change[sql.NullString]

+ Name types.Change[string]

+ type ArtistChanges struct

+ Available bool

+ Name types.Change[string]

+ Picture types.Change[sql.NullString]

type Database

+ func (db *Database) MarkAllAlbumsUnavailable(ctx context.Context) error

+ func (db *Database) MarkAllArtistsUnavailable(ctx context.Context) error

+ func (db *Database) MarkAllTracksUnavailable(ctx context.Context) error

+ func (db *Database) UpdateAlbum(ctx context.Context, id string, changes AlbumChanges) error

+ func (db *Database) UpdateArtist(ctx context.Context, id string, changes ArtistChanges) error

+ type TrackChanges struct

+ Available bool

+ BestQualityFile types.Change[string]

+ MobileQualityFile types.Change[string]

+ Name types.Change[string]

+ Number types.Change[int]

Feb 29, 2024

Changes in this version

type Album

+ ArtistId string

+ Id string

type Artist

+ Id string

type CreateAlbumParams

+ ArtistId string

type CreateTrackParams

+ AlbumId string

+ ArtistId string

+ type Database struct

+ func (db *Database) CreateAlbum(ctx context.Context, params CreateAlbumParams) (Album, error)

+ func (db *Database) CreateArtist(ctx context.Context, params CreateArtistParams) (Artist, error)

+ func (db *Database) CreateTrack(ctx context.Context, params CreateTrackParams) (Track, error)

+ func (db *Database) Exec(ctx context.Context, s ToSQL) (pgconn.CommandTag, error)

+ func (db *Database) GetAlbumById(ctx context.Context, id string) (Album, error)

+ func (db *Database) GetAlbumByPath(ctx context.Context, path string) (Album, error)

+ func (db *Database) GetAlbumsByArtist(ctx context.Context, artistId string) ([]Album, error)

+ func (db *Database) GetAllAlbums(ctx context.Context) ([]Album, error)

+ func (db *Database) GetAllArtists(ctx context.Context) ([]Artist, error)

+ func (db *Database) GetAllTracks(ctx context.Context) ([]Track, error)

+ func (db *Database) GetArtistById(ctx context.Context, id string) (Artist, error)

+ func (db *Database) GetArtistByPath(ctx context.Context, path string) (Artist, error)

+ func (db *Database) GetTrackById(ctx context.Context, id string) (Track, error)

+ func (db *Database) GetTrackByPath(ctx context.Context, path string) (Track, error)

+ func (db *Database) GetTracksByAlbum(ctx context.Context, albumId string) ([]Track, error)

+ func (db *Database) Query(ctx context.Context, s ToSQL) (pgx.Rows, error)

+ func (db *Database) QueryRow(ctx context.Context, s ToSQL) (pgx.Row, error)

+ func (db *Database) UpdateTrack(ctx context.Context, id, bestQualityFile, mobileQualityFile string) error

+ type ToSQL interface

+ ToSQL func() (string, []interface{}, error)

type Track

+ AlbumId string

+ AlbumName string

+ ArtistId string

+ ArtistName string

+ Id string

+ Number int

Jan 29, 2024

Changes in this version

type Album

+ Path string

type Artist

+ Path string

type CreateAlbumParams

+ Path string

type CreateArtistParams

+ Path string

type CreateTrackParams

+ Path string

type GetAllTracksRow

+ Path string

type GetTrackRow

+ Path string

type GetTracksByAlbumRow

+ Path string

type Queries

+ func (q *Queries) GetAlbumByPath(ctx context.Context, path string) (Album, error)

+ func (q *Queries) GetArtistByPath(ctx context.Context, path string) (Artist, error)

+ func (q *Queries) GetTrackByPath(ctx context.Context, path string) (Track, error)

type Track

+ Path string

Jan 24, 2024

Changes in this version

+ type GetAlbumsByArtistAndNameParams struct

+ ArtistID string

+ Name string

type Queries

+ func (q *Queries) GetAlbumsByArtistAndName(ctx context.Context, arg GetAlbumsByArtistAndNameParams) ([]Album, error)

Jan 23, 2024

Changes in this version

type Queries

+ func (q *Queries) GetArtistByName(ctx context.Context, name string) ([]Artist, error)

Jan 20, 2024

Changes in this version

+ type Album struct

+ ArtistID string

+ CoverArt string

+ ID string

+ Name string

+ type Artist struct

+ ID string

+ Name string

+ Picture string

+ type CreateAlbumParams struct

+ ArtistID string

+ CoverArt string

+ ID string

+ Name string

+ type CreateArtistParams struct

+ ID string

+ Name string

+ Picture string

+ type CreateTrackParams struct

+ AlbumID string

+ ArtistID string

+ BestQualityFile string

+ CoverArt string

+ ID string

+ MobileQualityFile string

+ Name string

+ TrackNumber int32

+ type DBTX interface

+ Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error)

+ Query func(context.Context, string, ...interface{}) (pgx.Rows, error)

+ QueryRow func(context.Context, string, ...interface{}) pgx.Row

+ type GetAllTracksRow struct

+ AlbumID string

+ AlbumName pgtype.Text

+ ArtistID string

+ ArtistName pgtype.Text

+ BestQualityFile string

+ CoverArt string

+ ID string

+ MobileQualityFile string

+ Name string

+ TrackNumber int32

+ type GetTrackRow struct

+ AlbumID string

+ AlbumName pgtype.Text

+ ArtistID string

+ ArtistName pgtype.Text

+ BestQualityFile string

+ CoverArt string

+ ID string

+ MobileQualityFile string

+ Name string

+ TrackNumber int32

+ type GetTracksByAlbumRow struct

+ AlbumID string

+ AlbumName pgtype.Text

+ ArtistID string

+ ArtistName pgtype.Text

+ BestQualityFile string

+ CoverArt string

+ ID string

+ MobileQualityFile string

+ Name string

+ TrackNumber int32

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CreateAlbum(ctx context.Context, arg CreateAlbumParams) (Album, error)

+ func (q *Queries) CreateArtist(ctx context.Context, arg CreateArtistParams) (Artist, error)

+ func (q *Queries) CreateTrack(ctx context.Context, arg CreateTrackParams) (Track, error)

+ func (q *Queries) DeleteAllAlbums(ctx context.Context) error

+ func (q *Queries) DeleteAllArtists(ctx context.Context) error

+ func (q *Queries) DeleteAllTracks(ctx context.Context) error

+ func (q *Queries) GetAlbum(ctx context.Context, id string) (Album, error)

+ func (q *Queries) GetAlbumsByArtist(ctx context.Context, artistID string) ([]Album, error)

+ func (q *Queries) GetAllAlbums(ctx context.Context) ([]Album, error)

+ func (q *Queries) GetAllArtists(ctx context.Context) ([]Artist, error)

+ func (q *Queries) GetAllTracks(ctx context.Context) ([]GetAllTracksRow, error)

+ func (q *Queries) GetArtist(ctx context.Context, id string) (Artist, error)

+ func (q *Queries) GetTrack(ctx context.Context, id string) (GetTrackRow, error)

+ func (q *Queries) GetTracksByAlbum(ctx context.Context, albumID string) ([]GetTracksByAlbumRow, error)

+ func (q *Queries) WithTx(tx pgx.Tx) *Queries

+ type Track struct

+ AlbumID string

+ ArtistID string

+ BestQualityFile string

+ CoverArt string

+ ID string

+ MobileQualityFile string

+ Name string

+ TrackNumber int32