Method remove_songs

src-tauri/database/src/database.rs:296–341

(&self, ids: Vec<String>)

    // TODO: Remove album
    #[tracing::instrument(level = "debug", skip(self))]
    pub fn remove_songs(&self, ids: Vec<String>) -> Result<()> {
        trace!("Removing song");
        self.pool
            .get()
            .unwrap()
            .transaction::<(), MoosyncError, _>(|conn| {
                for id in ids {
                    // First delete analytics data to avoid foreign key constraint violations
                    delete(QueryDsl::filter(
                        analytics,
                        schema::analytics::song_id.eq(id.clone()),
                    ))
                    .execute(conn)?;

                    // Then delete bridge references
                    delete(QueryDsl::filter(
                        album_bridge,
                        schema::album_bridge::song.eq(id.clone()),
                    ))
                    .execute(conn)?;
                    delete(QueryDsl::filter(
                        artist_bridge,
                        schema::artist_bridge::song.eq(id.clone()),
                    ))
                    .execute(conn)?;
                    delete(QueryDsl::filter(
                        genre_bridge,
                        schema::genre_bridge::song.eq(id.clone()),
                    ))
                    .execute(conn)?;
                    delete(QueryDsl::filter(
                        playlist_bridge,
                        schema::playlist_bridge::song.eq(id.clone()),
                    ))
                    .execute(conn)?;

                    // Finally delete the song itself
                    delete(QueryDsl::filter(allsongs, _id.eq(id.clone()))).execute(conn)?;
                }
                Ok(())
            })?;

        info!("Removed song");

        Ok(())
    }

    #[tracing::instrument(level = "debug", skip(self, song))]
    pub fn update_song(&self, song: QueryableSong) -> Result<()> {