mirror of
https://github.com/navidrome/navidrome.git
synced 2026-08-01 07:21:17 +00:00
9ce51cf575
Backfill enumerated every album, artist, playlist and radio via GetAll and mapped out just the ID. GetAll materializes full entities (library joins, participant/stats/tags JSON, annotation, artwork hydration), so on a large library it loaded tens of thousands of heavy structs only to read one field each — spiking transient RSS to ~1GB during the one-time upgrade backfill, a memory risk on small NAS/Pi hardware. Add GetAllIDs to the album, artist, playlist and radio repositories: it reuses each repo's base row-set filter (library visibility, artist content join, playlist userFilter) but projects only id, skipping the heavy columns and post-processing. A per-repo parity test asserts GetAllIDs returns exactly the same id set as GetAll. Verified on a 727MB / 29k-artist production DB copy: peak RSS during backfill dropped from ~1012MB to ~89MB, file descriptors flat, same 36,138 items enqueued.
38 lines
1.1 KiB
Go
38 lines
1.1 KiB
Go
package model
|
|
|
|
import (
|
|
"time"
|
|
|
|
"github.com/navidrome/navidrome/consts"
|
|
)
|
|
|
|
type Radio struct {
|
|
ID string `structs:"id" json:"id"`
|
|
StreamUrl string `structs:"stream_url" json:"streamUrl"`
|
|
Name string `structs:"name" json:"name"`
|
|
HomePageUrl string `structs:"home_page_url" json:"homePageUrl"`
|
|
UploadedImage string `structs:"uploaded_image" json:"uploadedImage,omitempty"`
|
|
CreatedAt time.Time `structs:"created_at" json:"createdAt"`
|
|
UpdatedAt time.Time `structs:"updated_at" json:"updatedAt"`
|
|
}
|
|
|
|
func (r Radio) CoverArtID() ArtworkID {
|
|
return artworkIDFromRadio(r)
|
|
}
|
|
|
|
func (r Radio) UploadedImagePath() string {
|
|
return UploadedImagePath(consts.EntityRadio, r.UploadedImage)
|
|
}
|
|
|
|
type Radios []Radio
|
|
|
|
type RadioRepository interface {
|
|
ResourceRepository
|
|
CountAll(options ...QueryOptions) (int64, error)
|
|
Delete(id string) error
|
|
Get(id string) (*Radio, error)
|
|
GetAll(options ...QueryOptions) (Radios, error)
|
|
GetAllIDs(options ...QueryOptions) ([]string, error)
|
|
Put(u *Radio, colsToUpdate ...string) error
|
|
}
|