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

namespace Sony.Filtr.AppleMusic.Data.Streams
{
    [PetaPoco.TableName("tblAppleMusicSongStreams")]
    [ExplicitColumns]
    public class AppleMusicTrackStream : IAggregatedStreamFormat
    {
        [PetaPoco.Column("DistributerId")]
        public int DistributerId { get; set; }

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

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

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

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

        [PetaPoco.Column("ReportDate")]
        [JsonProperty("report_date")]
        public DateTime ReportDate { get; set; }
        


        //[PetaPoco.Column("Licensor")]
        //[JsonProperty("licensor")]
        //public string Licensor { get; set; }


        [PetaPoco.Column("ActionType1")]
        [JsonProperty("action_type_1")]
        public long ActionType1 { get; set; }

        [PetaPoco.Column("ContainerSubtype0")]
        [JsonProperty("container_subtype_0")]
        public long ContainerSubtype0 { get; set; }

        [PetaPoco.Column("ContainerSubtype1")]
        [JsonProperty("container_subtype_1")]
        public long ContainerSubtype1 { get; set; }

        [PetaPoco.Column("ContainerSubtype10")]
        [JsonProperty("container_subtype_10")]
        public long ContainerSubtype10 { get; set; }

        [PetaPoco.Column("ContainerSubtype11")]
        [JsonProperty("container_subtype_11")]
        public long ContainerSubtype11 { get; set; }

        [PetaPoco.Column("ContainerSubtype2")]
        [JsonProperty("container_subtype_2")]
        public long ContainerSubtype2 { get; set; }

        [PetaPoco.Column("ContainerSubtype3")]
        [JsonProperty("container_subtype_3")]
        public long ContainerSubtype3 { get; set; }

        [PetaPoco.Column("ContainerSubtype4")]
        [JsonProperty("container_subtype_4")]
        public long ContainerSubtype4 { get; set; }

        [PetaPoco.Column("ContainerSubtype5")]
        [JsonProperty("container_subtype_5")]
        public long ContainerSubtype5 { get; set; }

        [PetaPoco.Column("ContainerSubtype6")]
        [JsonProperty("container_subtype_6")]
        public long ContainerSubtype6 { get; set; }

        [PetaPoco.Column("ContainerSubtype7")]
        [JsonProperty("container_subtype_7")]
        public long ContainerSubtype7 { get; set; }

        [PetaPoco.Column("ContainerSubtype8")]
        [JsonProperty("container_subtype_8")]
        public long ContainerSubtype8 { get; set; }

        [PetaPoco.Column("ContainerSubtype9")]
        [JsonProperty("container_subtype_9")]
        public long ContainerSubtype9 { get; set; }

        [PetaPoco.Column("ContainerType0")]
        [JsonProperty("container_type_0")]
        public long ContainerType0 { get; set; }

        [PetaPoco.Column("ContainerType1")]
        [JsonProperty("container_type_1")]
        public long ContainerType1 { get; set; }

        [PetaPoco.Column("ContainerType2")]
        [JsonProperty("container_type_2")]
        public long ContainerType2 { get; set; }

        [PetaPoco.Column("ContainerType3")]
        [JsonProperty("container_type_3")]
        public long ContainerType3 { get; set; }

        [PetaPoco.Column("ContainerType4")]
        [JsonProperty("container_type_4")]
        public long ContainerType4 { get; set; }

        [PetaPoco.Column("DeviceOs0")]
        [JsonProperty("device_os_0")]
        public long DeviceOs0 { get; set; }

        [PetaPoco.Column("DeviceOs1")]
        [JsonProperty("device_os_1")]
        public long DeviceOs1 { get; set; }

        [PetaPoco.Column("DeviceOs2")]
        [JsonProperty("device_os_2")]
        public long DeviceOs2 { get; set; }

        [PetaPoco.Column("DeviceOs3")]
        [JsonProperty("device_os_3")]
        public long DeviceOs3 { get; set; }

        [PetaPoco.Column("DeviceOs4")]
        [JsonProperty("device_os_4")]
        public long DeviceOs4 { get; set; }

        [PetaPoco.Column("DeviceOs5")]
        [JsonProperty("device_os_5")]
        public long DeviceOs5 { get; set; }

        [PetaPoco.Column("DeviceOs6")]
        [JsonProperty("device_os_6")]
        public long DeviceOs6 { get; set; }

        [PetaPoco.Column("DeviceType0")]
        [JsonProperty("device_type_0")]
        public long DeviceType0 { get; set; }

        [PetaPoco.Column("DeviceType1")]
        [JsonProperty("device_type_1")]
        public long DeviceType1 { get; set; }

        [PetaPoco.Column("DeviceType2")]
        [JsonProperty("device_type_2")]
        public long DeviceType2 { get; set; }

