mirror of
https://github.com/navidrome/navidrome.git
synced 2025-07-16 16:41:16 +03:00
bfa5b29913
* feat(subsonic): search by MBID functionality Updated the search methods in the mediaFileRepository, albumRepository, and artistRepository to support searching by MBID in addition to the existing query methods. This change improves the efficiency of media file, album, and artist searches, allowing for faster retrieval of records based on MBID. Signed-off-by: Deluan <deluan@navidrome.org> * feat(subsonic): enhance MBID search functionality for albums and artists Updated the search functionality to support searching by MBID for both albums and artists. The fullTextFilter function was modified to accept additional MBID fields, allowing for more comprehensive searches. New tests were added to ensure that the search functionality correctly handles MBID queries, including cases for missing entries and the includeMissing parameter. This enhancement improves the overall search capabilities of the application, making it easier for users to find specific media items by their unique identifiers. Signed-off-by: Deluan <deluan@navidrome.org> * fix(subsonic): normalize MBID to lowercase for consistent querying Updated the MBID handling in the SQL search logic to convert the input to lowercase before executing the query. This change ensures that searches are case-insensitive, improving the accuracy and reliability of the search results when querying by MBID. Signed-off-by: Deluan <deluan@navidrome.org> --------- Signed-off-by: Deluan <deluan@navidrome.org>
28 lines
655 B
SQL
28 lines
655 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
|
|
-- Add indexes for MBID fields to improve lookup performance
|
|
-- Artists table
|
|
create index if not exists artist_mbz_artist_id
|
|
on artist (mbz_artist_id);
|
|
|
|
-- Albums table
|
|
create index if not exists album_mbz_album_id
|
|
on album (mbz_album_id);
|
|
|
|
-- Media files table
|
|
create index if not exists media_file_mbz_release_track_id
|
|
on media_file (mbz_release_track_id);
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
|
|
-- Remove MBID indexes
|
|
drop index if exists artist_mbz_artist_id;
|
|
drop index if exists album_mbz_album_id;
|
|
drop index if exists media_file_mbz_release_track_id;
|
|
|
|
-- +goose StatementEnd
|