From 661e5f1e714dd2c5e18a97c4dd5d065d7bc71998 Mon Sep 17 00:00:00 2001 From: Marcel van der Veldt Date: Wed, 8 Jan 2025 00:20:57 +0100 Subject: [PATCH] temp fix on recently played query to avoid too many queries --- music_assistant/controllers/music.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/music_assistant/controllers/music.py b/music_assistant/controllers/music.py index 65a106c2..1a5f6ec7 100644 --- a/music_assistant/controllers/music.py +++ b/music_assistant/controllers/music.py @@ -463,9 +463,11 @@ class MusicController(CoreController): if media_types is None: media_types = MediaType.ALL media_types_str = "(" + ",".join(f'"{x}"' for x in media_types) + ")" + # temporary fix to avoid too many queries on providers: + # we only query for library items for now query = ( - f"SELECT * FROM {DB_TABLE_PLAYLOG} WHERE media_type " - f"in {media_types_str} ORDER BY timestamp DESC" + f"SELECT * FROM {DB_TABLE_PLAYLOG} WHERE provider = 'library' " + f"AND media_type in {media_types_str} ORDER BY timestamp DESC" ) db_rows = await self.mass.music.database.get_rows_from_query(query, limit=limit) result: list[MediaItemType] = [] -- 2.34.1