        [PetaPoco.Column("EndReason0")]
        [JsonProperty("end_reason_0")]
        public long EndReason0 { get; set; }

        [PetaPoco.Column("EndReason1")]
        [JsonProperty("end_reason_1")]
        public long EndReason1 { get; set; }

        [PetaPoco.Column("EndReason2")]
        [JsonProperty("end_reason_2")]
        public long EndReason2 { get; set; }
        

        [PetaPoco.Column("Offline0")]
        [JsonProperty("offline_0")]
        public long Offline0 { get; set; }

        [PetaPoco.Column("Offline1")]
        [JsonProperty("offline_1")]
        public long Offline1 { get; set; }

        [PetaPoco.Column("Source0")]
        [JsonProperty("source_0")]
        public long Source0 { get; set; }

        [PetaPoco.Column("Source1")]
        [JsonProperty("source_1")]
        public long Source1 { get; set; }

        [PetaPoco.Column("Source2")]
        [JsonProperty("source_2")]
        public long Source2 { get; set; }

        [PetaPoco.Column("Source3")]
        [JsonProperty("source_3")]
        public long Source3 { get; set; }

        [PetaPoco.Column("Source4")]
        [JsonProperty("source_4")]
        public long Source4 { get; set; }

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

    [PetaPoco.TableName("tblAppleMusicSongContainerStreams")]
    [ExplicitColumns]
    public class AppleMusicTrackContainerStream : IAggregatedStreamFormat
    {
        [PetaPoco.Column("DistributerId")]
        public int DistributerId { get; set; }

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

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

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

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

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

        [PetaPoco.Column("ContainerName")]
        [JsonProperty("container_name")]
        public string ContainerName { get; set; }
        
        [PetaPoco.Column("ContainerSubType")]
        [JsonProperty("container_subtype")]
        public string ContainerSubType { get; set; }
        

        [PetaPoco.Column("ReportDate")]
        [JsonProperty("report_date")]
        public DateTime ReportDate { get; set; }
        
        [PetaPoco.Column("ActionType1")]
        [JsonProperty("action_type_1")]
        public long ActionType1 { get; set; }

        [PetaPoco.Column("ContainerType0")]
        [JsonProperty("container_type_0")]
        public long ContainerType0 { get; set; }

        [PetaPoco.Column("ContainerType1")]
        [JsonProperty("container_type_1")]
        public long ContainerType1 { get; set; }

        [PetaPoco.Column("ContainerType2")]
        [JsonProperty("container_type_2")]
        public long ContainerType2 { get; set; }

        [PetaPoco.Column("ContainerType3")]
        [JsonProperty("container_type_3")]
        public long ContainerType3 { get; set; }

        [PetaPoco.Column("ContainerType4")]
        [JsonProperty("container_type_4")]
        public long ContainerType4 { get; set; }

        [PetaPoco.Column("DeviceOs0")]
        [JsonProperty("device_os_0")]
        public long DeviceOs0 { get; set; }

        [PetaPoco.Column("DeviceOs1")]
        [JsonProperty("device_os_1")]
        public long DeviceOs1 { get; set; }

        [PetaPoco.Column("DeviceOs2")]
        [JsonProperty("device_os_2")]
        public long DeviceOs2 { get; set; }

        [PetaPoco.Column("DeviceOs3")]
        [JsonProperty("device_os_3")]
        public long DeviceOs3 { get; set; }

        [PetaPoco.Column("DeviceOs4")]
        [JsonProperty("device_os_4")]
        public long DeviceOs4 { get; set; }

        [PetaPoco.Column("DeviceOs5")]
        [JsonProperty("device_os_5")]
        public long DeviceOs5 { get; set; }

        [PetaPoco.Column("DeviceOs6")]
        [JsonProperty("device_os_6")]
        public long DeviceOs6 { get; set; }

        [PetaPoco.Column("DeviceType0")]
        [JsonProperty("device_type_0")]
        public long DeviceType0 { get; set; }

        [PetaPoco.Column("DeviceType1")]
        [JsonProperty("device_type_1")]
        public long DeviceType1 { get; set; }

        [PetaPoco.Column("DeviceType2")]
        [JsonProperty("device_type_2")]
        public long DeviceType2 { get; set; }

        [PetaPoco.Column("EndReason0")]
        [JsonProperty("end_reason_0")]
        public long EndReason0 { get; set; }

        [PetaPoco.Column("EndReason1")]
        [JsonProperty("end_reason_1")]
        public long EndReason1 { get; set; }

        [PetaPoco.Column("EndReason2")]
        [JsonProperty("end_reason_2")]
        public long EndReason2 { get; set; }


