diff options
| author | Carl Hetherington <cth@carlh.net> | 2026-01-24 17:25:42 +0100 |
|---|---|---|
| committer | Carl Hetherington <cth@carlh.net> | 2026-04-25 12:55:26 +0200 |
| commit | 764d4d84cc65bd452f9df96eacae1e3353d43818 (patch) | |
| tree | 385c191c75489937c46ea9293f9d0bef9ad6b3b9 | |
| parent | 3986d2465b8e68ef97175751ecbc05f1585c6df4 (diff) | |
Delete SPL entries when deleting the SPL.
| -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(); } |