mirror of
https://github.com/navidrome/navidrome.git
synced 2025-08-14 14:31:15 +03:00
* fix: enable library access for headless processes Fixed multi-library filtering to allow headless processes (shares, external providers) to access data by skipping library restrictions when no user context is present. Previously, the library filtering system returned empty results (WHERE 1=0) for processes without user authentication, breaking functionality like public shares and external service integrations. Key changes: - Modified applyLibraryFilter methods to skip filtering when user.ID == invalidUserId - Refactored tag repository to use helper method for library filtering logic - Fixed SQL aggregation bug in tag statistics calculation across multiple libraries - Added comprehensive test coverage for headless process scenarios - Updated genre repository to support proper column mappings for aggregated data This preserves the secure "safe by default" approach for authenticated users while restoring backward compatibility for background processes that need unrestricted data access. Signed-off-by: Deluan <deluan@navidrome.org> * fix: resolve SQL ambiguity errors in share queries Fixed SQL ambiguity errors that were breaking share links after the Multi-library PR. The Multi-library changes introduced JOINs between album and library tables, both of which have 'id' columns, causing 'ambiguous column name: id' errors when unqualified column references were used in WHERE clauses. Changes made: - Updated core/share.go to use 'album.id' instead of 'id' in contentsLabelFromAlbums - Updated persistence/share_repository.go to use 'album.id' in album share loading - Updated persistence/sql_participations.go to use 'artist.id' for consistency - Added regression tests to prevent future SQL ambiguity issues This resolves HTTP 500 errors that users experienced when accessing existing share URLs after the Multi-library feature was merged. Signed-off-by: Deluan <deluan@navidrome.org> * fix: improve headless library access handling Added proper user context validation and reordered joins in applyLibraryFilterToArtistQuery to ensure library filtering works correctly for both authenticated and headless operations. The user_library join is now only applied when a valid user context exists, while the library_artist join is always applied to maintain proper data relationships. (+1 squashed commit) Squashed commits: [a28c6965b] fix: remove headless library access guard Removed the invalidUserId guard condition in applyLibraryFilterToArtistQuery that was preventing proper library filtering for headless operations. This fix ensures that library filtering joins are always applied consistently, allowing headless library access to work correctly with the library_artist junction table filtering. The previous guard was skipping all library filtering when no user context was present, which could cause issues with headless operations that still need to respect library boundaries through the library_artist relationship. * fix: simplify genre selection query in genre repository Signed-off-by: Deluan <deluan@navidrome.org> * fix: enhance tag library filtering tests for headless access Signed-off-by: Deluan <deluan@navidrome.org> * test: add comprehensive test coverage for headless library access Added extensive test coverage for headless library access improvements including: - Added 17 new tests across 4 test files covering headless access scenarios - artist_repository_test.go: Added headless process tests for GetAll, Count, Get operations and explicit library_id filtering functionality - genre_repository_test.go: Added library filtering tests for headless processes including GetAll, Count, ReadAll, and Read operations - sql_base_repository_test.go: Added applyLibraryFilter method tests covering admin users, regular users, and headless processes with/without custom table names - share_repository_test.go: Added headless access tests and SQL ambiguity verification for the album.id vs id fix in loadMedia function - Cleaned up test setup by replacing log.NewContext usage with GinkgoT().Context() and removing unnecessary configtest.SetupConfig() calls for better test isolation These tests ensure that headless processes (background operations without user context) can access all libraries while respecting explicit filters, and verify that the SQL ambiguity fixes work correctly without breaking existing functionality. * revert: remove user context handling from scrobble buffer getParticipants Reverts commit 5b8ef74f05109ecf30ddfc936361b84314522869. The artist repository no longer requires user context for proper library filtering, so the workaround of temporarily injecting user context into the scrobbleBufferRepository.Next method is no longer needed. This simplifies the code and removes the dependency on fetching user information during background scrobbling operations. * fix: improve library access filtering for artists Enhanced artist repository filtering to properly handle library access restrictions and prevent artists with no accessible content from appearing in results. Backend changes: - Modified roleFilter to use direct JSON_EXTRACT instead of EXISTS subquery for better performance - Enhanced applyLibraryFilterToArtistQuery to filter out artists with empty stats (no content) - Changed from LEFT JOIN to INNER JOIN with library_artist table for stricter filtering - Added condition to exclude artists where library_artist.stats = '{}' (empty content) Frontend changes: - Added null-checking in getCounter function to prevent TypeError when accessing undefined records - Improved optional chaining for safer property access in role-based statistics display These changes ensure that users only see artists that have actual accessible content in their permitted libraries, fixing issues where artists appeared in the list despite having no albums or songs available to the user. * fix: update library access logic for non-admin users and enhance test coverage Signed-off-by: Deluan <deluan@navidrome.org> * fix: refine library artist query and implement cleanup for empty entries Signed-off-by: Deluan <deluan@navidrome.org> * refactor: consolidate artist repository tests to eliminate duplication Significantly refactored artist_repository_test.go to reduce code duplication and improve maintainability by ~27% (930 to 680 lines). Key improvements include: - Added test helper functions createTestArtistWithMBID() and createUserWithLibraries() to eliminate repetitive test data creation - Consolidated duplicate MBID search tests using DescribeTable for parameterized testing - Removed entire 'Permission-Based Behavior Comparison' section (~150 lines) that duplicated functionality already covered in other test contexts - Reorganized search tests into cohesive 'MBID and Text Search' section with proper setup/teardown and shared test infrastructure - Streamlined missing artist tests and moved them to dedicated section - Maintained 100% test coverage while eliminating redundant test patterns All tests continue to pass with identical functionality and coverage. --------- Signed-off-by: Deluan <deluan@navidrome.org>
258 lines
6.7 KiB
Go
258 lines
6.7 KiB
Go
package model
|
|
|
|
import (
|
|
"cmp"
|
|
"crypto/md5"
|
|
"fmt"
|
|
"slices"
|
|
"strings"
|
|
|
|
"github.com/navidrome/navidrome/model/id"
|
|
"github.com/navidrome/navidrome/utils/slice"
|
|
)
|
|
|
|
type Tag struct {
|
|
ID string `json:"id,omitempty"`
|
|
TagName TagName `json:"tagName,omitempty"`
|
|
TagValue string `json:"tagValue,omitempty"`
|
|
AlbumCount int `json:"albumCount,omitempty"`
|
|
SongCount int `json:"songCount,omitempty"`
|
|
}
|
|
|
|
type TagList []Tag
|
|
|
|
func (l TagList) GroupByFrequency() Tags {
|
|
grouped := map[string]map[string]int{}
|
|
values := map[string]string{}
|
|
for _, t := range l {
|
|
if m, ok := grouped[string(t.TagName)]; !ok {
|
|
grouped[string(t.TagName)] = map[string]int{t.ID: 1}
|
|
} else {
|
|
m[t.ID]++
|
|
}
|
|
values[t.ID] = t.TagValue
|
|
}
|
|
|
|
tags := Tags{}
|
|
for name, counts := range grouped {
|
|
idList := make([]string, 0, len(counts))
|
|
for tid := range counts {
|
|
idList = append(idList, tid)
|
|
}
|
|
slices.SortFunc(idList, func(a, b string) int {
|
|
return cmp.Or(
|
|
cmp.Compare(counts[b], counts[a]),
|
|
cmp.Compare(values[a], values[b]),
|
|
)
|
|
})
|
|
tags[TagName(name)] = slice.Map(idList, func(id string) string { return values[id] })
|
|
}
|
|
return tags
|
|
}
|
|
|
|
func (t Tag) String() string {
|
|
return fmt.Sprintf("%s=%s", t.TagName, t.TagValue)
|
|
}
|
|
|
|
func NewTag(name TagName, value string) Tag {
|
|
name = name.ToLower()
|
|
hashID := tagID(name, value)
|
|
return Tag{
|
|
ID: hashID,
|
|
TagName: name,
|
|
TagValue: value,
|
|
}
|
|
}
|
|
|
|
func tagID(name TagName, value string) string {
|
|
return id.NewTagID(string(name), value)
|
|
}
|
|
|
|
type RawTags map[string][]string
|
|
|
|
type Tags map[TagName][]string
|
|
|
|
func (t Tags) Values(name TagName) []string {
|
|
return t[name]
|
|
}
|
|
|
|
func (t Tags) IDs() []string {
|
|
var ids []string
|
|
for name, tag := range t {
|
|
name = name.ToLower()
|
|
for _, v := range tag {
|
|
ids = append(ids, tagID(name, v))
|
|
}
|
|
}
|
|
return ids
|
|
}
|
|
|
|
func (t Tags) Flatten(name TagName) TagList {
|
|
var tags TagList
|
|
for _, v := range t[name] {
|
|
tags = append(tags, NewTag(name, v))
|
|
}
|
|
return tags
|
|
}
|
|
|
|
func (t Tags) FlattenAll() TagList {
|
|
var tags TagList
|
|
for name, values := range t {
|
|
for _, v := range values {
|
|
tags = append(tags, NewTag(name, v))
|
|
}
|
|
}
|
|
return tags
|
|
}
|
|
|
|
func (t Tags) Sort() {
|
|
for _, values := range t {
|
|
slices.Sort(values)
|
|
}
|
|
}
|
|
|
|
func (t Tags) Hash() []byte {
|
|
if len(t) == 0 {
|
|
return nil
|
|
}
|
|
ids := t.IDs()
|
|
slices.Sort(ids)
|
|
sum := md5.New()
|
|
sum.Write([]byte(strings.Join(ids, "|")))
|
|
return sum.Sum(nil)
|
|
}
|
|
|
|
func (t Tags) ToGenres() (string, Genres) {
|
|
values := t.Values("genre")
|
|
if len(values) == 0 {
|
|
return "", nil
|
|
}
|
|
genres := slice.Map(values, func(g string) Genre {
|
|
t := NewTag("genre", g)
|
|
return Genre{ID: t.ID, Name: g}
|
|
})
|
|
return genres[0].Name, genres
|
|
}
|
|
|
|
// Merge merges the tags from another Tags object into this one, removing any duplicates
|
|
func (t Tags) Merge(tags Tags) {
|
|
for name, values := range tags {
|
|
for _, v := range values {
|
|
t.Add(name, v)
|
|
}
|
|
}
|
|
}
|
|
|
|
func (t Tags) Add(name TagName, v string) {
|
|
for _, existing := range t[name] {
|
|
if existing == v {
|
|
return
|
|
}
|
|
}
|
|
t[name] = append(t[name], v)
|
|
}
|
|
|
|
type TagRepository interface {
|
|
Add(libraryID int, tags ...Tag) error
|
|
UpdateCounts() error
|
|
}
|
|
|
|
type TagName string
|
|
|
|
func (t TagName) ToLower() TagName {
|
|
return TagName(strings.ToLower(string(t)))
|
|
}
|
|
|
|
func (t TagName) String() string {
|
|
return string(t)
|
|
}
|
|
|
|
// Tag names, as defined in the mappings.yaml file
|
|
const (
|
|
TagAlbum TagName = "album"
|
|
TagTitle TagName = "title"
|
|
TagTrackNumber TagName = "track"
|
|
TagDiscNumber TagName = "disc"
|
|
TagTotalTracks TagName = "tracktotal"
|
|
TagTotalDiscs TagName = "disctotal"
|
|
TagDiscSubtitle TagName = "discsubtitle"
|
|
TagSubtitle TagName = "subtitle"
|
|
TagGenre TagName = "genre"
|
|
TagMood TagName = "mood"
|
|
TagComment TagName = "comment"
|
|
TagAlbumSort TagName = "albumsort"
|
|
TagAlbumVersion TagName = "albumversion"
|
|
TagTitleSort TagName = "titlesort"
|
|
TagCompilation TagName = "compilation"
|
|
TagGrouping TagName = "grouping"
|
|
TagLyrics TagName = "lyrics"
|
|
TagRecordLabel TagName = "recordlabel"
|
|
TagReleaseType TagName = "releasetype"
|
|
TagReleaseCountry TagName = "releasecountry"
|
|
TagMedia TagName = "media"
|
|
TagCatalogNumber TagName = "catalognumber"
|
|
TagISRC TagName = "isrc"
|
|
TagBPM TagName = "bpm"
|
|
TagExplicitStatus TagName = "explicitstatus"
|
|
|
|
// Dates and years
|
|
|
|
TagOriginalDate TagName = "originaldate"
|
|
TagReleaseDate TagName = "releasedate"
|
|
TagRecordingDate TagName = "recordingdate"
|
|
|
|
// Artists and roles
|
|
|
|
TagAlbumArtist TagName = "albumartist"
|
|
TagAlbumArtists TagName = "albumartists"
|
|
TagAlbumArtistSort TagName = "albumartistsort"
|
|
TagAlbumArtistsSort TagName = "albumartistssort"
|
|
TagTrackArtist TagName = "artist"
|
|
TagTrackArtists TagName = "artists"
|
|
TagTrackArtistSort TagName = "artistsort"
|
|
TagTrackArtistsSort TagName = "artistssort"
|
|
TagComposer TagName = "composer"
|
|
TagComposerSort TagName = "composersort"
|
|
TagLyricist TagName = "lyricist"
|
|
TagLyricistSort TagName = "lyricistsort"
|
|
TagDirector TagName = "director"
|
|
TagProducer TagName = "producer"
|
|
TagEngineer TagName = "engineer"
|
|
TagMixer TagName = "mixer"
|
|
TagRemixer TagName = "remixer"
|
|
TagDJMixer TagName = "djmixer"
|
|
TagConductor TagName = "conductor"
|
|
TagArranger TagName = "arranger"
|
|
TagPerformer TagName = "performer"
|
|
|
|
// ReplayGain
|
|
|
|
TagReplayGainAlbumGain TagName = "replaygain_album_gain"
|
|
TagReplayGainAlbumPeak TagName = "replaygain_album_peak"
|
|
TagReplayGainTrackGain TagName = "replaygain_track_gain"
|
|
TagReplayGainTrackPeak TagName = "replaygain_track_peak"
|
|
TagR128AlbumGain TagName = "r128_album_gain"
|
|
TagR128TrackGain TagName = "r128_track_gain"
|
|
|
|
// MusicBrainz
|
|
|
|
TagMusicBrainzArtistID TagName = "musicbrainz_artistid"
|
|
TagMusicBrainzRecordingID TagName = "musicbrainz_recordingid"
|
|
TagMusicBrainzTrackID TagName = "musicbrainz_trackid"
|
|
TagMusicBrainzAlbumArtistID TagName = "musicbrainz_albumartistid"
|
|
TagMusicBrainzAlbumID TagName = "musicbrainz_albumid"
|
|
TagMusicBrainzReleaseGroupID TagName = "musicbrainz_releasegroupid"
|
|
|
|
TagMusicBrainzComposerID TagName = "musicbrainz_composerid"
|
|
TagMusicBrainzLyricistID TagName = "musicbrainz_lyricistid"
|
|
TagMusicBrainzDirectorID TagName = "musicbrainz_directorid"
|
|
TagMusicBrainzProducerID TagName = "musicbrainz_producerid"
|
|
TagMusicBrainzEngineerID TagName = "musicbrainz_engineerid"
|
|
TagMusicBrainzMixerID TagName = "musicbrainz_mixerid"
|
|
TagMusicBrainzRemixerID TagName = "musicbrainz_remixerid"
|
|
TagMusicBrainzDJMixerID TagName = "musicbrainz_djmixerid"
|
|
TagMusicBrainzConductorID TagName = "musicbrainz_conductorid"
|
|
TagMusicBrainzArrangerID TagName = "musicbrainz_arrangerid"
|
|
TagMusicBrainzPerformerID TagName = "musicbrainz_performerid"
|
|
)
|