Method get_song_from_queryable

src-tauri/database/src/database.rs:674–713

(
        &self,
        conn: &mut PooledConnection<ConnectionManager<LoggingConnection<SqliteConnection>>>,
        s: QueryableSong,
    )

    }

    fn get_song_from_queryable(
        &self,
        conn: &mut PooledConnection<ConnectionManager<LoggingConnection<SqliteConnection>>>,
        s: QueryableSong,
    ) -> Result<Song> {
        let mut album: Option<QueryableAlbum> = None;
        let mut artist: Vec<QueryableArtist> = vec![];
        let mut genre: Vec<QueryableGenre> = vec![];

        let album_data =
            QueryDsl::filter(album_bridge, schema::album_bridge::song.eq(s._id.clone()))
                .first::<AlbumBridge>(conn);

        if let Ok(album_data) = album_data {
            album = Some(QueryDsl::filter(albums, album_id.eq(album_data.album)).first(conn)?);
        }

        let artist_data =
            QueryDsl::filter(artist_bridge, schema::artist_bridge::song.eq(s._id.clone()))
                .first::<ArtistBridge>(conn);

        if let Ok(artist_data) = artist_data {
            artist = QueryDsl::filter(artists, artist_id.eq(artist_data.artist)).load(conn)?;
        }

        let genre_data =
            QueryDsl::filter(genre_bridge, schema::genre_bridge::song.eq(s._id.clone()))
                .first::<GenreBridge>(conn);

        if let Ok(genre_data) = genre_data {
            genre = QueryDsl::filter(genres, genre_id.eq(genre_data.genre)).load(conn)?;
        }

        Ok(Song {
            song: s,
            album,
            artists: Some(artist),
            genre: Some(genre),
        })
    }

    #[tracing::instrument(level = "debug", skip(self))]
    pub fn get_songs_by_options(&self, options: GetSongOptions) -> Result<Vec<Song>> {