        [PetaPoco.Column("Offline0")]
        [JsonProperty("offline_0")]
        public long Offline0 { get; set; }

        [PetaPoco.Column("Offline1")]
        [JsonProperty("offline_1")]
        public long Offline1 { get; set; }

        [PetaPoco.Column("Source0")]
        [JsonProperty("source_0")]
        public long Source0 { get; set; }

        [PetaPoco.Column("Source1")]
        [JsonProperty("source_1")]
        public long Source1 { get; set; }

        [PetaPoco.Column("Source2")]
        [JsonProperty("source_2")]
        public long Source2 { get; set; }

        [PetaPoco.Column("Source3")]
        [JsonProperty("source_3")]
        public long Source3 { get; set; }

        [PetaPoco.Column("Source4")]
        [JsonProperty("source_4")]
        public long Source4 { get; set; }

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

    [PetaPoco.TableName("tblAppleMusicContainerStreams")]
    [ExplicitColumns]
    public class AppleMusicContainerStream : IAggregatedStreamFormat
    {
        [PetaPoco.Column("DistributerId")]
        public int DistributerId { get; set; }

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

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

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

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

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

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


        [PetaPoco.Column("ReportDate")]
        [JsonProperty("report_date")]
        public DateTime ReportDate { get; set; }

        [PetaPoco.Column("ActionType1")]
        [JsonProperty("action_type_1")]
        public long ActionType1 { get; set; }

        [PetaPoco.Column("ContainerType0")]
        [JsonProperty("container_type_0")]
        public long ContainerType0 { get; set; }

        [PetaPoco.Column("ContainerType1")]
        [JsonProperty("container_type_1")]
        public long ContainerType1 { get; set; }

        [PetaPoco.Column("ContainerType2")]
        [JsonProperty("container_type_2")]
        public long ContainerType2 { get; set; }

        [PetaPoco.Column("ContainerType3")]
        [JsonProperty("container_type_3")]
        public long ContainerType3 { get; set; }

        [PetaPoco.Column("ContainerType4")]
        [JsonProperty("container_type_4")]
        public long ContainerType4 { get; set; }

        [PetaPoco.Column("DeviceOs0")]
        [JsonProperty("device_os_0")]
        public long DeviceOs0 { get; set; }

        [PetaPoco.Column("DeviceOs1")]
        [JsonProperty("device_os_1")]
        public long DeviceOs1 { get; set; }

        [PetaPoco.Column("DeviceOs2")]
        [JsonProperty("device_os_2")]
        public long DeviceOs2 { get; set; }

        [PetaPoco.Column("DeviceOs3")]
        [JsonProperty("device_os_3")]
        public long DeviceOs3 { get; set; }

        [PetaPoco.Column("DeviceOs4")]
        [JsonProperty("device_os_4")]
        public long DeviceOs4 { get; set; }

        [PetaPoco.Column("DeviceOs5")]
        [JsonProperty("device_os_5")]
        public long DeviceOs5 { get; set; }

        [PetaPoco.Column("DeviceOs6")]
        [JsonProperty("device_os_6")]
        public long DeviceOs6 { get; set; }

        [PetaPoco.Column("DeviceType0")]
        [JsonProperty("device_type_0")]
        public long DeviceType0 { get; set; }

        [PetaPoco.Column("DeviceType1")]
        [JsonProperty("device_type_1")]
        public long DeviceType1 { get; set; }

        [PetaPoco.Column("DeviceType2")]
        [JsonProperty("device_type_2")]
        public long DeviceType2 { get; set; }

        [PetaPoco.Column("EndReason0")]
        [JsonProperty("end_reason_0")]
        public long EndReason0 { get; set; }

        [PetaPoco.Column("EndReason1")]
        [JsonProperty("end_reason_1")]
        public long EndReason1 { get; set; }

        [PetaPoco.Column("EndReason2")]
        [JsonProperty("end_reason_2")]
        public long EndReason2 { get; set; }


        [PetaPoco.Column("Offline0")]
        [JsonProperty("offline_0")]
        public long Offline0 { get; set; }

        [PetaPoco.Column("Offline1")]
        [JsonProperty("offline_1")]
        public long Offline1 { get; set; }

        [PetaPoco.Column("Source0")]
        [JsonProperty("source_0")]
        public long Source0 { get; set; }

        [PetaPoco.Column("Source1")]
        [JsonProperty("source_1")]
        public long Source1 { get; set; }

        [PetaPoco.Column("Source2")]
        [JsonProperty("source_2")]
        public long Source2 { get; set; }

        [PetaPoco.Column("Source3")]
        [JsonProperty("source_3")]
        public long Source3 { get; set; }

        [PetaPoco.Column("Source4")]
        [JsonProperty("source_4")]
        public long Source4 { get; set; }

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

}