using MySqlConnector;
using Sony.Filtr.Playlists.Spotify.Model;
using Sony.Filtr.Utility.Extensions;
using System.Data.Common;

namespace Sony.Filtr.Playlists.Extensions
{
    public static class DbDataReaderExtensions
    {
        public static SpotifyTrackAnalyzeData ToSpotifyTrackAnalyzeData(this MySqlDataReader reader)
        {
            var track = new SpotifyTrackAnalyzeData
            { 
                AddedAt = reader.GetUtcDateTime("Added"),
                Album = new SpotifyAlbumAnalyzeData
                { 
                    ImageFileName = reader.GetSafeString("SmallImageFilename"),
                    Upc = reader.GetSafeString("Upc"),
                    Id = reader.GetSafeString("AlbumId")
                },
                Isrc = reader.GetSafeString("ISRC"),
                Popularity = reader.GetInt32("Popularity"),
                TrackId = reader.GetSafeString("TrackId"),
                TrackName = reader.GetSafeString("TrackName"),
                PlaylistIndex = reader.GetInt32("PlaylistIndex")
            };

            track.Artists.Add(new SpotifyArtistAnalyzeData 
            {
                Name = reader.GetSafeString("ArtistName"),
                Id = reader.GetSafeString("ArtistId")
            });

            return track;
        }
    }
}