diff options
| author | Carl Hetherington <cth@carlh.net> | 2026-01-24 17:25:42 +0100 |
|---|---|---|
| committer | Carl Hetherington <cth@carlh.net> | 2026-02-03 21:37:04 +0100 |
| commit | 46cd465561ae8a431c306cfdb7357fd7329a1420 (patch) | |
| tree | c03bad70fe5b6b2e474a02d19da6469272f9314a /src | |
| parent | ccc67d2e11d87b64d5921148ee0af888a152d98a (diff) | |
Delete SPL entries when deleting the SPL.
Diffstat (limited to 'src')
| -rw-r--r-- | src/lib/show_playlist_list.cc | 10 |
1 files 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(); } |