using System;
using System.Linq;
using PetaPoco;

namespace Sony.Filtr.SpotifyAnalytics.Data
{
    public class StreamDataSummaryForAnalysis
    {
        public string Market { get; set; }
        public DateTime Date { get; set; }

        //We handle these as fields instead of properties so we can use Interlocked.Increment when analyzing
        public int TotalStreams;
        public int DeviceDesktopStreams;
        public int DeviceTabletStreams;
        public int DeviceMobileStreams;
        public int OSAndroidStreams;
        public int OSiOSStreams;
        public int OSWindowsStreams;
        public int OSMacOSStreams;
        public int OSOtherStreams;
        public int SourcePlaylist;
        public int SourceSearch;
        public int SourceArtist;
        public int SourceAlbum;
        public int SourceCollection;
        public int SourceOther;
        public int StreamsFromSonyPlaylists;
        public int StreamsFromLocalSonyPlaylists;
        public int UniqueUsers;
        public int UniqueUsersSourcePlaylist;
        public int UniqueUsersSourceSearch;
        public int UniqueUsersSourceArtist;
        public int UniqueUsersSourceAlbum;
        public int UniqueUsersSourceCollection;
        public int UniqueUsersSourceOther;
        public int UniqueUsersDeviceDesktop;
        public int UniqueUsersDeviceMobile;
        public int UniqueUsersDeviceTablet;
    }

    [TableName("tblSpotifyAnalyticsAccountStreamInfo")]
    public class StreamDataSummary
    {
        public int AccountId { get; set; }
        public string Market { get; set; }
        public DateTime Date { get; set; }

        public int TotalStreams { get; set; }
        public int DeviceDesktopStreams { get; set; }
        public int DeviceTabletStreams { get; set; }
        public int DeviceMobileStreams { get; set; }
        public int OSAndroidStreams { get; set; }
        public int OSiOSStreams { get; set; }
        public int OSWindowsStreams { get; set; }
        public int OSMacOSStreams { get; set; }
        public int OSOtherStreams { get; set; }
        public int SourcePlaylist { get; set; }
        public int SourceSearch { get; set; }
        public int SourceArtist { get; set; }
        public int SourceAlbum { get; set; }
        public int SourceCollection { get; set; }
        public int SourceOther { get; set; }
        public int StreamsFromSonyPlaylists { get; set; }
        public int StreamsFromLocalSonyPlaylists { get; set; }
        public int UniqueUsers { get; set; }
        public int UniqueUsersSourcePlaylist { get; set; }
        public int UniqueUsersSourceSearch { get; set; }
        public int UniqueUsersSourceArtist { get; set; }
        public int UniqueUsersSourceAlbum { get; set; }
        public int UniqueUsersSourceCollection { get; set; }
        public int UniqueUsersSourceOther { get; set; }
        public int UniqueUsersDeviceDesktop { get; set; }
        public int UniqueUsersDeviceMobile { get; set; }
        public int UniqueUsersDeviceTablet { get; set; }
    }
}