From 5d3be01a220403cc821f255445ee70dbcaa12ba6 Mon Sep 17 00:00:00 2001 From: Carl Hetherington Date: Sat, 24 Jan 2026 17:25:42 +0100 Subject: Delete SPL entries when deleting the SPL. --- src/lib/show_playlist_list.cc | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/src/lib/show_playlist_list.cc b/src/lib/show_playlist_list.cc index 6dfbbad29..901f537ff 100644 --- a/src/lib/show_playlist_list.cc +++ b/src/lib/show_playlist_list.cc @@ -114,9 +114,13 @@ ShowPlaylistList::update_show_playlist(ShowPlaylistID id, ShowPlaylist const& pl void ShowPlaylistList::remove_show_playlist(ShowPlaylistID id) { - SQLiteStatement statement(_db, "DELETE FROM show_playlists WHERE ID=?"); - statement.bind_int64(1, id.get()); - statement.execute(); + SQLiteStatement playlists(_db, "DELETE FROM show_playlists WHERE ID=?"); + playlists.bind_int64(1, id.get()); + playlists.execute(); + + SQLiteStatement entries(_db, "DELETE FROM entries WHERE show_playlist=?"); + entries.bind_int64(1, id.get()); + entries.execute(); } -- cgit v1.2.3