using System;
using System.Linq;
using Newtonsoft.Json;
using NodaTime;
using Sony.Filtr.Contracts.Abstractions;

namespace Sony.Filtr.SpotifyAnalytics.Data
{
    [PetaPoco.TableName("tblSpotifyTrackStreams")]
    public class SpotifyTrackStream : IAggregatedStreamFormat
    {
        [PetaPoco.Column("DistributerId")]
        public int DistributerId { get; set; }

        [PetaPoco.Column("Date")]
        [JsonProperty("date")]
        public LocalDate date { get; set; }

        [PetaPoco.Column("CountryCode")]
        [JsonProperty("country_code")]
        public string country_code { get; set; }

        [PetaPoco.Column("ReportCountryCode")]
        [JsonProperty("report_country_code")]
        public string report_country_code { get; set; }

        [PetaPoco.Column("Isrc")]
        [JsonProperty("isrc")]
        public string isrc { get; set; }

        [PetaPoco.Column("ReportDate")]
        [JsonProperty("report_date")]
        public LocalDate report_date { get; set; }
        
        [PetaPoco.Column("DeviceTypePersonalComputer")]
        [JsonProperty("device_type_personal_computer")]
        public int device_type_personal_computer { get; set; }

        [PetaPoco.Column("DeviceTypeCellPhone")]
        [JsonProperty("device_type_cell_phone")]
        public int device_type_cell_phone { get; set; }

        [PetaPoco.Column("DeviceTypeTablet")]
        [JsonProperty("device_type_tablet")]
        public int device_type_tablet { get; set; }

        [PetaPoco.Column("DeviceTypeGamingConsole")]
        [JsonProperty("device_type_gaming_console")]
        public int device_type_gaming_console { get; set; }

        [PetaPoco.Column("DeviceTypeSmartTvDevice")]
        [JsonProperty("device_type_smart_tv_device")]
        public int device_type_smart_tv_device { get; set; }

        [PetaPoco.Column("DeviceTypeConnectedAudioDevice")]
        [JsonProperty("device_type_connected_audio_device")]
        public int device_type_connected_audio_device { get; set; }

        [PetaPoco.Column("DeviceTypeBuiltinCarApplication")]
        [JsonProperty("device_type_builtin_car_application")]
        public int device_type_builtin_car_application { get; set; }

        [PetaPoco.Column("DeviceTypeOther")]
        [JsonProperty("device_type_other")]
        public int device_type_other { get; set; }

        [PetaPoco.Column("DeviceOsAndroid")]
        [JsonProperty("device_os_android")]
        public int device_os_android { get; set; }

        [PetaPoco.Column("DeviceOsBlackberry")]
        [JsonProperty("device_os_blackberry")]
        public int device_os_blackberry { get; set; }

        [PetaPoco.Column("DeviceOsBrowser")]
        [JsonProperty("device_os_browser")]
        public int device_os_browser { get; set; }

        [PetaPoco.Column("DeviceOsIos")]
        [JsonProperty("device_os_ios")]
        public int device_os_ios { get; set; }

        [PetaPoco.Column("DeviceOsLinux")]
        [JsonProperty("device_os_linux")]
        public int device_os_linux { get; set; }

        [PetaPoco.Column("DeviceOsMac")]
        [JsonProperty("device_os_mac")]
        public int device_os_mac { get; set; }

        [PetaPoco.Column("DeviceOsOther")]
        [JsonProperty("device_os_other")]
        public int device_os_other { get; set; }

        [PetaPoco.Column("DeviceOsWindows")]
        [JsonProperty("device_os_windows")]
        public int device_os_windows { get; set; }

        [PetaPoco.Column("RepeatPlay")]
        [JsonProperty("repeat_play")]
        public int repeat_play { get; set; }

        [PetaPoco.Column("ShufflePlay")]
        [JsonProperty("shuffle_play")]
        public int shuffle_play { get; set; }

        [PetaPoco.Column("SourceAlbum")]
        [JsonProperty("source_album")]
        public int source_album { get; set; }

        [PetaPoco.Column("SourceArtist")]
        [JsonProperty("source_artist")]
        public int source_artist { get; set; }

        [PetaPoco.Column("SourceChart")]
        [JsonProperty("source_chart")]
        public int source_chart { get; set; }

        [PetaPoco.Column("SourceCollection")]
        [JsonProperty("source_collection")]
        public int source_collection { get; set; }

        [PetaPoco.Column("SourceOther")]
        [JsonProperty("source_other")]
        public int source_other { get; set; }

        [PetaPoco.Column("SourceOthersPlaylist")]
        [JsonProperty("source_others_playlist")]
        public int source_others_playlist { get; set; }

        [PetaPoco.Column("SourceRadio")]
        [JsonProperty("source_radio")]
        public int source_radio { get; set; }

        [PetaPoco.Column("SourceSearch")]
        [JsonProperty("source_search")]
        public int source_search { get; set; }

        [PetaPoco.Column("Streams")]
        [JsonProperty("streams")]
        public int streams { get; set; }


    }
}